ERROR 1005 : Can't create table <>help

masood131

Hi
I am trying to create a table, but I am getting this error. CAn anyone help?

ERROR 1005 (HY000): Can't create table '.\books\customers.frm' (errno: 121)

Also can anyone tell me where I can look find MySQL error log, so I can look at it. Does it give more info than this one liner?

Is there anywhere where I can see what each error means? Perhaps the MySQL manual. I went there, but I couldn't find the error.

Thanks all

bradgrafelman

On my computer, I installed MySQL in c:\mysql\

The error log is here:

c:\mysql\logs<computer name>.err

With a computer name of 'server1', it would be:

c:\mysql\logs\server1.err

Look in there around the time it happened, or search for some keywords.

I'm guessing possible causes for this error are permissions settings, whether in the MySQL privilige table or actual file permissions on that directory.

masood131

That was a fast reply. Thanks

I have also have MySQL installed in c:\mysql\, but I don't have any log folder in my "MySQL" folder. Strange, isn't it?

I am running MySQL locally on my own computer, and I am the admin. I gave the password when I logged on, and the file as far as I know was not assigned any passwords.

Thank you for the reply

bradgrafelman

I am EXTREMELY SORRY, that was a TYPO.

Correct path is: c:\mysql\data\logs

I be an retarded :o

masood131

I also checked data and I have no logs in it. Bummer 😕

bradgrafelman

Is there perhaps:

c:\mysql\data<computer name>.err?

I.E.

c:\mysql\data\server1.err

masood131

No brad. There is only mysql, and test foder in my data folder plus bunch of other files that are not associated yet. But none are logs, or a computer name.

Well, I have to go to work. That all the time I have now. But I wished they would have a repository of errors for everyone to go and see what the errors are all about, and their explanation.

Thanks for all your help

Have a good night/day

bradgrafelman

I've come across a few cases in MySQL's bugs repository, not sure if they apply here...

Could you paste your exact & entire SQL code that caused this error?

ahundiak

mysql error codes are documented here:
http://dev.mysql.com/doc/mysql/en/error-handling.html

But it's not much help. The function mysql_error sometimes prints out more information but usually is just complains about syntax errors.

Make sure you check for errors following every mysql function calls. It could be that your connection attempt is failing silently.

Otherwise, post your CREATE TABLE sql. Not the code that generates it but the sql itself.