restore mongodb from backup

-fullback-$(date +%F).sql2. View the binary log Restore time:--flush-logs, here as long as the view from the beginning of the file can be, each time after scrolling from 154 onwards, there are 4,123 two operations, 4 rollback, 123 is an empty commandChange MASTER to master_log_file= ' master-bin.000023 ', master_log_pos=154; 3. Export Binary Log[[emailprotected] data]# cp /www/data/mysql/log-bin/master-bin.00002{3,4} ./[[emailprotected]

, ' Test 001 '), (2, ' Test 002 '), (4, ' Test 004 '), (5, ' Test 005 '); UNLOCK TABLES; "Specify Character Set backup (export) when backing up" "This will not be garbled when checking the exported database, the specified character set is the character set of the database table""Restore the backed up data while checking the recovered data"[Email protected]/]# mysql-uroot-poldboy123 Oldboy "plus-b

This article illustrates the simple way to backup and restore MySQL in PHP. Share to everyone for your reference, specific as follows: First, Backup: Two, restore More about PHP Interested readers can view the site topics: "PHP based on PDO Operation Database Skills Summary", "PHP+

----------Full Backup------------Full backup--Backup Database StudbTo disk= ' E:\stu.bak '--Log backup--Backup LOG StudbTo disk= ' E:\stu_log.bak 'Use masterGo--Restore the full backup

based on the incremental backup that has been created for the first time (the--incremental-basedir points to the backup, which is a differential backup)[Email protected] ~]# Innobackupex--defaults-file=/etc/my.cnf--user=backup--password=backuppassword--incremental /data/incremental/--incremental-basedir=/data/incremen

Environment:160G Hard disk 2 blocks, one of which is the system disk, another piece of spare , 40G hard disk, used to store the backup system files. Hdiska:160GB, system tray hdiskb:160gbHDISKC:40GB, Storage System backup img FileServer PE ISO file.To achieve the purpose: the system disk from the Hdiska backup to the img file to HDISKC storage, and then the syste

Easy Number one-click Restore software Backup options How to operate? Many users will use the easy number of a key to restore the software to back up the system , because the software will be based on the use of computer hard disk, will automatically set the optimal parameters. Of course, I can also modify these parameters themselves, where to modify it? The foll

Tags: value type in file equals system disk FOREIGN KEY constraint UID logical differenceIn the software testing, the database is the necessary knowledge, holiday busy stealing busy, organized a little study notes, and discuss together.Read CatalogueBasic knowledge History of Database Database nouns SQL composition Basic operations Log on to database operations Database Remote Connection operation Database Detach operation Database offline, online op

Backup and restore are most important when you are transporting a database. Today, we tested backup and restore using Pg_dumpall. Backup Restore method: Pg_dump and Pg_restore, first carefully explain these two commands Back up

Else Begin Select Top * * FROM News End Executive: Exec procnewsinsert ' 2009-05-10 11:36:43.810 ' Results: 15. Triggers A trigger is a special kind of stored procedure, which is the same as an event when the data is added, deleted, and changed at the same time. Create a new trigger: Script to write: EG1: Create Trigger Trigcategorydelete On Category After delete/* There are three kinds of insert,delete,update*/ As Begin SELECT * FROM deleted/* Delete the contents after deletion * * End GO P

Transferred from: http://blog.csdn.net/sunnylgz/article/details/8055315Before using Ubuntu, I believe many people have experienced the use of Windows systems. If you've backed up your Windows system, you must remember that you first need to find a backup tool (usually private software) and then restart your computer to the software environment provided by the Backup utility where you can back up or

Tags: Shell database backup restore #!/bin/bash #初始数据库文件放在/soft Directory, the backup database file is placed in the/tzxdb/backup/directory sif-stop echo "Stopping application, please wait 1 minutes" sleep60 dbname=$ (su-db2inst1-c "db2listdbdirectory" |sed-n "10p" |awk ' {print$5} ' |awk-f '/' ' {print$3} ') #获取数据库名

Before using Ubuntu, I believe many people have experienced the use of Windows systems. If you've backed up your Windows system, you must remember that you first need to find a backup tool (usually private software) and then restart your computer to the software environment provided by the Backup utility where you can back up or restore your Windows system. Norto

Most system administrators have used a single key restore. Indeed, a single key backup and restore can help the administrator recover the questionable operating system in the shortest time content. You can also configure multiple restore points for the operating system. But then a key

The purpose of this paper is to record the backup and restore of Linux system in command line mode, although there are many kinds of backup methods, but this article only records the simplest and most rude one:First become the root user:$ sudo suThen go to the root of the filesystem (of course, if you don't want to back up the entire file system, you can also go

MySQL Data backup and restore MySQL Data backup and restore Data backup Mysqldump Backup Copy this database directory directly

Tags: back boot zip2 dir must enter a style a lotBefore using Ubuntu, I believe many people have experienced the use of Windows systems. If you've backed up your Windows system, you must remember that you first need to find a backup tool (usually private software) and then restart your computer to the software environment provided by the Backup utility where you can back up or

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

Backup | programs | recovery adaptive Server Anywhere (ASA in this article) is a database management system that is PowerBuilder (Pb in this paper) and can be used as a database server for small application systems. And the backup/restore of the database is a basic work, can you do it in just a few minutes to complete the writing of this kind of program? This a

As long as there is a valid backup, it is easier to recover the SYSTEM tablespace data file loss fault. The most basic physical backup is used to restore the loss of the SYSTEM tablespace. As long as there is a valid backup, it is easier to recover the SYSTEM tablespace data file loss fault. The most basic physical