mysql backup

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 automysqlbackup

Now 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/

可视化管理数据库。