Re: adding then removing index produces different query results

2008-01-24 Thread mysql mysql
On 1/24/08, Chris <[EMAIL PROTECTED]> wrote: > > mysql mysql wrote: > > Thanks for the response Chris, although I can't seem to reproduce the > > problem now, but I'm sure you're right. > > > > There's something else strange that I've e

Re: adding then removing index produces different query results

2008-01-23 Thread mysql mysql
Thanks for the response Chris, although I can't seem to reproduce the problem now, but I'm sure you're right. There's something else strange that I've encountered while trying to optimize this query. I've got two machines, dev and production. After adding the index to the title attribute on the d

adding then removing index produces different query results

2008-01-22 Thread mysql mysql
Can anyone explain the following? I encountered the following very strange behaviour while attempting to optimize a query (more details are provided later on for those interested): 1) execute query takes 2 minutes 2) add index 3) execute same query takes 11 seconds 4) drop index 5) execute same

Change storage location

2003-12-21 Thread Mysql Mysql
Hi All, I have newly installed mysql 3.23.54 in Red Hat 9 (The one which was bundled with the OS). And default the data storage file location went to /var/lib/mysql, how do I change the location to /mysql, I have also tried modifying my.cnf it didn't help. Any suggestion. -mysql -

Any one can drop a table or database

2003-12-20 Thread Mysql Mysql
Hi, I am new to mysql. I have installed, created a database and also some created tables. Now any one who can login to the host are able to drop the table or also the database. How do I protect it? -mysql - Do you Yahoo!? New Yahoo! Photos - easier uploading

How to execute a file in mysql prompt

2003-12-20 Thread Mysql Mysql
Hi, I have a file which has Creation of tables and views. How can I run the file in mysql prompt. -mysql __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.my

Post-install

2001-09-21 Thread mysql mysql
Just installed mssql and in the end of the installation I receive the message taht now is the time to change root password for the db using mysqladmin using the following synthax: /usr/bin/mysqladmin -u root -p password 'new password' So issued the following command: /usr/bin/mysqladmin -u root -p