I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse the
stupid questions ...
1. I have just downloaded and successfully installed MySQL v5.1 on my
MacBook Pro running OS X 10.5.6
2. I have also downloaded and installed MySQL Tools: Administrator
Query Browser
(I come from
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell mysql -u root
mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql FLUSH PRIVILEGES;
mysql EXIT;
Where newpwd is your desired password.
Best to
or as the docs read:
shell mysqladmin password your password
John Daisley wrote:
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell mysql -u root
mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
I have two simple tables. One - list of forums, second - list of
messages and i want to
get the list of forums with number of messages in each.
Here is the query:
SELECT forums.id , COUNT( forum_msg.id ) AS cnt
FROM forums
LEFT JOIN forum_msg ON forums.id = forum_msg.forum_id
ORDER BY
You need to group by forum_id...
On 2/19/09 11:09 AM, Artem Kuchin mat...@itlegion.ru wrote:
I have two simple tables. One - list of forums, second - list of
messages and i want to
get the list of forums with number of messages in each.
Here is the query:
SELECT forums.id , COUNT(
SELECT forums.id , COUNT( forum_msg.id ) AS cnt
FROM forums
LEFT JOIN forum_msg ON forums.id = forum_msg.forum_id
ORDER BY forums.sorder ASC
Missing GROUP BY.
PB
-
Artem Kuchin wrote:
I have two simple tables. One - list of forums, second - list of
messages and i want to
get the list of
Following the documentation available at
http://dev.mysql.com/doc/refman/5.0/en/join.html
t1t2
a b a c
--- ---
1 x 2 z
2 y 3 w
Then a natural left join would product these results
mysql SELECT * FROM t1 NATURAL LEFT JOIN t2;
+--+--+--+
| a| b
I need to add an index on a table on a production server.
It is one 7Gb InnoDB table with single .ibd file (one_file_per_table),
the index creation on preprod server took 40 minutes but table was smaller.
I tried to add the index but was locking all applications on production
and had to kill it.
We have 5.0.22 installed on a test machine and for some reason the innodb
storage engine was not enabled. We install from RPMs so I'm not sure how to
enable the storage engine. If we compiled ourselves, we'd recompile but
that's not an option.
Does anyone know how to enable a storage engine once
Sorry, but I'm resending because I made a mistake in terminology and want to
be clear. The problem isn't that innodb is DISABLED on the database. The
innodb engine is not supported by the database.
We have 5.0.22 installed on a test machine and for some reason the innodb
storage engine was not
Where on earth did you get an RPM that doesn't have InnoDB support? I
find this unlikely. I think it is more likely that you have some
configuration error that's causing InnoDB to disable itself on start.
How do you know InnoDB isn't supported? And by isn't supported I
mean isn't compiled into
Yes, I had a slip of the mind. The engine that was not supported by the
install is the Federated engine. I apologize, I had a blind spot. The
SHOW ENGINES command lists FEDERATED but has NO in the Support column.
The question, though, is how does one add an unsupported engine to an RPM
Perhaps you disabled it via my.cnf
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons jlyons4...@gmail.com
Date: Thu, 19 Feb 2009 22:45:01
To: MySQLmysql@lists.mysql.com
Subject: Re: Resend: enabling storage engine with RPM install
Yes, I had a slip of the mind.
How does one do that in my.cnf?
It is possible to disable a supported engine by screwing up the my.cnf
configuration. For example, I once pointed the InnoDB data file to a
directory that still had root as its owner. The Innodb engined appeared as
DISABLED in the SHOW ENGINES output, but it was
Can you post you my.cnf please
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons jlyons4...@gmail.com
Date: Thu, 19 Feb 2009 23:06:33
To: chaim.rie...@gmail.com
Cc: MySQLmysql@lists.mysql.com
Subject: Re: Resend: enabling storage engine with RPM install
How does
What configuration parameter in the config file could have an impact on
whether a particular storage engine is supported? The binaries are built
before the config is even used. I don't mind posting the file, but I don't
see the point.
The question is pretty simple, can one add a storage engine
The answer is no
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons jlyons4...@gmail.com
Date: Thu, 19 Feb 2009 23:50:13
To: chaim.rie...@gmail.com
Cc: MySQLmysql@lists.mysql.com
Subject: Re: Resend: enabling storage engine with RPM install
What configuration
This is on a Mac OS X (v10.5.6) system in case that matters.
1. - MySQL Administrator Help button says:
HELP
Help isn’t available for MySQL Administrator.
Really, no help or did I screw-up the install somehow?
2. - I tried to create my first Table in MySQL Administrator but got
this
Hi Jim,
mysql rpm installation comes with default storage engine myism and innodb.
Just verify show engines on mysql prompt.
On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons jlyons4...@gmail.com wrote:
We have 5.0.22 installed on a test machine and for some reason the innodb
storage engine was not
Jeff,
For starters, it looks like you need a value for VARCHAR. Try the
same statement but with VARCHAR(255) .
On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock jeff_murd...@yahoo.com wrote:
This is on a Mac OS X (v10.5.6) system in case that matters.
1. - MySQL Administrator Help button
Hi JIm,
If you are installing mysql on debian operating system you will get all the
storage engines which are required.
mysql show engines;
++--++
| Engine | Support |
Comment
21 matches
Mail list logo