1) create db
mysql –u –p
will prompt for password, e.g. mysql –u root –p
create database <database> ;
e.g. create database sprit;
2) actuall db restore:
use mysql not msimport - the latter expects database structure to exist already
mysql –u –p <database> < <file>
will prompt for password
def. user - root
e.g. mysql –u –p <sprit> < <sprit.dmp>
3) to execute SQL commands from mysql console first execute
use <database> ; e.g. use sprit;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment