Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Achieve single backup of MySQL by innobackupex     - Linux ban single-user mode to enhance system security (Linux)

- Manually compile Hadoop 2.6.0 under Ubuntu 14.04 (Server)

- Oracle restrict certain IP, the malicious user actions on important table (Database)

- Open MySQL slow query log (Database)

- Ubuntu 14.10 used ifconfig commands to manage your network configuration (Linux)

- Configuration OpenOCD + FT2232 under Ubuntu (Linux)

- Linux / Centos anti CC attack script (Linux)

- Oracle 11g Export guide problem not an empty table (Database)

- Java Learning: elegant string (Programming)

- Linux server startup and logon security settings (Linux)

- The compiler installed Kaldi under Ubuntu 12.04 (Linux)

- Configuring the remote Linux server SSH key authentication to automatically login in Mac OS X (Server)

- How to clean up your Ubuntu 14.10 / 14.04 / 13.10 system (Linux)

- Intruder tools Knark Analysis and Prevention Linux environment (Linux)

- Linux scp remote file copy (Linux)

- Vagrant build LNMP environment (Server)

- DataGuard add temporary data files bug (Database)

- Sudo and Root Account in Ubuntu related (Linux)

- Firewall types and instructions (Linux)

- Linux non-graphical interface to install Oracle Database (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:      
 
- Talk about Java in the collection (Programming)
- Paint with Vim (Linux)
- Win8 mount disk partitions under Ubuntu (Linux)
- Linux platform host to prevent hacking skills (Linux)
- Servlet 3.0 interfaces of AsyncListener (Programming)
- Depth understanding of the use of Spring Redis (Programming)
- Linux Oracle environment variable is invalid Problem Solving (Database)
- Oracle data row split multiple lines (Database)
- Create a DLL using MinGW and Attention (Programming)
- How to override the plain text files and directories soft connection in linux (Linux)
- MongoDB 3.2 Cluster Setup (Database)
- How do you change the default browser and Email Client in Ubuntu (Linux)
- MySQL database under Linux to achieve automatic backup scheduled backup day (Database)
- Use DB2 federated access Oracle (Database)
- Swift string common method (Programming)
- How to make GRub instead of the default Ubuntu software center (Linux)
- PostgreSQL query lock and kill the process (Database)
- Ubuntu program using the Sound Recorder (Linux)
- RedHat6.4 installation tutorial --- Minimal Edition (Linux)
- redis configuration in detail (English) (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.