mysql & mysqldump
https://serverguy.com/servers/how-to-backup-mysql-database/
将数据库数据导出为 SQL语句。
mysqldump mysql-database > ABC-database-backup.sql
mysql database_name < database_name.sql
AutoMySQLBackup
自动化导出SQL语句的过程。
https://www.qingliezhiquan.com/howto-install-backup-restore-mediawiki/
https://serverpilot.io/docs/how-to-back-up-mysql-databases-with-automysqlbackup/
sudo automysqlbackupNow list all of the files under /var/lib/automysqlbackup:
$ ls -R /var/lib/automysqlbackup/ /var/lib/automysqlbackup/: daily monthly weekly /var/lib/automysqlbackup/daily: exampledb information_schema performance_schema test wordpress /var/lib/automysqlbackup/daily/exampledb: exampledb_2014-08-03_06h48m.Sunday.sql.gz ...
phpMyAdmin
https://serverguy.com/servers/how-to-backup-mysql-database/
https://www.phpmyadmin.net/
可视化管理数据库。