import a sql file on the MySQL command line
Because I had to figure this out the hard way, Here’s a reminder for myself and others on the best way to accomplish this. I had a 21MB file.
Assuming you already have your dumped sql file.
- remember where you saved the file
- log into mysql command line client
- run this: source /full/path/to/your/file.sql
- bask in glory
