We want restore our backup in the system, so how we added in the system our backup.
bench —site [sitename] restore
—with-private-files (path to tar file)
—with-public-files (path to public files)
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.
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