Announcement

Collapse
No announcement yet.

Backing up mySQL DB - do I need to include the innodb file?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Backing up mySQL DB - do I need to include the innodb file?

    Hi,

    I've inherited a server with MySQL installed. I have configured the backups to run automatically using a script and MySQLdump. Ive noticed on one of the server there are 2 data directories. One is set is set to the InnoDB folder and the other is set to the standard MySQL Server\Data directory.

    Am I correct in thinking doing a full backup of the data directory will be ok - MySQL Server...\Data\... Or do I need to look at adding the InnoDB Data directory folder as well?

    Thanks

  • #2
    Re: Backing up mySQL DB - do I need to include the innodb file?

    Some checking on says InnoDB is the "storage engine" and seems to have content in it, so should probably be backed up.

    Any good reasons not to?
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Backing up mySQL DB - do I need to include the innodb file?

      Originally posted by Ossian View Post
      Some checking on says InnoDB is the "storage engine" and seems to have content in it, so should probably be backed up.

      Any good reasons not to?
      Thanks and I did do a Google before asking. The reason I asked is (as a thought) just because I backed the file up would necessarily mean as a restore you could restore this potentially live\hot file. I know with some database systems having the live DB files isn't always the right way to go about it.

      Thanks for the reply though

      Comment

      Working...
      X