Migrate MySQL and ERPNext when bench command doesn't work

awebdesigner · August 12, 2018, 1:47pm

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

trentmu · August 12, 2018, 2:09pm

once you copy the entire DB from the VPS A to VPS B, you should be able to continue on VPS B.

I have run ERPNext on a machine with <1GB RAM though - depending on what other processes are active

awebdesigner · August 12, 2018, 2:29pm

Thank you.
I actually migrated all files to bitbucket but I don’t know which files to pick exactly and pull to VPS B.
Can you help me pick them out?

Thanks

trentmu · August 12, 2018, 4:37pm

you will need to use something like mysqldump to export the DB files (on VPS A),
then copy the exported DBfile to VPS B, and import it there.
This article…has some examples and so on that might help
https://mediatemple.net/community/products/dv/204403864/export-and-import-mysql-databases

awebdesigner · August 12, 2018, 5:21pm

Let me go through the article in the link then revert.
Thanks.

awebdesigner · August 12, 2018, 6:01pm

I have ran the following command.

bench --site [site1.local] --force restore databases-one.sql
But I see this
[site1.local] does not exist

trentmu · August 12, 2018, 6:55pm

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

awebdesigner · August 12, 2018, 8:28pm

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 '

trentmu · August 13, 2018, 7:51am

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;

awebdesigner · August 13, 2018, 8:58am

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.

trentmu · August 13, 2018, 9:48am

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

awebdesigner · August 13, 2018, 1:53pm

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

trentmu · August 13, 2018, 1:56pm

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

awebdesigner · August 13, 2018, 1:57pm

How is it created?

trentmu · August 13, 2018, 1:59pm

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

awebdesigner · August 13, 2018, 2:16pm

Is “magic bar” same as command?

trentmu · August 13, 2018, 3:03pm

the search bar…top centre of your screen

awebdesigner · August 13, 2018, 4:19pm

But look what I see at the screen? Anyway am so new to this. Please pardon me.

Updating%20ERP

trentmu · August 13, 2018, 5:49pm

The “magic bar” is in the top pic here…

No problem that it’s new - we all started out at the beginning like you - welcome to ERPNext!

If this error stays on screen for more than ~10 mins, maybe you should run (again)

bench update

awebdesigner · August 13, 2018, 7:48pm

Since the system is not running properly, I can’t seem access the magic bar.
Running bench update produces the similar error. I wish there is a way of creating a warehouse through the command line. That will save the day.

I appreciate your help.