MySQL Forums
Forum List  »  Newbie

#1146 - Table ... doesn't exist
Posted by: Jonathan Sachs
Date: June 28, 2011 06:44PM

I'm trying to import a database to one computer which I exported from another. MySQL is version 5.0.7; OS is Windows 7.

I did this:

1. Created the database in phpMyAdmin.

2. Created a corresponding user; granted the user all permissions (except GRANT) on the database.

3. Logged in to phpMyAdmin as the new user; selected the database; tried to do the import.

I got the message "#1146 - Table 'dbname.tablename' doesn't exist."

I tried copying the CREATE TABLE statement at the beginning of the import file and executing it by itself. I got the same error.

This doesn't make sense to me. If something is wrong with my request -- faulty permissions, say -- I'd expect an error message saying that. If nothing is wrong, it should create the stupid table. What's it trying to tell me?

Options: ReplyQuote


Subject
Written By
Posted
#1146 - Table ... doesn't exist
June 28, 2011 06:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.