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

XF 1.2 InnoDB Questions

Discussion in 'XenForo Questions and Support' started by lostincable, Aug 1, 2013.

  1. lostincable

    lostincable Active Member

    Hi all, in another thread I posted about my setup not using InnoDB from the start as it wasn't enabled on my server.

    Its now switched on and I wanted to ask two questions about it as follows -

    1) Is there a list of tables for Xenforo that should be InnoDB so I can convert them?

    2) When backing up InnoDB databases is the same as standard mysql? I was reading you not only need to back up the database but log files as well?

    Any help appreciated!
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    All tables except the following are InnoDB:

    Memory
    xf_attachment_view
    xf_session_activity
    xf_thread_view

    MyISAM
    xf_search_index
    xf_session
    xf_session_admin

    Backing up requires nothing more than a regular backup.
     
  3. lostincable

    lostincable Active Member

    No more waiting is required!!!

    Thanks @Brogan
     
  4. AndyB

    AndyB Well-Known Member

    You will want to backup using mysqldump for best results.
     

Share This Page