Posted by Vince Wadhwani on Sep 25, 2007

If you use phpmyadmin to manage to your databases you have one small hurdle to overcome: importing large sql files. You see, the limit is typically 2MB for doing this through the web interface. So, if you find yourself in a bind, just use this friendly piece of code:

mysql -u root -p yourdbname < yourdbfile.sql
After you press return you'll be prompted for the root password (for your mysql installation) and then voila! All done.