Mysql Dump

hmaddy

• December 27, 2021 12:15

How to dumb all databases to seperate files via cron job. i tried to use following script. but its only taking some databases for DB in $(mysql -e 'show databases' -s --skip-column-names); do mysqldump $DB > "$DB.sql"; done

• 

  GOT

  • December 27, 2021 17:16

  Check out AutoMysqlBackup. Or use the cPanel backup system which does dump the databases as part of its backup routine.

  0
• 

  hmaddy

  • December 27, 2021 17:50

  Check out AutoMysqlBackup. Or use the cPanel backup system which does dump the databases as part of its backup routine.

  
  only database backup required. so is there any tools available for this.??

  0
• 

  quietFinn

  • December 27, 2021 17:56

  " AutoMySQLBackup with a basic configuration will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers. "

  0

Please sign in to leave a comment.