docs/migrate_to_mysql.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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.