, the end of English), don't fall down
The code is as follows
Copy Code
#cmake.
7, installation
The code is as follows
Copy Code
#make#make Install
The installation is complete.
Simple backup-recovery test
Backup
The code is as follows
Copy Code
Mydumper–kill-long-queries-u root-b dbname-t db-tables-
time on 16-Jan-2008. I cocould use the following query to display the files I need to restore in sequence:
Select B. physical_device_name, A. backup_set_id, B. family_sequence_number, A. Position, A. backup_start_date, A. backup_finish_dateFrom MSDB .. backupsetInner join MSDB .. backupmediafamily B on A. media_set_id = B. media_set_idWhere a. database_name = 'adventureworks'And a. type = 'l'And a. backup_start_date> '10-Jan-2007'And a. back
The scope of this article: a comprehensive description of MySQL database operations, divided into virtual host and server two situations.
Virtual Host
1, through the phpMyAdmin import and export function, this software generally only supports the export of several megabytes of data, too large data may time out.
2, through the program with the database backup restore function to operate, some common PHP p
Steps to manually back up the registry in XP
Click Start, click Run, type%systemroot%system32restorerstrui.exe, and then click OK.
On the Welcome to the System Restore page, click Create a restore point, and then click Next.
On the Create a Restore Point page, type the restore point name, and then click Create
Wh
DNS server is responsible for the work of domain name resolution, its importance is self-evident. If there is a problem with the DNS server in the network or if the information data is lost, the server will not be able to complete the domain name parsing work. Therefore, you usually want to back up the data information of the DNS server frequently. When a DNS server fails, it is convenient to use backup files to quickly
user revokes the specified user's database permissions, the user can still connect to the MySQL server after revoking permissions, but the corresponding database operation is forbidden, the statement format is as follows:Revoke permissions list on database name. Table name from user name @ Source AddressFor more information on MySQL statements, refer to the MySQL online reference manualBackup and recovery of databaseMySQL backup can be used in many w
Method One:
With restore point recovery, you need to turn on system protection or create your own system restore points.
Tap the keyboard F11 key at the time of power-on, enter one key to restore, the steps are as follows:
Click Next,
Then choose your own account information, if you have the password type the system password, no password dire
1, modify the Rman configuration, can recover to 7 days of any point in timeSu-oracleRman Target/Configure retention policy to recovery windows of 7 days;Show All;2. Create backup database and archive log Rman script Online_database_archivelog.rman#创建备份目录Mkdir-pv/backup/oraclebk/databaseMkdir-pv/backup/oraclebk/archivelogChown-r Oracle.oinstallSu-oraclemkdir scri
Using mysqlworkbench graphical backup to restore mysql database bitsCN.com this article briefly introduces a simple and easy-to-use graphical interface to back up and restore the mysql database. It is helpful for friends who do not like to use command lines.
Workbench is a visual mysql tool developed by mysql AB. it is a good tool for users who are accustomed to
Today, a pgsql backup restore, almost no success, used to take for granted, did not seriously think behind the things, nor the process of the doubt to record, so there is no impression, common often new, this time since the meeting on the summary.Before the operation of the Pgsql database is mostly with the Navicat tool, but the first two with its backup to
Backup | reference | reference Manual | recovery | data | database | Chinese InnoDB Chinese Reference Manual---canine (heart sail) Translation 6 backup and restore InnoDB database
Secure database management is the use of regular data backups.
InnoDB Hot Backup is an online backup
protected] 2017-10-15_20-33-07]# MV chenfeng.tar.gz/data/backup/bak/Decompression to do recovery by:When recovering data, go through prepare (recovery) and restore two steps,Prepare export Table steps:[Email protected] backup]# Innobackupex--defaults-file=/etc/my.cnf--user=root--password=dsf0723-s/tmp/ Mysql.sock--apply-log--export/data/
MySQL Backup Restore methodMySQL backup and restore we typically do this by backing up the database on a live MySQL database (typically a Linux system) (typically dozens of g to hundreds of grams) to a Windows machine, Then go to the company and restore the files on the Wind
When the database file is too large, the data is partitioned, that is, the database is split into multiple filegroups. has been convenient data file management, improve the reading efficiency of the database, how to backup and restore the database of multi-file group, today, mainly long file group database backup and restore
, one or more files are generated.
Mysql-bin.000002 files store the data that is added to the database every day, where the incremental data of all databases is located.
3. check what is in a file like a mysql-bin.000002
[Root @ BlackGhost mysql] # mysqlbinlog/var/lib/mysql/mysql-bin.000002 gt;/tmp/add. SQL
An important index file is mysql-bin.index.
Java code
[Root @ BlackGhost mysql] # cat mysql-bin.index./mysql-bin.000001./mysql-bin.000002./mysql-bin.000003./mysql-bin.000004./mysql-bin
|| Wp_usermeta || Wp_users |+-----------------------+Rows in Set (0.01 sec2. Restore the database with the source command, as long as you have access to MySQL consoleMysql> mysql> Source/server/bak/wordpress.sqlQuery OK, 0 rows Affected (0.00 sec)3. Restore the database. If you are backing up the database with the-b parameter. You can not specify a databaseMysql-uroot-pmybaby99 >/server/bak/xxx.sqlthree. m
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.