From IT Mission Linux Tips, Hacks, Tutorials, Howtos - Itmission.org

Main: BashScriptAndMysqldumpCommandToBackupMysqlDatabases

  #!/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
Retrieved from http://www.itmission.org/Main/BashScriptAndMysqldumpCommandToBackupMysqlDatabases
Page last modified on July 23, 2007, at 03:53 PM