Problem with a specific select

2001-10-03 Thread Hugo Koji Kobayashi
Hi, I'm making some tests with mysql and I got the errors below when I run these selects: SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10; ERROR 1034: Incorrect key file for table: '#sql17adb_41f_4'. Try to repair it SELECT id, COUNT(*) FROM error_test WHERE info = 1

Re: Problem with a specific select

2001-10-03 Thread Hugo Koji Kobayashi
On Wed, Oct 03, 2001 at 06:39:45PM +0200, Carsten H. Pedersen wrote: Hi, I'm making some tests with mysql and I got the errors below when I run these selects: SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10; ERROR 1034: Incorrect key file for table:

Re: Problem with a specific select

2001-10-03 Thread Hugo Koji Kobayashi
On Wed, Oct 03, 2001 at 05:02:27PM +, Carl Troein wrote: Hugo Koji Kobayashi writes: I'm making some tests with mysql and I got the errors below when I run these selects: SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10; ERROR 1034: Incorrect key file

Re: cannot set root mysql password

2001-08-03 Thread Hugo Koji Kobayashi
Hello, On Fri, Aug 03, 2001 at 10:48:55AM +0500, Grigory Bakunov wrote: No. You need to remove -p from this command line. So /usr/bin/mysqladmin -u root password 'new-password' works like a dream -); So, this must be corrected on the install script ($bindir/mysql_install_db): - echo