You should be in that folder before the backup script is runmkdir /var/lib/mysqlbackup
Now runcd /var/lib/mysqlbackup
Code: Select all
for db in `echo 'show databases;' | mysql -u root --password='H00AOoE' | grep -v ^Database ` ; do mysqldump --opt $db | gzip > $db.sql.gz ; done
Code: Select all
for db in `echo 'show databases;' | mysql | grep -v ^Database ` ; do mysqldump --opt $db | gzip > $db.sql.gz ; done