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
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 wrote:
> This is on a Mac OS X (v10.5.6) system in case that matters.
>
>
>
> 1. - MySQL Administrator Help button says:
>
> HELP
>
> H
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 wrote:
> We have 5.0.22 installed on a test machine and for some reason the innodb
> storage engine was not enabled. We instal
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 me
The answer is no
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons
Date: Thu, 19 Feb 2009 23:50:13
To:
Cc: MySQL
Subject: Re: Resend: enabling storage engine with RPM install
What configuration parameter in the config file could have an impact on
whether a partic
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 t
Can you post you my.cnf please
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons
Date: Thu, 19 Feb 2009 23:06:33
To:
Cc: MySQL
Subject: Re: Resend: enabling storage engine with RPM install
How does one do that in my.cnf?
It is possible to disable a supported engi
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 s
Perhaps you disabled it via my.cnf
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons
Date: Thu, 19 Feb 2009 22:45:01
To: MySQL
Subject: Re: Resend: enabling storage engine with RPM install
Yes, I had a slip of the mind. The engine that was not supported by the
in
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
instal
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 int
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
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
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.
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
>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
You need to group by forum_id...
On 2/19/09 11:09 AM, "Artem Kuchin" 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( forum_msg.id )
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 forums.so
or as the docs read:
shell> mysqladmin 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');
mysql> FLUS
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
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
21 matches
Mail list logo
