I have exported mysql database file which is over 100mb and wants to import back. I've tried BIG DUMP and it takes forever. I've also tried import command of phymyadmin but got this error - "Fatal Error: Maxiumum execution time of 300 seconds exceeded". Can anyone tell me the fastest way to import back.
P.S I'm trying this on local host and I'm also server admin.

Apache : 2.2.4
Mysql : 5.0.4.1
Php : 4.4.7
Windows Xp SP2

Use the command line (shell login)

mysql -u [username] -p [databasename] > [backupfile.sql]

n.b. got my > syntax the wront way round first time. changed now.

Hi Homer,

Check out these links on the official MySQL documentation. These links provide detailed instructions on Backup and Restoring database.

http://dev.mysql.com/doc/refman/5.0/en/mysql.html

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Thanks guys