vBulletin sql restore.. HELP!

[Isolde]

I done a backup via my cpanel > Backups > Download a MySQL Database Backup and now i want to restore it.. its in file.sql format zipped so i extracted it onto my desktop and im trying to restore it through same way Backups > Restore a MySQL Database > Browse > upload and i get a new window its blank and loading for ages.. am i doing this right? or is there another quick easy way? thanks

regards,
isolde

[Isolde]

Sorry for the double post but i need this help ASAP. thanks.

regards,
isolde

[Soy]

Can't you do it manually through the phpmyadmin

[Hitman]

"its blank and loading for ages"

If it is a big SQL file, then that will be because it's still uploading...

[Isolde]

through phpmyadmin dont work... it says maxiumm 300 seconds exceeded or somthing like that.. my file is big its 19.3MB someone suggested to cut it in sections how'd i do that?

[Jamesy]

Do you have shell access to your server? SSH etc?

[Isolde]

I've finally been able to do it now thanks to Hitman. So a great big thank you for his time and patience. +rep

And thanks to everyone else who replied to the post.

regards,
isolde

[Irrorate]

I was able to reimport a large backup (25mb) via phpMyAdmin by deleting the current tables and importing the backup as a new import rather than an overwrite.

[Jamesy]

I was able to reimport a large backup (25mb) via phpMyAdmin by deleting the current tables and importing the backup as a new import rather than an overwrite.

Really that's down to the various memory and php settings over anything else.

[Isolde]

I had to end up slicing the sql, well Hitman done it for me.

regards,
isolde

[Devestation]

I heard there is something called;
BigDump

If you get this in future, upload your MySQL.db and the BigDump.php, run bigdump [www.yourdomain/forum/bigdump.php] and locate the sql db.

It auto installs for you.

[DJ-Ains.T]

BigDump works fine for me ^^ and it's fast.

[Isolde]

I heard there is something called;
BigDump

If you get this in future, upload your MySQL.db and the BigDump.php, run bigdump [www.yourdomain/forum/bigdump.php] (http://www.yourdomain/forum/bigdump.php%5D) and locate the sql db.

It auto installs for you.

Great, thank you for the info. I sure will be using BigDump from now on, it's quicker. +rep

regards,
isolde

[Isolde]

I heard there is something called;
BigDump

If you get this in future, upload your MySQL.db and the BigDump.php, run bigdump [www.yourdomain/forum/bigdump.php] (http://www.yourdomain/forum/bigdump.php%5D) and locate the sql db.

It auto installs for you.

I done what you told me but then i get this error;

Error at the line 4104: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
Query: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

MySQL: Variable 'sql_mode' can't be set to the value of 'NULL'


How do i fix this?

[Devestation]

Im not sure. Did you have all the things on your forum home directory (/forum?)?

[Isolde]

I've got it working thank you.