Mysqldump Gzip

This article describes how to back up and restore mysql database under linux. Database backup is very important. If you do a regular backup, so that you can recover the data in the event of a system crash to the last normal state, the loss is reduced to a minimum. First, use the command to achieve backup MySQLl provides a mysqldump command, we can use it for data backup. Follow the prompts to enter the password, which put all the tm database table structure and # mysqldump-u root-p tm> tm_05051 ...

Script on /home/user/mysql_backup.sh crontab # crontab -l # m dom dom dow downgrade 28 16 * * * / home / user / m ...

Intermediary trading http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnosis Taobao guest Cloud host technology Hall nearly half a year, has lost 5 of Web site data, mostly due to the damage caused by VPS hard disk, RAID10 in order to speed is very not insurance the last 2 times respectively is directspace and BUYVM so, must backup, make good VPS ready to lose data ready ...

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall with the database in the construction of the continuous application of the site, the vast majority of sites have been inseparable from the database support , because the database can store not only information such as site content, but also information submitted by users. 　　Since this information is invaluable, it is almost impossible to recover once it is lost. All webmaster should not only pay attention to backup ...

Data tampering is to modify, add or delete computer network data, resulting in data destruction. The database data was attacked first to see if it was deleted or tampered with? Is there any backup data that can be restored and reinforced? This article comes from the database technical expert Zhang, mainly describes the MySQL attack tampering data, utilizes the Binlog from the library backup and the main library to carry on the incomplete recovery. The following is the author's original: First, the discovery of the problem today is 2014-09-26, development early in the morning that the database was attacked. The article in the database of an article table ...