1、登陆MySQL
C:/Documents and Settings/lij>mysql -uroot -p123456
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 1352
Server version: 5.1.34-community MySQL Community Server (GPL)
Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.
2、创建导入dump文件中的数据库 ,如本例导入的为my_db数据库
2、创建导入dump文件中的数据库
mysql> create database monitorjczx;
Query OK, 1 row affected (0.02 sec)
mysql> exit
Bye
3、导入dump文件(文件地址为D:/my_db.dump)
C:/Documents and Settings/lij>mysql -uroot -p123456 monitorjczx <D:/monitor_data.dump
--转自