#1064 Database importing error

5 pts.
Tags:
phpMyAdmin
SQL Query
I am getting this error when I import the database in phpMyAdmin. Only few tables is imported.
SQL query:

<!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a href="tbl_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60chnine_wp1%60+LIKE+%27wp_posts%27&show_query=1&db=chnine_wp1&table=wp_posts&token=33ade7cece3d07206b6d78ecd3125fb3"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p> <p> <span class="syntax"><span class="inner_sql"><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fshow.html&token=33ade7cece3d07206b6d78ecd3125fb3" target="mysql_doc"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span></a> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_alpha syntax_alpha_reservedWord">STATUS</span> <span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_quote syntax_quote_backtick"><code>chnine_wp1</code></span> <a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc[...]

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
<p><strong>SQL quer' at line 1
 


Software/Hardware used:
wordpress
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    It is very hard to see the command that was attempted, but it appears that it was SHOW TABLE STATUS.

    It is also not clear whether you tried to run that command, or was something done automatically during the import process.

    In case you tried to run it, the syntax would be something like this:

    SHOW TABLE STATUS FROM <database name> LIKE '%tables%name%pattern%';

    84,640 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: