导出数据库： C 5)G^  
iOzw)<  
1、windows下cmd打开命令行 P+oCcYp  
RwY) O5  
2、cd 到MySQL的安装目录的bin 目录，如果bin目录添加到环境变量中不需要切换到bin目录 gp(w6:w  
$+V{2k4X,  
3、导出数据库：mysqldump -u 用户名 -p 数据库名 > 导出的文件名 $6ITa}o  
[wIyW/
+  
比如在命令行中输入命令 mysqldump -u root -p person >d:\person.sql (输入后会让你输入进入MySQL的密码) QWfwoe&;R:  
（如果导出单张表的话在数据库名后面输入表名即可） .RoO6:T6  
vC+mC4~/(  
4、执行完成后，会看到d盘中有person.sql 文件 evtn/.kDR  
qlDL
Z.  
MySQL命令行导入数据库 0H;dA1
  
1、进入MySQL：mysql -u 用户名 -p AE^&hH0^  
如我输入的命令行:mysql -u root -p   (输入同样后会让你输入MySQL的密码) dk;Ed  
2、新建一个数据库，这时是空数据库，如新建一个名为person的目标数据库 .hZ =8y9  
3，输入：mysql>use 目标数据库名 ;?%2dv2d  
如我输入的命令行:mysql>use person; RwT.B+Onuy  
4，导入文件：mysql>source 导入的文件名; r|rV1<d  
如我输入的命令行：mysql>source d:/person.sql;

MySQL Workbench |jB/d@RE  
一个图形化管理工具，功能类似SQL Server Management Studio (SSMS) #9glGPR(  
http://dev.mysql.com/downloads/tools/workbench/ hLr\;Swyp  
6)veuA3]  
MySQL 命令大全 [X 9zrGHt  
http://see.xidian.edu.cn/cpp/u/mysql_ml/ X7rsO^}W  
F!<!)_8Q  
1. CMD - MySQL Backup aH_0EBR
c  
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" -u root -p123abc test > D:\Backup\MySQL\test_20140521.sql qg2Vmj<H  
h])oo:u'/Q  
可以通过计划任务来调用MySQL_Backup.bat批处理来实现每天自动备份； 6HZVBZhM  
@ECHO OFF Qb5@e#  
set y=�te:~0,4% OtbPrF5  
set m=�te:~5,2% iwy;9x  
set d=�te:~8,2% _C)\X(;  
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" -u root -p123abc test > D:\Backup\MySQL\test_%y%%m%%d%.sql +{#L,0t  
2. CMD - MySQL Restore &`,Y/Cbw  
恢复的过程，先创建一个数据库，然后进入这个数据库，使用Source来恢复数据库。 '6cXCO-_P  
mysql.exe -u root -p \&l@rMD3s  
show databases; A&A{Thz  
create database test001; DYoGtks(  
use test001;   LJ K0WWch  
source D:\Backup\MySQL\test_20140521.sql ; .%!^L#g  
BT`g'#O  
3. Example :cf#Tpq"  
### 备份 Bg] %  
C:\Users\Administrator>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" -u root -p1234-qwer test > D:\Backup\MySQL\test_20140521.sql 0cDP:EzR;  
Warning: Using a password on the command line interface can be insecure. /=T:W*C  
### 恢复 e,r7UtjoxR  
C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql.exe -u root -p _u'y7-  
Enter password: ********* %P{3c~?DH  
Welcome to the MySQL monitor. Commands end with ; or \g. z4~p(tl  
Your MySQL connection id is 60 jSSEfy>^  
Server version: 5.6.10 MySQL Community Server (GPL)
1{wbC)  
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. \ @[Q3.VX  
Oracle is a registered trademark of Oracle Corporation and/or its K- $,:28  
affiliates. Other names may be trademarks of their respective 7A) E4f'  
owners. @SyL1yFX  
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. N!MDD?0  
mysql> show databases; ^ g|VZN  
+--------------------+ z[ 'G"yCi  
| Database | + ~5P7dh6  
+--------------------+ (Q @'fb9z  
| information_schema | 7(oA(l1V  
| mysql | Z1:%AqxP  
| performance_schema | pkae9
1  
| sakila | 9X%: ){  
| test | RGs7Hc  
| world | vy7/
 
+--------------------+ 6 Bdxdx*zt  
7 rows in set (0.00 sec) eU@Mv5&6  
mysql> create database test001; g2m*Q%  
Query OK, 1 row affected (0.00 sec) pjX=:K|  
mysql> show databases; ZJQFn  
+--------------------+ 5h`LWAB  
| Database | Su"Z3gm5Kw  
+--------------------+ K%+4M#jj5  
| information_schema | 8cG`We8l&  
| mysql | ~F@n `!c  
| performance_schema | V){Io_"  
| sakila | Wm`*IBWA  
| test | R"V90bCf  
| test001 | NRJp8G Z%U  
| world |
aG^E^^Y  
+--------------------+ 9N'fU),I  
8 rows in set (0.00 sec)
xxvt<J  
mysql> use test001 Y;_F,4H  
Database changed ?x&}ammid  
mysql> source D:\Backup\MySQL\test_20140521.sql g^(gT  
Query OK, 1 row affected (0.00 sec) *>:phs~r{  
mysql> exit |<h}'  
Bye Ovk=s,a)K