-Original Message-
From: Neil Aggarwal n...@jammconsulting.com
Sent: 10 December 2009 01:19
To: mysql@lists.mysql.com
Subject: RE: Missing Entries
Carlos:
I was checking my fresh install of MySQL and noticed I had empt spaces
or missing entries in some sections when I did a search
Hi Eric,
At least with Maatkit, you get transparency. We make a concerted
effort to update the RISKS section of each tool with each release, so
there
is full disclosure.
Fair enough, but I still found the warnings a little too scary. A more
complete explanation of the exact nature of the
Good Day,
I am attempting to do something new (to me) with MySQL. I am looking to have
my query return with the value in the visitor and home columns replaced with
the corresponding team name from the teams table. schedule.visitor and
schedule.home are essentially foreign keys to
Terry Van de Velde wrote:
Good Day,
I am attempting to do something new (to me) with MySQL. I am looking to have
my query return with the value in the visitor and home columns replaced with
the corresponding team name from the teams table. schedule.visitor and
schedule.home are essentially
delete from user where Password='';
Be careful doing this on a fresh install, if you don't set
passwords for root first you will delete all the initial root
accounts too!
That is a good point. I always set the root password first.
I just assumed that he would do that firt, but it is
I already set the root password for the MySQL root user. That is why
in my 1st email you see the encrypted password listed for root in
localhost, mail, 127.0.0.1.
Thanks for all your info. I followed Neil's steps and it worked
perfect...after I realised that those were two 's and not a single
On Wed, Dec 9, 2009 at 2:24 PM, Joerg Bruehe joerg.bru...@sun.com wrote:
Hi everybody!
Neil Aggarwal wrote:
Paul:
SELECT COUNT(event.src_ip) AS count, INET_NTOA(event.src_ip),
mappings.cc FROM event, mappings WHERE event.timestamp BETWEEN
'2009-12-06 20:00' and '2009-12-07 20:00:00' AND
A couple of thoughts - it's not no quotes on integers, but
no quotes around column references. When you use 'mappings.end_ip',
you are saying the string mappings.end_ip, and not referring to
a column in the mappings table. It just becomes a constant at that
point.
As for the performance, you
All,
I have a stored procedure that I'm writing where I need to run a lot of
queries against a particular table. The name of the table will be a
parameter to the stored procedure ... example:
CALL normalize_data('name_of_table_here');
Since I want to run queries against this table, I don't
Creating a temporary merge table works fine for me on 5.0.
Your table isn't innodb is it? That will fail with an error like you're
getting.
Regards,
Gavin Towey
-Original Message-
From: Dante Lorenso [mailto:da...@lorenso.com]
Sent: Thursday, December 10, 2009 3:20 PM
To:
Gavin Towey wrote:
Creating a temporary merge table works fine for me on 5.0.
Your table isn't innodb is it? That will fail with an error like you're
getting.
Strange. Now that I am on my home network and trying this again, it
seems to be working.
mysql SELECT version();
How can it possibly be that mySQL doesn't allow you to rename a database? I
can't fathom how this can be a difficult task at all to do. Aren't mySQL
databases stored in a directory of the DB name? And for INNODB, can't you
just find the spot in the ibdata file and alter whatever needs to be
Uhhh... wow. Unless I'm very, very, very mistaken, I think you're missing
something pretty obvious: I believe you can simply
a) shut down the database
b) mv the directory to a different directory name.
*DONE* Your database now has a different name. Boy, that 30 seconds of
hard labor was sure
13 matches
Mail list logo
