migrate to mysql

1 files changed, 17 insertions, 1 deletions

diff --git a/docs/migrate_to_mysql.md b/docs/migrate_to_mysql.md
index 45fe7de..f414a1e 100644
--- a/docs/migrate_to_mysql.md
+++ b/docs/migrate_to_mysql.md
@@ -1 +1,17 @@
-migrate_to_mysql.md
+# 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.