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