mysql - Amit's Blog

Shell Script to Check the Status of MySQL Replication

!/bin/bash emailAddress="emailtoNotify@domain.com [emailAddress=%22emailtoNotify@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 on hostname" $emailAddress fi If

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 read -p "Please Enter Host To Allow

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``` ****Compress the output of mysqldump :**** mysqldump -u username -p database | /bin/gzip -9 > filename.sql.gz **Backuping a single table from a database** mysqldump -u -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>set global max_allowed_packet=200*1024*

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 [ftp://ftp.pbone.net/mirror/centos.karan.org/el5/extras/testing/i386/RPMS/pam_mysql-0.7-0.5.