Linux backup mysql and Extract files (zip)

One requirement today is to back up mysql Data at every day. Because I don't know where the mysql installation directory is.

Pass:

 

[Root @ localhost root] # find/-name mysql-print
/Var/lib/mysql
/Var/lib/mysql
/Var/lock/subsys/mysql
/Etc/rc. d/init. d/mysql
/Etc/logrotate. d/mysql
/Usr/bin/mysql
/Usr/lib/mysql
/Usr/share/mysql
[Root @ localhost root] # find/usr-name mysqldump-print
/Usr/bin/mysqldump

Find the mysqldump path

Execute a shell file using vi beifen. sh on a regular basis.

/Usr/bin/mysqldump-u root-p test>/home/mysql/test. bak

Then add a task through crontab-e

* 2 *** beifen. sh

You can.

You can view all the files in the home directory using hl when checking the information on the Internet.

Originally, it was abbreviated as alias hl = 'LS-l/home.

Zip package file name. zip file to be pressurized

Zip-r compressed package file name. zip file to be pressurized

Unzip uncompress the package. Zip to the current directory

Unzip-Z file. Zip to view compressed files