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:
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
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
> >
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
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
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
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
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
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
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
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
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
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
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
?.
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,
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
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
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
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
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
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
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
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
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
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
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
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
27 matches
Mail list logo