[GH-ISSUE #1898] Error in migrate no MySQL #1100

New issue

Closed

opened 2026-03-03 02:06:16 +03:00 by kerem · 0 comments

kerem commented

2026-03-03 02:06:16 +03:00

Owner

Originally created by @altendorfme on GitHub (Aug 12, 2021).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1898

I'm having trouble migrating the sqlite database to MySQL, I followed the documentation process:

docker run -d --name vaultwarden -e RUST_BACKTRACE=1 -e DATABASE_URL='mysql://vaultwarden:PASSWORD@127.0.0.1:3306/vaultwarden' -e ADMIN_TOKEN=XYZ -e ENABLE_DB_WAL='false' -v /docker/vaultwarden/:/data/ -p 80:80 vaultwarden/server:latest

docker stop vaultwarden

sqlite3 db.sqlite3 .dump | grep "^INSERT INTO" | grep -v "__diesel_schema_migrations" > sqlitedump.sql ; echo -ne "SET FOREIGN_KEY_CHECKS=0;\n$(cat sqlitedump.sql)" > mysqldump.sql

mysql --force --password --user=vaultwarden --database=vaultwarden < mysqldump.sql

ERROR 1146 (42S02) at line 2: Table 'vaultwarden.users' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'vaultwarden.devices' doesn't exist
...
ERROR 1146 (42S02) at line 10: Table 'vaultwarden.folders_ciphers' doesn't exist
...
ERROR 1146 (42S02) at line 136: Table 'vaultwarden.ciphers' doesn't exist
...

If i try fix:
sed -i 's#\"#\#g' mysqldump.sql

sed: -e expression #1, char 8: unterminated `s' command

mysql --version

mysql  Ver 15.1 Distrib 10.3.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Originally created by @altendorfme on GitHub (Aug 12, 2021). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1898 I'm having trouble migrating the sqlite database to MySQL, I followed the documentation process: `docker run -d --name vaultwarden -e RUST_BACKTRACE=1 -e DATABASE_URL='mysql://vaultwarden:PASSWORD@127.0.0.1:3306/vaultwarden' -e ADMIN_TOKEN=XYZ -e ENABLE_DB_WAL='false' -v /docker/vaultwarden/:/data/ -p 80:80 vaultwarden/server:latest` `docker stop vaultwarden` `sqlite3 db.sqlite3 .dump | grep "^INSERT INTO" | grep -v "__diesel_schema_migrations" > sqlitedump.sql ; echo -ne "SET FOREIGN_KEY_CHECKS=0;\n$(cat sqlitedump.sql)" > mysqldump.sql` `mysql --force --password --user=vaultwarden --database=vaultwarden < mysqldump.sql` ``` ERROR 1146 (42S02) at line 2: Table 'vaultwarden.users' doesn't exist ERROR 1146 (42S02) at line 3: Table 'vaultwarden.devices' doesn't exist ... ERROR 1146 (42S02) at line 10: Table 'vaultwarden.folders_ciphers' doesn't exist ... ERROR 1146 (42S02) at line 136: Table 'vaultwarden.ciphers' doesn't exist ... ``` If i try fix: `sed -i 's#\"#\#g' mysqldump.sql` ``` sed: -e expression #1, char 8: unterminated `s' command ``` ---- `mysql --version` ``` mysql Ver 15.1 Distrib 10.3.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 ```