zzzzsys_session backup ... and the server go away

[Mr71]

The table zzzzsys_session has three records from yesterday sessions and compared to the previous backup (48kb) has (10mb) occupation... it's strange!!!. Now if I try to restore the backup locally it returns me "The MySQL server has gone away (error 2006)". Compared to the previous backup I added an html iframe with the display of a field with base64 data that probably inflates the session table (assume !??). How can I fix!? no errors in operations but I'm afraid I won't be able to make valid copies anymore...

[kev1n]

How about deleting the zzzzsys_session's data from the backup file?

[Mr71]

I can do it!? I make the backup for the zzzzz_session table by configuring the copy only for the structure and not for the data!

[Mr71]

Yessss ... Solved!!!

[kev1n]

How did you solve it?

[Mr71]

Hi Kevin ... Thanks for helping me ...

1) Backup all tables with data and structure
2) Only for table zzzzsys_session I selected structure. I tried the copy in localhost and it works.

But the table on the server!? Everything works, but how do I delete 10mb sessions in the table!?

[kev1n]

You can truncate the table

[Mr71]

it works! even if in this case after a while the sessions are automatically deleted reducing the size of the database!

Thanks!