Sponsored Content
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
replace(1)							  MySQL database							replace(1)

NAME
replace - A utility program that is used by msql2mysql, but that has more general applicability as well. replace changes strings in place in files or on the standard input. Uses a finite state machine to match longer strings first. Can be used to swap strings. USAGE
replace [-?svIV] from to from to ... -- [files] or replace [-?svIV] from to from to ... < fromfile > tofile SYNOPSIS
replace [-?|-I] [-s] [-v] DESCRIPTION
replace -?|-I info -s silent -v verbose EXTRA INFO
Special characters in from string: ^ Match start of line. $ Match end of line.  Match space-character, start of line or end of line. For a end  the next replace starts locking at the end space-character. A  alone in a string matches only a space-character. EXAMPLE
this command swaps a and b in the given files: shell> replace a b b a -- file1 file2 ... SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi- lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/ BUGS
Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur- media.com) ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on http://opensolaris.org. MySQL 4.0 19 December 2000 replace(1)
All times are GMT -4. The time now is 07:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy