MySQL Server Data Backups on CentOS

MySQL Tutorials - Herong's Tutorial Examples

∟MySQL Server Data Backups on CentOS

This section provides a tutorial example on how to create backups of MySQL databases and load it back to another MySQL server for MySQL 8.0 server on CentOS 8 systems.

After using MySQL database server to store your own data, you need to perform data backups periodically and store them on another computer. This can be dump by using the "mysqldump" command as shown in this tutorial:

1. Create a backup of all databases on MySQL server as SQL statements:

herong$ mysqldump -u root -p --all-databases > mysql-bck-2020-03-28.sql

2. Zip the backup file:

herong$ zip mysql-bck-2020-03-28.zip mysql-bck-2020-03-28.sql
  adding: mysql-bck-2020-03-28.sql (deflated 89%)

3. Send it to another computer:

herong$ scp mysql-bck-2020-03-28.zip herong@storage:backup

4. Use the "mysql" command to load the backup file in another MySQL server, if you needed:

herong$ mysql -u root -p < mysql-bck-2020-03-28.sql

Table of Contents

About This Book

Introduction of SQL

MySQL Introduction and Installation

Introduction of MySQL Programs

PHP Programs and MySQL Server

Perl Programs and MySQL Servers

Java Programs and MySQL Servers

Datatypes and Data Literals

Operations and Expressions

Character Strings and Bit Strings

Commonly Used Functions

Table Column Types for Different Types of Values

Using DDL to Create Tables and Indexes

Using DML to Insert, Update and Delete Records

Using SELECT to Query Database

Window Functions for Statistical Analysis

Use Index for Better Performance

Transaction Management and Isolation Levels

Locks Used in MySQL

Defining and Calling Stored Procedures

Variables, Loops and Cursors Used in Stored Procedures

System, User-Defined and Stored Procedure Variables

MySQL Server Administration

Storage Engines in MySQL Server

InnoDB Storage Engine - Primary and Secondary Indexes

Performance Tuning and Optimization

Bulk Changes on Large Tables

MySQL Server on macOS

►Installing MySQL Server on Linux

Install MySQL Database Server on CentOS

Manage MySQL Server 'mysqld' on CentOS

Set MySQL Server "root" Password on CentOS

MySQL Server File Locations on CentOS

►MySQL Server Data Backups on CentOS

MySQL Server Log Files on CentOS

"Multiple files found for the same tablespace ID" Error

Connection, Performance and Second Instance on Linux

Archived Tutorials

References

Full Version in PDF/EPUB