DB back up probs.

[ExTincTi0N]

Okay I want to back up my db from the acp. It says it saves to the root in my ftp. But I don't see it there. Then when I make a directotory to save the db and chmod it to 777 it won't let me save the db into that folder because its not word writable. Oh do I make it word writable?

[badboyz]

man never make bk ups from acp it sux ** again i say it those bk ups are worth less ... i made bk ups from acp none of them are working ....

its it better if u ask your hosting ppl to make bk up for you n send it to u .

that is the best way to make bk ups .. and you will know that that back up will work !!!

[Opserty]

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

(Courtesy of Dismounted :D)

[badboyz]

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

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

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

this was restoring back ups ... as he mentioned use ssh or tel net for making backups !

[Dismounted]

(Courtesy of Dismounted :D)
(Courtesy of Marco :D)