Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Use innobackupex full realization of MySQL hot backup     - Docker + Nginx + Tomcat7 simple load balancing configuration (Server)

- How VirtualBox and VMware virtual machine conversion (Linux)

- Basic Operation Linux files and directories (Linux)

- Linux system security reinforcement (Linux)

- ssh using scp: / directory: Permission denied (Server)

- Visual Studio Code experience (Linux)

- shell script: MySQL monitoring service is normal (Database)

- Linux Command Tutorial: cat command to view the contents of the file (Linux)

- Linux, how to filter, split, and merge pcap file (Linux)

- Java implementation linear table - represents the order of representation and chain (Programming)

- mysqldump issue a note (Database)

- Linux Network Programming - libnet Guide (Programming)

- C # function (Programming)

- Installation configuration CUDA under Ubuntu 14.04 (Linux)

- MongoDB collection data migration to MySQL database (Database)

- Android recyclerview cardview (Programming)

- Teach you how to ensure password security under the Linux operating system (Linux)

- xCAT line installation on CentOS 6.X (Linux)

- Command-line based tools for better alternatives (Linux)

- linux server security (Linux)

  Use innobackupex full realization of MySQL hot backup
  Add Date : 2017-04-13      

By innobackupex full realization of MySQL hot backup


OS: CentOS 6.6 32bit


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

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

# Create a directory to store the backup
mkdir / backup

# Starting the backup before the backup Make sure there is enough space.
innobackupex --password = RedHat / backup /
# This is the simplest usage of this command, because I was directly root user backup is omitted --user argument.
# Note that the password is entered here MySQL administrator password, make no mistake, oh.
# If you do not use the root user to back up, then you need to specify the --user argument.
# If your database is not the default configuration file /etc/my.cnf, then you need to use --defaults-file arguments.
# By default, the system automatically creates a timestamp with the current time as a named directory under your specified backup directory, if you want to name your own style, then you can use the --no-timesmtap argument on this parameter when, in the future it may appear in other chapters.
# Note that the best specified datadir in my.cnf file, otherwise when you use this command to back up you may need to use --datadir parameters, recovery is also the same reason, it is best to specify directly in the my.cnf.

After the backup is certainly good # To verify the effect of it (beginners do not take the production environment to test oh).
# To stop the database
service mysqld stop
# Clear the data directory (my data directory is / wwwroot / mysql), be careful not to delete the parent directory mysql.
rm -rf / wwwroot / mysql / *
# Prepare to enter the stage, watch out, here we must select the directory you just backup timestamp.
innobackupex --apply-log / backup / 2015-11-07_14-08-51 /
# Enter the recovery phase
innobackupex --copy-back / backup / 2015-11-07_14-08-51 /
# Authorization
chown -R mysql: mysql / wwwroot / mysql /
# Start Service
service mysqld start

Through the above operations to complete a full backup and restore.

Note that the data directory must be empty to do a complete restore, otherwise it will affect the results of the reduction.
- Linux kernel update error, update-initramfs: failed Solution (Linux)
- Shell command line operation (Linux)
- How to configure security management services under Linux (Linux)
- HTML5 postMessage cross-domain data exchange (Programming)
- CentOS 6.4 of cron scheduled task configuration (Linux)
- RHEL6.4 x86_64 build SVN service (Server)
- Linux network security probing tools Hping2 (Linux)
- Kali Linux virtualbox rc = Error 1908 workaround (Linux)
- Linux command in the dialog whiptail (Linux)
- VirtualBox modify the size of the virtual machine disk VDI (Linux)
- Machine Learning: Classification of the curse of dimensionality (Programming)
- Ubuntu 12.04 configure NVIDIA CUDA 5.5 Record (Linux)
- JDK comes with tools jinfo (Linux)
- Linux file and directory permissions settings (Linux)
- Hadoop 2.7.1 installation configuration based on availability QJM (Server)
- Linux CPU Monitoring Index (Linux)
- Using 30 seconds to write a detailed analysis of garbage removal system (Linux)
- How to use Linux to download music from Grooveshark (Linux)
- MongoDB 3.2 Cluster Setup (Database)
- Linux common commands ll namely ls -l --color = auto (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.