PMA-SQL-ERROR

Permalink
While importing database from a live site to my local server, I got this PMA-SQL-ERROR in phpMyAdmin. I am unable to figure out what was actually giving out this error. It looks like this error is part of 'WorkflowRequestObjects' table import.

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+%60advht_c5db%60+LIKE+%27WorkflowRequestObjects%27&show_query=1&db=advht_c5db&table=WorkflowRequestObjects&token=712d9d10771a043248ec7d81487f1a47"><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=712d9d10771a043248ec7d81487f1a47" 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">`advht_c5db`</span> <a [...]
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


I took another database dump of the server the next day and tried importing the sql. This time, everything worked as normal.

Does anyone know why I got the error the first time? I am using 5.6.3.2.

BlueFractals
View Replies: