In the last episode (Nov 20), mos said:
> At 08:02 PM 11/20/2008, you wrote:
> >Try drop table if exists Tablex;
>
> Ahhh, I don't necessarily want to drop the table if it already
> exists. :) If the table already exists then I'll add new rows to it
> (and keep the existing rows). If the table doe
At 08:02 PM 11/20/2008, you wrote:
Try drop table if exists Tablex;
Ahhh, I don't necessarily want to drop the table if it already exists. :)
If the table already exists then I'll add new rows to it (and keep the
existing rows). If the table doesn't exist, then I'll create it.
I suppose co
Thanks for advice.
There're no environment for me to test the cluster again right now. Hope the
chance chooses me, then the english version will be done.
:)
On Fri, Nov 21, 2008 at 10:48 AM, steve grosz <[EMAIL PROTECTED]>wrote:
> Hello Moon's Father,
>
> That would be great..if it was in eng
Hello Moon's Father,
That would be great..if it was in english ;)
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio <[EMAIL PROTECTED]>
wrote:
Hi,
Does anybody has a tip to install a MySQ
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> what do these errors mean:
>
> mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
> TABLES
> mysqldump: Couldn't execute 'show create table `Antrag`':
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> what do these errors mean:
>
> mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
> TABLES
> mysqldump: Couldn't execute 'show create table `Antrag`':
Try drop table if exists Tablex;
On Fri, Nov 21, 2008 at 9:53 AM, mos <[EMAIL PROTECTED]> wrote:
> How can I determine if a temporary table exists? Normally I use something
> like:
>
> create temporary table Tablex like Table1;
> show tables like "Tablex";
>
> but the Show Tables never displays a
How can I determine if a temporary table exists? Normally I use something like:
create temporary table Tablex like Table1;
show tables like "Tablex";
but the Show Tables never displays any rows for a temporary table even
though the temporary Tablex exists. (All in same thread).
So is there a
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using
LOCK TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got error 1
from storage engine (1030)
mysqldump: Couldn't execute 'show create table `Autor`': Got error 1
from stora
I had done many instances on one machine before, the most important thing
is about the my.cnf.
And there are many individual my.cnf, which belonged to their own instance.
Since your total memory is 32GB, you can assign them properly.
On Fri, Nov 21, 2008 at 3:40 AM, Claudio Nanni <[EMAIL PROTECTE
You may execute mysql_fix_privileges_table script to upgrade all of your
mysqld.
On Thu, Nov 20, 2008 at 7:54 PM, Ronan Lucio <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I installed MySQL-5.0.67_1.
> When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I get
> the message:
>
>
> +
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5?
> Is it better from source or can it be from
Aha! I get it! I *was* being an idiot. The longitude of @g1 is 12*2*, not 121...
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Have you tried "in boolean mode"?
Santino Cusimano
At 16:30 -0500 20-11-2008, Little, Timothy wrote:
We are using MySQL 5.0.22 on CENTOS/redhat
linux. The table and database character-sets
are all utf8.
We have a database supporting numerous
languages. Of course, full-text works
beautifu
We are using MySQL 5.0.22 on CENTOS/redhat linux. The table and database
character-sets are all utf8.
We have a database supporting numerous languages. Of course, full-text works
beautifully with most of the languages.
But Chinese and Japanese are giving us problems, and there is NO reason
Hi,
Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5?
Is it better from source or can it be from yum?
I do prefer yum because it's easier for upgrades, but I don't know if
the available package was compiled for that.
Thank you,
Ronan
--
MySQL General Mailing List
For list
we are going to be
setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2
slaves-ro)...each having 16 to 32 GB of RAM.
If it is still true what you wrote you need different installations.
Of course master and slave on the same host has the only use of an
online backup solution,
[snip]
Virtualization includes overhead.
It is fine as long as your application can tolerate that, but if your
performance demands grow there will be a point where a DB server in a
virtual machine will cause trouble but the same HW as a "real" machine
would still suffice.
[/snip]
We run MySQL in v
Hi Shain, all!
Shain Miley wrote:
> Ok...based on the responses that I received so far...it seems like maybe
> I should be leaning toward a non virtualized solution.
Virtualization includes overhead.
It is fine as long as your application can tolerate that, but if your
performance demands grow t
Check out Giuseppe Maxia's MySQL Sandbox program. It is a very easy way
to run however many MySQL servers you want with separate config files
and such .. heck..even separate versions if you want (one 5.0, one 5.1,
one 6.0). It is available here: https://launchpad.net/mysql-sandbox
Will take yo
Ok...based on the responses that I received so far...it seems like maybe
I should be leaning toward a non virtualized solution.
What I am wondering now is...
1)would it be better to have one MySQL instance running and have the
developers each have their own DB inside that one instance?
or
Hi,
I installed MySQL-5.0.67_1.
When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I
get the message:
++---+--++
| Table | Op| M
Hi,
Yesterday i encounter a very strange problem, i found some data on a
replication db differ from that on the master.
master:
+-+++-+-++
| id | date | uid| type_id | report_type | amount |
+-+++--
Chris,
> I might be being an idiot.
Yes, you are :-)
> -122.1529 is between -121.148 and -121.1575
This is not true!
-122.something cannot be between -121.somethingother and -121.somethingelse
-121.1529 is between -121.148 and -121.1575
Regards,
--
Jigal van Hemert.
--
MySQL General Maili
Tompkins Neil wrote:
Hi
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we
> >As a sidenote, your strings should be enclosed by single quotes, as per
> >SQL standard, not double quotes, those are reserved for delimited
> >identifiers.
> >
> Hmmm. I've sort-of carried that over from the way I do PHP. I tend to use
> single quotes for strings that have no variables in them,
I have always used this for de-duplicating...
ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( myField1, myField1 ) ;
It works a treat, hope it helps
Roger
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: 20 November 2008 00:35
To: jean claude babin
Cc: mysql@lists.mysq
Jed Reynolds wrote:
I'm seeing errors in my application where I'm getting from simple
selects every few hours:
I do a "flush table activity_profiles; check table activity_profiles;"
and the table seems to have fixed itself.
Any thots?
Thanks for the thots, guys. It turns out one of my co-m
28 matches
Mail list logo
