1.创建测试库

CREATE DATABASE testdb;
CREATE DATABASE testdb1;
CREATE DATABASE testdb2;


USE testdb;
CREATE TABLE person
(　　
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name CHAR(40) NOT NULL DEFAULT '',
    age INT NOT NULL DEFAULT 0,
    info CHAR(50) NULL,
    PRIMARY KEY(id)
);


USE testdb1;
CREATE TABLE person1
(　　
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name CHAR(40) NOT NULL DEFAULT '',
    age INT NOT NULL DEFAULT 0,
    info CHAR(50) NULL,
    PRIMARY KEY(id)
);

USE testdb2;
CREATE TABLE person2
(　　
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name CHAR(40) NOT NULL DEFAULT '',
    age INT NOT NULL DEFAULT 0,
    info CHAR(50) NULL,
    PRIMARY KEY(id)
);

INSERT INTO person2(id,name,age,info) VALUES(1,'Green',21,'Lawyer');
INSERT INTO person2 VALUES(2,'aaa',18,'MAN');
INSERT INTO person2 (name,id,age,info) VALUES('bbb',6,188,'hagffdgha');
INSERT INTO person2 (name,id,age,info) VALUES('ddd',5,19,'hhbdfsd');


mysql> select * from testdb.person;
+----+-------+-----+--------+
| id | name  | age | info   |
+----+-------+-----+--------+
|  1 | Green |  21 | Lawyer |
|  2 | aaa   |  18 | MAN    |
|  3 | bbb   |  17 | haha   |
+----+-------+-----+--------+
3 rows in set (0.00 sec)

mysql> select * from testdb1.person1;
+----+-------+-----+--------+
| id | name  | age | info   |
+----+-------+-----+--------+
|  1 | Green |  21 | Lawyer |
|  2 | aaa   |  18 | MAN    |
|  3 | bbb   |  17 | haha   |
|  4 | ccc   |  18 | hhb    |
+----+-------+-----+--------+
4 rows in set (0.00 sec)

mysql> select * from testdb2.person2;
+----+-------+-----+-----------+
| id | name  | age | info      |
+----+-------+-----+-----------+
|  1 | Green |  21 | Lawyer    |
|  2 | aaa   |  18 | MAN       |
|  3 | bbb   |  17 | haha      |
|  5 | ddd   |  19 | hhbdfsd   |
|  6 | bbb   | 188 | hagffdgha |
+----+-------+-----+-----------+
5 rows in set (0.00 sec)

备份所有数据库

[root@mysql bin]# ./mysqldump -hlocalhost -uroot -pwwwwww --all-databases > /data/all-databases.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.

备份数据库testdbhttp://www.cndba.cn/hbhe0316/article/4839

[root@mysql bin]# ./mysqldump -hlocalhost -uroot -p testdb > /data/testdb.sql
Enter password:

备份数据库testdb的person表http://www.cndba.cn/hbhe0316/article/4839

[root@mysql bin]# ./mysqldump -hlocalhost -uroot -p testdb person > /data/testdb_person.sql

备份数据库testdb的person和person_1表http://www.cndba.cn/hbhe0316/article/4839

[root@mysql data]# /mysql/bin/mysqldump -hlocalhost -uroot -p testdb person person_1 > /data/testdb__person_person_1.sql

版权声明：本文为博主原创文章，未经博主允许不得转载。

Mysql