mysql Shell Script to Check the Status of MySQL Replication !/bin/bash emailAddress="emailtoNotify@domain.com" cmd=mysql -e 'show slave status\G' | grep Slave_SQL_Running | awk '{print $2}' if [ "$cmd" == "No" ];then MSG="Mysql Replication Broken on hostname, please check asap" echo
mysql Shell Script to Create and Grant Privilege to a new user !/bin/bash #Script to Create a user and assign privilege to a MySQL Database read -p "Please Enter Database Name:" dbname mysql -Bse "USE $dbname" 2> /dev/null if [ $? -eq 0 ]; then read -p "Please enter the username
mysql Mysqldump Tips and Tricks MySQL Database Backup Ignore one or more tables while doing mysqldump : mysqldump -u username -p database --ignore-table=db.table1 --ignore-table=db.table2 > mysqldump.sql``` **<font size="3">**Compress the output of mysqldump :**</font>** mysqldump -u username -p
mysql Backup restore mysql database `mysqldump --databases db1 db2 db3 db4 > backup.sql``` mysqldump --all-databases > backup.sql If you get an error that says : Got a packet bigger than ‘max_allowed_packet’ bytes then increase your max allowed packet either in my.cnf or in mysql shell
mysql Vsftpd With Mysql backened Vsftpd With Mysql Backened EL 5 pam_mysql.so wget ftp://ftp.pbone.net/mirror/centos.karan.org/el5/extras/testing/i386/RPMS/pam_mysql-0.7-0.5.rc1.el5.kb.2.i386.rpm rpm -ivh pam_mysql-0.7-0.5.rc1.el5.kb.2.i386.