Backup from VM and restore in local machine

[ahmed_personal]

Continuing the discussion from Restore from ERPnext Virtual Machine to Ubuntu new installation:

@ahmed_personal

Hello,

I have been using the virtual machine of ERPnext since July 2014, I downloaded it from erpnext.com website. I have a lot of data in the system by now, and I want to have it now on a local Ubuntu installation.

I installed ERPnext on Ubuntu successfully using the easy install script. I backed up the databases and files from VM, and tried to restore it on local machine, I got errors that site1.local databse already exist, so I used -f at the end of the restore command which ended up in an error (I think because my VM database name and username is erpnext), and now I get “Internal Server Error” when I go to localhost.

Can you explain the steps of restoring the configuration from a erpnext VM to a local install please.

Regards,
Ahmed

[ahmed_personal]

This is what I get when I run restore:

root@ahmed-Q500A:/home/ahmed/frappe-bench# ls
20141230_21537504_database.sql config env Procfile
apps config.json logs sites
root@ahmed-Q500A:/home/ahmed/frappe-bench# bench frappe --restore erpnext 20141230_21537504_database.sql
MySQL root password:
Traceback (most recent call last):
File “/home/ahmed/frappe-bench/env/bin/frappe”, line 9, in
load_entry_point(‘frappe==4.9.1’, ‘console_scripts’, ‘frappe’)()
File “/home/ahmed/frappe-bench/apps/frappe/frappe/cli.py”, line 54, in main
return run(fn, parsed_args)
File “/home/ahmed/frappe-bench/apps/frappe/frappe/cli.py”, line 82, in run
out = globals().get(fn)(*args.get(fn), **args)
File “/home/ahmed/frappe-bench/apps/frappe/frappe/cli.py”, line 68, in new_fn
return fn(*args, **new_kwargs)
File “/home/ahmed/frappe-bench/apps/frappe/frappe/cli.py”, line 387, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File “/home/ahmed/frappe-bench/apps/frappe/frappe/cli.py”, line 318, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File “/home/ahmed/frappe-bench/apps/frappe/frappe/installer.py”, line 31, in install_db
create_database_and_user(force, verbose)
File “/home/ahmed/frappe-bench/apps/frappe/frappe/installer.py”, line 52, in create_database_and_user
raise Exception(“Database %s already exists” % (db_name,))
Exception: Database site3.local already exists

[ahmed_personal]

Just noted that VM is running old bench, while local machine runs new bench. I don’t know if this can cause trouble, but anyway I have updated bench on VM now.

[ahmed_personal]

Still no luck. I am stuck at this stage and will require your help.

[pdvyas]

Pass -f to ignore the the warning and replace current data,

bench frappe --restore site3.local 20141230_21537504_database.sql -f

[ahmed_personal]

I have done that, and it ends up in an error, something related to “access denied for user …”. Then when I try to log in from browser I get “Internal Server Error”.

[pdvyas]

Try the following,

bench new-site site4.local
bench frappe --restore site4.local /path/to/sql -f site4.local
bench set-default-site site4.local
bench setup nginx

Then
as root,

service nginx reload

You can then drop databases that aren;t required.

[ahmed_personal]

This worked. Thanks.

How can I drop the not required databases ?

Regards,

[pdvyas]

You can run drop database query as mysql root user. Be careful to not drop a system database or the database the production site you’re using.

[Rehan_Ansari]

can you share restore process in vm machine

[ahmed.sharaf]

Check this video

How to restore ERPNext Cloud backup to VirtualBox - Step by Step

[Rehan_Ansari]

this error is coming when downloading backup in vm?

[Rehan_Ansari]

i wanted to backup vm hosted erpnext and restore it to another vm.

[krnkris]

@Rehan_Ansari

Just make a snapshot of the full VM instance and upload to new VM.

Hope it helps.