OS error 1453

Dear Fellows, How to deal with the following error: regards mysqld-nt --console 050608 11:12:42 InnoDB: Operating system error number 1453 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: Error number 1453 means 'Unknown error'. InnoDB: See als

Can't Start MySql

MySQL 4.0.14 Win98 platform. what could cause the following error by typing mysqld --console. regards 050525 16:50:13 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 1 154545

Select Query!

Hi, Would this be the best way, if I was to run query to obtain first 2 records of each category from the database. The database could contain literally 100s of 1000s of records. select t1.field1, t2.field2 as CommonFld from table1 t1, table2 t2 where t1.keyfield = t2.keyfield and t1.field1 = '

Update Text + Text

Hi, MySql 4.0.14 How can I do this? Update Table1, Table2 set Table1.Field1 = Table2.Field1 + Table1.Field1 where Table1.KeyField = Table2.KeyField Tried the above with no success. Field1, in both tables is of type Text. regards _

Indexes

MySql 4.0.14 I understand that the most effective way of speeding up SELECT statements is to have column level indexes. Are there any other level indexes exist? I have been told that there are but I have no idea, looked through the manual, could not find anything that speeds up column level ind

Cannot run MySQL

MySql 4.0.14 We tried to convert MyISAM table format to INNODB format, it took forever to finish the process, someone intervened and killed the process through Task Manager. Now can't run Mysqld-nt, running it with the --console reports the followings. Your help is appreciated. Microsoft Window

Premature InnoDB conversion.

MySql 4.0.14 We tried to convert MyISAM table format to INNODB format, it took forever to finish the process, someone intervened and killed the process through Task Manager. Now can't run Mysqld-nt, running it with the --console reports the followings. Your help is appreciated. Microsoft Wind

Error: 1040 too many connections

Hi, MySQL 4.0.14 This may have been queried a lot here. We get this error and after re-starting the server (MySQL) it seems to go away for a while. As per instructions we have changed the max connection in the My.ini to 500 (max_connections=500). MySQLAdmin displays connections = 120. Is th

General query question

Hi, Mysql 4.0.14 In a seconrio, some reocrds are missing from a child table. If we run this query it returns the missing records: select a.field1, b.field2 from table1 a left join table2 b on (a.field1 = b.field1) where b.field1 is null I want to create entries in the child table (table2) fo

Re: General query question

Thanks, I did think of it but not having the option as this is linked to executables, which I'm sure have some sorts of calculation for this field to calculate the next value. regards --- Jigal van Hemert <[EMAIL PROTECTED]> wrote: > > I want to create entries in the child table > (table2) >

probs with starting mysql (urgent pls)

MySQL 4.0.14 InnoDB (File size as it stands at present) = 6 GB We have tried move the data folder from one hard disk to another still the same problem. We really are in need of help here. Is there any size limit in InnoDB? I did ask this before, I did get some reponse thank you. But due to th

Re: mysqld-nt error 23. Urgent pls

der.php > > Order MySQL technical support from > https://order.mysql.com/ > > > > - Original Message - > From: "A Z" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Wednesday, November 17, 2004 1:48 AM > Subject: mysqld-nt

Mysql & NTFS

MySQL 4.0.14 Are there any known issues with MySQL (above version) and NTFS file system with 120 GB of hard-disk and Win 2000 pro. We are facing a problem of mysqld-nt crashing intermittently, throwing error numbers 995, 32. any help is appreciated. regards ___

mysqld-nt error 23. Urgent pls

MySQL 4.0.14 Need help please with the folowing: On starting mysqld-nt using mysqld-nt --console we the get the follwing output 041115 10:31:59 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: lo

How?

Hi, MySql 4.0.14 How can I force the following query to use a reference in table1. select * from table1 a left join table2 b on (a.field1 = b.field1) order by b.field2 limit 1 both a.field1 and b.field1 have indexes. Explaining the command indicates that, MySql uses an index (possible_keys)

Duplicate Rows

MySQL 4.0.14 In a scenario: Ref EmailAddr 1[EMAIL PROTECTED] 2[EMAIL PROTECTED] 3[EMAIL PROTECTED] 4[EMAIL PROTECTED] how can I delete duplicate email entries (records 1, 2) leaving 4. regards

Select

MySQL 4.0.14 Trying to run a select statement on field (varchar) containing values (e.g. ':', '/', '\') returns blank recordset although records exist. select * from table1 where field1 = 'c:\folder\filename.extension' Is there any particular rule to follow. I inserted the same row twice and r

Concat

Hi, Concat() returns Null if any field in the field list is Null. How can I use it to return a String regardless, or is there another function to do it? regards ___ALL-NEW Yahoo! Messenger - all new f

How to?

An existing database table structures has changed, I want to create the same database with new table structures. I do not want to lose any data. How can I do this? do a backup how? regards ___ALL-NEW

Performance

Mysql 4.0.14 2 Tables: Table1: Indexed on Field1 (primary key), Field2 Table2: Indexed on Field1 (primary key), Field2 (Foreign key from table1) When I do this explain select a.*, b.* from table1 a, table2 b, where a.field1 = b.field2 and a.field2 = 'value'. returns the result: Table type

How to (Unique value)?

4.0.14 Its rather a general SQL question, I'll ask it as I'm using MySQL. An converted table has field of type VarChar(6), containing alphanumeric chars. Is it possible to run a query to generate a unique key so this can be used for new record? regards

Re: Exists

MySQL 4.0.14 regards --- Rhino <[EMAIL PROTECTED]> wrote: > What version of MySQL are you running? The answer to > your question depends > on the version. > > Rhino > > - Original Message - > From: "A Z" <[EMAIL PROTECTED]> > To: <

Exists

Hi, How can I write this query? Insert into table1 (field1) select (a.field1) from table2 a where a.field1 not exists (select c.field1 from table1 c) regards Yahoo! Messenger - Communicate instantl

Filling column

Hi, Is there a function to fill an integer column in incremental order (1,2,..,n). Cannot use Auto_Increment as the table has another primary key. regards Yahoo! Messenger - Communicate instantly..

Max

Hi, A field of type VarChar() with following syntax: ABA1. How to get the Max value. Bearing in mind that value ABA10 comes before ABA2. regards Yahoo! Messenger - Communicate instantly..."Ping"

Type=InnoDB

the following raises error:150. Does this mean we cannot do this in INNODB format? create table t1 (a1 integer not null, b1 varchar(36), primary key (a1), foreign key (b1) references t2(b1) on delete cascade) TYPE=INNODB regards _

Query 2 DBs

Hi, 2 DBs sitting on different machines, any idea of how to run the query? Select a.*, b.field1 from computernam.db1.table1 a, computername.db2.table1 b where a.fieldx = b.fieldx where computername is host for DB. regards __

MS 2000 Advance Server

Hi, MySQL 4.0.14 Are there any known issues on windows 2000 advance server? After installation, on running the WinMySQLAdmin the green light comes on for a second or two and then disconnected. We tried running MySQLd-nt on its own, it simply cannot establish connection. What could be wrong here?

If DataBase Exists

MySQL 4.0.14 Possible to query for existence of a DB. For example connect to MySQL and run run a command to check if Database (Test2) existed. regards ___ Yahoo! Messenger - Communicate instantly..."P

Re: Another Performance query

¦ BTREE regards --- Benoit St-Jean <[EMAIL PROTECTED]> wrote: > A Z wrote: > > >Thanks for your replies regarding to my previous > >query. > > > >We have encountered another problem: > >MySQL 4.0.14, INNODB. > >A table does have an Index

Another Performance query

Thanks for your replies regarding to my previous query. We have encountered another problem: MySQL 4.0.14, INNODB. A table does have an Index on Field1, this field (Field1) is also the Primary Key. Querying on this field takes a long time, running along with Explain command it displays that it d

Re: Select Performance

gards --- Harald Fuchs <[EMAIL PROTECTED]> wrote: > In article > <[EMAIL PROTECTED]>, > A Z <[EMAIL PROTECTED]> writes: > > > The problem (very slow) occurs when the query is > run > > on combination of these fields: > > Select * from table1 where

Select Performance

A table (Table1) with the relevant indices (e.g. Field1Idx, Field2Idx) exists. Running a query like: Select * from table1 where Field1Idx Like 'Value%' returns result in expected timing scale, so does the query: Select * from table1 where Field2Idx Like 'Value%' The problem (very slow) occurs wh

Help is appreciated

I am running Delphi 6 Ent. along with Corelab technology to access MySQL 4.1.14. We run into problem of table coruption (error: 127, 145) from time to time using the following SQLs. This is done in the transaction context. Most of the time it works fine but it does get into problem. We have tes