Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to back up files regularly by mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "mysql how to back up files regularly"!

I _ regular backup file mysql

Create test under cd / home

[root@oracle01 test] # find / kingsql/-name mysqldump (absolute path to mysqldump)

[root@oracle01 test] # cat test_database_backup.sh

/ kingsql/database/mysql/bin/mysqldump-u root-poracle kingsqldb > / home/test/kinsqldb_$ (date +% Y%m%d_%H%M%S) .dmp

[root@oracle01 test] # crontab-e

* / 1 * / home/test/test_database_backup.sh

Enter mysql to create a database and prepare to import data that must be backed up.

Mysql > create database kingsqldb3

[root@oracle01 test] # mysql-uroot-poracle kingsqldb3

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.