mysql备份与还原

Question

大家好，请问MYSQL是怎样实现数据库备份与还原的，现我想把本机的数据库people备份，用：
mysqldump -uroot -p1234 -h127.0.0.1 people > E:\backup\people.sql
mysqldump -uroot -p1234 -h127.0.0.1 people < E:\backup\people.sql
备份与还原时报：Unknown command '\b'.
要怎样解决？

Answer 1

备份
mysqldump -uroot -p1234 -h127.0.0.1 people > E:\backup\people.sql还原
mysql -uroot -p1234 -h127.0.0.1 people < E:\backup\people.sql

Answer 2

jiaguwen123 (孤才尚赏)
  '截至2009-10-27 20:15:45  用户结帖率12.21%  总发帖：131  正常结帖：16  未结帖：115  当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

Answer 3

--------------------
备份是 mysqldump

Answer 4

mysqldump -uroot -p1234 -h127.0.0.1 people > E:\backup\people.sql
mysqldump -uroot -p1234 -h127.0.0.1 people < E:\backup\people.sql 
-------------------------------
mysqldump -uroot -p1234 -h127.0.0.1 people > E:\backup\people.sql
mysql -uroot -p1234 -h127.0.0.1 people < E:\backup\people.sql 

Answer 5

[Quote = #5楼jiaguwen123]  报错[/Quote]报错信息是什么？ 

Answer 6

E:\backup\people.sql 
E:\b
\b
可能是这里？

Answer 7

是字符转义的问题吧，这样写应该可以。备份
mysqldump -uroot -p1234 -h127.0.0.1 people > E:\\backup\\people.sql
还原
mysql -uroot -p1234 -h127.0.0.1 people < E:\\backup\\people.sql