On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz wrote:
> Then I guess it's a matter of preference. I'd rather edit a text file than
> build a new instance of MySQL.
>
The way I parse that, you're saying that there is a way to reattach ibd
files to another database ?
--
Bier met grenadyn
Is al
Good day
thank you all for the responses thus far.
Just to add onto the requirements.
The client's business is based around a website that does all
business related tasks and are exremely utilized.
The idea is to provide failover as well as the best possible
response time
Hi!
Machiel Richards wrote:
> Good day all
>
> Maybe someone can assist me here as I am not sure where to get this
> information from and I need this for a proposed environment for a
> client.
>
>
> 1. The client will have 2 new machines, had a look at the specs and
> it is fairly goo
Then I guess it's a matter of preference. I'd rather edit a text file than
build a new instance of MySQL.
On the other hand, if he has a development environment (as we all, of course,
do) then he could futz around in there.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington
Ilham,
It means what it says.You are attempting to insert into a table
that has a primary or other unique key and that data which you are
trying to insert already has that unique value. To diagnose, it would
be helpful to know the circumstance under which you got this error
message.
- micha
> -Original Message-
> From: Joeri De Backer [mailto:fons...@gmail.com]
> Sent: Tuesday, November 09, 2010 1:16 AM
> To: mysql
> Subject: Re: Order by "in" clause
>
> On Tue, Nov 9, 2010 at 10:09 AM, Mark Goodge
> wrote:
> > Hi,
> >
> > I have a query like this:
> >
> > select id, ti
Dear friends.
Anybody would be so nice to explain about meaning of this error message:
"
Duplicate entry '2' for key 1
:.
It comes if we visit this:
http://www.otekno.biz/kn/code/functions.php?task=sync
Thank you very much in advance.
--
Enjoy our free facilities: http://www.otekno.biz
--
M
Not if he has the raw innodb files.
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Tuesday, November 09, 2010 11:05 AM
To: Gavin Towey; 'Andy Wallace'; 'mysql list'
Subject: RE: question about restoring...
That's overkill.
You should be able to import the data in
That's overkill.
You should be able to import the data into another database within the same
instance, unless the file is too big to handle.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
No, you should import the data into another instance of mysql to extract the
records.
Regards,
Gavin Towey
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Tuesday, November 09, 2010 10:34 AM
To: mysql list
Subject: question about restoring...
So, I got a req
So, I got a request this morning to recover some specific records for
a client. I just want a handful of records from a couple of tables here.
I have a copy of the INNODB files for these two tables - is there a way
to extract the table contents from these files short of a full import?
thanks,
ans
Would a compound index on both startnum and endnum be a better choice?
JW
On Tuesday, November 9, 2010, Aveek Misra wrote:
> Probably indexes need to be rebuilt using myisamchk after you changed the
> data type of the index columns. Apart from that I can't see why your query is
> not using the
On 11/8/2010 10:47 PM, wroxdb wrote:
> Hello,
>
> I have a query below:
>
> mysql> select * from ip_test where 3061579775 between startNum and endNum;
> +++-+--+--++
> | startNum | endNum | country | province | city | isp|
> +
Seems like a better plan than simply rolling your own, yes. Do make sure
that the key string is well-documented :-p
On Tue, Nov 9, 2010 at 2:30 PM, Vikram A wrote:
> Sir,
>
> We have done a encryption by using our own algorithm. it works fine. But
> during
> the report analysis we are facing the
Dear Sir,
As you advised we will keep the "key" as well documented.
Thank you
Vikram A.
From: Johan De Meersman
To: Vikram A
Cc: MY SQL Mailing list
Sent: Tue, 9 November, 2010 7:05:39 PM
Subject: Re: Best encription method?
Seems like a better plan than
Sir,
We have done a encryption by using our own algorithm. it works fine. But during
the report analysis we are facing the performance issue. Which is not
appreciated by our users.
We need only one column to be encrypted and the column size will never exceed 3
chars.
We have planed to use
Probably indexes need to be rebuilt using myisamchk after you changed the data
type of the index columns. Apart from that I can't see why your query is not
using the indexes. Is it possible that the cardinality of the column values is
so low that indexes are not being used? You could try and run
Thanks for the idea.
I have changed the datatype to bigint, the result is not changed.
mysql> desc select * from ip_test where startNum <= 3061579775 and
endNum >= 3061579775;
++-+-+--+-+--+-+--++-+
| id | select_type
I don't see how BETWEEN is not equivalent to (startNum <= and endNum >=). Of
course please try and let us know if that resolves the issue. But if it
doesn't, I suspect it is because the indexes are created on columns which are
floating point data type. That's because floating point numbers are a
在 2010年11月9日 下午3:51，Johan De Meersman 写道：
> Indexes typically only work on the left-hand-side. Rewrite as
> select * from ip_test where startNum <= 3061579775 and endNum >= 3061579775;
>
Thanks.
But this seems the same case happened:
mysql> desc select * from ip_test where startNum <= 30615797
On Tue, Nov 9, 2010 at 10:09 AM, Mark Goodge wrote:
> Hi,
>
> I have a query like this:
>
> select id, title from product where id in (1,3,5,8,10)
>
> What I want it to do is return the rows in the order specified in the "in"
> clause, so that this:
>
> select * from product where id in (10,3,8,5,
Hi,
I have a query like this:
select id, title from product where id in (1,3,5,8,10)
What I want it to do is return the rows in the order specified in the
"in" clause, so that this:
select * from product where id in (10,3,8,5,1)
will give me results in this order:
+--+-+
| id
22 matches
Mail list logo
