Import Data Tool

DieTjommie · October 27, 2015, 12:06pm

Is there any progress on this issue?

saurabh6790 · October 28, 2015, 7:37am

Check current site name using vi sites/currentsite.txt from frappe-bench forlder.

Then execute, bench --site sitename_from_currentsite backup

ruchin78 · October 28, 2015, 12:34pm

Thanks @saurabh6790
Sorry @DieTjommie I couldn’t reply your post as I was busy with other stuff.

DieTjommie · October 30, 2015, 7:32am

Thank you, I can now successfully backup the site, but when I upload it, it asks for a MySQL root password. I’ve used erpnext and then it tells me the database already exists. Do I have to delete or remove the database in order to restore another one?

saurabh6790 · October 30, 2015, 7:42am

Try with this,

`bench --force --site {sitename} restore path_to_mysql_file``

DieTjommie · October 30, 2015, 7:53am

I put the sql file in : /home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/private/backups : as database.sql.

Is it correct if path_to_mysql_file is then: sites/erpnext.erpnext-vm/private/backups/database.sql?

saurabh6790 · October 30, 2015, 7:58am

I think you need tp provide absolute path,

/home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/private/backups/database.sql

DieTjommie · October 30, 2015, 8:00am

Thank you so much for your help. Its working 100%.