/backup/rtak_$ (Date +%y%m%d_%h%m%s). sql.gz
Note:
Bkdatabasename.sh replaced with interesting names
SQL backup and GZ Backup can be either optional or full backup
User name password needs to be replaced
4. Add executable permissions:
chmod u+x bkdatabasename.sh
Test whether the file is performing normally (./bkdatabasename.sh)
Note: (1) If error mysqldump: Command not Found, execute
Ln-fs/usr/local/mysql/bin/mysqldump/usr/bin (/usr/local/mysql path to MySQL installation path)
(2) If there is a
Report Options dialog box, where you can select if you are managing maintenance plan reports: You can write them to a file, or you can send the database administrator by e-mail. Click the Next button when you are finished setting up.10) The Complete wizard dialog box pops up and the Finish button is clicked to complete the maintenance plan creation operation.11) After you create the maintenance plan, confirm that SQL Server Agent is started: In the Object Explorer window, right-click the SQLSer
recoveringBackup Database NorthwindCSTo disk= ' G:\Backup\NorthwindCS_Full_1.bak ', disk= ' G:\Backup\NorthwindCS_Full_2.bak '--Mirrored backup--Each goal is the sameBackup Database NorthwindCSTo disk= ' G:\Backup\NorthwindCS_Mirror_1.bak 'MirrorTo disk= ' G:\Backup\NorthwindCS_Mirror_2.bak 'With format-the first time you do a mirrored backup format the target--mirrored backup to local and remoteBackup Database NorthwindCSTo disk= ' G:\Backup\NorthwindCS_Mirror_1.bak 'MirrorTo disk= ' \\192.168
tasks2. Add a scheduled task.3, the last step is to specify the backup time.It is easy to complete the automatic scheduled backup here.Finally, let's say one more word about this batch command \%date:~0,3% the meaning of extracting the day of the week informationOf course, if you want to create years and days of the words with%date:~0,10%, the system will give you a daily directory of the date. It's very convenient.%date:~0,10%//Extract date information%date:~-3%//Extract Day of the week inform
[email protected]:/home/db_backup//home/zabbix_backupThen 10.254.254.29 to consider not each copy with a password, so we have to use the SSH method to generate a secret key, let 10.254.254.29 fully accept 10.254.254.23, do not enter the password;The method is:On the 29 machine:Ssh-keygen–d or ssh-keygen–t RSAUpload to the root of 23 under SSH:Ssh-copy-id-i ~/.ssh/id_dsa.pub [email protected]This implements the method of executing the rsync command on 29 without entering the password:Then use th
1. Create a batch file@echo off rem ########################################################### rem # Windows Server 2008 Oracle Database Automatic backup batch script REM ###########################################################Setcurdate=%date:~0,4%%date:~5,2%%date:~8,2%Sethour=%time:~,2%if "%time:~,1%"==" " SetHour=0%time:~1,1%Setcurtime=%hour%%time:~3,2%%time:~6,2%REM Setting the database name, user name, and passwordSetOwner=ORCLSetUser=FlzdSetpassword=Flzdrem Create a backup directory wi
Once the backup SQL file is generated in auto-package, monitor the operation!#Crontab Time # variablesfile_dir=/data/mysql_bak/ #备份存放路径DATE = ' Date +%y_%m_%d ' #获取当前系统时间FILE_NAME = " Mysqldata_bak_$date.tar.gz "#最终保存的数据库备份文件名FILE =${file_dir}${file_name} #echo" $FILE "# to determine if the backup file of the day generates an IF [!-f ' $FILE ']; Then echo "####### $DATA #########" >>/data/mysql_bak/mysql_bak.err echo "MySQL back up $DATE hava not crea ted! ">> /data/mysql_bak
Original link: http://www.cnblogs.com/gnuhpc/Full backup:Establish test paths and filesmkdir Test Touch Test/{a,b,c}Generate three files under testPerform a full backuptar -G snapshot-zcf backup_full. tar. GZ testView Tarball Contenttar ztf backup_full. Tar . Gztest/Test/atest/btest/CDifferential + Incremental Backup:Add a file and modify the contents of a fileTouch test/eecho123 > test/aPerform a second incremental backup (note tarball file name)tar -G snapshot-zcf backup_incremental_2. tar. GZ
Myth #30:30 Misconceptions about Backup
It's all wrong.
Before starting a misunderstanding about backup, if you are not aware of the basics of backup, see my previous article in TechNet Magazine: Understanding SQL Server Backups.
30-01) backup operation can cause blocking
No, the backup does not cause a lock on the user object, although the burden of the backup on the IO system causes it to appear blocked, but not in practice. The only special cas
Introduction:
Continuing with my backup articles (part two of my Amanda series coming soon ...), I thought I wowould tell you about how I do my remote backups. the program I use is rdiff-backup, with a Perl script to sort out e-mail Notification and logfile generation. I will take you through my script and show you how to enable SSH passwordless access using public and private keys, so no interaction is required for full automatic
Tags: non-homogeneous Oracle backup file backup restore record number of Oracle database ACLsDescribes how Oracle database logical and physical backups are.Answer: Oracle backups include logical and physical backups.1). Logical backupA logical backup of a database consists of reading a database recordset and writing a recordset to a file.A. The output (export) ou
easily achieve.2. Combine incremental and automated backups to make backups faster and more hassle-efficient.Incremental backups In other words, multiple backups do not simply copy all the source and database of the site, but compare the two versions first, and then store the differences between versions. This approac
All about Oracle User-Managed Database Backups The V $ BACKUP view is most useful when the database is open. it is also useful immediately after an instance failure because it shows the backup status of the files at the time of the failure. use this information to determine whether you have left any tablespaces in backup mode. V $ BACKUP is not useful if the control file currently in use is a restored backup or a new control file created after the med
Scheduled tasks in Linux automatically delete old files n days ago
Linux is a system that automatically generates files, such as logs, emails, and backups. Although hard disks are cheap now, we can have a lot of hard disk space to waste these files, but there are always many requirements ~ I think it is refreshing to make the system clean up unnecessary files on a regular basis ~~
Statement Syntax:Find directory-mtime + days-name "file name"-exec Rm-R
Gitlab Migrating backupsFirst, the basic stepsInstalling Gitlab with the Gitlab one-click installation package is simple, and the same backup recovery and migration is simple. Use one command to create a full Gitlab backup:gitlab-rakegitlab:backup:create Using the above command /var/opt/gitlab/backups creates a compressed package with a name similar to that in the directory 1393513186_gitlab_backup.tar , which is the entire complete part of the Gitlab
reuse a maximum of
Manual designation:
Rman> backup copies 2 datafile 4
2> format '/u01/app/oracle/rmanbak/d1/df_%u ',
3> '/u01/app/oracle/rmanbak/d2/df_%u ';
Auto-Specify: Configure the following parameters
Rman> Configure DataFile backup copies for device type disk to 2; --Specifies the number of copies of the backup data file
Rman> Configure Archivelog backup copies for device type disk to 2;--specify number of backups log file copies
3. Backup
options, run the following command:
ALTER Database Database name SET RECOVERY {full | Simple | Bulk_Logged}
In addition to data, SQL Server backups include database outlines (schema) and database metadata (that is, database files, filegroups, and their locations). SQL Server allows the user to still use the database at backup time, so transactions that occur during the backup are also recorded in the backup.
Backing up a database
To back up the datab
Label:Original: Backup/restore Principles for SQL Server differential backupsBackup/restore Principles for SQL Server differential backupsRemember one point: Differential backups are based on the difference from the last full backup, not the difference based on the last differenceBackup process:1-After a full backup there have been no modifications to the database, if any, the last LSN of the logging database, if no changes have been made to the datab
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.