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).
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)
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)
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)
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)
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)
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)
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)
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)
Understanding frm myd and myi files