Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How to solve Mysql database connection error frequently after wordpress installation? Question Question
MySQL job will not start - database list could not be retrieved? Question Question

Question

How to connect Managed database to existing WordPress

Posted February 28, 2020 2.3k views
MySQLWordPress

How to connect Managed database to existing WordPress installation that I installed over Marketplace?

Add a comment
zelamedia
By:
zelamedia

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How to solve Mysql database connection error frequently after wordpress installation? Question Question
MySQL job will not start - database list could not be retrieved? Question Question

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
alexdo February 28, 2020

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

How To Install WordPress with a Managed Database on Ubuntu 18.04
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.
Reply Report
  • zelamedia February 29, 2020

    This shows how to do it from scratch but I have an existing installation that I installed from Marketplace

    Reply Report
    • alexdo February 29, 2020

      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

      Reply Report

Related

Looking for something else?

Ask a new question Search for more help