Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Lock???

Status
Not open for further replies.
maccherons

maccherons

Programmer
Joined
Jun 3, 2004
Messages
9
Location
IT
I'm writing a backup script for my database. I use SHOW KEYS and SHOW FIELDS to have the information I need to write the INSERT and CREATE inctruction, but after using show intructions I have my tables as if they were locked. If I try to drop a table I have this message bacK: Error on delete of '.\Borghi\categorie.MYI' (Errcode: 13).

Details: I use mysql MySQL 4.0.0-alpha-nt on Windows XP
Please don't reply me to use a Linuz sys: it's not my choice

Thanx
 
Status
Not open for further replies.

Similar threads

Loomis
  • Locked
  • Question Question
stepping through table rows
Replies
7
Views
823
rashmibala
R
Marclem
  • Locked
  • Question Question
Joining 4 tables issue
Replies
11
Views
1K
Andrzejek
Andrzejek
boylesg
  • Locked
  • Question Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
908
spamjim
spamjim
lupidol
  • Locked
  • Question Question
Cannot create new table in mySQL
Replies
6
Views
1K
lupidol
lupidol
Arthur Lewis
  • Locked
  • Question Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
329
Arthur Lewis
Arthur Lewis

Part and Inventory Search

Sponsor

Back
Top