Database Backup

[lolzers]

I have read the guide on how to add the database backup, but my phpMyAdmin doesnt seem to have the same functions as the one in the guide does.

Could anyone type out a how to for me? Thank you in advance!

[Lynne]

It might help if you tell people what version of phpMyAdmin you are using. And also, which guide did you read that is incorrect for you? Also, do you have shell access? That's an easy way to add the backup - instructions in the vbulletin manual.

[lolzers]

I have gone into the correct database in phpMyAdmin, I have clicked SQL. There is no browse button. I am using phpMyAdmin Version: 2.11.0. The guide I used: http://www.vbulletin.com/docs/html/main/maintenance_phpmyadmin_restore - The screenshot of what my phpMyAdmin looks like when I click SQL:

http://www.tehupload.com/9349265181.png

[Lynne]

Hmmm, I go into mine and I have the Browse box on the bottom (as well as the option to Drop after the Operations button). It's almost like you don't have some privileges set to allow you to do it. Someone else will have to help with this since I really don't know what to suggest.

[lolzers]

Alright, hopefully ill get some help on this.

[Brandon Sheley]

Automatic Database Back-up (http://www.vbhackers.com/f76/automatic-database-back-up-3013/)

This is what I use :)

[lolzers]

I have my database backed up, I want to add the database.sql to a different database now.

Will this do it?

[Marco van Herwaarden]

If your phpMyAdmin is not the same as on the screenshots, consult your host for instructions.

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

[rpainter]

I use MySQLDumper, and love it.

[lolzers]

I have some questions about MuSQLDumper -

On installation, what do I put for hostname?