LINUX, Backup all mysql databases to individual files on a remote server

Home ·

Backup all mysql databases to individual files on a remote server

LINUX - copy mysql databases to a remote server
Backup all mysql databases to individual files on a remote server

Shell script to Backup all mysql databases to individual files on a remote server for I in $(mysql -e 'show databases' -u root --password=root -s --skip-column-names); do mysqldump -u root --password=root $I \| gzip -c \| ssh user@server.com "cat > /remote/$I.sql.gz"; done It grabs all the database names granted for the $MYSQLUSER and gzip them to a remote host via SSH. This shell script is very much helpful to backup the mysql database. It will just backup the mysql database.
The topic on LINUX - Backup all mysql databases to individual files on a remote server is posted by - Math
Hope you have enjoyed this LINUX - Backup all mysql databases to individual files on a remote server . Thanks for your time.

LINUX - copy mysql databases to a remote server

Backup all mysql databases to individual files on a remote server

Shell script to Backup all mysql databases to individual files on a remote server

for I in $(mysql -e 'show databases' -u root --password=root -s --skip-column-names); do mysqldump -u root --password=root $I | gzip -c | ssh user@server.com "cat > /remote/$I.sql.gz"; done

It grabs all the database names granted for the $MYSQLUSER and gzip them to a remote host via SSH.

This shell script is very much helpful to backup the mysql database. It will just backup the mysql database.

The topic on LINUX - Backup all mysql databases to individual files on a remote server is posted by - Math

Hope you have enjoyed this LINUX - Backup all mysql databases to individual files on a remote server . Thanks for your time.