[GH-ISSUE #984] Migrating from SQLite to MySQL One Bug #701

New issue

Closed

opened 2026-03-03 02:02:20 +03:00 by kerem · 1 comment

kerem commented

2026-03-03 02:02:20 +03:00

Owner

Originally created by @onepve on GitHub (May 6, 2020).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/984

10.2.30-MariaDB

sqlite3 db.sqlite3 .dump > sqlitedump.sql 
grep "INSERT INTO" sqlitedump.sql | grep -v "__diesel_schema_migrations" > mysqldump.sql

Then error loading data mysqldump.sql Load error

error (1064): Syntax error near '"users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581','2019-05-26 03:55:06.05651' at line 1

Finally found

INSERT INTO "users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******)
Should be changed to
INSERT INTO `users` VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******)
or
INSERT INTO users VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******)

From " To `

cd /home/bw-data
sqlite3 db.sqlite3 .dump > sqlitedump.sql
grep "INSERT INTO" sqlitedump.sql | grep -v "__diesel_schema_migrations" > mysqldump.sql

sed -i s#\"#\#g mysqldump.sql

mysql -ubitwarden_rs pyourpassword
use bitwarden_rs
source /home/bw-data/mysqldump.sql
exit

Originally created by @onepve on GitHub (May 6, 2020). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/984 10.2.30-MariaDB ``` sqlite3 db.sqlite3 .dump > sqlitedump.sql grep "INSERT INTO" sqlitedump.sql | grep -v "__diesel_schema_migrations" > mysqldump.sql ``` Then error loading data mysqldump.sql Load error ``` error (1064): Syntax error near '"users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581','2019-05-26 03:55:06.05651' at line 1 ``` Finally found ``` INSERT INTO "users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******) Should be changed to INSERT INTO `users` VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******) or INSERT INTO users VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******) ``` From " To ` ------------------------------ ``` cd /home/bw-data sqlite3 db.sqlite3 .dump > sqlitedump.sql grep "INSERT INTO" sqlitedump.sql | grep -v "__diesel_schema_migrations" > mysqldump.sql ``` ``` sed -i s#\"#\#g mysqldump.sql ``` ``` mysql -ubitwarden_rs pyourpassword use bitwarden_rs source /home/bw-data/mysqldump.sql exit ```

kerem closed this issue

2026-03-03 02:02:20 +03:00

kerem commented

2026-03-03 02:02:21 +03:00

Author

Owner

@dani-garcia commented on GitHub (May 7, 2020):

Can you edit the wiki page https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MySQL-Backend?

Just adding a mention to this fix at the end would be great, thanks!

@dani-garcia commented on GitHub (May 7, 2020): Can you edit the wiki page https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MySQL-Backend? Just adding a mention to this fix at the end would be great, thanks!

kerem referenced this issue

2026-03-03 08:53:04 +03:00

[PR #701] [MERGED] Trying to fix issue #687 #2784