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 as a

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

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 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

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. User table :