[rt-users] Missing MySQL files???

[Jeff Holst]

Ruslan U. Zakirov wrote:
>You use backup software for MyISAM mysql tables, RT uses InnoDB for all 
>tables except sessions.

Well... yes.  We use NetVault software along with a Dell jukebox for 
corporate wide backups.  NetVault has an APM for MySQL backups, so I would 
like our existing backup strategy to be able to  include RT.

Apparently, standard MySQL database files have 3 versions ( .frm, .MYI, and 
.MYD ) because that is what the NetVault software is looking for. when it 
does the backups.  The backups are failing, however, because my RT database 
only contains the ".frm" files.

Can anyone tell me if what I'm seeing below is correct or if something is 
setup incorrectly???

[root at zeus mysql]# cd /var/lib/mysql/rt3
[root at zeus rt3]# ls -ltr
total 256
-rw-rw----    1 mysql    mysql          65 Jan 18 08:38 db.opt
-rw-rw----    1 mysql    mysql        9948 Jan 18 08:38 Users.frm
-rw-rw----    1 mysql    mysql        8922 Jan 18 08:38 Transactions.frm
-rw-rw----    1 mysql    mysql        9538 Jan 18 08:38 Tickets.frm
-rw-rw----    1 mysql    mysql        8834 Jan 18 08:38 
TicketCustomFieldValues.frm
-rw-rw----    1 mysql    mysql        8978 Jan 18 08:38 Templates.frm
-rw-rw----    1 mysql    mysql        8640 Jan 18 08:38 sessions.frm
-rw-rw----    1 mysql    mysql        9230 Jan 18 08:38 Scrips.frm
-rw-rw----    1 mysql    mysql        8936 Jan 18 08:38 ScripConditions.frm
-rw-rw----    1 mysql    mysql        8874 Jan 18 08:38 ScripActions.frm
-rw-rw----    1 mysql    mysql        9084 Jan 18 08:38 Queues.frm
-rw-rw----    1 mysql    mysql        8680 Jan 18 08:38 Principals.frm
-rw-rw----    1 mysql    mysql        8898 Jan 18 08:38 Links.frm
-rw-rw----    1 mysql    mysql        8732 Jan 18 08:38 Groups.frm
-rw-rw----    1 mysql    mysql        8630 Jan 18 08:38 GroupMembers.frm
-rw-rw----    1 mysql    mysql        8878 Jan 18 08:38 
CustomFieldValues.frm
-rw-rw----    1 mysql    mysql        8934 Jan 18 08:38 CustomFields.frm
-rw-rw----    1 mysql    mysql        8752 Jan 18 08:38 
CachedGroupMembers.frm
-rw-rw----    1 mysql    mysql        8954 Jan 18 08:38 Attributes.frm
-rw-rw----    1 mysql    mysql        8992 Jan 18 08:38 Attachments.frm
-rw-rw----    1 mysql    mysql        8860 Jan 18 08:38 ACL.frm
-rw-rw----    1 mysql    mysql        2048 Jan 20 13:18 sessions.MYI
-rw-rw----    1 mysql    mysql        5308 Jan 20 13:18 sessions.MYD



>From: "Ruslan U. Zakirov" <Ruslan.Zakirov at acronis.com>
>To: Jeff Holst <jeffholst at hotmail.com>
>CC: rt-users at lists.bestpractical.com
>Subject: Re: [rt-users] Missing MySQL files???
>Date: Fri, 21 Jan 2005 22:57:33 +0300
>
>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
>