Announcement

Announcement Module
Collapse
No announcement yet.

Backup - do i need to keep ibdata1?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Backup - do i need to keep ibdata1?

    Hi guys, got a quick question:

    I have a Master - Slave setup running. I'd like to copy the backed up files to offsite backups. Do i need to keep ibdata1?

    I am taking a backup off of the slave:

    $>innobackupex-1.5.1 --slave-info --user=root --password=XX --databases="db1" .

    Then I am running:
    $> innobackupex-1.5.1 --apply-log 2011-03-02_14-20-10

    After doing this, am i free to delete ibdata1???

    ibdata1 is about 1 gig in size, the database directory: 2011-03-02_14-20-10/db1 is only around 12 meg.

    Is it safe to just delete the ibdata1 file?

    will everything i need be in 2011-03-02_14-20-10/db1 directory?

    Thanks in advance

    Jon
Working...
X