mysql 导入dump文件

1、登陆MySQL

C:\Documents and Settings\Administrator>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文件中的数据库

mysql> create database my_db;
Query OK, 1 row affected (0.02 sec)  
mysql> exit
Bye  

3、导入dump文件(文件地址为D:\my_db.dump)

C:\Documents and Settings\Administrator>mysql -uroot -p123456 my_db <D:\monitor_data.dump

4、至此，导入结束！