Can we restore one ERPNext backup file into another instance of ERPNext?

Hi All,

I’m trying to restore one backup file of ERPNext into another instance of ERPNext but its giving below error:
pymysql.err.OperationalError: (2013, ‘Lost connection to MySQL server during query’)

Could you please comment your entire error log. Also, please mention the version of ERPNext and frappe.


Versions:
ERPNext: v10.1.23(master)
Frappe Framework: v10.1.23(master)

… just to confirm… why are you fetching the .sql from the “public” folder… that should be in the private folder under “backups” and normally comes as .sql.gz

Are you sure your backup file is unzipped and in public/files folder?

regards

@spa
I think location of back up file does not matter.
Yeah backup file is unzipped and in public/files folder…

Seems database size is too large.

Increase max packet size in etc/mysql/my.cnf

1 Like

@saurabh6790
I went through etc/mysql/my.cnf this path:
By default max_allowed_packet = 16M is there.
So, how much i have to increment for max_allowed_packet?

what is database size?

Database | Size (MB) |
±-------------------±------------+
| 90a8834de7632686 | 67.45838928