please help me thanks.
- Original Message -
From: "wangxu" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 02, 2006 5:27 PM
Subject: How does the federated engine table work
> How does the federated engine table work when the query statement include
> a join substatement, it join
who can help me?
- Original Message -
From: "wangxu" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 02, 2006 5:29 PM
Subject: question about the query against to the federated engine tables
> I have a question about the query against to the federated engine tables.
> As the follow
It bring great effect in performance if federated engine can't use the cache.
If mysql intend to support it in the future?
- Original Message -
From: "Michael Loftis" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>;
Sent: Thursday, August 03, 2006 1:27 AM
Subject: Re: query cache a
John wrote:
I get this error:Fatal error: Cannot redeclare class
mysql in /home/public_html/n/config.php on line 6
This is a php question, it's not a mysql problem.
Find a more appropriate mailing list/forum.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
I get this error:Fatal error: Cannot redeclare class
mysql in /home/public_html/n/config.php on line 6
I have two processes running on one page and do not
know how to declare class for both with out getting
this error. I have one or the other working no problem
but never both. arghhh
Someone pl
> DELETE from cart
> WHERE product_id NOT IN( SELECT id FROM products where status = 'enabled')
> AND user_id = '90'
>
> The above is what I would like it to do, though I can not test it as I do
> not have access to a mysql that supports it.
>
> Aside from two queries, can someone perhaps show m
>Description:
Running mysqld (built from NetBSD's pkgsrc, normally reliable),
I find that the initial install works, but attempts to restart
the server later fail with signal 4!
>How-To-Repeat:
Install server. Stop and restart server.
>Fix:
Never reboot or r
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
DELETE from cart
WHERE product_id NOT IN( SELECT id FROM products where status = 'enabled')
AND user_id = '90'
The above is what I would like it to do, though I can not test it as I do
not have access to a mysql that supports it.
Aside from two queries, can someone perhaps show me how to run the
I figured it out. Thanks for listening. I maybe just needed to vent.
-Original Message-
From: Josh Milane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 12:46 PM
To: mysql@lists.mysql.com
Subject: query logging is making me mental!
Hello Everyone,
I am hoping that someone
Hi obed
I looked many times in the commands list and maybe I didn't wat to see it
!!!
The answer is a '\G' appended at the end of the line.
Thanks for the help
Bill
>> Can you remind me how to tell mysql to list vertically instead of horiz
>> in
>> text mode?
>>
> List of all MySQL commands:
Mazur Worden, Kathy wrote:
which column(s) isn't found? Would it happen to be any of the columns
you're using a function on? I ask because aliasing those might help.
I can confirm that passing the full db name will work with ASP through a
recordset. I've set them up like this:
Set objConn
On 8/8/06, Josh Milane <[EMAIL PROTECTED]> wrote:
I installed MYSQL 5 along with PHP and apache 2 as part of the XAMPP
stack put out by ApacheFriends. I am putting together a few CMS sites
and think the product is great.
I don't. IMHO anything that hides stuff you SHOULD know to use the
softwa
Gerald L. Clark wrote:
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv fi
On 8/8/06, Ben Clewett <[EMAIL PROTECTED]> wrote:
Dear MySQL,
I posted a problem with 4.1.9 crashing when reading data from a InnodB
HotBackup image, and then encountering a foreign key conflict.
Have you tried another tool to backup and restore?
I can't talk to InnoDB, they make it very cl
Hello Everyone,
I am hoping that someone can help me. Before I jump off the roof!
I installed MYSQL 5 along with PHP and apache 2 as part of the XAMPP
stack put out by ApacheFriends. I am putting together a few CMS sites
and think the product is great.
But I am having a simple problem
So the question is what if I have multiple conditions say "COLOR LIKE
'Blue' [AND|OR] NAME LIKE 'Fred'". Will I have to create a JOIN for
each?
SELECT *
FROM T
LEFT JOIN StringVal CSV ON T.ID = CSV.REF_ID
INNER JOIN StringType CST
ON CSV.TYPE_ID = CST.ID AND CST.ID = COLOR
LEFT
which column(s) isn't found? Would it happen to be any of the columns
you're using a function on? I ask because aliasing those might help.
I can confirm that passing the full db name will work with ASP through a
recordset. I've set them up like this:
Set objConnRead = Server.CreateObject("AD
Mazur Worden, Kathy wrote:
I've had success using the fully qualified db, table and column name in
a single query like yours below. Have you tried sending strSQLCombo
through either strConnProd or strConnSales already?
K. Mazur Worden
Kathy,
Just tried referencing one and got the "Item cann
I've had success using the fully qualified db, table and column name in
a single query like yours below. Have you tried sending strSQLCombo
through either strConnProd or strConnSales already?
K. Mazur Worden
> -Original Message-
> From: brent [mailto:[EMAIL PROTECTED]
> Sent: Monday, A
Sort of a chicken/egg problem - no support until you pay, but you
won't pay until your problem is fixed? Have you contacted them to
inquire whether this is a problem they could help you with if you did
pay for support?
Another avenue to pursue might be a support contract with MySQL. We
had one
--On August 8, 2006 11:36:21 AM +0200 thomas Armstrong
<[EMAIL PROTECTED]> wrote:
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Renato Golin wrote:
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in the replication (2-way
to make switching back and forth easy) chain.
Why do you need a ba
On 08.08.2006 13:16 CE(S)T, chris smith wrote:
> Are you sure about that ?
Well, I'm sure about what I've seen.
> Notice that you're installing into /usr/local/mysql5 which is NOT a
> standard path.
>
> Maybe it's finding an old version, check it:
>
> mysql --version
The 'mysql' binary it find
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv file so newlines are
repr
On 8/8/06, Yves Goergen <[EMAIL PROTECTED]> wrote:
Hello,
I was just trying out the mysql_upgrade script on my MySQL 5.0 server
but it shows an error message that makes me believe it doesn't know
where to find its own data.
Here's what I did:
mysql_upgrade --basedir=/usr/local/mysql5 --datadir
MySQL DBA, Marlboro, NJ | 80-100k | Paid Relo
Our client hires great people and encourages them to make their dreams
come true. They believe in hard work and the sort of imagination that
only talented people from diverse backgrounds can provide. They are
looking for people with world-class skills
On 8/8/06, thomas Armstrong <[EMAIL PROTECTED]> wrote:
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain.
Why do you need a backup site to write th
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't o
Hello,
I was just trying out the mysql_upgrade script on my MySQL 5.0 server
but it shows an error message that makes me believe it doesn't know
where to find its own data.
Here's what I did:
mysql_upgrade --basedir=/usr/local/mysql5 --datadir=/var/mysql5/data
--password
And this is what I got:
Hi All,
PBXT version 0.9.6 has been released and can be downloaded from
http://www.primebase.com/xt.
Most of the mysql-test-run scripts now run correctly with PBXT as the
default storage engine. This version has also been compiled and tested
on a multi-processor, 64-bit machine. In addition,
Dear MySQL,
I posted a problem with 4.1.9 crashing when reading data from a InnodB
HotBackup image, and then encountering a foreign key conflict.
I can't talk to InnoDB, they make it very clear on their web site that
they do not offer support until money changes hands. This will not
happen
34 matches
Mail list logo
