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

Does xenforo make use of foreign keys?

Discussion in 'XenForo Questions and Support' started by Jesepi, Sep 13, 2011.

  1. Jesepi

    Jesepi Well-Known Member

    I have previously been using AutoMySQLBackup to keep copies of my databases, but they were all myisam tables. Since xenforo uses innodb, I saw some posts on some sites mentioning that this utility might not be dependable if there were foreign keys involved.

    Should I not worry about this? Or should I consider another option for rotating backups?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Can you link to those posts? Maybe they are talking about foreign key constraints which are not used by XenForo.

    The backup should work fine regardless of the storage type (myisam or innodb).
  3. Jesepi

    Jesepi Well-Known Member

  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yeah, foreign key constraints can cause problems when restoring a backup, but XenForo doesn't use them. There is no problem.

Share This Page