Re: Installation Question - RedHat 9.0

2003-12-16 Thread Nicolas Ross
For RedHat, just download the rpms and install it, it's far much simpler... Nicolas - Original Message - From: "Ryan Sinnwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 1:21 PM Subject: Installation Question - RedHat 9.0 I am trying to setup Jabberd2

Innodb in production

2003-12-15 Thread Nicolas Ross
Hi ! Our db server has about 140+ db's for a total of about 1.5 gigs of data. Some while ago, for a specific DB, I did testing using transaction tables with bdb. This was a bad experience. I ran into some problems and I had to convert back to myisam. One thing I don't like about innobd and bdb i

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-15 Thread Nicolas Ross
> > >2. Grants aren't working. > > > > > >Almost for each db we have the grant I did is something like : > > > > > >grant all on db.* to 'user'@'%.domain.com' identified by 'password'; > > > > > >So, I end up with a user with no global privilege in the user table, and > a > > >entry in the db table

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
> >2. Grants aren't working. > > > >Almost for each db we have the grant I did is something like : > > > >grant all on db.* to 'user'@'%.domain.com' identified by 'password'; > > > >So, I end up with a user with no global privilege in the user table, and a > >entry in the db table with all privs. >

MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower case. This not a major issue, as the dbs are s