Import Large data file into MySQL

How to import a large sql file into mysql when phpmyadmin has hit it’s 5 or so megabyte limit?

This is a common problem  so I will place this up here to make it easier to find.

  • Create the destination database in MySQL
  • Put the .sql file into a convenient location (the MySQL /bin directory would be perfect w/XAMPP)
  • login to MySQl
  • SOURCE sqlfilename (if you put it outside mysql bin, you probably need the full path

Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.