MySQL Error 1030: Got error -30996 from table handler

List, I would appreciate if somebody has any ideas on the above error. We are getting this error Error 1030: Got error -30996 from table handler with BDB tables on a Linux Server (Red Hat 7.3), the version of MySQL is 3.23.42 Thanks Sridhar

Sorting the query results of a MySQL BerkeleyDb Table produces incorrect results

Dear List, Sorry for reposting the issue, once again One of our MySQL db's containing BDB tables is exhibiting a strange behavior. A query consisting of an ORDER BY clause is returning wrong result set. The same query when used without an ORDER BY clause returns the correct result set.

Re: Select with order by clause on a MySQL BDB table returning incorrect

[EMAIL PROTECTED] wrote: Sridhar, Wednesday, September 25, 2002, 12:23:29 AM, you wrote: SP One of our MySQL db's containing BDB tables is exhibiting a strange SP behavior. SP A query consisting of an ORDER BY clause is returning wrong result set. SP The SP same query when used without

Select with order by clause on a MySQL BDB table returning incorrect

Dear List, One of our MySQL db's containing BDB tables is exhibiting a strange behavior. A query consisting of an ORDER BY clause is returning wrong result set. The same query when used without an ORDER BY clause returns the correct result set. Environment: Sun Solaris 2.7, MySQL 3.23.51, Table

Multi-Table Delete with MySQL 3.23.51

Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables. The delete logic is not simple, i have to check a number of tables before i can actually delete a row from a

Multi-Table Referential Delete Clarification with MySQL 3.23.51

Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables. The delete logic is not simple, i have to check a number of tables before i can actually delete a row from a

Re: Multi-Table Referential Delete Clarification with MySQL 3.23.51

Forgot to mention that all of my tables are of TYPE: MyISAM Thanks Sri [EMAIL PROTECTED] wrote: Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables.

Q: Data Modeling Tool for MySQL ???

Can anyone suggest a good data modeling tool that can be used for: a) Reverse enginering: dump file = data model b) Create a new data model c) Generate the ddl from the data model d) The tool should handle the latest features of MySQL 3.23.52 Any comments about the tool called dezign. Is it any

How to upgrade/migrate Mysql Server

Mysql Gurus, We are currently using Mysql (3.22.32) on a Solaris platform. We are looking to upgrade/migrate this current version to 3.23.49a, for utilizing the replication functionality. I would appreciate if anyone can clarify the following: 1) Any known/unknown issues with 3.23.49a 2) What

Mysql Error while starting up

Has anyone encountered the following error, while starting the mysql daemon as a user other than root. Can't create IP Socket: Permission Denied I do not encounter any problem when running the same as root I have checked the permission on /datadir /basedir /tmp, they seem to be OK. Thanks