[Urgent] Restore a database

Hello,
I restored an SQL database by

bench restore db.sql

and it works.
However, I want to restore the old database the was overwritten.

How can this be?? I’m using Linux machine.

Please this is urgent, some data were lost from the old database.

To do this, you will need to get a copy of one of the automatic backups from before you overwrote the database.

These can be found in the following directory:

/home/[USER]/frappe-bench/sites/site1.local/private/backups

If one of them dates to before your overwrite condition you can use it to restore the original data.

Hope this helps…

BKM :nerd_face:

1 Like

The new database is different than the old. do you think I’ll still will find it there? or these backups have been overwritten also.

I think this way doesn’t work properly because the SQL file that I restore would restore the these backup files too.