Noel Goodman <goldenchild_gt@yahoo.com> wrote:
Each table consists of 3 files with extensions, .MYI .MYD and .FRM respectively.
I would like some background info on these file types or a proper link to say exactly what these file types are and how they are used.
Those are MySQL internals, not Koha. Please ask a MySQL discussion for further info, but the basic description is in http://dev.mysql.com/doc/refman/5.1/en/myisam-storage-engine.html Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension. Hope that helps, -- MJ Ray - see/vidu http://mjr.towers.org.uk/email.html Experienced webmaster-developers for hire http://www.ttllp.co.uk/ Also: statistician, sysadmin, online shop builder, workers co-op. Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/