adb full backup

Scenario: Perform a full backup every Sunday and perform an incremental backup 1 o'clock in the afternoon every day Configuration The prerequisite for performing an incremental backup is that MySQL opens the log-bin log switch, for example in My.ini or my.cnf Join Log-bin=/opt/data/mysql-bin The string after "log-

This article is mainly about how to use the shell to achieve a full amount of MySQL, incremental backup. Incremental backups are replicated mysql-bin.00000* to the specified directory at Monday-Saturday 3 o'clock in the morning, while full backups use mysqldump to export all of the databases, hold every Sunday 3 o'clock in the morning, and delete the mysq-bin.000

. mongoimport-d my_mongodb-c User User.datParameter description:-d indicates which library to use, in this case "My_mongodb"-C indicates the table to be exported, in this case "user"You can see that the table structure is created implicitly when importing data2. mongoexport-d my_mongodb-c user-o User.datParameter description:-d indicates which library to use, in this case "My_mongodb"-C indicates the table to be exported, in this case "user"-O indicates the name of the file to be exported, in th

Tags: blog http ar using SP file Data 2014 problemFirst of all, I want to explain that you must have a full database backup, the following restore tutorial, only useful, if other problems, please search other Daniel's solution, this method is only suitable for beginners.This connection is the webmaster adult's unusual recovery method, has the question to study http://www.cnblogs.com/dudu/archive/2011/10/15/

Tags: backup database backup database file integer database service database Name list select database ServerMaterial: one copy of the full backup database, a differential backup of the most recent backupNow it needs to be fully restored to another database server.First of a

Learn a few days of MySQL knowledge. Just get in touch with a command that is simply a grammar. But when there is a problem, I don't know where to begin. It is still not practical to find the relevant information on the Internet. So I began to summarize the backup and restore examples. This article is used by mysqldump. 2 case operations were performed. Of course two cases are very similar. The second one expands for the first one. If you figure out t

Mysql Backup Tools Xtraback full-volume and incremental testingXtrabackup is an open source project for Percona, can be hot backed up InnoDB, XtraDB, and MyISAM (Will lock the table)Official website Http://www.percona.com/docs/wiki/percona-xtrabackup:startXtrabackup is an open source software developed by Percona , which can be said to be an open source alternative to the InnoDB hot standby tool Ibbackup .

Tags: mysql backupI believe that many of the small partners will use the MySQL database, the following provides a script to share with gentlemen.#!/bin/bashscript_dir=$ (dirname)Backup_dir= "/data1/mysqlbackup"backup_days=480RM-RF ${backup_dir}/*db_ip= '/sbin/ifconfig-a|grep inet|grep-v 127.0.0.1|grep-v Inet6|awk ' {print $} ' |tr-d ' addr: ' |head-1 'Backup_type= ' Xtra_full 'For i in ' Ps-ef |grep port= |grep-v grep|cut-d "="-F 10 'Dodb_port= $iNew_dir= "/data1/mysqlbackup/${db_port}"If [-E "$

statements and Instert statements are used when restoring. You can create a table by using the CREATE statement in the data when you restore it. Use the INSERT statement to restore the data. It can implement a full server backup, or it can implement a single or partial database, a single or partial table, some rows in a table, stored procedures, stored functions, triggers, and automatically record the bina

Data backups are in the form of full backups, differential backups, and incremental backups, so what are the differences between these three types of backups, and how do you choose them in specific applications? This paper introduces these problems. A brief introduction of backup method 1. Full backup Backing up all se

[MySQL] innobackupex online backup and recovery (full and incremental) Xtrabackup is an open-source software developed by percona. It is the innodb Hot Backup Tool ibbackup (paid commercial software) is an open-source alternative. Xtrabackup consists of xtrabackup and innobackupex. The xtrabackup tool is used to back up innodb and xtra [MySQL] innobackupex online