About this user

« Newer Snippets
Older Snippets »
1 total  XML / RSS feed 

How to load a sql dump into a new database

// description of your code here

open up iterm

change to the directory with the sql dump you want to load

/usr/local/mysql/bin/mysql --user=root -p

create database mydatabasename default character set utf8;

use mydatabasename;

source mydatabasedump.sql;

show tables;

« Newer Snippets
Older Snippets »
1 total  XML / RSS feed