[rt-users] Missing MySQL files???

[Ruslan U. Zakirov]

Jeff Holst wrote:
> RT 3.2.2
> MySQL 4.1.8
> Red Hat Enterprise Linux 3.0
> 
> I've setup RT3 and the application seems to run fine ( I can access, 
> login, and use it via the web interface.)  When I try to backup my 
> database the backup software complains "Failed to get 3 table files for 
> table: ACL"  I've confirmed that my /var/lib/mysql/rt3 directory does 
> only contain ACL.frm and NOT ( ACL.MYI and ACL.MYD )  This is true for 
> all the tables except "sessions" which contains all three files.
> 
> My question is, have my RT tables been setup incorrectly?  Other 
> databases on my system have .frm, .MYI, and .MYD files for every table, 
> but my instance of RT3 does not.  What did I screw up?
You use backup software for MyISAM mysql tables, RT uses InnoDB for all 
tables except sessions.
http://dev.mysql.com/doc/mysql/en/Backing_up.html
http://www.google.ru/search?q=site%3Adev.mysql.com+backup+InnoDB

> 
> Thanks,
> 
> -jeff
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon! 
> (Boston, San Francisco, Austin, Sydney) Contact 
> training at bestpractical.com for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com