the MyData container, such as:DB1 Mount
[Root@localhost ~]# Docker run-it--volumes-from mydata--name db1 Debianroot@9a42647f5a2d:/# Cat Mydata1/data.txt2016-09-01-04:14:35root@9a42647f5a2d:/#
DB2 Mount
[Root@localhost ~]# Docker run-it--volumes-from mydata--name DB2 Debianroot@8f7738f2f159:/# Cat Mydata1/data.txt2016-09-01-04:14:35root@8f7738f2f159:/#At this point, no matter where the modification will be synchronized, of course, you can also use the--volumes-from parameter multiple times to
MySQL mysqldump data backup and mysqlmysqldump1. mysqldump command tool description
Parameter annotation: mysqldump adopts an SQL-level backup mechanism. It imports data tables into SQL script files and is suitable for upgrading between different MySQL versions. This is also the most common
1, the Linux system needs to back up the data/root/Directory:/home/directory:/var/spool/mail/directory:/etc/Directory: Other directories:2, the installation of services dataData that Apache needs to back upconfiguration files, Web page home directories, log filesMySQL needs to back up the data = Source Package installed mysql:/usr/local/mysql/data/RPM Package Ins
several log files with different extensions named mysqllog.
Binlog-do-db = backup # specify the database for logs
Restart database service
Use the show master status command to view the logs.
B is slave
Modify the my. ini file of mysql B. Add the following configuration to the mysqld configuration item:
Server-id = 2
Master-host = 10.10.10.22
Master-user = backup # synchronize user accounts
Master
BCP is generally stored in the BIN directory of the installed ASE or Open Client. For ASE earlier than version 12, the bcp directory is $ SYBASE/bin, and for Versions later than Version 12 (including version 12), the directory is $ SYBASE/OCS-12_x/bin. $ SYBASE is the SYBASE installation directory. 12_x represents versions 12.0 and 12.5 and is displayed as 12_0 or 12_5. the executable file name is bcp. EXE.
The parameter list is as follows:(Available bcp-available)
Usage: bcp [[database_name.] o
Guide: Today's Baidu Cloud disk free capacity is 2 T, even if the computer all the stuff on the put up, there are plenty of space left. For the webmaster, is fully able to make full use of these hard disk space, now we use Baidu Cloud disk to back up the data on the Linux server. have been thinking, if the Baidu Cloud disk support FTP is good, you can implement the Linux scheduled backup
received, re-reads the memory snapshot file from master, rebuilds the entire memory table data structure, and the final state is set to the redis_repl_connected state. Slave state machine flow is completed;
The master side in the process of sending the snapshot file, any command that changes the data set will be temporarily saved in the slave network connection of the Send cache queue joins (list
Step one Select the Backup Function button in the menu bar of the Navicat interface.
Navicat Backup: Backup button
Step two, click the "New Backup" button in the navigation bar.
Navicat Backup: New Backup button
Step three
mysqldump It is recommended to use data below 10g for backup, which is a logical backup of MySQL databasemysqldump instruction-A all tables-all-databases-b--databases db1 DB2 ...: Back up the specified libraries while creating the library (cannot be used with A)-X lock table--lock-all-tables pleaseTo lock all tables and then back up, do Win Bei--single-transactio
MySQL Big Data backup and incremental backup and restoreX The trabackup implementation is a physical backup, and is a physical hot standby There are currently two major tools available for physical heat preparation:ibbackup and xtrabackup ;ibbackup are expensive to authorize and xtrabackup is more powerful and open-s
Label:MySQL Learning Note 12: Data backup and RecoveryData backup 1. Physical Backup and logical backup Physical backup Physical backup is to copy the database
First, the basic introduction of rsync1. What is rsyncRsync is an open source, fast, multi-functional, incremental local goods remote data mirroring synchronous backup of excellent tools, rsync use and unix,linux,windows and other platforms2, the characteristics of rsync1) Support for copying special files2) can have exclude specified file or directory3) can maintain the original file or directory permissio
Data backup and restore1.mysqldump1.1 file Address :E:\xampp\mysql\binFile name: Mysqldump.exeCMD down into Mysqldump.exeCD E:\xampp_new\mysql\bin1.2 Call Mysqldump The ParametersMysqldump–u user Name [-H host] [-P password] database name [ table name table name] > path and file name to backup toBack up all tables for multiple databases:Mysqldump–u user Name [-H
We all know that Oracle 8.0 implements incremental Oracle backup only when relevant recovery management is introduced. Before RMAN, the output of the Oracle database can also be incrementally increased. However, once any part of a table changes, the entire table needs to be overwritten. RMAN Incremental Backup only needs to re-write the modified part in the given data
Method One, use 360 handset assistant to carry on the backup with the computer
1. First the computer online and then install 360 mobile phone Assistant in the computer, then the phone to be backed up using the data cable to connect the phone, and then click on the bottom right of the "Data Backup" button below.
2. In
Data can be effectively stored using the Huawei Switch configuration backup technology. The implementation of Huawei Switch configuration backup is a common problem. How can we implement the Huawei Switch configuration backup technology? Any related password issues will be fully resolved in this article.
The two
The original Article is from the previous article on the Internet, but there are some problems with the original storage process. This article has been verified and further corrected, and the backup date is automatically added when backup is added. The content of this article is as follows: backup processing Stored Procedure setANSI_NULLSONsetQUOTED_IDENTIFIERONg
file is saved as backup.sh, and two directories/olcbackup and/backup have been created in the system. Each time the backup.sh is executed, the files that begin with the/backup directory are moved to the/oldbackup directory.The execution plan for the above script is as follows:#crontab-E30 1 * * */backup.sh4,mysqldump full-volume backup +mysqlbinlog binary log In
In addition, rsync + inotify enables Real-time Data Backup
Advantages and disadvantages of rsync
Compared with traditional cp and tar backup methods, rsync has the advantages of high security, fast backup, and support for Incremental backup. rsync can meet the demand for
We back up some files to be retained during learning or entertainment. In order to solve the data disaster, we can find and process the files we need in time, so we should back up the data of the files. What we want to talk about today is how to back up data in Linux.
1. manual backup of local dataOn Linux, there is a
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.