Question

How to connect Managed database to existing WordPress

Posted February 28, 2020 188 views
MySQLWordPress

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.

×
1 answer

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:

https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-managed-database-ubuntu-18-04

Hope it helps!

Regards,
Alex

by Mark Drake
WordPress is the most popular CMS (content management system) on the internet. It allows you to easily set up flexible blogs and websites on top of a MySQL backend with PHP processing. In this guide, we'll focus on getting a WordPress instance set up on a managed MySQL database on an Ubuntu 18.04 server.
  • 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:

      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

Submit an Answer