4,348
edits
MySQL: Difference between revisions
→Create a snapshot using mysqldump (on master)
| Line 79: | Line 79: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
$ mysqldump --master-data --databases `mysql -B -N -e "SHOW DATABASES LIKE 'foobar%'" -uroot -p` -uroot -p | $ mysqldump --master-data --databases `mysql -B -N -e "SHOW DATABASES LIKE 'foobar%'" -uroot -p` -uroot -p > dbdump.db | ||
</syntaxhighlight> | </syntaxhighlight> | ||