Right
Keep them in the datadir to make things easier for you
Sent via BlackBerry from T-Mobile
-Original Message-
From: "Ananda Kumar" <[EMAIL PROTECTED]>
Date: Sun, 24 Aug 2008 23:47:24
To: Jim Lyons<[EMAIL PROTECTED]>
Cc: mysql
Subject: Re: multiple mysql service on the same server
Hi Jim,
If i need to use different my.cnf file, they should be in different
directory right.
regards
anandkl
On 8/24/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Hi All,
> I did using single my.cnf file, by specifying different server groups,
> which allows for specifying different socket, pi
Hi All,
I did using single my.cnf file, by specifying different server groups, which
allows for specifying different socket, pid and data directory structure. It
can be managed by using mysqld_multi.
regards
anandkl
On 8/22/08, Jim Lyons <[EMAIL PROTECTED]> wrote:
>
> You really need different c
Hi,
Thanks for your input. Yes I can logon to the server and I will try this
command next time it hangs. Will let you know what I see.
Best regards,
Andreas
---
On Sat, Aug 23, 2008 at 5:32 PM, Johnny Withers <[EMAIL PROTECTED]>wrote:
> There are all kinds of logs mysql will produce. You should
I have a strange problem: we have two OpenBSD 4.3 AMD64 servers. We
upgraded one of them from 4.1 to 5.0 with no problem. But we are unable
to upgrade the second one!
All the compilation and installation is OK (version 5.0.67). But when we
try to run the server it stops and the following error
correction, the command that's failing evidently is the 'create table
columns_priv', not a drop table. Sorry for the typo.
2008/8/24 Jim Lyons <[EMAIL PROTECTED]>
> The command that's failing evidently is the "drop table columns_priv" which
> is why you're getting the error message:
>
> *ERROR 1
The command that's failing evidently is the "drop table columns_priv" which
is why you're getting the error message:
*ERROR 1050 ( ) at line : Table 'columns_priv' already exists*
I assume you're trying to restore the mysql database from a backup and the
script is trying to re-create the privileg