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

# 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/my-medium.cnf /etc/my.cnf # sed '/skip-external-locking/i\datadir = /usr/local/mysql/var' -i /etc/my.cnf # sed -i 's:#innodb:innodb:g' /etc/my.cnf # sed -i 's:/usr/local/mysql/data:/usr/local/mysql/var:g' /etc/my.cnf # /usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --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; 备份mysql mkdir -p /opt/shell vim /opt/shell/mysql_backup.sh 脚本如下: ################################ #!/bin/bash backdir='/data/mysql_bak' backtime=`date +%Y%m%d` DB_USER='root' DB_PASS='123456' DB_NAME='lt' mysql_dump='/usr/local/mysql/bin/mysqldump' if [ ! -d $backdir ];then ? ? mkdir -p $backdir fi $mysql_dump -u${DB_USER} -p${DB_PASS} -B ${DB_NAME}