dot "." And backup. sh.
8. when preparing for backup, run the "ls-l (or ll)" command to check the current directory. At this time, there should be several files: alterbackup. sh, begin. sh, database. script, gzip. sh, startup. script.
After that, execute the following command:
$ Chmod + x begin. sh
If everything is done, you can execute begin. sh to complete the backup
Tags: web site mysql server databaseThe main way of MySQL backup is to use mysqldump for logical export backup, mysqldump is a tool that comes with MySQL serverAdvantages:Simple to use; backup generates a file format in SQL script format.Disadvantages:The results of the expo
runFLUSH TABLES WITH READ LOCKNote-this command may take a while to complete if you have long running queries. the catch here is flush tables with read lock actually waits for all statements to complete, even selects. so be careful if you have any long running queries. if you're using only Innodb tables and do not need to synchronize binary log position with backup you can skip this step.
1) connect to MySQL and runFLUSH TABLES WITH READ LOCKNote: If
normal mode. In addition, running Startup Repair initiates system repair and runs system image recovery to recover from a backed up system image. What needs to be explained is that Vista also enables System Restore offline, but it needs to use the Vista system Setup disk to boot the system into the System Recovery options console. The installation disk is not required in Windows 7 because Windows 7 has integrated it into the system. 2, free custom
You only need to run begin. Sh each time you need a backup. Here, you can also use crontab to automatically back up data as planned. For details about how to use crontab, refer to relevant information or query it online. This article will not introduce it any more.
Using this method for physical backup not only backs
Use RMAN Incremental backup to update the transmitted tablespace
To use RMAN Incremental backup to update the transmitted tablespace, you need to understand the Incremental backup of the transmitted tablespace and RMAN. Here we will mainly introduce how to
Use Case of MySQL quick backup tool XtraBackup in production environment
There are many ways to back up MySQL. The most common method is MySQLdump. Export the database to an SQL file. When restoring, source db. SQL is executed happily. Our friends happily put on a shell script with cron, and happily watched the generation of backup files every day, feeling safe.
. Saving disk space and network bandwidth
4. Automatic Backup Verification
5. high-availability rows due to rapid restoration
As mentioned above, I believe it, or the database with more than 6 GB, and it takes 5 minutes to restore the database. Remember, if you restore Data Using backup for a few hours, the boss will have an idea! Haha.
Operating System: CentOS release 6.5
MySQL: 5.6.21
I. Installation
Yum
The reason for this error is that there is a database in your database server with the same name!RESTORE DATABASE [student] from DISK = N ' g:\ backup files ' with file = 1, move n ' student ' to n ' G:\student.mdf ', move n ' Studen T_log ' to N ' g:\\student.ldf ', nounload,replace, STATS = ten, PASSWORD = ' 123456 'So add REPLACE or STOPAT after with to restore! But the database with the same name may be overwritten!MSSQL-The log tail of the databa
Tags: mysql mysql enterprise backupHow to use Mysql:mysql Enterprise BackupFor MySQL hot spares use the most should xtrabackup tools,But this tool does not have a window version, just our company those wonderful to put MySQLInstalled on the window, the first time using the mysqldump backup has no effect on the system,After a large amount of data, the estimation s
; CREATE USER ' bkpuser ' @ ' localhost ' identified by ' S3cret '; Mysql> REVOKE all privileges, GRANT OPTION from ' Bkpuser '; Mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT on *. * to ' bkpuser ' @ ' localhost '; mysql> FLUSH privileges; When you use a Innobakupex backup, it calls Xtrabackup back up all InnoDB tables, copies all related files (. frm) about the table structure definition, and relat
Use backupninja to customize backup plans for Debian
Backupninja is a powerful and highly configurable backup software in the Debian system (as well as the Debian-based release. In the previous article, we discussed how to install backupninja and how to configure and execute two backup operations. However, those are ju
For the system, we can have a lot of ways to back up (restore) the system or file, the reason is to do the backup, is to be in the system or file damage, the timely recovery, reduce the loss to a minimum. Of course, the importance of backup is important for enterprise servers. Let's discuss in detail today how to use dump and restore for
. We can see that the steps described above are used for backup when plus archivelog is used.
RMAN> Backup Database Plus archivelog
2> Format '/u01/APP/Oracle/rmanbak/LG _ % d _ % U' Delete input;
6. backup flash back area
RMAN> Backup recovery area;
When the Backup
specified, default is 4) dump thread START TRANSACTION with consistent SNAPSHOT; Open read the same thing dump NON-INNODB tables, first export the main table of the non-things engine UNLOCK tables and things engine backup, release the global read-only lock dump InnoDB tables, based on things to export InnoDB table things knot Beam
Backup generated files All of the back
Use rsync and crond servers for WEB Service backup, rsynccrondBack up WEB services using rsync and crond serversScenario:A company has a Web server. The data in the server is very important, but if the hard disk breaks down, the data will be lost.Now the leaders ask you to back up data on other machines. The requirements are as follows:At every night, package the backup
of database backup;
Host address and Port: The user can fill in the database host address and database connection port;
Database account, Password: Users need to fill in the database required to use the account and password, the proposed completion of the account, password fill, click the "Test Account" for inspection;
Database name: The system automatically obtains all the database name, the user may f
' S3cret ';mysql> REVOKE all privileges, GRANT OPTION from ' BKP User ';mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT on *. * to ' bkpuser ' @ ' localhost ';mysql> FLUSH privileges;When you use a Innobakupex backup, it calls Xtrabackup back up all InnoDB tables, copies all related files (. frm) about the table structure definition, and related files for the MyISAM, MERGE, CSV, and archive tables. Fi
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.