how to move wordpress database to managed MYSQL Database

Posted July 5, 2021 178 views
WordPressDigitalOcean 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

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.

Submit an Answer
1 answer

I have the same question as you