Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Understanding frm myd and myi files
Top Forums Web Development MySQL DevZone RSS Understanding frm myd and myi files Post 302324023 by chebarbudo on Tuesday 9th of June 2009 04:25:32 PM
Old 06-09-2009
Question 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
 

8 More Discussions You Might Find Interesting

1. Programming

Reading frm text file

hi, Actually i have a text file which contain data in the following format: ---------------------------------- black pepper john barber steven johnson ------------------------------------ and the list goes on. I'm writing a c program that reads the text file and output the following... (10 Replies)
Discussion started by: kanexxx
10 Replies

2. Shell Programming and Scripting

how to call one script frm another

Hi all, I would like to know how to call one script from another and the return the value of the called script to the calling script for further processing?(in bash) This is kinda urgent ,pls assist Regards wrapster (4 Replies)
Discussion started by: wrapster
4 Replies

3. Shell Programming and Scripting

giving input to a python wch has been called frm shell script....urgent

i'm calling a python script from shell script. the python needs Y as an input everytime. how can i giv it thru shell script. I tried below code for arg in `cat erd_gen_list.lst` do generateErdSql.py -S $arg << Y done This is giving me err : `<<' unmatched pls help. (1 Reply)
Discussion started by: vini
1 Replies

4. Shell Programming and Scripting

need help understanding mv

I just started shell coding and I'm a bit confused on how 'mv' works can someone explain to me how it works and if i did this correctly. Thanks. echo "Enter Name of the first file:" read file1 #echo $file1 if ; then echo "Sorry, file does not exist." exit 1 ... (16 Replies)
Discussion started by: taiL
16 Replies

5. UNIX for Dummies Questions & Answers

understanding {%/*}/

Hi Gurus: I am trying to understand the following line of code.I did enough of googling to understand but no luck.Please help me understand the follow chunk of code: X=$0 MOD=${X%/*}/env.ksh X is the current script from which I am trying to execute. Say if X=test.ksh $MOD is echoing :... (3 Replies)
Discussion started by: vemana
3 Replies

6. Shell Programming and Scripting

shell script to copy files frm a linux machine to a windows machine using SCP

I need a shell script to copy files frm a linux machine to a windows machine using SCP. The files keeps changing day-to-day. I have to copy the latest file to the windows machine frm the linux machine. for example :In Linux, On July 20, the file name will be 20.txt and it should be copied to... (3 Replies)
Discussion started by: nithin6034
3 Replies

7. Shell Programming and Scripting

Need your help in understanding this

Hi, I found this in a script and I would like to know how this works Code is here: # var1=PART1_PART2 # var2=${var1##*_} # echo $var2 PART2 I'm wondering how ##* makes the Shell to understand to pick up the last value from the given. (2 Replies)
Discussion started by: sathyaonnuix
2 Replies

8. Shell Programming and Scripting

Need help understanding this Regex.

Hi everyone, This regex looks simple and yet it doesn't make sense how it's manipulating the output. ifconfig -a eth0 Link encap:Ethernet HWaddr 00:0c:49:c2:35:6v inet addr:192.16.1.1 Bcast:192.168.226.255 Mask:255.255.255.0 inet6 addr:... (2 Replies)
Discussion started by: xcod3r
2 Replies

LEARN ABOUT SUSE

mysql_fix_extensions

MYSQL_FIX_EXTENSI(1)					       MySQL Database System					      MYSQL_FIX_EXTENSI(1)

NAME

       mysql_fix_extensions - normalize table file name extensions

SYNOPSIS

       mysql_fix_extensions data_dir

DESCRIPTION

       mysql_fix_extensions converts the extensions for MyISAM (or ISAM) table files to their canonical forms. It looks for files with extensions
       matching any lettercase variant of .frm, .myd, .myi, .isd, and .ism and renames them to have extensions of .frm, .MYD, .MYI, .ISD, and
       .ISM, respectively. This can be useful after transferring the files from a system with case-insensitive file names (such as Windows) to a
       system with case-sensitive file names.

       Invoke mysql_fix_extensions like this, where data_dir is the path name to the MySQL data directory.

	   shell> mysql_fix_extensions data_dir

COPYRIGHT

       Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Sun Microsystems, Inc. (http://www.mysql.com/).

MySQL 5.1							    04/06/2010						      MYSQL_FIX_EXTENSI(1)
All times are GMT -4. The time now is 02:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy