back-up database - never the same size
 

Hi all,

i do a back-up of my database each day, but i have a problem... i suppose...

the back-up file size is never the same, i know it's ok if the size growing but it's not.
for example :

back-up july 3th : 38 Mo
back-up july 4th : 32 Mo
back-up july 5th : 41 Mo
back-up july 6th : 37 Mo

is it ok ? :confused:

have you been deleting stuff?

vb cleans out some tables via cron jobs.

i'm not.

what ? what ? what ?
i'm french and i understand nothing... i'm sorry :(

when i read vbulletin.sql file in notepad there is not really a "end" :
## database dump completed ## doesn't appears in last line...

Basically, what he said is that this is normal.

ok thanks, and what about that ?


and also when i try to empty post-cache i have this database error :

The error indicates that the max_allowed_packet setting in MySQL is to low, it needs to be increased, i would ask you host or if your on a dedicated server, use root access and increase the limit.

Dumping the databse should be done with a shell using mysqldump, you shouldn't depend on the backup from the admincp, i wouldn't trust a backup from there, phpmyadmin is also another source to backup your database, but again, mysqldump is the most reliable.

A cron allows scripts to be run automatically. What Paul is saying is that vBulletin runs a few scripts to "cleanup" your database.

thanks all for your support ! https://vborg.vbsupport.ru/external/2011/02/1.gif

i will try mysqldump or back-up manually my database by phpmyadmin...

thanks again ;)