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
More UNIX and Linux Forum Topics You Might Find Helpful
Powered by 
06-09-2009
Understanding frm myd and myi files
Threaded Mode
