AMINUL ISLAM SHAMIM

* root@btm:/usr/local/bin# cat xxx-DB.sh
* #!/bin/bash
* # Database credentials
* user="bkupdb"
* password="p*Bu_$]QSd8K"
* host="localhost"
* db_name="service_quiz"
* #
* # Other options
* backup_path="/var/backup/xxx-DB"
* date=$(date +"%b-%d-%Y")
* #
* # Set default file permissions
* umask 177
* #
* # Lock the database and sleep in background task
* mysql --user=$user --password=$password -e "FLUSH TABLES WITH READ LOCK; DO SLEEP(3600);" &
* sleep 3
* #
* # Dump database into SQL file
* mysqldump --user=$user --password=$password --host=$host --opt $db_name | gzip > $backup_path/$db_name-$date.sql.gz
* #
* # When finished, kill the previous background task to unlock
* kill $! 2>/dev/null
* wait $! 2>/dev/null
* 
* echo "Finished export, and unlocked !"

vi /etc/my.cnf without pass mysql login

• # add below to vi /etc/my.cnf and reboot mysql then try to login mysql -p -u root
• [mysqld]
• #skip-grant-tables