Mysqldump: Difference between revisions
fuller interactive version of backup.db.sh |
add a mysqldump one-liner |
||
| Line 82: | Line 82: | ||
mysql --execute="show databases" | awk '{print $1}' | grep -iv ^Database$ | sed 's/\(.*\)/mysqldump \1 > \1.'$(date +"%Y%m%d")'.sql/' | mysql --execute="show databases" | awk '{print $1}' | grep -iv ^Database$ | sed 's/\(.*\)/mysqldump \1 > \1.'$(date +"%Y%m%d")'.sql/' | ||
# Then just redo the command piped to sh | # Then just redo the command piped to sh | ||
</source> | |||
One of many ways to dump a database from one machine to another | |||
<source lang="bash"> | |||
sudo mysqldump mydb | gzip -c | ssh ubuntu@10.0.50.53 'cat > /home/ubuntu/mydb.dump.sql.gz' | |||
</source> | </source> | ||
| Line 94: | Line 99: | ||
</source> | </source> | ||
[[Category:Database]] | [[Category:Database]] | ||
[[Category:Bash]] | [[Category:Bash]] | ||
[[Category:System Administration]] | [[Category:System Administration]] | ||