MySQL Server Data Backups on CentOS

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 to Linux Systems

 Cockpit - Web Portal for Administrator

 Process Management

 Files and Directories

 Users and Groups

 File Systems

 Installing CentOS

 SELinux - Security-Enhanced Linux

 Network Connection on CentOS

 Software Package Manager on CentOS - DNF and YUM

 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

 vsftpd - Very Secure FTP Daemon

 Postfix - Mail Transport Agent (MTA)

 Dovecot - IMAP and POP3 Server

 Email Client Tools - Mail User Agents (MUA)

 GCC - C/C++ Compiler

 Conda - Environment and Package Manager

 Tools and Utilities

 References

 Full Version in PDF/EPUB