Hello,
I have created a new server for ERPNext, and only want to move the website from our old server, is this possible? and if it is can someone please tell me how.
I’ve tried to export web page but its not an option on the old server, but it is an import option on the new server which is strange!
You should check this out.
Basic concept is just copy whole db and whole site folder.
Thanks for the reply but I want a clean ERP and just the website moving.
If I use that guide and copy the DB across wont it pull all the other information too?
It will copy all information and data on you website.
I get this error after running the first command, any idea what it might be?
mysqldump: Got error: 2005: “Unknown MySQL server host ‘mariadb’ (-2)” when trying to connect
mysqldump -h'mariadb' -u'root' -p source_database_name > site_data.sql
-h'mariadb' part need to be change to mariadb ip base on your setting, if your mariadb is install on same host as erpnext you could remove this part, so it’ll be.
mysqldump -u'root' -p source_database_name > site_data.sql
Hello @pipech,
The Database which I’m trying to import doesn’t have any data in it. It just have one new custom doctype with 5 fields. Even though I’m getting the below error msg. Would be grateful if you help me to solve this.
Enter password:
SETVAL(`access_log_id_seq`, 1, 0)
1
SETVAL(`activity_log_id_seq`, 851, 0)
851
SETVAL(`console_log_id_seq`, 1, 0)
1
SETVAL(`crm_note_id_seq`, 1, 0)
1
SETVAL(`docshare_id_seq`, 51, 0)
51
SETVAL(`document_follow_id_seq`, 1, 0)
1
SETVAL(`email_queue_id_seq`, 1, 0)
1
SETVAL(`energy_point_log_id_seq`, 1, 0)
1
SETVAL(`error_log_id_seq`, 51, 0)
51
SETVAL(`event_sync_log_id_seq`, 1, 0)
1
SETVAL(`event_update_log_id_seq`, 1, 0)
1
SETVAL(`leads_99acresadcategory1child_id_seq`, 1, 0)
1
SETVAL(`leads_additionalaccessorieschild_id_seq`, 1, 0)
1
SETVAL(`leads_adthemechild_id_seq`, 2, 0)
2
SETVAL(`leads_desksizechild_id_seq`, 1, 0)
1
SETVAL(`leads_finalpreferredlocationschild_id_seq`, 1, 0)
1
SETVAL(`leads_floornamechild_id_seq`, 1, 0)
1
SETVAL(`leads_preferredlanguagechild_id_seq`, 1, 0)
1
SETVAL(`leads_propertynamechild_id_seq`, 1, 0)
1
SETVAL(`leads_referredbychild_id_seq`, 6, 0)
6
SETVAL(`leadssuitablecenterschild_id_seq`, 1, 0)
1
SETVAL(`notification_log_id_seq`, 1, 0)
1
SETVAL(`prospect_opportunity_id_seq`, 1, 0)
1
SETVAL(`scheduled_job_log_id_seq`, 3351, 0)
3351
SETVAL(`version_id_seq`, 1451, 0)
1451
SETVAL(`view_log_id_seq`, 1, 0)
1
SETVAL(`web_form_list_column_id_seq`, 1, 0)
1
ERROR 1118 (42000) at line 17865: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Thank you.
You should create a new apps for that.
Create new apps add custom doctype then install the app into you site.
Thank you for the reply.
Could you please guide me to create an app with one doctype.