mysql备份与还原

C:\Program Files\MySQL\MySQL Server 5.0>cd bin

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u root -pdongjj --all-database>d:\bak.sql

C:\Program Files\MySQL\MySQL Server 5.0\bin>
------------------»Ö¸´----------------------

C:\Program Files\MySQL\MySQL Server 5.0>cd bin

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -pdongjj mysql<d:\bak.sql

C:\Program Files\MySQL\MySQL Server 5.0\bin>





mysql> LOAD DATA  LOCAL INFILE 'd:/bird.txt' INTO TABLE niao FIELDS TERMINATED BY ','      OPTIONALL
Y ENCLOSED BY '"'  LINES TERMINATED BY '\r\n';
Query OK, 3 rows affected, 2 warnings (0.03 sec)
Records: 3  Deleted: 0  Skipped: 0  Warnings: 2

mysql> select * from niao;
+------+------+
| id   | name |
+------+------+
|    1 | n    |
|    2 | d    |
|    3 | x    |
|    1 | n    |