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 Kasutajad peavad seda kasulikuks
Kas see vastus oli kasulik?

Related Articles

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...

Remove STRICT_TRANS_TABLES in SQL Mode for WHMCS

WHMCS, a billing and support software for the web hosts, may experience a conflict with default...