Database Backups

[Aadil]

Hey I do backups via VB and they come out like 40MB but the database is like 76MB big?

does this mean I have some sort of problem?

Thanks

[PAKIDIL]

yeah its mean you are not getting it 100% are u trying to download it from myphpadmin ?

[markbolyard]

Depending on the size of your database, backing up through the admincp in vBulletin is probably timing out.

You are best to either use phpmyadmin and the export function, or if you have SSH access follow these instructions: http://www.vbulletin.com/docs/html/main/maintenance_ssh_backup

[Phaedrus]

Hey I do backups via VB and they come out like 40MB but the database is like 76MB big?

does this mean I have some sort of problem?

Thanks

It is possible that you are getting your backup compressed.

Does it end with tar.gz?

If so, it is simply compressed and you are likely backing up just fine.

[Marco van Herwaarden]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

[Aadil]

sorry for late reply and thanks all for replying.

Its not a tar.gz its mysql file, I do have phpadmin and root ssh, but i would like the normal way to do it via VB to work..

[Dismounted]

Backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.