DigitalOcean database migration guide

February 16, 2024

Introduction

In this article, we’ll walk through migrating a MySQL database from DigitalOcean to PlanetScale using the Import tool.

We recommend reading through the Database import documentation to learn how our import tool works before proceeding.

Prerequisites

Before you can start migrating your database, you’ll also need to collect the following information from your DigitalOcean cluster:

• The admin username and password
• The database host
• The port
• Database name

Most of this information is located on the landing page of your cluster.

You can view the list of databases in the "Users & Databases" tab. This article will use the default database created when the cluster was initialized, named defaultdb.

Update trusted sources

In order for PlanetScale to connect to your DigitalOcean database, you must allow network traffic into the database by adding the necessary IP addresses to the trusted sources list in DigitalOcean. The specific IP addresses you will need to allow depend on the region you plan to host your PlanetScale database. Check the Import tool public IP addresses page to determine the IP addresses to allow before continuing. This guide will use the AWS us-east-1 (North Virginia) region so we’ll allow the following addresses:

3.209.149.66
3.215.97.46
34.193.111.15
23.23.187.137
52.6.141.108
52.70.2.89
50.17.188.76
52.2.251.189
52.72.234.74
35.174.68.24
52.5.253.172
54.156.81.4
34.200.24.255
35.174.79.154
44.199.177.24

In the DigitalOcean dashboard, navigate to the “Settings” tab of your database and locate Trusted sources in the list of configuration items. Click “Edit” and the row should change to allow edits to the setting.

When you enter an IP address from the list, a message will appear below the input box asking if you want to add that IP as an address. Click that message to add it to the list. Repeat this step for each IP address that needs to be added, then click “Save” once you are done.

Disable ANSI_QUOTES setting

The default settings for MySQL databases on DigitalOcean is to have ANSI_QUOTES enabled in the global MySQL settings, which is not supported by PlanetScale. To remove this setting, navigate to the "Settings" tab of your cluster and locate the section titled Global SQL mode. Click “Edit” in that section to change the configuration settings.

To remove the ANSI_QUOTES setting, click the “x” next to the tag and click “Save.” The change should apply immediately.

Importing your database

In the PlanetScale dashboard, click “New database”, then “Import database”.

Complete the form using the information gathered in the previous section. Click “Connect to database”, and the import tool will attempt to connect to your DigitalOcean database.

The “Connect to database” button will update with the connection status.

If the connection is successful, click “Begin database import” to migrate your data to PlanetScale.

You’ll then be moved to a page where you can monitor the import status of the database from DigitalOcean.

Once the initial import has been completed, the first card in the Database import section will update to reflect the status of the import. If it is successful, you’ll have the option to “Enable primary mode,” which will prepare the PlanetScale database to be used as the primary data source. Click “Enable primary mode” & you’ll be presented with a confirmation modal to proceed.

Once Primary mode is enabled, you can complete the migration by clicking “Finish import” and confirming on the modal that will display. This will remove any synchronization occurring between DigitalOcean and PlanetScale.

This concludes the guide to migrating a database from DigitalOcean to PlanetScale.

Need help?

Get help from the PlanetScale Support team, or join our GitHub discussion board to see how others are using PlanetScale.