If you already have a DigitalOcean database, you can migrate any database type supported on Kinsta’s Database Hosting.

Export the Database From DigitalOcean

  1. Download and install the database client of your choice on your local machine. For this guide, we’re using TablePlus.
  2. In TablePlus, click Create a new connection, choose the database type, and click Create.

    Create a new MySQL connection in TablePlus.
    Create a new MySQL connection in TablePlus.
  3. Complete the connection settings in TablePlus with your database connection details from DigitalOcean and click Connect once you’ve filled in the following:
    • Host/Socket
    • Port
    • User
    • Password
    • Database

    Add your database’s connection details from Digital Ocean in TablePlus.
    Add your database’s connection details from Digital Ocean in TablePlus.
  4. Back up the DigitalOcean database.

Create a New Database at Kinsta

In MyKinsta, create a new database (Databases > Add database). If you are connecting the database to an application hosted at Kinsta, you must choose the same region for both your application and database.

Create a new MySQL database in MyKinsta.
Create a new MySQL database in MyKinsta.

Restore the Database at Kinsta

  1. Connect to your Kinsta database.
  2. Restore your DigitalOcean database backup to your Kinsta database.
  3. Once the restore finishes, the data is now in your Kinsta database. Use an internal connection to connect your database to an application hosted at Kinsta. To connect your database to an application hosted elsewhere, use your database’s external connection details.

Related Documenation

Referenced Content