I have VPS A and VPS B. VSP A. Has erpnext and all database. Bench command is not working Seems the 1GB RAM is not enough VPS B. Has fresh erpnext installed Bench is working Is KVM VPS with 2GB of RAM How to do I migrate ERPNEXT and databases from VPS A to VPS B? Thank you

Although this is NOT the recommended way, it seems to work OK [image] Update/patch from v8 fails on 6 patch modules Setup I have been working on a system which WAS on frappe/erpnext 8.0.66/8.0.48, and which crashed during an update. Using a bunch of completely not-recommen…

I think the [site.local] part should probably be site.local (no square brackets)

I’m getting there below. erpman@localhost:~/frappe-bench$ mysql -u root -p 1bd3e0294da19198 < databases-one.sql; Enter password: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '

I think the system is reading in the DBname(1bd3e0294da19198) as the password. Import the database by executing the following command: mysql -u root -p PASSWORD_HERE 1bd3e0294da19198 < databases-one.sql;

Actually that’s not the case. I run mysql -u root -p 1bd3e0294da19198 < databases-one.sql; It asks for the password. The error comes after the entering the password.

My apologies. Could you perhaps post the first few lines of the sql file? Alternatively, use a GUI based DB utility like phpmyadmin to assist you with the export/import. HeidiSQL is free and open, and the community version of SQLyog is also

I have ended up using a 2 months earlier than latest backup. It seems it will work but I get this error. Could not find Default Warehouse: Stores - G

Just create it again, and/or set it to default if it already exists

In the “magic bar”…just type new warehouse and you will be prompted for the rest. or you can use the “warehouse tree”

Is “magic bar” same as command?

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace GitHub

Frappe Forum

Migrate MySQL and ERPNext when bench command doesn't work

ERPNext

trentmu August 27, 2018, 5:17pm 23

Although this is NOT the recommended way, it seems to work OK