# 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.