Database retoring odoo 11 CE

[guidev224]

Hello, I have an odoo 11ce instance running on a VPS and I use the auto_backup module to backup the database. When I try to restore the database on my local dockerized odoo I get weird things:

1. Sometime the restoring succeeds but the user table (res.users) does not contain all data. It only contains default data. It is the same case for res.partner. But all other tables contains their data
2. The second attempt I got this error:

psycopg2.IntegrityError: insert or update on table "ir_model" violates foreign key constraint "ir_model_write_uid_fkey"
DETAIL:  Key (write_uid)=(19) is not present in table "res_users".

[arabkhemar]

@guidev224 export your database from odoo database manager (make sure to include filestore!) then import it on your local env.