I am using MariaDB version 10.x with binary logs
after the mysql server has been backup with innobackupex
1- i ran an insert into table… select … statement containing blobs . 19121 rows are generated.
2- shutdown the db , move it to another folder xmysql
3- restore the db with innobackup to a new mysql folder
4- run mysqlbinlog on the binary logs in xmysql (parameters used: --disable-log-bin) to a file mybinlog
5- run mysql --max_allowed_packet=2147483648 --binary-mode <mybinlog , try also inside mysql source mybinlog
6- i got MySQL server has gone away
i tried the same process after insert into table… select … limit 5 , all is working fine
it seems that the huge quantity of rows with blob causes the issue ,how i can solve this ?
Thanks for your help