For Oracle databases, only physical and logical backups
Physical Backup: A backup process that copies the operating system files that actually make up the database from one place to another, usually from disk to tape.
Logical backup: Is the process of extracting data from a database in a SQL language and coexisting it in a binary file.
The first class is a phys
I. Scripting notes1.mysql data files and binary log files are best saved on different partitions or storage devices2. After the backup is complete, take care to modify the data permissions to prevent the disclosure of important information, which hosts which users can use to recover3. View the exported 2 log file to see if it is logical and business, 2 binary log files can only guarantee the physical data point-in-time restore, but does not guarantee
=myisamdefaultcharset=utf8;mysql>insert NBSP;INTONBSP;MYISAM_TBL (name) ->values (' One '), (' Joy '), (' Li '), (' Tom '), (' Jerry '), (' Hello ');### a good way to build data mysql>insertintomyisam_tbl (name ) ->selectnamefrommyisam_tbl;### Create a table mysql>createtableinnodb_tbl for the InnoDB engine (-> idINTNotnullauto_increment,->namevarchar (+), ->primarykey (ID) - >) engine=innodbDEFAULTcharset=utf8;# myisam_tbl data to Innodb_ TBL Table MYSQLGT;NBSP;INSERTNBSP;INTONBSP;INNODB_TBL (
During traditional Oracle backup, database files are backed up by copying files from the operating system. The backup granularity is data files, which may be large,
During traditional Oracle backup, database files are backed up by copying files from the operating system. The backup granularity is data files, which may
1. Separate backup1. Classic full-database backup: backup as compressed backupset database include current controlfile plus archivelog delete all input;2. tablespace: name of the backup tablespace;3. Data File: backup datafile n; (n: Data File No. select file_name, file_id, tablespace_name from dba_data_files ;)4. Cont
Scripts are placed in the/home/user/mysql tutorial _backup.sh
Crontab
# crontab-l
# m H Dom Mon Dow command
* * */home/user/mysql_backup.sh
The script is as follows
#!/bin/sh
# mysql_backup.sh:backup MySQL databases and keep newest 5 days backup.
#
# Last updated:20 March 2006
# ----------------------------------------------------------------------
# This are a free shell script under GNU GPL version 2.0 or above
# Copyright (c) 2006 Sam T
Tags: and through director extended get database int backup technology shareOne: Handwritten tsql script 1, automatic backup Weekly full Backup of database, set Schedule Interval to weekly UseMasterGo
Declare @FileName nvarchar( the)
Set @FileName =N'D:\SQLBackupFolder\TestDB_FullBackup_'+CONVERT(nvarchar(Max),getdate(), the)+N'. bak'
Tags: mysql automatic hot standbyPros: Hot backup, no impact on business, incremental backup, remote backup.Purpose: Automatically package backup to remote 10.0.0.111 backup serverPremise:1. Installing XtrabackupYum Install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpmYu
Label:One, cold backup A cold backup occurs when the database has been shut down properly and provides us with a complete database when it shuts down normally. Cold backup is a statement that copies critical files to another location. The fastest and safest method for backing up Oracle information for cold backups. The advantages of cold
In SQL Server 2000, assume that we have a database of: Test, which now requires it to be automatically backed up 19:00 every day, and in the event of a database error in the future, we can restore the database to any backup point in time with a backup file.Backup steps:1. In SQL Server Enterprise Manager, register the server where the database resides, note that you want to use the SA user name and password
Use backup-manager on Linux for system backup, wiibackupmanager
Whether simple or not, we have the opportunity to understand the importance of backup. Considering that the backup method is really versatile, you may want to know how to effectively select the right tools and appropriate policies for your system.
In this
Symantec backup software for VMware, Hyper-V virtual machines, file servers, sql/oracle database backup softwareThe main components are: core versions (cores); agents (agent); options (option)core version (cores)It is commonly referred to as the backup main program, and the computer on which the backup main program is
---------- Full backup -----------Backup set: block backup used in data filesImage copy: a complete copy of all data files.---------- Incremental Backup -----------A backup of a database that has changed since a specific time point. This time point can be the time point of t
For an Oracle database tutorial, only physical and logical backups
Physical Backup: A backup process that copies the operating system files that actually make up the database from one place to another, usually from disk to tape.
Logical backup: Is the process of extracting data from a database in a SQL language and coexisting it in a binary file.
The first cla
I. Hot Backup
Cold backup occurs when the database is shut down normally. When the database is shut down normally, it will provide us with a complete database. This article describes how to copy key files to another location during cold backup. The fastest and safest way to back up Oracle information during cold backup
I. Cold backup
Cold backup occurs when the database is shut down normally. When the database is shut down normally, it will provide us with a complete database. This article describes how to copy key files to another location during cold backup. The fastest and safest way to back up Oracle information during cold backup
First, the service environment(1), WEBserver (192.168.10.130); Backserver (192.168.10.129)(2), Backserver Server deployment, install required software, and start(3), set up the system backup user backup (both Web server and backup server are established users)[[email protected] ~]# useradd backup; Echo
First, use the percona-xtrabackup tool to perform full backup of the database, and then perform Incremental backup of the data after each database data update.
First, use the percona-xtrabackup tool to perform full backup of the database, and then perform Incremental backup of the data after each database data update.
2014-07-27 BaoxinjianI. Summary
1. Cold BackupA cold backup database is a backup of all critical files, including data files, control files, and online redo log files, to be copied to another location after the database is closed.In addition, cold backups can include backups of parameter files and password files, but these two backups can be selected as needed.Cold
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.