chronos backup

One, separate backup1. Classic backup of the whole library: backup as compressed backupset database include current controlfile plus archivelog Delete all input;2, tablespace:backup tablespace name;3, Data files: Backup datafile N; (N: Specific data file number select File_name,file_id,tablespace_name from Dba_data_files;)4, Control files:

Tags: clean disk rm-rf mtime option Insert Add tle submithttp://blog.csdn.net/mchdba/article/details/51527081 The MySQL version is the 5.7.10-log community version and needs to be backed up, but after a long backup time, the disk is not enough, so you need to clean up the specified old backup collection. 1,mysqldump Backup ScriptsBackup script for, there are sev

Simple backup policy for small and medium-sized sites is based on drupal's small and medium-sized websites. We can use the backup_migrate module, which provides the regular backup function, backup time, number of backups retained, and so on, after the configuration is complete, execute cron regularly to make the backup

Logical backupA logical backup is a backup SQL statement that performs a backup of the SQL statement to reproduce the database data at the time of recovery.Tool: MysqldumpCharacteristics:1. Strong portability2. Backup and recovery takes a long time and does not apply to large business systemsPhysical backupPhysical

Tags: blank database target MySQL periodichttp://hongge.blog.51cto.com/ Backups of MySQL databases in a production environment are recurring operations, so it is common to write script implementations that periodically execute backup scripts through Crond scheduled tasks mysqldump Backup scenarios: Sunday 1 o'clock in the morning full-Library backup From Monday t

One. Task SchedulerWindows-Control Panel-Administrative Tools-Schedule task programs, right-click Task Scheduler Library, create taskSecond: The contents of the relevant script:Content in 2.1 Back_rman.bat:Set Oracle_sid=fsf:\oracle\product\10.2.0\db_1\bin\rman target/ cmdfile=h:\worksql\windows_backupscript\ BACKUP.RCV log=h:\worksql\windows_backupscript\backup_%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~ 3,2%.logContent in 2.2 BACKUP.RCV:Run {Allocate channel D1 type disk;allocate

1. name the backup database tempsql and calculate its MD520540. (for MD5 calculation method, see MD5java) spanstylewhite-space: Slave-uroot-pwugroupweixinD: mysql_backtemp 1. name the backup database temp. SQL, calculate its MD5 value (for MD5 calculation method, see MD5.java) String dos = "cmd/c mysqldump-uroot-pwugroup weixin> D:/mysql_back/temp. SQL "; // doscommand runtime.getruntime(cmd.exe c (dos); //

1. How to Use Dell DataSafe Local Backup to create system recovery mediaDell DataSafe Local Backup is a secure, simple, and highly reliable Local Backup and recovery solution that helps Dell Computer users avoid software faults and hard disk damages.The latest factory Dell Computer, such as Dell Alienware M11x, has been pre-installed with Dell DataSafe Local Back

Xtrabackup full backup solution, full Backup Recovery record [html] mysql> use inno Database changed mysql> insert into mm select 1; Query OK, 1 row affected (0.01 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> insert into mm select 2; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> insert into mm select 3; query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnin

Mysql automatic backup, using MD5 for unique backup1. Name the backup database temp. SQL and calculate its MD5 value (for MD5 calculation method, see MD5.java) 2. traverse the Backup Directory and calculate the MD5 value of the files under the directory, respectively compared with temp. SQL 4. Exit the program if there is the same 5. If all files in the directory

FTP (FILETRANSFERPROTOCOL) as a file transfer protocol, is a common way of backup, the benefits of the operation is simple, but FTP also has some insurmountable shortcomings, such as no backup version management, upload the existence of a binary selection problem. In the current development of cloud computing, SaaS applications based on data backup are increasing

Generally, you can manually back up the websites in the VPS. Generally, the old man prefers to back up a website once a week. This frequency should be quite good. The "automatic and timed backup of database/website Files" method shared yesterday is more suitable for data, it cannot be maintained in front of the computer for a long time. For example, some friends often go on a business trip. When they come back, they open the website and find that t

sql2008 "Database backup in Backup set differs from existing XX database" workaroundBecause it is in another computer to the same name database backup, using the usual method to restore, prompt is not the same database, do not let restore, find the following method on the Internet to solve:First, right-click the system database master, new queryExecute the follow

This article describes how Oracle uses odu to verify rman backup to process command instances for truncate object backup. If you need rman backup, you can refer to this article. By Digging data files before and after rman backup through odu, we know the rman backup process,

Today, there is no doubt about the importance of data protection for both individuals and businesses. Once the data has problems, such as lost, stolen, damaged, the consequences will be grim. For example, the site was attacked, the content was tampered with, but found no backup, unable to recover, which will affect the normal operation of the site, serious will lead to the closure of the site. So do a good job of data storage

1,Database backup TypesAccording to the database size backup, there are four types, respectively applied to different occasions, the following brief introduction:1.1Full BackupThis is the way most people use it to back up the entire database, including all database objects, such as user tables, system tables, indexes, views, and stored procedures. But it takes more time and space, so it's generally recommen

Copy codeThe Code is as follows:USER = root # database usernamePASSWORD = cucrzmysql # Database User PASSWORD# DATABASE = idssr # DATABASE NameFor DATABASE in 'ls/mysql/data/mysql/| grep idss' # DATABASE NameDo# WEBMASTER = 849699940@qq.com # administrator email address to send backup failure message reminderBACKUP_DIR =/mysql_bak # backup file storage pathLOGFILE =/mysql_bak/data_backup.log # Log File Path

SQL Regular automatic backup, encryption and compression of backup files, and automatic downloadRelease date:Author: knife tip customer QQ: 51978456 MSN: peters99@hotmail.com========================================================== ======= */ AsProgramStaff or database maintenance personnel may be frequent The thing to do is to back up the database, and it is best to back up the database remotely for s

Backup and recovery data database Case 2-use online backup to restore the database. 1. Set archiving Parameters 1, Drop database mydb Create Database mydb Update dB CFG for mydb using implements logpathd: \ backup \ log 2. updatedb CFG for using userexit on // Enable User exit 3. db2update dB CFG for using logretain on // enable archiving logs 4. db2update dB CFG

10. Click Finish11, we can see the corresponding task plan in the Mission Plan library.12, then we double-click the corresponding scheduled task, click "Edit Trigger", here we set the scheduled task time for each day, and then back every two days;13, then we export the backup configuration, and then delete the corresponding task schedule;14. We then create a new backup plan in Windows Server