Transfer sqlite to mariadb #813

New Issue

OVERLORD · 2026-02-04T22:46:58+03:00

OVERLORD commented

2026-02-04 22:46:58 +03:00

Originally created by @gkl1368 on GitHub (Sep 25, 2020).

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

Originally created by @gkl1368 on GitHub (Sep 25, 2020). When I restore database dump to mariadb, it shows Duplicate entry '{email}' for key 'email'

OVERLORD closed this issue

2026-02-04 22:47:04 +03:00

OVERLORD commented

2026-02-04 22:47:17 +03:00

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

OVERLORD commented

2026-02-04 22:47:22 +03:00

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

OVERLORD commented

2026-02-04 22:47:27 +03:00

@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

OVERLORD commented

2026-02-04 22:47:29 +03:00

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

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/vaultwarden#813