How to move an ERPNext site to another server

Read how to completely move an ERPNext site to another location

 · 1 min read
  1. Backup site from source site. Both database and folder in sites.
  2. Create a new site on new server with same name and password
  3. Edit the database sql dump file and find all tables ending in _seq Then replace the create table and insert appropriately. For example table access_log_id_seq
    1. CREATE SEQUENCE `access_log_id_seq`;
    2. SELECT SETVAL(`access_log_id_seq`, 9);
  4. Restore database to the new site
  5. Do the same for sequence activity_log_id_seq
  6. Copy the db_password field from file site_config.json
  7. Remove the created new site folder and replace the old one.
  8. Run bench migrate command
Published on
KAINOTOMO PH LTD