Load MySQL Database from Dump

January 31, 2016 in #mysql

In terminal...

mysql -u root -p  

In mysql console...

create database dbname;  
exit;  

Install pv if you don't have it. Gives you a progress bar. Very useful for larger data.

pv structure.file | mysql -u root -p dbname  
pv data.file | mysql -u root -p dbname