I have old Production server v14 version now changing my new server in azure so i download the backup file and try to restore in new server but its show an error as “gzip: stdin: unexpected end of file” and same file created as .sql so i restore the sql file and give as bench migrate its show the below error.
Hi @a_jagadish,
Could you please share the complete error message here? This way, the community can better understand and assist you. The error you provided isn’t clear enough for a proper understanding.
ok bro
Your Error message is showing like a sql database file not able to unzip a sql file. Please share a full error in a screen shot.
Thank You So Much I Found the Error and Cleared.
Facing same issue. I have downloaded .sql.gz from Download backups and while running bench restore it giving error:
frappe@deab2c928fdf:/workspace/development/frappe-bench/apps/solar_square$ bench --site development.localhost restore /workspace/development/frappe-bench/20250317_053003-solar-square-database.sql.gz
MySQL root password:
b’\ngzip: /workspace/development/frappe-bench/20250317_053003-solar-square-database.sql.gz: unexpected end of file\nERROR 1064 (42000) at line 51048: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''{\“added\”:[[\“exploded_items\”,{\“amount\”:23559.97150460595,\“creation\”:\…' at line 1\n’
b’SETVAL(access_log_id_seq, 67178, 0)\n67178\nSETVAL(activity_log_id_seq, 365380, 0)\n365380\nSETVAL(bisect_nodes_id_seq, 1, 0)\n1\nSETVAL(console_log_id_seq, 54, 0)\n54\nSETVAL(crm_note_id_seq, 1, 0)\n1\nSETVAL(docshare_id_seq, 5285, 0)\n5285\nSETVAL(document_follow_id_seq, 1, 0)\n1\nSETVAL(email_queue_id_seq, 13252, 0)\n13252\nSETVAL(energy_point_log_id_seq, 1, 0)\n1\nSETVAL(error_log_id_seq, 1700172, 0)\n1700172\nSETVAL(event_sync_log_id_seq, 1, 0)\n1\nSETVAL(event_update_log_id_seq, 1, 0)\n1\nSETVAL(ledger_health_id_seq, 1, 0)\n1\nSETVAL(notification_log_id_seq, 7838, 0)\n7838\nSETVAL(prospect_opportunity_id_seq, 1, 0)\n1\nSETVAL(scheduled_job_log_id_seq, 770565, 0)\n770565\nSETVAL(tax_withheld_vouchers_id_seq, 1, 0)\n1\nSETVAL(version_id_seq, 928702, 0)\n928702\nSETVAL(view_log_id_seq, 38175, 0)\n38175\nSETVAL(web_form_list_column_id_seq, 1, 0)\n1\n’
Command failed