Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Use innobackupex full realization of MySQL hot backup     - KUbuntu / Ubuntu 14.04 (downgrade) installed SVN 1.7 (Linux)

- Create several practical points of high security PHP site (Linux)

- Oracle database physical file backup / restore (Database)

- To install Ganglia (Linux)

- CentOS installed JDK8 (Linux)

- Linux iptables port mapping settings (Server)

- Selection sort, insertion sort, and Shell sort (Programming)

- Oracle Database import and export combat (Database)

- Ubuntu Linux installation GAMIT10.6 (Linux)

- Java to achieve local fileCopy (Programming)

- Security Knowledge: redirection command application security (Linux)

- About Nginx 7 (Server)

- How to download video youtube-dl in Linux (Linux)

- Use the TC flow control test under Linux (Linux)

- HTML5 postMessage cross-domain data exchange (Programming)

- To install and use Docker under linux (Server)

- How LUKS encrypted disk / partition to perform remote incremental backup (Linux)

- C # using the HttpClient Note: Preheat the long connection (Programming)

- Redis-- persistence articles (Database)

- DIY security of Linux platform (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.
- RHEL7 unattended automatic installation DHCP + TFTP + SYSLINUX + TFTP + Kickstart (Linux)
- Using 30 seconds to write a detailed analysis of garbage removal system (Linux)
- Linux - use chroot command (Linux)
- Ubuntu 14.10 Apache installation and configuration (Server)
- ImageMagick Tutorial: How to cut images in Linux command line (Linux)
- Android judgment toward camera pictures (Programming)
- Sorting algorithm of dichotomy (binary) insertion sort algorithm (Programming)
- 8 Git tips (Linux)
- How to use the internal network IP forwarding to connect to the Internet on Linux (Linux)
- 12 novice Linux command must learn (Linux)
- C # socket udp broadcast (Programming)
- Bootstrap 3.3.5 release download, Web front-end UI framework (Linux)
- How to create a someone project on github (Linux)
- Shell scripts quickly deploy Tomcat project (Server)
- VirtualBox virtual machine to install Linux (Linux)
- jQuery update the content and method of use 3.0 (Programming)
- The array of C language (Programming)
- Getting Started with Linux system to learn: how to use tcpdump to capture TCP SYN, ACK and FIN packets (Linux)
- To install Ganglia configuration of experience under CentOS 5.5 (Linux)
- Using RAID in Linux: Create a RAID 5 (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.