InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_a'
``.<result 2 when explaining filename '#sql1d84_2_a'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_6'
``.<result 2 when explaining filename '#sql1d84_2_6'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_2'
``.<result 2 when explaining filename '#sql1d84_2_2'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_8'
``.<result 2 when explaining filename '#sql1d84_2_8'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_5'
``.<result 2 when explaining filename '#sql1d84_2_5'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_a'
``.<result 2 when explaining filename '#sql1d84_2_a'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_6'
``.<result 2 when explaining filename '#sql1d84_2_6'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_2'
``.<result 2 when explaining filename '#sql1d84_2_2'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_8'
``.<result 2 when explaining filename '#sql1d84_2_8'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110315 2:31:37 InnoDB: Error: table 110315 2:31:37 [Warning] Invalid (old?) table or database name '#sql1d84_2_5'
``.<result 2 when explaining filename '#sql1d84_2_5'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
110316 4:47:38 InnoDB: highest supported file format is Barracuda.
110316 4:47:39 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
110316 4:47:39 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './tmp/#sql2ac7_1_0.ibd'!
InnoDB: Have you moved InnoDB .ibd files around without using the
InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?
InnoDB: It is also possible that this is a temporary table #sql...,
InnoDB: and MySQL removed the .ibd file for this.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
InnoDB: We removed now the InnoDB internal data dictionary entry
InnoDB: of table 110316 4:47:39 [Warning] Invalid (old?) table or database name '#sql2ac7_1_0'
"tmp".<result 2 when explaining filename '#sql2ac7_1_0'>.
110316 4:47:39 InnoDB: Waiting for the background threads to start
110316 4:47:40 InnoDB: 1.1.5 started; log sequence number 1141736332040
110316 4:47:44 InnoDB: Error: table 110316 4:47:44 [Warning] Invalid (old?) table or database name '#sql2ac7_1_0'
``.<result 2 when explaining filename '#sql2ac7_1_0'> does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
这样你SHOW TABLES是可以看见的,但是在执行SQL语句的时候会报unknown ....的错误