库的操作

show databases;

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] *db_name *[*create_option*] ... 
 
*create_option*: [DEFAULT] { 
    CHARACTER SET [=] *charset_name *
    | COLLATE [=] *collation_name *
    | ENCRYPTION [=] {'Y' | 'N'} 
}
 
举个例子：
    create database test character set utf8;
或者
    create database test charset=utf8;

show warnings;

show charset;

show collation;

show variables like '%character%';
show variables like '%collation%';

show create database 库名;

show processlist;

use 库名;

select database();

drop database [if exists] db_name;

ALTER {DATABASE | SCHEMA} [*db_name*] 
    *alter_option* ... 
 
*alter_option*: { 
      [DEFAULT] CHARACTER SET [=] *charset_name *
    | [DEFAULT] COLLATE [=] *collation_name *
    | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} 
    | READ ONLY [=] {DEFAULT | 0 | 1} 
}

mysqldump -P3306 -u root -p 密码 -B 数据库名 > 数据库备份存储的文件路径（一般备份为.sql文件）
 
举个例子：
mysqldump -P3306 -uroot -p -B db1 > db1.sql

source 数据库备份存储的文件路径(即sql文件的位置);