diff options
| author | lens <lens@neural.garden> | 2021-03-23 21:10:11 +0000 |
|---|---|---|
| committer | lens <lens@neural.garden> | 2021-03-23 21:10:11 +0000 |
| commit | cc1d0c52e104245f9f1c0d77eb24a5a33800be38 (patch) | |
| tree | 02d8483dfe47803525b926a43c582dcfbf61c5db /docs/migrate_to_mysql.md | |
| parent | 81c673f058fda04b96baae7b2302f876479bc0a9 (diff) | |
| parent | 7a3ec205e001e4c071a67ecc5c375612fa72afdc (diff) | |
Merge branch 'master' of asdf.us:swimmer
Diffstat (limited to 'docs/migrate_to_mysql.md')
| -rw-r--r-- | docs/migrate_to_mysql.md | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/docs/migrate_to_mysql.md b/docs/migrate_to_mysql.md new file mode 100644 index 0000000..f414a1e --- /dev/null +++ b/docs/migrate_to_mysql.md @@ -0,0 +1,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. |