1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backups Innodb

Discussion in 'XenForo Questions and Support' started by lostincable, Mar 18, 2013.

  1. lostincable

    lostincable Active Member

    Hi all, when I installed Xenforo I was running MyISAM so all my tables are now MyISAM.

    I have enabled Innodb but before converting the required tables to Innodb I wanted to ask how you backup Innodb?

    Currently I use automysqlbackup and compress the databse file and moves it offsite.

    If I move the required tables to Innodb I end up with a mix of MyISAM and Innodb so can I still backup the same way?

    I was reading about files for Innodb need to backed up as well??

    Or does that relate to Tables as Files for Innodb and do I need to configure that option?

    Any advice appreciated!
  2. lostincable

    lostincable Active Member

    Further to this I have been doing a bit of reasearch on Innodb and it seems a fair few people have corruption issues with Innodb from making config changes.

    The only way out is to restore a backup, is Innodb that dangerous???

    I have been using MyISAM for a long time now so a bit worried if its going to be a night mare :)!
  3. Brogan

    Brogan XenForo Moderator Staff Member

    This is what Kier had to say:
    I have been using the default mix of MyISAM and InnoDB since the first beta, with no issues at all.
    Just back the database up in the normal manner - I use phpMyAdmin, Gzipped.
  4. MattW

    MattW Well-Known Member

  5. lostincable

    lostincable Active Member

  6. MattW

    MattW Well-Known Member

  7. HWS

    HWS Well-Known Member

    This should really be the standard setting with INNODB.

    You might also want to have a look at Percona XtraBackup. It is free and specialized in INNODB:
  8. lostincable

    lostincable Active Member

    Okay cheers everyone for the advice put my mind at ease wether I should do this or not :)!

    So my plan is -

    1) Backup existing database and re import on my test box to verify its ok and I have the latest snapshot

    2) Configure my.cnf to enable Innodb including the files per table option as suggested

    3) Restart mysql

    4) Update the required tables on the XF database to Innodb

    5) Export another backup and import it to my test box verifying its ok

    From there I can just continue using automysql backup or XtraBackup to dump my backups.

    Fingers crossed!
  9. MattW

    MattW Well-Known Member

    I played around with that when I first moved to Percona, but found it easier to stick with mysqldump as I then move all my backups off site.
    Biker likes this.
  10. lostincable

    lostincable Active Member

    Thanks all, just one final question before i make the switch.

    I currently have this setting -

    innodb_data_file_path= ibdata1:2G:autoextend
    And I was thinking of changing it to this -


    But I am worried about splitting it across multiple files and then if it reaches the 50MB limit what happens then?

    What settings do others have?

Share This Page