How to connect Managed database to existing WordPress installation that I installed over Marketplace?
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.
×Hello, @zelamedia
I believe this was answered here in this question in our community:
https://www.digitalocean.com/community/questions/how-to-configure-wordpress-with-a-managed-database
You can check it and ask if you have any questions.
You can also check our tutorial for installing WordPress with a Managed Database on Ubuntu 18.04:
Hope it helps!
Regards,
Alex
This shows how to do it from scratch but I have an existing installation that I installed from Marketplace
Hello, @zelamedia
You can follow the steps and connect your WordPress installation with the managed database. However if you with to export and import your current database and move it from your droplet to the Managed Database you will need to do few more things/task from your end.
Once you’ve installed the MySQL client, you can export your database and then import it to the Managed Database platform.
In order to export your database you can use the following command:
Question
mysqldump --column-statistics=0 -u root -p --databases DB1 > DB1.sql
and to import the database to the Managed Database:
mysql -u doadmin -p -h private-MYHOST.ondigitalocean.com -P 25060 --ssl-mode=REQUIRED DB1 < DB1.sql
Hope this helps!
Regards,
Alex