Database Backup Problem

[NoKSouLz]

Hi there,

i am trying to change serves for my forum.

The server i am currently on does not have cpanel, and everytime i load admicnp and click save database to the server it gets down to processing poll and crashed.

Processing: pollvote

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/gow2forum.co.uk/Public_HTML/includes/class_core.php on line 721

How can i fix this so i can download the database.

I have tried using the other method but it still seems to only downlod 40MB of the database when i know the database should be bigger

[snakes1100]

1. You shouldnt be downloading/dumping the database thru the admincp.

2. You should be dumping the db via the cmd line in ssh/shell.

3. mysqldump --opt u username -p dbnamehere > /path/tp/save/backup/backup.sql

Your error is a setting in php.ini max_execution_time = 30

Change to 60 or higher and restart apache.

AGAIN DO NOT BACKUP YOUR DATABASE THRU THE ADMINCP, ITS NOT A GUARANTEED BACKUP METHOD!

[NoKSouLz]

Ok ive got the server admins to generate a backup of the database using phpmyadmin

Thanks

[snakes1100]

Do not use phpmyadmin either, the only reliable backup method is via mysqldump.

[Lynne]

From the manual:
Backing Up The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_backup) or
Backing Up The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_backup)

Restoring The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_restore) or
Restoring The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_restore)

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)