Tags: java ee mysql automatic backupI believe many friends have experienced database problems, I also (see my previous blog: phpMyAdmin mistakenly deleted the recovery process after the table (the courage to jump AH)). If the data is large or important, it is very difficult to recover, so when we are doing a relatively perfect system, the backup/restore function of the database is essential. This article wi
Tags: server table LVM snapshot successfully install Mys ble resource ossOn a mariadb of several replication models, this time lost a few MARAIDB common backup recovery simulation bar.Backup related knowledge why to back upBackup is mainly used to deal with the following situations: disaster recovery, hardware failure, software failure, natural disaster, xxx malicious xxx, human error caused by the damage of data and so on.The focus of the
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
; or rman> SQL ' alter system switch logfile ';View archive Log:rman> list archivelog all;View Backup archive Log:rman> list backup of Archivelog all;Recover archive Log:rman> restore Archivelog sequence between 1 and 9; Determine the range of sequence to be recovered based on the results viewedTo clear redundant archive logs:First manually remove the archived lo
number: Used to specify the access port, you can use-p 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.htmlCurrently, 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:
" 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
, Xtrabackup, xtrabackup_51 tools to/usr/bin Cp/usr/local/percona-xtrabackup-2.1.5-680-linux-x86_64/bin /innobackupex/usr/bin/innobackupex Cp/usr/local/percona-xtrabackup-2.1.5-680-linux-x86_64/bin/xtrabackup/usr/bi N/xtrabackup cp/usr/local/percona-xtrabackup-2.1.5-680-linux-x86_64/bin/xtrabackup_55/usr/bin/xtrabackup_55 4. BackupThe backup that needs to be described is for the instance, not for a database/innobackupex--user=root--password=123456--de
1, the mobile phone connected to the computer, open Tai Chi brush Master, select "Backup Restore"-> "itunes backup"
2, itunes contains two types of backup, you can choose whether to back up the mobile phone application data (backup application data for a long time, l
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
"show databases;" | Sed ' 2,4p 'Do$MYDUMP $database >/back/${database}_$ (date +%f). sql.gzDoneNote: When there is extra content behind the variable, use the {} number, for example: ${dbnamel}_back.sql.gzSub-table Backup:#!/bin/bashUser=rootpasswd=123456Mysqlcmd= "MYSQL-U$USER-P$PASSWD"mydump= "MYSQLDUMP-U$USER-P$PASSWD"For database in ' $MYSQLCMD-e ' show databases; "| Egrep-v "Database|information_schema|mysql"DoFor tables in ' $MYSQLCMD-e ' show t
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
Linux manual backup restore HDD Master boot record MBR with hard disk partition Table DPT Tutorialtwo Cow Linux, Ubuntu, Windows 1,885 views View comments Recently cows have been tossing Linux grub and GRUB2, because the former ghost restore Windows when the error occurred, causing the partition table is destroyed, unable to enter the system. Today we are going
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 path to the Unix domain socket. The default is obtained from the PGHOST environment variable, if the environment variable is set, otherwise, try a Unix domain socket connection.-P Port--port=portDeclares that the server is listening and waits for a joined TCP port or a local Unix master socket file handle. The default is to use the value of the environment variable PGPORT, if one exists, or the default value at compile time.-u usernameTo give a user identity join.-WForce a password prompt.
starting the database the first time after the restore. At the same time, the archive mode also supports non-archive cold standby recovery methods.2) system Tablespace is lost in archive mode (can support single data file loss recovery):A, Shutdow shut down the machineB. Take back the backup file back to the data file locationC, StartupD, recover datafile 1;recover tablespace system;recover database;E, ALT
--stop-datetime= ' 20161129 09:59:59 '/var/log/mysql/mysqlbin.000033 |mysql-uroot-pB. Skip the point in time of the failure, and continue with the subsequent binlog to complete the recovery.shell> mysqlbinlog--start-datetime= ' 20161129 10:01:00 '/var/log/mysql/mysqlbin.000033 |mysql-uroot-p2) Location-based recoveryis similar to a point-in-time recovery, but more precise because multiple SQL statements may be executed simultaneously at the same point in time. The following actions are restored:
Scenario Description:
A friend asked, ms SQL server will back up the database to restore to other machines is very convenient, basically is a silly operation, Oracle control files, parameter files a bunch of things, I think the restoration is very complicated; otherwise, I took some time to give a simple demonstration of the case. For more information, see! To make it simple and fast, I use RMAN for backup
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
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.