XF 1.2 InnoDB Questions

[lostincable]

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!

 

[Paul B]

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.

 

[lostincable]

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.

No more waiting is required!!!

Thanks @Brogan

 

[AndyB]

2) When backing up InnoDB databases is the same as standard mysql?

You will want to backup using mysqldump for best results.