I thought a fun thing to do would be to switch my main VPS to #alpinelinux for more frequent updates (compared to ubuntu). (I run #nextcloud, a custom #laravel site, and some other simpler stuff) So far, I've started using #linode, and also have been learning that migrating from mysql/mariadb to #postgresql may have been too ambitious an idea.
Migrating a #laravel site to #postgresql from mysql/mariadb
1. Run migrations to create db structure
2. Remove single quotes from the database (and newlines/control characters, because why not). This allows mysqldump files to be imported into postgresql.
3. mysqldump --compatible=postgres --no-create-info --skip-add-locks $DB | psql $DB
4. Fix increments `ALTER sequence song_id_seq RESTART 12345;` (current versions of laravel use old-fashioned postgres increments)
