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