Hey... If you check your mysql folder you'll find a folder called data which holds the databases used with koha. 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. Thankyou Noel- University of Guyana Image by FlamingText.com --------------------------------- Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase.
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/
participants (2)
-
MJ Ray -
Noel Goodman