Re: is this a MySQL bug?

2002-11-27 Thread Chris Barnes
n 28 Nov 2002, at 3:24, Chris Barnes wrote: > > > i do > > "lock tables jobs read" > > > > everything seemed ok so then i do > > > > "lock tables mechanics read" > > > > again no errors so i guess it worked..now i'm expec

is this a MySQL bug?

2002-11-27 Thread Chris Barnes
Hi, I keep getting error 1100 (table [table name(s) was not locked with LOCK TABLES) but I am definitely locking them with LOCK TABLES... here's examples of what i'm doing... i have 2 tables i'm trying to work with...jobs and mechanics i do "lock tables jobs read" everything seemed ok so then i

lock statement

2002-09-23 Thread Chris Barnes
hi people, just a quick question. is there a way i can use the "lock tables" statement to lock all the tables in a database which out having to specify all tables individually? i dont really want to use a statement like: lock tables table1 read, table2 read table3 read, table4 read, table5 read,

RE: mysqldump on tables which use auto_increment

2002-08-27 Thread Chris Barnes
Hi, I have a database which a few tables which have a few fields set with auto_increment and i'm having alot of trouble restoring the backup because the backup recreates the table with the auto_increment field, but when it tries to enter the data back into the table it cant because it is trying to

MySql table corruption...

2002-07-13 Thread Chris Barnes
Hi people, I'm new to the list. I'm writing because I've been having trouble with table corruption. I'm using isam tables and i've been using myisamchk under linux to check them. alot of the time it just reports that some of the tables were'nt closed properly so i repair them but after doing that

RE: MyODBC driver window keeps popping up...

2001-03-22 Thread Chris Barnes
Anybody know how to solve the Same Problem in Access 2K ? Cheers Chris >= Original Message From Frank Hacker <[EMAIL PROTECTED]> = >Hi Gert! > >Thanks for the very, very excellent tip - worked just great! > >Now I can start on the PHP coding :-)) > >Bye! > >Frank Hacker ([EMAIL PROTECTE