MyBB Community Forums

I import mysql data base and try to import into new database. When I try to import it shows error as below.

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+%60365com16%60+LIKE+%27mybb_privatemessages%27&amp;show_query=1&amp;db=365com16&amp;table=mybb_privatemessages&amp;token=58dab79545e16f1cb920992a240dbbdd"><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&amp;token=58dab79545e16f1cb920992a240dbbdd" 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">365com16</span> <a href="./url.php?url=http%3A%2F%2Fd[...]
MySQL said:

#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 

Please help me to get import mysql data base correctly.

The file you are trying to import appears to be a HTML file, not a database dump.

(2015-08-14, 09:55 AM)StefanT Wrote: [ -> ]The file you are trying to import appears to be a HTML file, not a database dump.

No its a SQL file.

But it's not an SQL Query you show in your opening post. As Stefan says, this is HTML which is about an SQL error.

(2015-08-15, 09:13 AM)Ad Bakker Wrote: [ -> ]But it's not an SQL Query you show in your opening post. As Stefan says, this is HTML which is about an SQL error.

So is there anyway to correctly import mysql database into new database?

(2015-08-16, 02:30 AM)freeeducation365 Wrote: [ -> ]So is there anyway to correctly import mysql database into new database?

What do you know about the origin of this file? Because as it is, it is no valid mysql database.