diff options
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/migrate_to_mysql.md | 18 |
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. |