Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Achieve single backup of MySQL by innobackupex     - Oracle 11g modify MEMORY_TARGET (Database)

- Articles do not resolve after opening under Ubuntu WordPress setting a fixed link (Server)

- Oracle RAC 10.2.0.5 upgrade to 11.2.0.4 problems encountered (Database)

- IPTABLES configuration steps under Linux (Linux)

- Android View event delivery (Programming)

- Ubuntu 14.10 installation GNOME 3.14 (Linux)

- Ubucompilator-Ubuntu, Debian, Linux Mint created deb package of graphical tools (Linux)

- CentOS 7 RHEL 7 to reset the root password (Linux)

- Variables Python variables (Programming)

- Linux uses the SMTP proxy to send mail (Linux)

- Install and configure GO 1.2.1 under CentOS 6.5 (Linux)

- Four IDS intrusion detection tool under Linux environment (Linux)

- Configuring automatic mail GAMIT under CentOS system (Linux)

- Use Makeself Create installation file (Linux)

- Linux startup and logon security settings (Linux)

- Linux for enterprises to build a firewall (Linux)

- Android SDK Manager can not update the domestic solutions (Linux)

- C ++ complex class of operator overloading (Programming)

- Use Epoll develop high-performance application server on Linux (Server)

- Manually create Oracle Database Explanations (Database)

 
         
  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:      
 
- Depth understanding of the use of Spring Redis (Programming)
- Java threads in the life cycle (Programming)
- Android Custom View step (Programming)
- RHEL5.x RHEL6.x replace CentOS yum source (Linux)
- Installation and configuration of Hadoop under Linux (Server)
- MySQL dual master configuration (Database)
- Ubuntu download install and configure Plank Dock (Linux)
- I like Linux Security (Linux)
- Bash variable expansion modifier (Programming)
- There is sort of a directed acyclic graph topology (Programming)
- Archlinux installation tutorial (Linux)
- Oracle SQL statement to retrieve data paging table (Database)
- Spacewalk Linux system configuration and installation (Linux)
- Role Object of registerNatives () method (Programming)
- System Security: Build Linux with LIDS steel castle (Linux)
- Ubuntu 15.04 installation Powercommands 2.0 (Linux)
- How to use the Linux command compress JPEG images (Linux)
- To protect the temporary files for Linux security (Linux)
- Android webView URL redirects affect goBack () (Programming)
- Kali Linux virtualbox rc = Error 1908 workaround (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.