MySQL Command Line – Part 2

By | 4 April, 2013

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?