Use xtrabackup to implement mysql backup and xtrabackupmysql
: Https://www.percona.com/downloads/XtraBackup/
Install xtrabackup
[root@node1 ~]# yum install percona-xtrabackup
Full backup
Node 1
Modify the configuration file and set it to a unique tablespace for each form. This item must be set during database installation.
[root@node1 ~]# vim /etc/my.cnf[mysqld]i
The version used here is: Vista one-click Restore (Vista Ghost) 1.3 Simplified Chinese version or 1.35 Simplified Chinese version, its one-click Restore Backup function is easy to use, but if there are more than one system?
Because the "Vista one-click Restore 1.3 Simplified Chinese version" uses the Ghost kernel, so the backup restore multiple systems start Gho
Using these parameters, we can construct the following example to solve the problem of deleting backup script files. You can create a script based on the modified date or backup type. You can even construct scripts that can reference both standards.
Using these parameters, we can construct the following example to solve the problem of deleting backup script files
Use sqlcmd, osql, and iSQL backup and restoration of sqlserver
-- Sqlcmd, new sql2005 Tool1. Backup"C:/program files/Microsoft SQL Server/90/tools/binn/sqlcmd. EXE "-S. /sqlexpress-U sa-P 000000-D master-Q "backup database test to disk = 'C:/AA/AAA. bak '"
The database 'test' and the file 'test' (located on file 2) pro
Windows Server Backup is a feature built into Windows Server that uses Windows Server Backup to back up the entire server (all volumes), selected volumes, System State, or specific files or folders. And you can create a backup for bare metal recovery. You can recover volumes, folders, files, certain applications, and system state. In addition, you can perform a b
Use the earlier version of Xtrabackup to restore the full backup file created by the later version of Xtrabackup.Recently, we want to restore the data of multiple MySQL servers backed up by xtrabackup to another MySQL Server and start multiple instances using different ports as the review environment. Several database instances fail to be started when the utility executes auto-Restore. Check the error log i
There are many causes for database destruction, and the degree of severity varies. If you are lucky, it may be a small destruction of one or two tables (for example, if your machine is temporarily suspended due to power failure ). If this is not the case, you may need to replace the entire data directory (for example, if a disk crashes and the data directory is on it ). In other cases, recovery is also required. For example, when a user mistakenly deletes a database or table or the table content
Database destruction occurs for many reasons and varies in degree. If you're lucky, it could be a small damage to one or two tables (for example, if your machine is temporarily shut down due to a power outage). If this is not the case, you may need to replace the entire data directory (for example, if a disk is paralyzed and the data directory is on it). In other cases, recovery operations are also required, such as when a user mistakenly deletes a database or table, or when the contents of a ta
1. Windows 7:
Install python2.x or 3.x,Programming LanguageNote that most of the tutorials on the Internet are 2. x.
After cmd, before running Python XXX. py, you need to set the environment variable and write the path name during Python installation to the variable value. The variable name is still the path
In my situation, the shortcut key FN + F5 is used to run the py file. The packaging fails, but Python XXX. py runs the packaging script normally in cmd,CodeAs follows:
#-*-Coding: cp9
archive synchronization with the slave database. The tragedy is that the master database had a full-Database Backup action in the early morning of Sunday,
After the backup is complete, all the archives are deleted, which results in the loss of this part of the archive, from the inventory in the GAP. DBA intends to redo DG and applied for
8 hours in the evening, because data
You can use SQL statements to add and delete modify fields, perform basic operations on tables and fields, and perform database backup. For more information, see.
You can use SQL statements to add and delete modify fields, perform basic operations on tables and fields, and perform database backup. For more information,
The mysqldump command creates a logical backup, and the result set has two formats: one is to convert data into standard SQL statements (a bunch of CREATE, DROP, INSERT, and other statements ), the other is
The mysqldump command creates a logical backup, and the result set has two formats: one is to convert data into standard SQL statements (a bunch of CREATE, DROP, INSERT, and other statements ), the other
SVN directory use case:A team plans to develop a "Mo Mo" projectPart of the base code is already in the early stages of this projectResearch and development team in this basic code after 3 months of effort, developed a relatively complete V1.0 version of the launch promotion, and achieved good results (backup to tags)As the market feedback was good, the team began to work on the development of the V2.0 vers
When you use mysqldump to back up MySQL, the backup file is a text file in SQL format, consisting of a series of CREATE TABLE and INSERT statements. When recovering, just use the SQL file as input to the MySQL program, as follows:
Mysqldump mydb mytbl > Mytbl.sql
MySQL MyDB
Note: Do not attempt to load the backup f
in the data directory of hostb MySQL.
Refresh the phpMyAdmin of hostb and check the database list. We can see that Testa has appeared, and the query and modification operations are normal. The Backup recovery is successful.
Test conclusion: MySQL databases can be stored in the form of files, backup, recovery as long as the corresponding file directory can be restored, no need to
Using mysqlworkbench graphical backup to restore mysql database bitsCN.com this article briefly introduces a simple and easy-to-use graphical interface to back up and restore the mysql database. It is helpful for friends who do not like to use command lines.
Workbench is a visual mysql tool developed by mysql AB. it is a good tool for users who are accustomed to
[2]: No standby redo logfiles of size 1024000 blocks existMon Dec 10:05:55 CST 2014Media Recovery Log +data/zhglptdg/archivelog/1_23095_790186477.dbfMedia Recovery waiting for thread 1 sequence 23096 (in transit)Mon Dec 10:05:57 CST 2014RFS[2]: Archived Log: ' +data/lixora/archivelog/1_23096_790186477.dbf 'Primary database is in MAXIMUM performance modeRFS[2]: No standby redo logfiles of size 1024000 blocks existMon Dec 10:06:00 CST 2014Media Recovery Log +data/lixora/archivelog/1_23096_79018647
--defaults-file=/etc/my.cnf--host=127.0.0.1-port=3306--user=root--password=123456--no-timestamp-- Incremental/data/mysqlbak/2015.sql1717-zengliang--incremental-basedir=/data/mysqlbak/2015.sql1717333795Parameter description:–incremental Specify the destination directory where the incremental backup resides–incremental-basedir= Specifying a full backup directory# You can also make incremental backups on a ful
Saying "Not afraid of 10,000, just in case," the data stored in the computer system, regardless of the security measures taken, are likely to encounter unexpected attacks and accidental damage or loss, and damage or loss of important data content once can not be found back, the resulting loss may be fatal. In view of this, the Windows system has built up the data backup, restore functionality early, and in the Windows 7 system environment, the data
Myth #27: Use Backup ... With checksum can replace DBCC CheckDB
Error
At first glance, because backup with checksum detects the value of the checksum for all assigned pages, this myth seems to be the case, but it's not really the case, for the following reasons:
The database page checksums that was raised by SQL Server 2000 or earlier must be turned on. After it
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.