[[emailprotected] mongodb]# mongorestore -d tank /home/zhangy/mongodb/tank/ #tank这个数据库的备份路径 [[emailprotected] mongodb]# mongorestore -d tank_new /home/zhangy/mongodb/tank/ #将tank还有tank_new数据库中
These two commands can be implemented to backup and restore the database, the file format is JSON and Bson. Unable to refer to a table backup or
definition file, the data file, the index file).Mysqlhotcopy can only be used for backup MyISAM.
Cases:
Back up the database test to the/backup directory:
/usr/local/mysql/bin/mysqlhotcopy-uroot-pxxx Test/backup
Mysqlhotcopy will lock the database before execution, and will automatically release the lock after completion
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
" hereinafter called for short) and the location the backup file has be put ("path" hereinafter called for short) and the archive filename of the backup ("name" hereinafter called for short)Run the script$/Usr/local/bin/untarbackup. Sh instance path nameE. g .:/Usr/local/bin/untarbackup. Sh idsinst/opt/backup 2009_mar_26.tar.gzThe script will mainly do three oper
Call the SQL statement to implement a backup restore of SQL Server, including full and differential backups, because it takes a certain amount of time to perform a backup restore, so you need to set the CommandTimeout parameter.
BACKUP DATABASE Call SQL statement
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
Evolution, is the Ubuntu system, after the installation of the mail client, can be used to collect mail (feel this sentence is nonsense ...) )。 Since many beginners, even under Windows, do not use client software to collect mail (minority ...). , this is the first time to write this Evolution, software configuration tutorial.After the Ubuntu system is installed, you can run it from the applications (application)-internet (Internet)-evolution Mail. As shown in figure: The first run, you will be a
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
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
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
How to make WIN8 system image backup?Win8.1 How to restore a system image backup?Although win8/win8.1 introduces a new system initialization feature, this feature is generally limited to branded computers. How does a normal user make a Win8 system image backup? Is the latest version of Win8.1 update possible to make a
instead;
--socket=socket file: Used to specify the socket file, you can use-s instead;
Mysqlhotcopy is not a MySQL-band, it needs to install Perl's database interface package; for: http://dev.mysql.com/downloads/dbi.html Currently, the tool is only able to back up tables of type MyISAM.Second, data restoration 1. The syntax for restoring a database backed up using the mysqldump command is as follows: Mysql-u root-p [dbname] Example: Mysql-u Root-p 2.
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
Tags: god represents file HTML common category name cat stringZhang Ying published in 2013-12-03 Category list: NoSQL Tags: mongodb, backup, import, export, restore MongoDB data backup and restore is mainly divided into two kinds, one is for the library of Mongodump and Mongorestore, one is for the table in the library
About MySQL Backup restore command operation, everything is done in cmd, not into MySQL command line**************************************************************Backup command: (command does not need to enter a password, enter the password will be considered the name of the database, password, etc. press ENTER will prompt input)Mysqldump-h localhost-u root-p Tes
One, the backup of SQL database :1. Open Start menu → program →microsoft SQL Server 2005→sql server Management Studio, here I use the umvtest named database to teach you backup features:2, select the database to be backed up "Umvtest", right click → tasks → backup,Second, SQL Restoring the database :1, select the database you want to
MySQL database backup and restore common commands are the key to the MySQL database backup and restore, no commands, nothing to do, not to mention what backup restore, only to the system this command, let it go to perform, in orde
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.