I have a new server that I have installed v14 on it and everything is ok, but when I want to restore the DB, I faced this error.
The two sites are v14, and the same apps
SETVAL(`crm_note_id_seq`, 1, 0)
SETVAL(`designation_duty_and_responsibility_id_seq`, 5, 0)
SETVAL(`designation_experience_id_seq`, 2, 0)
SETVAL(`designation_leader_for_id_seq`, 1, 0)
SETVAL(`designation_qualification_id_seq`, 2, 0)
SETVAL(`feedback_on_non_recipients_statements_table_id_seq`, 3, 0)
SETVAL(`job_applicant_log_detail_id_seq`, 1, 0)
SETVAL(`manager_appraisal_template_goal_id_seq`, 20, 0)
SETVAL(`procurement_method_detail_id_seq`, 1, 0)
SETVAL(`prospect_opportunity_id_seq`, 1, 0)
SETVAL(`tax_withheld_vouchers_id_seq`, 1, 0)
SETVAL(`web_form_list_column_id_seq`, 1, 0)
ERROR 2006 (HY000) at line 15409: Server has gone away
App frappe already installed
Table '_9920798c4fa8eea4.tabSingles' doesn't exist
Thank you in Advance
This means mysql server went away during restore. I’d suggest just attempting restore again.
You might want to check if the
max-allowed-packet in /etc/mysql/mariadb.conf.d/mariadb.cnf is big enough
Tried several times and it didn’t work
I make it
4024M it and still the same error.
I think that the reason is the database that I want to restore because it did not save all the tables in the database.
Do you have a solution to make the backup copy pull all the tables and not be incomplete?
Something like this will create an sql+TGZ copy of the entire DB in the home subdir of the user that runs it. Obviously that user needs to have permission to access it
DBname="_9920798c4fa8eea4"; # based on the line above `Table '_9920798c4fa8eea4.tabSingles' doesn't exist`
#Create a backup from the local machine
mysqldump -u$u -p$p -B $DBname > $HOME/$buDate-$BUfile-$DBname.sql;
# Compress the backup
tar -cvzf $HOME/$buDate-$BUfile-$DBname.DB.tgz $HOME/$buDate-$BUfile-$DBname.sql;
# rm -f $HOME/$buDate-$BUfile-$DBname.sql; # [optional - uncomment if reqd] remove the local .SQL file (since it is already zipped)