I want to migrate wordpress database to MYSQL database

Hi everyone,

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

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hey there!

I think in this case it may be best to import that phpmyadmin export into your managed database first. You can then make the connection change in your Wordpress settings. To import that database into your managed database you can follow this guide: How to Import MySQL Databases into DigitalOcean Managed Databases There is also a full guide on using Wordpress with managed databases that may be helpful as well: How To Install WordPress with a Managed Database on Ubuntu 18.04