Posted by Ian Dela Cruz

Have you ever tried importing large MySQL backup files via PHPMyAdmin? If yes, you would probably have experienced timeout errors, and PHPMyAdmin will tell you to reload the page... but the same thing happens again.

Solution is use the mysql command line to restore your backup files.

Here's the command:

mysql --user=myuser mydatabase < mybackupfile.sql

You would be surprised at how fast your backup file is restored!