"mysqldump --opt --single-transaction --master-data > dump.sql"
I am using InnoDB. The dump I used was 'mysqldump --all-databases'. If I
used the '--opt --single-transaction' option as you described above, does
that mean that I would not need to first 'FLUSH TABLES WITH READ LOCK'?
Also, if I do the dump you describe, will that capture all databases or do I
have to be using the specific db I want. Sorry if these are VERY stupid
questions - as of a few days ago I had never dealt with mysql. Thanks
Marcus Bointon wrote:
>
> On 23 Nov 2007, at 09:15, FMGreen wrote:
>
>>> mysql> FLUSH TABLES WITH READ LOCK;
>
>
> If you're using InnoDB for everything, there is an alternative that's
> much less disruptive:
>
> mysqldump --opt --single-transaction --master-data > dump.sql
>
> This ensures that the data dump is in a consistent state and provides
> master log file and position info, ready to import into a slave.
>
> Marcus
> --
> Marcus Bointon
> Synchromedia Limited: Creators of http://www.smartmessages.net/
> UK resellers of info@hand CRM solutions
> marcus@stripped | http://www.synchromedia.co.uk/
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>
>
--
View this message in context:
http://www.nabble.com/replication-on-Linux-broken-after-db-restore-tf4850053.html#a13910058
Sent from the MySQL - Replication mailing list archive at Nabble.com.
