how to auto backup mysql database

1. Why back up the database? Backup is the most important and easy to ignore for databases. Unexpected events may cause serious losses. The more important the data is, the more frequently the data changes, and the more frequently backup is

MySQL Learning Note 12: Data backup and RecoveryData backup1. Physical Backup and logical backupPhysical backupPhysical backup is to copy the database data files, configuration files, log files and so on to other paths, this backup speed is

The article introduced two kinds of database record code, one is our PHP write common database backup class, the other is for Linux friends to provide an automatic timing backup MySQL database code, the need for students can refer to. Save the

MySQL Backup solution--(using mysqldump and Binlog binary logs)As data continues to grow, and in order to be compatible with future InnoDB storage engines, consider the strategy of mysqldump full + log incremental backup. Using mysqldump is good

Day05I. Data backup and recovery-incremental and incremental recoveryA.binlog Log description (binary file): one of the types of log files used by the MySQL database service. Logs a SQL command other than a query. Not enabled by defaultQueries for

Database Common backup scheme 1. Full-scale backupRefers to a full copy of all data or applications at a given point in timeAdvantages: Fast Data recoveryCons: Long backup times 2. Incremental backupmeans that after a full backup or a

from:http://blog.csdn.net/mchdba/article/details/11575605As data continues to grow, and in order to be compatible with future InnoDB storage engines, consider the strategy of mysqldump full + log incremental backup. Using mysqldump is good support

Learn a little about mysql dual-host hot backup-quickly understand the principle and practice of mysql master/slave backup Thank you for learning Git in the previous article-quick start with git in 20 minutes. Here we will share the dry goods and

MySQL has become one of the most widely used databases on the network, especially for Web applications. it occupies the absolute advantage of small and medium applications. All of this comes from its small and easy-to-use, secure and effective, open

Database Hot Standby Script:Vim backup.sh#!/bin/shTime= ' Date ' +%y%m%d_%h%m%s "'Host= ' hostname 'week= ' Date +%w 'Monitor= "/home/mysql/monitor/mysql_hotbackup_status.txt" # #zabbix监控文件time_start= ' Date +%s 'N=0 # # #要周几做全备, Sunday is 0, Monday