[GH-ISSUE #1459] wrong migrate sqlite to mysql doc #968

New issue

Closed

opened 2026-03-03 02:05:10 +03:00 by kerem · 0 comments

kerem commented

2026-03-03 02:05:10 +03:00

Owner

Originally created by @scofieldpeng on GitHub (Mar 4, 2021).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1459

Subject of the issue

wrong doc in migrate from sqlite to mysql

Deployment environment

bitwarden_rs version: 1.19.0

Install method: docker
Clients used:
Reverse proxy and version:
MySQL/MariaDB or PostgreSQL version:
Other relevant details:

Steps to reproduce

pull the 1.19.0 docker image from docker hub by docker pull bitwarden_rs/server:1.19.0 (by the way, the `bitwarden_rs/server:1.19.0-alpine don't support mysql)
start docker image by docker run command to let bitwarden create the latest tables to mysql
stop docker container
run 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 in bitwarden data dir.
when import sql to mysql, I sure occur this problem error (1064): Syntax error near '"users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581'*********)
follow the doc run the command in bash sed -i 's#\"#\#g' mysqldump.sql, in fact, this command will not run correctly, I search the right command in issue, and run the correct command sed -i s#\"#\#g mysqldump.sql
start container again
bitwarden start but the all passwords are not shown

the problem is the sed command, it want to change

INSERT INTO "users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******)

INSERT INTO users VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******)

but it also remove the all " in field data in table cipher, so the json string broken.

help this issue can help those people want to migrate from sqlite to mysql :-)

Expected behaviour

Actual behaviour

Troubleshooting data

Originally created by @scofieldpeng on GitHub (Mar 4, 2021). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1459   ### Subject of the issue  wrong [doc](https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MariaDB-%28MySQL%29-Backend) in migrate from sqlite to mysql ### Deployment environment     * bitwarden_rs version: 1.19.0  * Install method: docker * Clients used:  * Reverse proxy and version:  * MySQL/MariaDB or PostgreSQL version:  * Other relevant details: ### Steps to reproduce  1. pull the 1.19.0 docker image from docker hub by `docker pull bitwarden_rs/server:1.19.0` (by the way, the `bitwarden_rs/server:1.19.0-alpine don't support mysql) 2. start docker image by `docker run command to let bitwarden create the latest tables to mysql` 3. stop docker container 4. run `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` in bitwarden data dir. 5. when import sql to mysql, I sure occur this problem `error (1064): Syntax error near '"users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581'*********)` 6. follow the [doc](https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MariaDB-%28MySQL%29-Backend) run the command in bash `sed -i 's#\"#\#g' mysqldump.sql`, in fact, this command will not run correctly, I search the right command in [issue](https://github.com/dani-garcia/bitwarden_rs/issues/984), and run the correct command `sed -i s#\"#\#g mysqldump.sql` 7. start container again 8. bitwarden start but the all passwords are not shown the problem is the sed command, it want to change ```sql INSERT INTO "users" VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******) ``` to ```sql INSERT INTO users VALUES('9b5c2d13-8c4f-47e9-bd94-f0d7036ff581',******) ``` but it also remove the all `"` in field `data` in table `cipher`, so the json string broken. help this issue can help those people want to migrate from sqlite to mysql :-) ### Expected behaviour  ### Actual behaviour  ### Troubleshooting data