mysqldump备份MySQL中数据库名db01且恢复时更改为redb01数据库

最新推荐文章于 2024-06-27 16:01:16 发布

zxrhhm

最新推荐文章于 2024-06-27 16:01:16 发布

阅读量253

点赞数 2

文章标签：数据库 mysql

本文链接：https://blog.csdn.net/zxrhhm/article/details/139045679

版权

1、mysqldump备份db01

检查数据库中的表

(root@localhost) [db01]> show tables;
+----------------------+
| Tables_in_redb01     |
+----------------------+
| bonus                |
| departments          |
| dept                 |
| dept_emp             |
| dept_emp_latest_date |
| dept_manager         |
| emp                  |
| employees            |
| salaries             |
| salgrade             |
| t_emp_dept           |
| t_miitem0601         |
| titles               |
+----------------------+
13 rows in set (0.00 sec)


(root@localhost) [db01]> select * from dept;
+--------+------------+----------+
| deptno | dname      | loc      |
+--------+------------+----------+
|     10 | ACCOUNTING | NEW YORK |
|     20 | RESEARCH   | DALLAS   |
|     30 | SALES      | CHICAGO  |
|     40 | OPERATIONS | BOSTON   |
+--------+------------+----------+
4 rows in set (0.01 sec)

cd /backup

mysqldump -uroot -p db01 > db01.sql

2、sed 行编辑器修改备份文件中数据库名

[root@PROD01 ~]# sed -i 's/'db01'/'redb01'/g' db01.sql

3、创建数据库redb01

[root@PROD01 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 64
Server version: 8.0.28 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

(root@localhost) [(none)]> create database redb01;
Query OK, 1 row affected (0.00 sec)

4、恢复数据

(root@localhost) [(none)]> use redb01;
(root@localhost) [redb01]> source db01.sql

5、数据库表信息及数据检查

(root@localhost) [redb01]> show tables;
+----------------------+
| Tables_in_redb01     |
+----------------------+
| bonus                |
| departments          |
| dept                 |
| dept_emp             |
| dept_emp_latest_date |
| dept_manager         |
| emp                  |
| employees            |
| salaries             |
| salgrade             |
| t_emp_dept           |
| t_miitem0601         |
| titles               |
+----------------------+
13 rows in set (0.00 sec)

(root@localhost) [redb01]> select * from dept;
+--------+------------+----------+
| deptno | dname      | loc      |
+--------+------------+----------+
|     10 | ACCOUNTING | NEW YORK |
|     20 | RESEARCH   | DALLAS   |
|     30 | SALES      | CHICAGO  |
|     40 | OPERATIONS | BOSTON   |
+--------+------------+----------+
4 rows in set (0.01 sec)