How to restore Backup

We want restore our backup in the system, so how we added in the system our backup.

bench —site [sitename] restore

Additional parameters:
—with-private-files (path to tar file)
—with-public-files (path to public files)

bench migrate

If the command that @schilgod gave you doesn’t work, then I have always used this command from the ~/frappe-bench directory:

sudo bench --force --site [site_name] restore /path_to_sql_file

This has never failed me. It has always worked since as far back as at least version 7 of ERPNext. I use it several time a week to move copies of the backup to other testing servers.

Hope this helps.




Have understood the commands, but don’t know where I should be entering these commands. Which is the command line prompt for frappe for ERPNext Cloud… and how do I access it.

Excuse my ignorance, but I’m new to this whole thing.

This should help:


Never mind… post deleted.

You will have to contact the guys running the cloud to see if you can get command line access. Many of us here run our own servers and have that access from the beginning.


Hello !!

It ask for MYSQL root password. Where can I get it. there is not file like frappe-bench password.txt.


If you are working from frappe cloud servers, then you probably not allowed access to the mariadb root password. I am sure they would want to keep that secure.

If you run your own server then it would be in password.txt file


I run my own server.
I can not find password.txt on the server.


if you install erpnext through easy install script then password.txt exist, if you manually install it then reset your mariadb root password

If you used the easy install method then the password.txt file was placed in the home directory of the user that ran the install.

So, if you followed the directions exactly then the user would be “frappe” and the file would be in /home/frappe

For me I used “bkm” user so in mine it is /home/bkm/passwords.txt

Refer this video

1 Like

This worked for me but don’t forget to bench --site {site name} migrate
Thank you @bkm you always help via your contributions to the community.