Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    0

    Unanswered: Before doing a MySQL dump for backup, should I STOP MySQL first?

    Hi guys,

    When I do a MySQL dump for backup, should I STOP MySQL first?

    If I do, service will be interrupted.
    But if I dont, is the data more likely to be corrupted?

    Pleasse shed a light on this. Thanks in advance


  2. #2
    Join Date
    Aug 2004
    Location
    San Antonio, TX
    Posts
    84
    If you mean stop the MySQL service then no, you can't. What you can do is lock the tables or entire databases to disallow others to access during the dump then unlock them afterwards. This can be done via a mysqldump parameter. The manual tells you all about it.

Posting Permissions

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