CODEWITHSUNDEEP
mysqltable-lock
Akhil
Akhil

Reputation: 967

Error in importing mysql database

I took dump of a DB from the production. I want to import into my local database

mysql -u user_name -p db < db.sql

But it shows some error

ERROR 1005 (HY000) at line 25: Can't create table 'table_account' (errno:13)

And I am unable to import the table. This issue is occurring when I try to Import a particular database. Tried to import some other database. It works fine.

Could anybody solve this.

Thanks in Advance.

Upvotes: 1

Views: 1366

Answers (3)

Akhil
Akhil

Reputation: 967

I am re posting the answer I mentioned in the comment for easy accessibility.

Command used -> mysql -u root -p lock-tables=false db < databackup.sql

Also the below mentioned link will give you more information link

Upvotes: 0

Mukilan R
Mukilan R

Reputation: 445

Do not create any tables in the database 'mysql'; it is special. Instead CREATE some other DATABASE, and get into it with a USE.

Upvotes: 0

Aman Aggarwal
Aman Aggarwal

Reputation: 18479

Check the owner of the database directory, may be its the issue..

try this : chown -R mysql:mysql /var/lib/mysql/database_name.

Upvotes: 1

Related Questions