1.怎么查mysql数据文件存放路径?
mysql> show variables like '%datadir%';
+---------------+---------------------------------------------+
| Variable_name | Value |
+---------------+---------------------------------------------+
| datadir | C:\ProgramData\MySQL\MySQL Server 5.1\Data\ |
+---------------+---------------------------------------------+
1 row in set (0.00 sec)
2.如何查看mysql版本信息
进入mysql后
mysql> \s
--------------
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe Ver 14.14 Distrib 5.1.50,
for Win32 (ia32)
Connection id: 6
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.50-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 35 min 18 sec
Threads: 2 Questions: 176 Slow queries: 0 Opens: 42 Flush tables: 1 Open ta
bles: 0 Queries per second avg: 0.83
--------------
3.如何备份数据(备份某个数据库)
前提:mysql服务处于启动状态,进入mysql安装路径,-p后面没有空格,直接输入密码
C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqldump -u root -p12345 crm>crm.sql
C:\Program Files\MySQL\MySQL Server 5.1\bin>
备份后的数据文件crm.sql在C:\Program Files\MySQL\MySQL Server 5.1\bin>目录下
4.备份某个数据库下的某个表
mysqldump -u root -p密码 dbname tablename>d:\test.sql ------------备份某个库下的某个表
5.备份所有数据库
mysqldump -u root -p密码 --all-databases >d:\test.sql ------------备份全库
6.显示数据库信息,表信息
查看数据库:show databases;
进入数据库:use 数据库名;
查看当前数据中有哪些表:show tables;
查看表结构:desc 表名
修改密码:mysqladmin –uroot -p1 password 123
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqldump -u root --default-characte
r-set=gbk -proot crm>crm.sql