Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Achieve single backup of MySQL by innobackupex     - C ++ input and output summary _ Input (Programming)

- Analysis of common mistakes when compiling MySQL installation (Database)

- ethtool implementation framework and application in Linux (Linux)

- Summarize small problems encountered in the use Lua (Programming)

- CentOS 5.11 Open VNC access (Linux)

- Ubuntu method for single-card dual-IP (Linux)

- ActionContext and ServletActionContext Summary (Programming)

- Access clipboard content across multiple vim instances in a terminal (Linux)

- Linux System Getting Started Learning: hard disk partition, and to deal with traps (Linux)

- Linux, Oracle listen address modification (Database)

- Java data structures - the linear form of the single-chain applications (Programming)

- Ubuntu 15.04 and Ubuntu 14.04 installed Cinnamon 2.6 (Linux)

- To teach you how to safely send mail (Linux)

- Linux pwd command learning experience (Linux)

- Linux security settings Basics (Linux)

- Linux Basics Tutorial: Combining awk delete data before the specified date hdfs (Linux)

- CentOS6.5 setup Oracle 11gR2 startup (Database)

- C # and JavaScript arrays to re-summary (Programming)

- How to configure a development environment elegant Lua (Linux)

- Availability Hadoop platform - Oozie Workflow (Server)

 
         
  Achieve single backup of MySQL by innobackupex
     
  Add Date : 2018-11-21      
         
       
         
  Purpose

Achieve single backup of MySQL by innobackupex

surroundings

OS: CentOS 6.6 32bit

Introduction

Official website: https: //www.percona.com/

Official Download: https: //www.percona.com/downloads/XtraBackup/LATEST/

operating

# Start Backup
innobackupex --password = RedHat --databases = db1 / backup /
# Note: redhat is my MySQL root password, db1 is the database I want to back up, / backup / directory to store my backup (created in advance).
 
# Analog Recovery
# Out of service
service mysqld stop
# Clear the data directory (Note: / wwwroot / mysql / my data directory)
rm -rf / wwwroot / mysql / *
# Prepare to enter the stage
innobackupex --apply-log / backup / 2015-11-07_15-12-34 /
# Enter the recovery phase
innobackupex --copy-back / backup / 2015-11-07_15-12-34 /
# Initialize the database by mysql_install_db
cd / usr / local / webserver / mysql /
./scripts/mysql_install_db --user = mysql --datadir = / wwwroot / mysql /
# Authorization
chown -R mysql: mysql / wwwroot / mysql /
# Start Service
service mysqld start
# Initialize the root password (Note: redhat is my password)
mysqladmin -uroot password redhat

Through the above steps can be completed in one database backup, but I did not feel anything, because you want to back up or share the data source, that file is the biggest, so it was not as direct a full backup.
     
         
       
         
  More:      
 
- Extended use of the swap file swap space on Linux (Linux)
- C ++ virtual functions Classic Insights (Programming)
- CentOS 7.0 running Docker kernel error solution (Server)
- Proxmox VE implement KVM OpenVZ virtualization cloud computing (Server)
- RMAN backup file is much larger than the size of the database Cause Analysis (Database)
- Linux upgrade GCC 4.8.1 clear and concise tutorials (Ubuntu 12.04 64-bit version as an example) (Linux)
- Ubuntu Install OpenSSL (Linux)
- Use Epoll develop high-performance application server on Linux (Server)
- Monitor traffic Linux Shell Edition (Programming)
- Machine Learning: Classification of the curse of dimensionality (Programming)
- Java objects to garbage collection (Programming)
- Modify Linux terminal prompt path length (Linux)
- Linux FAQ - How to fix tar:Exitingwith failure status due to previous errors (Linux)
- Linux script commands - terminal recorder (Linux)
- Unetbootin make use U disk loading Linux system (Linux)
- RHEL / CentOS / Fedora Install Nagios 4.0.1 (Linux)
- SSH security note (Linux)
- Update GAMIT10.6 command (Linux)
- JavaScript property of checkbox.disabled (Programming)
- hadoop 2.7.1 High Availability Setup Deployment (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.