Home>

After backing up mariadb, I tried moving the dumped file to a different server and trying to restore it, but failed with the message ERROR 2006 (HY000) at line 859: MySQL server has gone away. Line 859 is a blob type table insert.

[Backup command]
mysqldump --opt --all-databases --events --default-character-set = binary --hex-blob -u root --password ='1234'>dump.sql

[Restore command]
mysql -u root -p<dump.sql