Migrating from legacy infrastructure

Preparing a database dump

If you have previously self-hosted your setup with our legacy Syncing Server, you will need to first dump the data from your existing database. There are two ways to do this depending on whether you had a separate database or the one we provided with our Docker setup.

Database from Docker setup

In order to create a database dump, use the following command:

$ docker exec your_db_container_id sh -c 'exec mysqldump your_database_name -uroot -p "your_password"' > ./dbdump.sql

Note: In order to get the value of your_db_container_id, run docker ps to inspect your running containers. your_database_name and your_password have to be changed to whatever you had set up in your .env file.

External database

Run:

mysqldump your_database_name -h your_host -u your_user -p "your_password" > ./dbdump.sql

Note Change your_host, your_database_name, your_user and your_password to values that you use to connect to your database.

Importing your database dump

In order to import your data to the database that our self-hosted setup will create, just place your dbdump.sql file inside the path-to-your-self-hosted/data/import folder. The data will be imported once the setups starts.

To proceed, head over to our Self-hosting with Docker page.

Other ways to get help

Browse or post to the forum
Recommended for non-account related issues.
Join the Standard Notes Discord group
Recommended for small talk.
Send an email to help@standardnotes.com
Recommended for account related issues.