KAYWEB Blogs Flash Header
Web Design, Web Developer, Search Engine Optimisation
Blogs Related Pages Header

Blogs

JUL21
Restoring large MySQL backup files

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!

Facebook   Twitter   Google   Technorati   Stumble Upon   Digg   Linked In  

Comments



Post A Comment

For security purposes, please copy the following characters into the textbox. Captcha