编译安装mysql并写备份脚本加入定时任务.docVIP

# yum -y install make cmake gcc gcc-c+ gcc-g77 flex bison file libtool libtool-libs autoconf libjpeg libjpeg-devel libpng libpng-devel libpng10 libpng10-devel gd gd-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glib2 glib2-devel bzip2 bzip2-devel libevent libevent-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel vim-minimal nano fonts-chinese gettext gettext-devel ncurses-devel gmp-devel pspell-devel unzip libcap diffutils# tar xf mysql-5.6.2-m5.tar.gz# cd mysql-5.6.2-m5# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci# make & make install# groupadd mysql# useradd -s /sbin/nologin -M -g mysql mysql# cp support-files/f /etc/f# sed /skip-external-locking/idatadir = /usr/local/mysql/var -i /etc/f# sed -i s:#innodb:innodb:g /etc/f# sed -i s:/usr/local/mysql/data:/usr/local/mysql/var:g /etc/f# /usr/local/mysql/scripts/mysql_install_db -defaults-file=/etc/f -basedir=/usr/local/mysql -datadir=/usr/local/mysql/var -user=mysql# chown -R mysql:mysql /usr/local/mysql/# cp support-files/mysql.server /etc/init.d/mysqld# chmod +x /etc/init.d/mysqld# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql# ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump# /etc/init.d/mysqld start# chkconfig mysqld on# /usr/local/mysql/bin/mysqladmin -u root password 123456# mysql -u root -p create database lt; show databases; use lt; CREATE TABLE test (number INT(11),name VARCHAR(255);quit;备份mysqlmkdir -p /opt/shellvim /opt/shell/mysql_backup.sh脚本如下:#!/bin/bashbackdir=/data/mysql_bakbacktime=date +%Y%m%dDB_USER=rootDB_PASS=123456DB_NAME=ltmysql_dump=/usr/local/mysql/bin/mysqldumpif ! -d $backdir ;then mkdir -p $backdirfi$mysql_dump -u$DB_USER -p$DB_PASS -B $DB_NAME $backdir/$DB_NAME_$backtime.sql# chmod +x/opt/shell/mysql_backup.sh然后添加定时任务