mysql 数据库导出

 

cmd 命令行下

导出

C:/Documents and Settings/Administrator>mysqldump -u root -p oa > oa.sql    
Enter password: *******

C:/Documents and Settings/Administrator>

 

注意 密码为mysql 密码oa.sql 后无任何符号，oa.sql 文件在C:/Documents and Settings/Administrator 目录下

 

导入

 

C:/Documents and Settings/Administrator>mysql -u  root -p oa < oa.sql
Enter password: *******

C:/Documents and Settings/Administrator>

注意 ：“<”字符的样式