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,
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)
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)
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)
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)
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 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,
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)
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 DEBIAN
mysql-schema-diff
MYSQLDIFF(1p) User Contributed Perl Documentation MYSQLDIFF(1p)NAME
mysql-schema-diff - compare MySQL database schemas
SYNOPSIS
mysql-schema-diff [B<options>] B<database1> B<database2>
mysql-schema-diff --help
DESCRIPTION
mysql-schema-diff is a Perl script front-end to the CPAN <http://www.perl.com/CPAN> module MySQL::Diff
<http://search.cpan.org/search?module=MySQL::Diff> which compares the data structures (i.e. schema / table definitions) of two MySQL
<http://www.mysql.com/> databases, and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will
transform the structure of the first database to be identical to that of the second (c.f. diff and patch).
Database structures can be compared whether they are files containing table definitions or existing databases, local or remote.
N.B. The program makes no attempt to compare any of the data which may be stored in the databases. It is purely for comparing the table
definitions. I have no plans to implement data comparison; it is a complex problem and I have no need of such functionality anyway.
However there is another program coldiff <http://rossbeyer.net/software/mysql_coldiff/> which does this, and is based on an older program
called datadiff which seems to have vanished off the 'net.
For PostgreSQL there are similar tools such as pgdiff <http://pgdiff.sourceforge.net/> and apgdiff <http://apgdiff.startnet.biz/>.
EXAMPLES
# compare table definitions in two files
mysql-schema-diff db1.mysql db2.mysql
# compare table definitions in a file 'db1.mysql' with a database 'db2'
mysql-schema-diff db1.mysql db2
# interactively upgrade schema of database 'db1' to be like the
# schema described in the file 'db2.mysql'
mysql-schema-diff -A db1 db2.mysql
# compare table definitions in two databases on a remote machine
mysql-schema-diff --host=remote.host.com --user=myaccount db1 db2
# compare table definitions in a local database 'foo' with a
# database 'bar' on a remote machine, when a file foo already
# exists in the current directory
mysql-schema-diff --host2=remote.host.com --password=secret db:foo bar
OPTIONS
More details to come; for now run "mysql-schema-diff --help".
INTERNALS
For both of the database structures being compared, the following happens:
o If the argument is a valid filename, the file is used to create a temporary database which "mysqldump -d" is run on to obtain the table
definitions in canonicalised form. The temporary database is then dropped. (The temporary database is named
"test_mysqldiff_temp_something" because default MySQL permissions allow anyone to create databases beginning with the prefix "test_".)
o If the argument is a database, "mysqldump -d" is run directly on it.
o Where authentication is required, the hostname, username, and password given by the corresponding options are used (type
"mysql-schema-diff --help" for more information).
o Each set of table definitions is now parsed into tables, and fields and index keys within those tables; these are compared, and the
differences outputted in the form of MySQL statements.
BUGS, DEVELOPMENT, CONTRIBUTING
See <http://software.adamspiers.org/wiki/mysqldiff>.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
MySQL::Diff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils, mysql, mysqldump, mysqlshow
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MYSQLDIFF(1p)