From 901beb4df2c074ba54fedc91dd6e780cebe093d1 Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Tue, 16 Mar 2021 17:04:54 +0100
Subject: migrate to mysql

---
 docs/migrate_to_mysql.md | 18 +++++++++++++++++-
 1 file changed, 17 insertions(+), 1 deletion(-)

(limited to 'docs/migrate_to_mysql.md')

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.
-- 
cgit v1.2.3-70-g09d2