3 Easy ways to import large MySQL database

From time to time, we get into situation when we would like to know just how-to import big database in phpmyadmin?


The problem is that most of the php.ini - the PHP configuration file on server (that is your host, if you are on shared hosting) is limiting maximum file upload size to 2mb.

In that case casual BROWSE>UPLOAD model fails to work with phpmyadmin, so we need to seek altarnatives. Let’s see what we can do:

1. Notepad Way - First of all we could just open sql backup file with Notepad and just copy-paste code blocks to phpmyadmin SQL function and execute it one-by-one. But what to do if database is way too large?
2. Sever-side Way - If you’re on dedicated server the quick fix would be just to rise maximum file upload limitation, and maximum execution time, so importing will not stop in the middle of the process.

[Read more..]

Courtesy : http://deployo.com