How to Change Database Location?

[Insane21m]

Hi all,

I've migrated my MySQL database to it's own dedicated database server and want to point my website to the new location.

I've attempted to edit the conf_global.php to the new location, but when I do I get a generic 500 error on my website.

I have confirmed I am able to hit the database server just fine, and the migration worked without issue.

 

Once I revert the settings back, everything works as normal.. any ideas?

Was hoping this would be relatively simple.

 

Thanks!

 

[Eudemon]

are you exposing your port to outside access, mysql default 3306

you can test locally via command line connect mysql -u username -h hostname:port -p

Edited May 3, 2020 by Eudemon

[Insane21m]

Not "Outside" access, but it's open internally yes. I migrated the Database to the other server just fine and testing connection worked without issue.

Is there anything else that needs to be updated, or should editing the conf_global.php file be all that I need to do?

 

I can install a clean instance of IP.Board in this manner and direct the location to my DB server successfully, so it appears that when I'm trying to update my DB location of an existing instance, it breaks things..

Edited May 3, 2020 by Insane21m

[Meddysong]

Something similar has happened to me a couple of times. The solution in both cases was to create a totally fresh database and import into it. It wasn't enough to empty the previous one or use the old one's name for the new one; it needed to be a totally new database with a different name.

[Insane21m]

I'll give that a try and see how it goes. Thank you

[bfarber]

If you have the sql_socket configuration option defined in your conf_global.php, you may need to remove it or adjust it in addition to adjusting the rest of the database information.