Cold backup for MySQL backup and recovery

In one sentence, cold backup refers to stopping database services, such as MySQL and Oracle, and then backing up the data directory using the copy, package, or compression commands. If the data is abnormal, you can recover the data through backup. Cold backup generally requires customization plans, such as when to back up and which data is backed up each time. However, because such backups occupy too much space and are not suitable for environments with large data volumes, the production environment is rarely used.

 

Secondary cold backup

3. Cold Standby Experiment

 

Step 1: Create a test database and insert Test Data

mysql> use larrydb;Database changedmysql> show tables;+-------------------+| Tables_in_larrydb |+-------------------+| access            |+-------------------+1 row in set (0.00 sec)mysql> drop table access;Query OK, 0 rows affected (0.00 sec)mysql> clearmysql> show tables;Empty set (0.00 sec)mysql> mysql> create table class(    -> cid int,    -> cname varchar(30));Query OK, 0 rows affected (0.01 sec)mysql> show create table class \G;*************************** 1. row ***************************       Table: classCreate Table: CREATE TABLE `class` (  `cid` int(11) DEFAULT NULL,  `cname` varchar(30) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin11 row in set (0.00 sec)ERROR: No query specifiedmysql> create table stu(    -> sid int,    -> sname varchar(30),    -> cid int) engine=myisam;Query OK, 0 rows affected (0.00 sec)mysql> show create table stu \G;*************************** 1. row ***************************       Table: stuCreate Table: CREATE TABLE `stu` (  `sid` int(11) DEFAULT NULL,  `sname` varchar(30) DEFAULT NULL,  `cid` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf81 row in set (0.00 sec)ERROR: No query specifiedmysql> insert into class values(1,'linux'),(2,'oracle');Query OK, 2 rows affected (0.00 sec)Records: 2  Duplicates: 0  Warnings: 0mysql> desc class;+-------+-------------+------+-----+---------+-------+| Field | Type        | Null | Key | Default | Extra |+-------+-------------+------+-----+---------+-------+| cid   | int(11)     | YES  |     | NULL    |       || cname | varchar(30) | YES  |     | NULL    |       |+-------+-------------+------+-----+---------+-------+2 rows in set (0.00 sec)mysql> desc stu;+-------+-------------+------+-----+---------+-------+| Field | Type        | Null | Key | Default | Extra |+-------+-------------+------+-----+---------+-------+| sid   | int(11)     | YES  |     | NULL    |       || sname | varchar(30) | YES  |     | NULL    |       || cid   | int(11)     | YES  |     | NULL    |       |+-------+-------------+------+-----+---------+-------+3 rows in set (0.00 sec)mysql> insert into stu values(1,'larry01',1),(2,'larry02',2);Query OK, 2 rows affected (0.00 sec)Records: 2  Duplicates: 0  Warnings: 0mysql> select * from stu;+------+---------+------+| sid  | sname   | cid  |+------+---------+------+|    1 | larry01 |    1 ||    2 | larry02 |    2 |+------+---------+------+

 

For more details, please continue to read the highlights on the next page:

Implementation of MySQL backup and recovery

MySQL backup: mylvmbackup introduction and use

Using mysqldump in Linux to back up a MySQL database as an SQL File

Use mysqldump in Linux to regularly back up MySQL Databases

1 2 Next Page