Hey guys

im trying to restore a database through phpmyadmin that comes with cPanel. I have the database in a .sql file. When i try to upload it because its a big file (4.5mb) it times out over the 300 sec time limit. So, i tried copying and pasting it but when i ctrl-v it jus locks up my IE and doesnt respond.

Any ideas?

Cheers

how about copy a pasting it a bit at a time

yeah i have tried this but it would simply take hours.

i jus thought it there a way to easily convert SQL syntax and put it into a php file and run?

Ask your host to do it, they can load the file for you from the command line without any trouble.

ok i ahve access to the command line on the server since the server is partly mine. Do you know the command i should use

Command into the directory where the backup is, if it is zipped or tarred unzip/untar so you have a .sql file then use the following command (change to correct settings):

mysql -u dbusername -p databasename < backupname.sql


If you need to use with hostname use:

mysql -h servername -u dbusername -p databasename < backupname.sql

thanks alot it worked a treat