Detailed introduction to scheduled data backup

There are many types of MYSQL database backups (cp, tar, lvm2, mysqldump, xtarbackup), etc. Which one to use depends on the size of your data. A table is given below #Extracted from "Learn to Backup Mysql Database in Various Attitudes" Backup method Backup speed Recovery speed Convenience function is generally used for cp fast and average, low flexibility and weak small amount of data backup mysqldump slow and average, can ignore storage Differences in engines: lvm2 is generally fast for backup of small and medium-sized data volumes, supports almost all hot backups, and is fast. Generally, xtrabackup is fast for backup of small and medium-sized data volumes. It implements InnoDB hot backup and requires powerful storage engines for large-scale backup. Of course, this article only talks about mysqldump [official document]. I can share other methods with you when I have the opportunity. When using mysqldump for backup, my method is relatively simple. It is done using batch processing + timing. To put it bluntly, mysqldump backup means saving the required statements. Main features: Adapt to all mysql engines, support

1. Detailed introduction to scheduled backup data in mysqldump (pictures and text)

Introduction: There are many types of MYSQL database backups (cp, tar, lvm2, mysqldump, xtarbackup), etc. Which one to use depends on your data. scale. A table is given below

2. Detailed explanation of a very easy-to-use SQL scheduled backup database toolIntroduction: A very easy-to-use scheduled database backup tool that can save money It’s time to do a job backup, and the built-in backup format is high compression, with a compression ratio of up to 10% (when the database file utilization is 100%). The disadvantage is that scheduled backup can only use its backup format, that is, the software must be installed during recovery. (1) Efficient backup--SQL Backup 5.3 Function: Comes with high compression

3. SQL SERVER two ways to regularly back up the databaseIntroduction: Today we will summarize There are two methods for regularly backing up databases on SQL SERVER. Friends who need to regularly back up data on SQL SERVER can refer to this tutorial.

4. mssql scheduled backup database method

Introduction: mssql scheduled database backup method //Method 1 requires the use of a remote database Back up local. Local databases can also be backed up remotely.

5. SQL Server remote backup database

Introduction: In some projects involving databases, it is often There is a need to back up the database regularly. It is quite easy to back up to the local machine regularly, and the scheduled task can be completed. However, if the whole machine hangs up, then it is meaningless to back up to the local machine. Then you need to consider backing up to the LAN or other computers. At first I thought it was quite simple, use a remote shared file

6. Use python to send emails with attachments to regularly back up the mysql database

Introduction: Wordpress was recently migrated and the system was upgraded to CentOS 6. There is a very strange problem. The script that was used normally under CentOS 5.8 to regularly back up the database and send it via email cannot be sent. Attachments and others are normal. The content of the email is also the file encoding generated by uuencode, but the attachment is not generated. And I can't find the reason. I hope someone who knows can enlighten me. In order to understand

7. Automatically back up the database and send email reports to the database

Introduction: Recently, in an internal system of an enterprise, the database uses SQL2000, in order to ensure the security of the data. , need to back up data after get off work every day, and notify the administrator of the backup status via email. Backing up the database is very simple. Use SQL Agent to create a job and back up the database regularly every day. If you want to send emails through SQL2000, go online

8. SqlServer regularly backs up the database and Kill database deadlock regularly to solve

Introduction: Last Friday the team leader told me to kill the deadlock process of the database. Sometimes writing to the database at the same time will cause this situation to happen, because I am not very familiar with databases. I was familiar with it. Suddenly the team leader said it and I decided to make some changes. Otherwise, how could I improve? If you don’t study it now, maybe you will study it next time. Once it is freed up, you can do it next time

9. SQL2008 Back up the database regularly and upload it to FTP

Introduction: First, create a new database maintenance plan, perform database backup regularly, open the database manager - Management - Maintenance Plan - Right-click the New Maintenance Plan Wizard - Plan Change - Select the execution time. Select the maintenance task: Back up database. Select the database to be backed up, optional database backup directory, and backup report. The maintenance plan is added. FTP upload script

10. mysql scheduled data backup tool (c#)

Introduction: The source of this blog post is http:/ /blog.csdn.net/zhujunxxxxx/article/details/40124773zhujunxxxxx@163.com, if you have any questions, please contact the author. In order to ensure the security of data, we often need to back up the data. But in order to reduce our workload, I wrote a simple data backup tool to backup the database regularly. That

The above is the detailed content of Detailed introduction to scheduled data backup. For more information, please follow other related articles on the PHP Chinese website!