Linux Apps Tutorials - Herong's Tutorial Examples - v1.03, by Herong Yang
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
Running Apache HTTP Server (httpd) on Linux Systems
Running Apache Tomcat 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