RE: MySql Version difference

2007-01-24 Thread Nilesh
Thanks Peter. But is there any other way to do that. Can't i directly compare the 2 version, instead of reading Change Histroy section for all the version in between. Regards, Nilesh _ From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 11:

Re: restoring mysqldump ???

2003-11-23 Thread Nilesh Avalani
the user with the necessary rights... --- Nilesh Avalani <[EMAIL PROTECTED]> wrote: > Hi Mikael, > > I've tried that but it says : > test-dump-Sat.sql: No such file or directory. > tell me something... when i type in this command > where > should my "test

Re: restoring mysqldump ???

2003-11-23 Thread Nilesh Avalani
ght? or should it be somewhere on my local system? just in case i didnt say this before... I've trying to run this command on a remote solaris server... Thanks, Nilesh --- Mikael Fridh <[EMAIL PROTECTED]> wrote: > > i have a backup copy created using mysqldump > called > >

restoring mysqldump ???

2003-11-22 Thread Nilesh Avalani
i have a backup copy created using mysqldump called "test-dump-Sat.sql". i need to restore it into the "test" database on my remote Solaris server. after getting into mysql i gave command: use test; mysql test < test-dump-Sat.sql; i got the following error: ERROR 1064: You have an error in your SQ

RE: Mysql Table Case

2002-08-15 Thread Nilesh Shah
Answer is No. Case-sensitivity of table names depends on operating system you are running mysql on.MySQL stores table definitions in TABLENAME.* files. So it will always be case-sensitive on *nix and case-insensitive on windows. Nilesh -Original Message- From: James Kelty [mailto

RE: Replication from InnoDB -> MyISAM

2002-07-15 Thread Nilesh Shah
I am sorry. I should have paid more attention to Heikki email. Nilesh -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:43 PM To: Nilesh Shah Cc: [EMAIL PROTECTED] Subject: Re: Replication from InnoDB -> MyISAM On Mon, Jul 15, 2002 at

RE: Replication from InnoDB -> MyISAM

2002-07-15 Thread Nilesh Shah
How does transaction works in this scenario?. Is rollbacked transaction written into bin-log files?. Nilesh -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 1:30 PM To: Philip Molter; [EMAIL PROTECTED] Subject: Re: Replication from InnoDB

RE: Replication slave repeatedly gets error 1159 from master

2002-07-15 Thread Nilesh Shah
Check the list. This question has been asked before many time. You can set net_read_timeout variable to bigger value to avoid this problem. Still no one knows (or answered) impact of net_read_timeout and wait_timeout. which one takes precedence. Nilesh -Original Message- From

RE: Goodday

2002-07-12 Thread Nilesh Shah
This is funny, but my email regarding replication slave disconnect error in 3.23.51 was bounced back as Spam and asked me to add sql,query in message. Whereas, Spam like this goes unnoticed. Nilesh -Original Message- From: Njamba [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002

RE: mysql replication

2002-07-10 Thread Nilesh Shah
No. You cann't have one slave connected to more than one master. Nilesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 10:30 PM To: [EMAIL PROTECTED] Subject: mysql replication Hi All, I have 3 mysql servers with Red Hat 7.2 a

RE: Replication - Error reading packet from server: (server_errno=1159)

2002-07-10 Thread Nilesh Shah
Set variable net_read_timeout to some bigger value. http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Nilesh Shah -Original Message- From: Mark Hughes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 3:36 AM To: [EMAIL PROTECTED] Subject: Replication - Error reading packet

RE: verification upon update, help, please

2002-07-03 Thread Nilesh Shah
What happens if you put third TIMESTAMP column.?. Will that be updated?. Just curios. Nilesh -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:42 PM To: Paul Tomsic; [EMAIL PROTECTED] Subject: Re: verification upon update, help, please

RE: er diagramming

2002-07-01 Thread Nilesh Shah
PowerDesigner from Sybase is awesome. Nilesh -Original Message- From: Bill Bernat [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:25 PM To: [EMAIL PROTECTED] Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL

RE: Multiple Network Interface

2002-06-27 Thread Nilesh Shah
Thanks all -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 10:56 AM To: Nilesh Shah Cc: [EMAIL PROTECTED] Subject: Re: Multiple Network Interface Nilesh Shah wrote: > We are setting up three MySQL server (on separate machines) with

Multiple Network Interface

2002-06-27 Thread Nilesh Shah
?. Thanks, Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe,

MySQL DBA wanted

2002-06-11 Thread Nilesh Shah
rs. > > Please send your resumes to [EMAIL PROTECTED] mention "MySQL DBA" > in subject. > > For company detail visit http://www.vonage.com . > > Thanks, > > Nilesh - Before posting

RE: mysqld refusing connections while getting sloooow

2002-06-11 Thread Nilesh Shah
I think increasing memory and giving more memory to MySQL would help. Nilesh -Original Message- From: Jared Richardson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:48 PM To: Stefan Hinz; [EMAIL PROTECTED] Subject: Re: mysqld refusing connections while getting slw

RE: 45 seconds

2002-06-10 Thread Nilesh Shah
Try using LIKE instead of regexp and create index on HOST_NAME if not present. Nilesh -Original Message- From: Chris Knipe [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:24 PM To: Elsad YUSIFLI; [EMAIL PROTECTED] Subject: Re: 45 seconds I have multiple tables on a 166MMX

INNODB conversion

2002-02-20 Thread Nilesh Deshpande
Dear sir, I am using MySQL database & I just wanted to use transaction.so as per manual i have to make table type as Innodb. Then i had set Innodb startup options as follows innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_g

Problems installing mysql-4.0-alpha on my Redhat

2001-12-13 Thread Nilesh Parmar
try to start mysql by typing "mysql" at the command prompt I get the following error: Error 2002: Can't connect to MySQL server through socket /var/lib/mysql/mysql.sock. I've tried the installation about 2-3 times but i get the same messages all the time. Can an

Video game programming????

2001-09-12 Thread Nilesh Parmar
st thought if anyone could tell me more on this. What's video game programming got to do with MySQL ?? and what does he mean by this. Can anyone enlighten me on this ?? Thanx in advance. Nilesh - Before posting, please check

MySQL and Perl

2001-09-11 Thread Nilesh Parmar
Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

How do i see system tables ???

2001-09-11 Thread Nilesh Parmar
Hi Can anyone tell me how do i see all the system tables (default tables) used by mysql. To see the databases i know that there is a "showdatabases" command. How do i see the system tables ? thanx in advance rega

Re: BDB Tables, InnoDB tables ??

2001-09-09 Thread Nilesh Parmar
Hi I just came across these words in the mailing lists. Can anyone tell me what are "BDB tables" and "InnoDB tables" . I am new to mysql and would like to know what are they . thanx

BDB Tables, InnoDB tables ??

2001-09-09 Thread Nilesh Parmar
Hi I just came across these words in the mailing lists. Can anyone tell me what are "BDB tables" and "InnoDB tables" . I am new to mysql and would like to know what are they . thanx in advance Nilesh

RPM or SourceCode ???

2001-09-06 Thread Nilesh Parmar
the source code ?? except that if we install from the source code it is a bit tedious where as with the rpm it is convineint. Are there any reasons other than this ?? i for one feel that installing from the source gives us a lot of options and flexibility thanx in advance. cheers !! Nilesh Parmar [EMAIL

Need info

2001-08-28 Thread Nilesh Keshavji Parmar
in what areas of technology are people using mysql, is it web or whatever and how successfull is it. I am sorry if i sound stupid. hope i can get a response as soon as possible. many thanx Nilesh - Before