Migrating from SQLite to MySQL One Bug #701

New Issue

2025-11-07T06:45:48-06:00

GiteaMirror commented

2025-11-07 06:45:48 -06:00

Originally created by @onepve on GitHub (May 6, 2020).

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). 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 ```

GiteaMirror closed this issue

2025-11-07 06:45:48 -06:00

GiteaMirror commented

2025-11-07 06:45:49 -06:00

@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!