[Jawelin]

Originally posted by PPN
[...]
Though i optimize all my tables every 24 hours before they get backed up.

Please, excuse the o-t.

Uh, PPN ? I'm not good at MySql properly, but know DBs enough.
Just a tip: DON'T make such a mass operation BEFORE a backup, do it just after.... :nervous:
Such an operation is very inensive to the DBMS engine and if something goes wrong (i.e. db goes down) during that, I'll lose any rollback feature as the engine loose the control.
Your side, you'll loose last 24h activity of your board...

Unrequested tip: make each all-table intensive operation after a backup... You said, with the optimization you'd recover only few bytes for your backed-up gzip file... with very high risk.

Bye