nuBuilder Forum

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...

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

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!

Yessss ... Solved!!!

How did you solve it?

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!?

You can truncate the table

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

Thanks!