Results 1 to 3 of 3

Thread: Does this mysqldump command lock all tables?

  1. #1

    Default Does this mysqldump command lock all tables?

    When I execute the command below, does mysqldump lock all tables while the backup is in process? I want to make sure this is the appropriate type of backup command for MyISAM database.


    mysqldump -h myhostname --default-character-set=utf8 -u root --password=mypassword --opt --single-transaction DBname > /root/backup.sql

  2. #2
    Join Date
    Sep 2008
    Location
    Earl Shilton UK
    Posts
    298

    Default Re: Does this mysqldump command lock all tables?

    OT, but you're a Genesis fan?
    Happily using Linux since 1998
    Share & Enjoy

  3. #3
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: Does this mysqldump command lock all tables?

    Near the beginning of mysqldump.info it says that --opt includes --add locks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •