MySQL database restoration error

[nitaish]

While testing restoration of a backup from a cPanel server to DA server, I am facing an issue with MySQL database restoration. I found the following error

Error with query:
ALTER DATABASE db_name CHARACTER SET 'utf8' COLLATE 'latin1_swedish_ci'
COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'
Unable to restore database db_name.sql to db_name : ERROR 2006 (HY000) at line 557 in file: '/home/account/backups/backup/db_name.sql': MySQL server has gone away

How to resolve this issue?

 

[zEitEr]

Check MySQL error for possible clues. It might be that your query is too long, or DBs/tables are corrupted.