1 files changed, 17 insertions, 0 deletions
diff --git a/docs/migrate_to_mysql.md b/docs/migrate_to_mysql.md
new file mode 100644
index 0000000..f414a1e
--- /dev/null
+++ b/docs/migrate_to_mysql.md
@@ -0,0 +1,17 @@
+# Migrate to MySQL
+
+1. Create a MySQL user and database
+
+```
+CREATE USER 'swimmer'@'localhost' IDENTIFIED BY 'swimmer';
+CREATE DATABASE swimmer;
+GRANT ALL PRIVILEGES ON swimmer.* TO 'swimmer'@'localhost';
+```
+
+2. Set up the `.env` which should disable SQLite.
+
+3. Run `./cli.py db upgrade head`
+
+4. Run `./cli.py admin migrate_to_mysql`
+
+5. Restart the server.