back-up database - never the same size

[touba]

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 ?

[David Lama]

have you been deleting stuff?

[Paul M]

vb cleans out some tables via cron jobs.

[touba]

Originally Posted by David Lama

have you been deleting stuff?

i'm not.

Originally Posted by Paul M

vb cleans out some tables via cron jobs.

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

[da420]

Originally Posted by touba

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

Basically, what he said is that this is normal.

[touba]

Originally Posted by da420

Basically, what he said is that this is normal.

ok thanks, and what about that ?

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

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

MySQL Error  : Paquet plus grand que 'max_allowed_packet' re?u
Error Number : 1153
Date         : Monday, July 9th 2007 @ 02:29:11 AM
Script       : http://www.club-scootergt.com/forums/*****/misc.php?do=buildpostcache&startat=50002&pp=10000
Referrer     : http://www.club-scootergt.com/forums/*****/misc.php?do=buildpostcache&startat=40002&pp=10000
IP Address   : 90.41.***.***
Username     : ******
Classname    : vb_database

[snakes1100]

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.

[Dismounted]

Originally Posted by touba

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

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

[touba]

thanks all for your support !

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

thanks again