Re: multiple mysql service on the same server

2008-08-24 Thread chaim . rieger
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

Re: multiple mysql service on the same server

2008-08-24 Thread Ananda Kumar
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

Re: multiple mysql service on the same server

2008-08-24 Thread Ananda Kumar
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

Re: mysqld hangs

2008-08-24 Thread Andreas Wideroe
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

Unable to upgrade to 5.0: Address already in use

2008-08-24 Thread Federico Giannici
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

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

2008-08-24 Thread Jim Lyons
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

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

2008-08-24 Thread Jim Lyons
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