4,461
edits
MySQL: Difference between revisions
→Get master's binary log coordinate: Create a snapshot using mysqldump
→Create a user for replication: add Get master's binary log coordinate |
→Get master's binary log coordinate: Create a snapshot using mysqldump |
||
| Line 37: | Line 37: | ||
| mysql-bin.000003 | 73 | test | manual,mysql | | | mysql-bin.000003 | 73 | test | manual,mysql | | ||
+------------------+----------+--------------+------------------+ | +------------------+----------+--------------+------------------+ | ||
</syntaxhighlight> | |||
=== Create a snapshot using mysqldump === | |||
This assuming there are existing data using InnoDB engines. | |||
<syntaxhighlight lang="bash"> | |||
$ mysqldump --all-databases --master-data > dbdump.db | |||
</syntaxhighlight> | </syntaxhighlight> | ||