Bash Script And Mysqldump Command To Backup Mysql Databases

  • Bash script to backup mysql db's
  #!/bin/sh
  mysqldump -uroot -ppwd --opt database_a > /backup/db_a.sql
  mysqldump -uroot -ppwd --opt database_b > /backup/db_b.sql

  cd /backup

  tar -cvzf mysql_db_backup.tar.gz  *.sql