H hmaddy Verified User Joined Apr 17, 2019 Messages 292 Dec 27, 2021 #1 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
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
Active8 Verified User Joined Jul 13, 2013 Messages 1,813 Dec 27, 2021 #2 Why not using the builtin admin backup system ? you can also create cronjobs there
