|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| MySQL DevZone RSS MySQL Developer Zone RSS |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Understanding 2>&1 | mojoman | UNIX for Dummies Questions & Answers | 2 | 03-04-2009 11:57 AM |
| Understanding cut | krishmaths | Shell Programming and Scripting | 3 | 01-22-2009 07:46 AM |
| CIACTech02-005: Understanding Capturing Files with Microsoft Word Field Codes | iBot | Security Advisories (RSS) | 0 | 12-24-2007 09:40 AM |
| need further understanding of init.d | jigarlakhani | UNIX for Advanced & Expert Users | 1 | 09-20-2002 04:11 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
06-09-2009
|
|||||
|
|||||
Understanding frm myd and myi files
Hi there, Here is the content of a folder containing a database: Code:
terminal4:~# ls -Al /var/lib/mysql/ndtv/ total 172 -rw-rw---- 1 mysql mysql 8788 2009-06-09 21:57 categorie.frm -rw-rw---- 1 mysql mysql 65 2008-08-12 10:28 db.opt -rw-rw---- 1 mysql mysql 8718 2009-06-09 21:57 groupe.frm -rw-rw---- 1 mysql mysql 8880 2009-06-09 21:57 liste_de_lecture.frm -rw-rw---- 1 mysql mysql 8754 2009-06-09 21:57 liste_media.frm -rw-rw---- 1 mysql mysql 8828 2009-06-09 21:57 liste_terminal.frm -rw-rw---- 1 mysql mysql 8664 2009-06-09 21:57 magasin2.frm -rw-rw---- 1 mysql mysql 1904 2009-06-09 21:57 magasin2.MYD -rw-rw---- 1 mysql mysql 1024 2009-06-09 21:57 magasin2.MYI -rw-rw---- 1 mysql mysql 9168 2009-06-09 21:57 magasin.frm -rw-rw---- 1 mysql mysql 8730 2009-06-09 21:57 media_categorie.frm -rw-rw---- 1 mysql mysql 13583 2009-06-09 21:57 media.frm -rw-rw---- 1 mysql mysql 8757 2009-06-09 21:57 region.frm -rw-rw---- 1 mysql mysql 8856 2009-06-09 21:57 terminal.frm -rw-rw---- 1 mysql mysql 8730 2009-06-09 21:57 terminal_groupe.frm -rw-rw---- 1 mysql mysql 8964 2009-06-09 21:57 utilisateur.frm The db.opt file contains the database options. Each frm file correspond to a table and every table has it's frm file. There's only two files left : magasin2.MYD and magasin2.MYI I found that these are MyIsam files. Question 1: Why is magasin2 the only table to have MyIsam files? If I make changes to some table (I tested with media and terminal), the only file modified is magasin2.MYI (not even the frm file corresponding to the table name). Question 2: How come? Thanks for your help Santiago |
|
| Bookmarks |
| Tags |
| mysql myisam files |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
