oxwivi
April 8, 2018, 12:58pm
1
How do I export SQL data from ERPNext.com hosted instance? I want the backup generated right at the moment I want to export.
@oxwivi
Hope this help to get on the right way:
change to bench directory
erpnext@server:~$ cd frappe-bench/
erpnext@server:~/frappe-bench$
use command
erpnext@server:~/frappe-bench$ bench backup
or command
erpnext@server:~/frappe-bench$ bench backup-all-sites
your database backups will be in ~/frappe-bench/sites/[sitename]/private/backups/
check out for the most recent backup with current time, there may be backups there already.
Now take backups of files
erpnext@server:~/frappe-bench/sites/[sitename]/public$ tar cvf ~/[sitename]-f…
With backup you have all your files + the sql save.
Since erpnext.com is your host - with no console access and possibly limited to scheduled backups and not on-demand backups - you may be out of luck oxwivi.
support@erpnext.com will advise or confirm your options?