How to Backup Entire MySQL Server and All Databases


This article provides a guide for how to backup entire MySQL server and all databases.

Any time when a live database server is being updated or modified, it is recommended to make a full backup that can be restored in case of unforeseen issues.

How to Backup Entire MySQL Server and All Databases

To backup entire MySQL server and all databases, follow the steps provided:

  1. Access the server as root user (or equivalent) via shell/command line.
  2. Run the following commands to create a separate storage directory and create the backups:
    mkdir -p ~/mysqlbkp
    systemctl restart mysqld --skip-networking --skip-grant-tables
    mysql_upgrade
    mysqldump --all-databases --routines --triggers > ~/mysqlbkp/dbcopy.sql
    systemctl stop mysqld
    cp -r /var/lib/mysql/mysql ~/mysqlbkp/
    systemctl start mysqld
  3. Verify the backup process is completed successfully before proceeding.

Conclusion

You now know how to backup entire MySQL server and all databases.

  • mysql, mariadb, backups, mysqldump
  • 0 Usuários acharam útil
Esta resposta lhe foi útil?

Related Articles

Manually Create config.inc.php for phpMyAdmin

This article discusses the manual creation of config.inc.php for phpMyAdmin installation....

Install MySQL on CentOS 7 Server

This tutorial provides step-by-step instructions for installing MySQL database server on CentOS...

Install MySQL on CentOS 6 Server

This tutorial provides step-by-step instructions for installing MySQL database server on CentOS...

MySQL Server GPG Keys Expired (Workaround)

This article provides a guide for resolving an issue caused by MySQL GPG key expiration. This...

Install MySQL on CentOS 8 Server

This tutorial provides step-by-step instructions for installing MySQL database server on CentOS...