PlanetScale to SingleStore Migrator
How to migrate from PlanetScale to SingleStore
Create a free account with SingleStore. You can use our free Shared Tier, or get $600 in free credit for our paid tier.
In the SingleStore Portal create a workspace. Once that's created, create a database that is attached to that workspace.
Copy the connection string for the workspace and paste it in the "SingleStore connection string" field below.
We'll make some changes to this connection string to add all the required information:
Ensure that you also insert the username (defaults to
admin
) and password (which you are required to set before you get your connection string).Add the name of the database you created to the end of the connection string like so
/<database>
You should adjust the connection string to be in this format:
mysql://<username>:<password>@<host>:<port>/<database>
Run
pscale db dump <DATABASE_NAME> <BRANCH_NAME>
from the Planetscale CLIYour generated dump files will have a structure similar to this:
dump-folder/├── metadata├── project.table1-schema.sql├── project.table1.00001.sql├── project.table2-schema.sql└── project.table2.00001.sqlPaste each dump file in the text box below, ensuring you paste the table schemas before the data. In this example
project.table1-schema.sql
beforeproject.table1.00001.sql
etc.Click "Import to SingleStore"
Migrator
Having trouble?
Learn more about loading data into SingleStore from MySQL, or load data directly from PlanetScale using SingleStore Pipelines.