Migrate MySQL and ERPNext when bench command doesn't work

ERPNext
1

I have VPS A and VPS B.
VSP A.

  1. Has erpnext and all database.
  2. Bench command is not working
  3. Seems the 1GB RAM is not enough

VPS B.

  1. Has fresh erpnext installed
  2. Bench is working
  3. Is KVM VPS with 2GB of RAM

How to do I migrate ERPNEXT and databases from VPS A to VPS B?
Thank you

2

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

3

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

4

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

5

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

1 Like
6

I have ran the following command.

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

7

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

8

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 '

9

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;

10

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.

11

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

12

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

13

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

14

How is it created?

15

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

16

Is “magic bar” same as command?

17

the search bar…top centre of your screen

18

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

Updating%20ERP

19

image
image1824Ă—118 16.4 KB

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

20

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.