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.sql
  adding: mysql-bck-2020-03-28.sql (deflated 89%)

3. Send it to another computer:

herong$ scp 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 to Linux Systems

 Process Management

 Files and Directories

 Running Apache Web Server (httpd) on Linux Systems

 Running PHP Scripts on Linux Systems

Running MySQL Database Server on Linux Systems

 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

 MySQL Server Socket Connection on CentOS

 MySQL Server TCP/IP Connection on CentOS

 Open Firewall for MySQL Server on CentOS

 "Server sent charset unknown to the client" Error

 Performance of Inserting Integers to MySQL Database

 Performance Comparison of Inserting Integers vs. Strings

 Running Python Scripts on Linux Systems

 Conda - Environment and Package Manager

 GCC - C/C++ Compiler

 Graphics Environments on Linux

 SquirrelMail - Webmail in PHP

 Tools and Utilities


 Full Version in PDF/EPUB