Error import mysql database

Question

i export my database and export to another computer use phpmyadmin

but it error,

Static analysis:

2 errors were found during analysis.

Unexpected character. (near ":" at position 53) Unrecognized statement type. (near "div" at position 1) SQL query:

<div class="error"><h1>Error</h1><p><strong>SQL query:</strong> <a href="db_sql.php?sql_query=SET+time_zone+%3D+%22%2B00%3A00%22&amp;show_query=1&amp;db=project1&amp;token=9e474724fcd1b27aa482f098f19b22f1"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" />&nbsp

MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near <div class="error"><h1>Error</h1><p><strong>SQL query:</strong> <a href="db_sql. at line 1

Answer 1

Your export file clearly contains HTML code and not SQL code. Make sure you export your database properly. You can export your database in phpMyAdmin as follows.

1. Log into phpMyAdmin
2. Click the database you are working with in the left menu
3. Click Export in the top menu
4. Under the Export heading, ensure that all of your tables are selected and that the SQL option is selected.
5. Ensure the Save as file option (towards bottom of page) is checked.
6. Click Go
7. You will be prompted to either open or save the file. Please select the option to save the file.

-- cited from http://www.inmotionhosting.com/support/website/phpmyadmin/export-database-using-phpmyadmin