how to move wordpress database to managed MYSQL Database


I installed wordpress on my UBUNTU droplet and my live website is running from there with the standard wp-config define( ‘DB_HOST’, ‘localhost’ ); If I change these settings to my DO Database connection it takes me to the WP installation page. So, wondering do I import my wordpress.sql(I got from pypmyadmin export) file? I’ve also tried connecting through the console with Mysql with connection details and reports 2003 ‘can’t connect to mysql server’ I also have the MySQL shell installed if that helps. I have changed the password to ‘Legacy’ as I see that has caused some problems for others.

Not sure what to do other than reinstall wordpress and recover backup? is it not possible to just add the tables and data to the new connection?

thanks very much


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

I have the same question as you