This question is based on this thread.
I run unsuccessfully
sudo mysql
\. /users/cs/SO_db/posts.sql
I get the error
ERROR 1146 (42S02): Table 'personal.posts' doesn't exist
MySQL's manual says
A five-character SQLSTATE value ('42S02'). The values are specified by ANSI SQL and ODBC and are more standardized. Not all MySQL error numbers are mapped to SQLSTATE error codes. The value 'HY000' (general error) is used for unmapped errors.
and
Error: 1146 SQLSTATE: 42S02 (ER_NO_SUCH_TABLE)
Message: Table '%s.%s' doesn't exist
How can you solve the error message?
probably your sql file doesn't include the "create table" command.
As I mentioned in the post you referenced, you NEED to create the tables first. Peek at the XML or the SQL output on what columns you need. e.g. here is a table that can hold the output from badges.xml (I don't have the others available right now..)
Your posts.sql contains some statements referencing a posts table, which doesn't exist in your personal schema.
To "solve" the error, ensure the table is created!
The SQL script you have loaded makes reference to a database and/or table which does not exist in the database.
Typically one would not call the
mysql
tool withsudo
, as the system user privileges are different from MySQL users.To execute an SQL script through mysql I would try something like:
This command would load 'somefile.sql' into
mysql
tool, connecting to a MySQL server onlocalhost
as user<mysqluser>
and selecting the database<mysqldb>
. Themysql
tool will prompt for<mysqluser>
's access password before executing the script.Have you actually created the database 'personal' and the table 'posts'?
You might want to try something like: