MysqL数据库备份和恢复数据_mysqldump 10.14 distrib 5.5.64-优快云博客

本文链接：https://blog.youkuaiyun.com/aaronszm/article/details/103714484

本文介绍了在Centos 7.3系统中如何进行MySQL数据库的冷备份及数据恢复。首先，模拟了数据库被删除的情况，接着通过两种恢复方式详细阐述了数据恢复过程，包括备份数据库目录和恢复数据的具体操作。在恢复过程中，强调了需修改文件的属主和属组为mysql，以确保数据库服务能正常访问。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

环境准备:
系统: Centos 7.3

[root@ localhost backup]# cat /etc/redhat-release 
CentOS Linux release 7.3.1611 (Core)

# 创建备份的目录
mkdir /backup
# 备份命令
mysqldump -uroot -p123 test > /backup/test.sql

cd /backup/
[root@ localhost backup]# ls
test.sql
[root@ localhost backup]# more test.sql 
-- MySQL dump 10.14  Distrib 5.5.64-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version	5.5.64-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

模拟数据库被删除恢复数据

[root@ localhost backup]# mysql -uroot -p123
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 15
Server version: 5.5.64-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| szm                |
| test               |
| testdb             |
+--------------------+
6 rows in set (0.00 sec)

MariaDB [(none)]> drop database test;
Query OK, 1 row affected (0.06 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| szm