[rt-users] InnoDB question... Maybe lame

[Michael S. Liebman]

At 05:19 PM 3/30/2004, Brent Wiese wrote:
>I have little knowledge of InnoDB, so I apologize in advance if this ends up
>being a dumb question.
>
>First, how do I know if RT is using InnoDB tables right now? I'm running
>4.0.14. There are ibdata files and such.

SHOW TABLE STATUS FROM `rt3`;

Look at the type column.

>I usually have to delete the ibdata files and then restart. Is that safe?

Hmm, its not entirely clear to me when log file pruning happens. Generally, 
for similar database formats (like Berkley DB), it is not consider highly 
reliable to count on the log files for regenerating an entire data file.

>Third, I assume doing a mysqldump of the DB will give me everything,
>including what would be in those tables, so I know my backups are complete?

Yes, mysqldump dumps out the SQL contents of the database regardless of the 
underlying table type.

Michael

-- 
Michael S. Liebman                      m-liebman at northwestern.edu
                 http://msl521.freeshell.org/
"I have vision and the rest of the world wears bifocals."
        -Paul Newman in "Butch Cassidy & the Sundance Kid"