CODEWITHSUNDEEP
mysql
Vinay S
Vinay S

Reputation: 51

MySQL: [Err] 1146 - Unknown error 1146

I'm using MySQL 5.7.13. I'm getting above error if a table doesn't exist. Not only this whatever the error is I'm getting only 'unknown error'. Can any let me know that how to make MySQL to display actual error i.e. Table doesn't exist.

Thanks

Upvotes: 3

Views: 8363

Answers (3)

captain_a
captain_a

Reputation: 3287

Following two steps will help you out:

  1. if you have copied the mysql data , Go to the original directory xampp/mysql/data ( or whatever is relevant to your OS) , and copy all the files starting with word ib, like ib_logfil0 etc. and paste to the new directory.

  2. Go to mysql command line, and run this command:

mysql_upgrade

Upvotes: 0

AlikElzin-kilaka
AlikElzin-kilaka

Reputation: 35991

Having the same issue with a raw download binary.

Comes with this error when trying to run any mysqld:

[ERROR] Can't find error-message file

Solved it by specifying --lc_messages_dir.

Examples:

mysqld --console --datadir ~/.mysqldata --lc_messages_dir=$MYSQL_HOME/share/english --initialize-insecure 
mysqld --console --datadir ~/.mysqldata --lc_messages_dir=$MYSQL_HOME/share/english

Upvotes: 1

Tn PRAVEEN KUMAR
Tn PRAVEEN KUMAR

Reputation: 1

1.You should probably look if your table exist. 2. If you are inserting data from one table to another table with a statement like, Insert into table_A select * from table_B, in this if there is any column mismatch, you will encounter this error.

Upvotes: 0

Related Questions