Anyone every backup database from another version and restore to a new version (13)

ERPNext
2

Thanks to @Suresh_Thakor i was a able to restore a backup from version 12 into version 13 and working.
What did we do?

Install version 13 not the beta - If you install the beta you will get some doctype error for workspace. If youhave the beta install with the new ui just switch to version 13 with out the beta.

How to switch?
sudo bench switch-to-branch version-13 frappe erpnext --upgrade
sudo bench update --patch
sudo bench setup requirements
sudo npm cache clean -f
sudo npm install -g n
sudo n stable
sudo bench setup requirements
sudo bench migrate
sudo bench build
sudo bench restart

Once you install is complete successfull make sure you create a site and test your site.
Next Restore a backup from your previous site

  1. Make sure you are in the frappe-bench folder (cd /home/frappe/frappe-bench if you are on ubuntu)

  2. Copy your backup from you old version server to you new version server. You can used WinSCP to copy backup.

  3. Make sure you backup file name is not long and include the correct extension *.sql.gz

  4. Execute this command bench --site yoursitename --force restore yoursitebackup.sql.gz (remember to add your site name before execute)

Now Let’s Update Bench

  1. Execute bench migrate or * sudo bench --site <my site> migrate if you want to do 1 by 1
    If you encounter any doctype error you must install them from bench consoleby executing this command in the following steps 1 bench --site yoursitename console step 2 frappe.reload_doc(‘desk’, ‘doctype’, ‘workspace’) step 3 frappe.db.commit() step 4 exit

  2. Execute bench update --patch just incase you restore missing db migration

Rebuild your site and you should be good

  1. sudo bench build
  2. sudo bench restart
7 Likes