[GH-ISSUE #1157] Transfer sqlite to mariadb #814

New issue

Closed

opened 2026-03-03 02:03:30 +03:00 by kerem · 4 comments

kerem commented

2026-03-03 02:03:30 +03:00

Owner

Originally created by @gkl1368 on GitHub (Sep 25, 2020).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1157

When I restore database dump to mariadb, it shows Duplicate entry '{email}' for key 'email'

Originally created by @gkl1368 on GitHub (Sep 25, 2020). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1157 When I restore database dump to mariadb, it shows Duplicate entry '{email}' for key 'email'

kerem closed this issue

2026-03-03 02:03:30 +03:00

kerem commented

2026-03-03 02:03:31 +03:00

Author

Owner

@BlackDex commented on GitHub (Sep 25, 2020):

Have you check the steps in: https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MySQL-Backend ?
It explains what you need to do to get this working.

@BlackDex commented on GitHub (Sep 25, 2020): Have you check the steps in: https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MySQL-Backend ? It explains what you need to do to get this working.

kerem commented

2026-03-03 02:03:31 +03:00

Author

Owner

@gkl1368 commented on GitHub (Sep 25, 2020):

Have you check the steps in: https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MySQL-Backend ?
It explains what you need to do to get this working.
Now I use this way
mysql --password --user=bitwarden_rs
use bitwarden_rs
source /bw-data/mysqldump.sql
exit

But after that I can't login. It shows Username or password is incorrect. Try again

And I use Navicat to transfer database Users, It show Duplicate entry '{email}' for key 'email'

@gkl1368 commented on GitHub (Sep 25, 2020): > Have you check the steps in: https://github.com/dani-garcia/bitwarden_rs/wiki/Using-the-MySQL-Backend ? > It explains what you need to do to get this working. Now I use this way mysql --password --user=bitwarden_rs use bitwarden_rs source /bw-data/mysqldump.sql exit But after that I can't login. It shows Username or password is incorrect. Try again And I use Navicat to transfer database Users, It show Duplicate entry '{email}' for key 'email'

kerem commented

2026-03-03 02:03:31 +03:00

Author

Owner

@BlackDex commented on GitHub (Sep 25, 2020):

All you need to do is create the dump like in the wiki article. Follow every other step there except the import. Now use that mysqldump.sql in your database manager as the import file, but make sure all tables, except __diesel_migraties before you do thr import

@BlackDex commented on GitHub (Sep 25, 2020): All you need to do is create the dump like in the wiki article. Follow every other step there except the import. Now use that mysqldump.sql in your database manager as the import file, but make sure all tables, except __diesel_migraties before you do thr import

kerem commented

2026-03-03 02:03:31 +03:00

Author

Owner

@gkl1368 commented on GitHub (Sep 25, 2020):

Resolve. LDAP sync auto add email to user table.

@gkl1368 commented on GitHub (Sep 25, 2020): Resolve. LDAP sync auto add email to user table.