mysql run sql_To run a .sql -file in MySQL

可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):

问题:

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 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?

回答1:

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..) CREATE TABLE `badges` ( `Id` int(11) NOT NULL default '0', `UserId` int(11) not NULL, `Date` datetime not NULL, `Name` varchar(32) not NULL, PRIMARY KEY (`Id`), KEY `Date` (`Date`), KEY `UserId` (`UserId`) ) ;

回答2:

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 with sudo, as the system user privileges are different from MySQL users.

To execute an SQL script through mysql I would try something like: cat somefile.sql | mysql -u -p

This command would load 'somefile.sql' into mysql tool, connecting to a MySQL server on localhost as user and selecting the database . The mysql tool will prompt for 's access password before executing the script.

回答3:

Have you actually created the database 'personal' and the table 'posts'?

You might want to try something like: mysql -h localhost -u -p -D personal < /users/cs/SO_db/posts.sql

回答4:

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!

回答5:

probably your sql file doesn't include the "create table" command.