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