mysql - Amit's Blog

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 $MSG | mail -s "Replication Broken

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 you wish to create : " 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 database | /bin/gzip -9 > filename.

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>set global max_allowed_

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.rpm yum install mysql-server vsftpd EL