MySQL: #1146 – Table ‘xxx.xxxxx’ doesn’t exist

errorSometimes you get this type of error when you just changed the hoster or moved your database files physically to the new location:

#1146 – Table ‘xxx.xxxxx’ doesn’t exist

This error usually comes up when you try to import your data into database and your sql file that you import, has CREATE statement. Nothing scary. The folders containing files of your databases in /usr/local/mysql-x.x/ should have 755 permission BUT files inside of those folders should have permission 644.

However, if you only need to do it properly in one or two databases, you can just drop these databases using phpMyAdmin and then create them again with the same names and permissions. After that your CREATE statement will be able create table and you shouldn’t have an issue to import your sql file.

Bookmark and Share
Here can be your banner, contact me about conditions.