to restore very large backups, frappe may have issues
mysql -uroot -p -- connect to database SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'; SET GLOBAL max_allowed_packet = 1073741824; -- 1GB
gunzip -c ./sites/large-db.sql.gz | mysql -u root -p db_name
follow this method - https://gist.github.com/vr-greycube/458a424b02eac48a09fb0e0f53717af9
tabDeleted Document
tabAccess Log
__global_search
tabEmail Queue
# remove inserts for tabAccess Log zcat dump.sql.gz | sed '/LOCK TABLES `tabAccess Log` WRITE;/,/UNLOCK TABLES;/d' > cleaned_dump.sql
There was an error while loading. Please reload this page.