Attachments in Database !! Urget Help

[arauf]

Hi ,
i have recently change my server and i made home directory backup and uploaded it on my new server but the SQL file is not uploading becuase of the attachments are in the database i dint know that before :( attachments table giving error and the SQL file size is 94 MB can anyone please tell me how to Fix that how can i remove that attachments from the SQL File all i have is Only SQL file and attachments in it :( :( :(

[Marco van Herwaarden]

How did you create the backup?

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

[arauf]

thanks alot .. my forum is up now !! :)