• 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?

Jesepi

Well-known member
#1
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?
 

Jake Bunce

XenForo moderator
Staff member
#2
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.
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).
 

Jake Bunce

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