Previously introduced a small MySQL backup php script program, but it is not for MySQL shell permissions of the virtual host users, here want to talk about more common backup and restore methods, suitable for their own host friends.
1, about Backup: We use MySQL in the general use of MyISAM types of tables, which are
One, MongoDB Backup 1, mongodb backup backup data using the following command mongodump-h dbhost-d Dbname-o dbdirectory back up the user database [[email protected] bin]#. mongodump-h127.0.0.1-d User-o/home/[[email protected] bin]# Ls/home/user/b3.bson B3.metadata.json C1.bson c1.metadata.json# can see the backed up files 2, MongoDB single collection
1. Backup TypeDepending on whether the server is able to continue to provide services in the case of a backup: hot, warm, cold backup.Hot backup: Online, read, write not affected;Warm backup: Online, but can only perform read operations;Cold backup: Offline, read, write oper
Tags: MySQL backup restoreMySQL backup and restore one, data backup 1. How to Back up1) Full backup: Full backup of the database 2) Incremental backup: Files changed since the last
=# # Viewing from the specified event location--stop-position=# # displays only to the specified event location--start-datetime=yyyy-mm-dd hh:mm:ss # Viewing from a specified time--stop-datetime=yyyy-mm-dd hh:mm:ss # displays only to the specified timeIncremental backup vs. differential backup based on location (location according to your needs in the binary)[[Email protected]
protected]::wwwfiles to consider./ab100% 0.00kb/s 0:00:00 (2, 66.7% of 6)258 bytes received 95.43 bytes bytes/150995011 speedup is 452080.87Reference:Http://wangchujiang.com/linux-command/c/rsync.html (the above content is transferred from this article)Http://blog.csdn.net/zpf336/article/details/51659666 (example)https://my.oschina.net/jccpp/blog/124941 (example)http://davidbj.blog.51cto.com/4159484/1181388/(example)http://linuxcentos.blog.51cto.com/7176396/1213241 (example)https://yq.aliyun.co
perform the first step of exporting the empty table settings statement. --- Step two: Back up the database ---Start-run, enter CMD, enter BACKUP statement Exp userid=abc/[email protected] file=d:\01abc\ database backup \abc20160520.dmp log=d:\01abc\ database backup \abc20160520.log ---Description: Exp userid= username/password @net service name file= (
Manual steps for backing up the registry in Windows XP:
1. Click Start, click Run, type%systemroot%\system32\restore\rstrui.exe, and then click OK;2. On the Welcome to the System Restore page, click Create a restore point, and then click Next.3. On the Create a Restore Point page, type the name of the
Tags: restore technology Application log easy to use control file exp latest meaningBackupCold: shuts down the database and copies the database physical files.Hot- Standby: The database is in the open phase of the backup, through the instruction of the database file header lock, then the physical system copy, and then through the instructions to unfreeze the data file header, after thawing through the log f
MySQL backup and restore details under Centos 6.4We described in the previous article in CentOS 6.4 installation and configuration of MySQL, after installation in order to ensure the security of data so we also have to learn to back up and restore, backup and restore operati
This article summarizes how to restore iis backup (MetaBase. xml) after you reinstall the system.
MetaBase. xml is the IIS configuration file, which is automatically backed up every day.
I. IIS backup
1. In the IIS management unit on the local computer, right-click the computer icon under Internet Information Service.
2. Select "all tasks/
Label: A, MySQL Backup tool xtrabackup installation1. Percona the binary version of the official xtrabackup; The binary version is available for decompression. 2. Unzip Xtrabackup Create a connectionTar-XZVF percona-xtrabackup-2.3.4-linux-x86_64.Tar. gz-c/usr/local/LN-s/usr/local/percona-xtrabackup-2.3.4/usr/local/Xtrabackup3. Set the PATH environment variable export path=/usr/local/xtrabackup/bin/: $PATH B, create a user
GXPT is a distributed system, which temporarily includes the privilege system, the basic system, the evaluation system, the examination system, each system has its own Oracle database. Our group is responsible for the evaluation of the teaching system, and the normal needs of the evaluation system and the use of the system of authority and the basic system, the specific business here is not much explanation. The recent evaluation of teaching activities, the basic system in the basic library into
Tags: stat original alt OSC config IP address navicat a WindowsData software is using: SQL Server 20141. Version
Operating systems for new servers: Windows Server 2012
Server Software for new server: SQL Server 2014
Database management software:
SQL Server Management Studio
Navicat Premium
2.IP
If using the original IP: server operation is set to the original IP
If new IP: The profile IP address of each test cabinet is changed to a new IP
, ' 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
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
For the cold backup to restore the database can be rolled back to restore the problem, itpub forum on the relevant links in the http://www.itpub.net/showthread.php? S = threadid = 220971.Experiments show that cold backup and database restoration can be performed before rollback and recovery:The experiment process 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.