A small update/add to my previous post about MySQL command line, well, commands:
So you know from my previous post how to open mysql command prompt, connect, etc. so now i am just going to leave here how you can restore a dump from inside the mysql prompt:
First select the database you want to restore using
use [database name];
Then, assuming the dump is “dump.sql”, you just do:
mysql> source dump.sql;
Simple, eh?