PHPmyAdmin MySQL Backup FYI ~ IE VS Firefox

[DieselMinded]

Ive been pleaged with Not being able to back up via the AdminCP on VB cause of the Size , Resorted to Backing up Via Phpmyadmin tried for 3 weeks could not get it to cooperate ...

Then I tried FireFox instead of IE and it worked like a charm , So to anyone having issues Browsing through your Database Via PhpMyAdmin Give Firefox a try it has made me able to do back ups Again

THANKS FIRE FOX ,,,,,,

While your at it Install FireBug then Yslow it will tell you all the errors ect on all your pages and give you Tons of information about speeding it up ect... a Real Nice Set up

DM

[Marco van Herwaarden]

There should be no difference between IE or FF as the timeout occurs on the server-side, not in the browser on the client side.

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