Error import mysql database

2
votes

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

3
mysqlphpmyadmin
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 - Slatan-ko
So what is your question here? You got a clear error message stating the issues. - arkascha
How big is your database? What export file type did you use? - Isaac Bennetch
Possible duplicate of import mysql database from external drive into local lamp stack - e4c5
@e4c5 No this is not a duplicate - different error message altogether (maximum execution time exceeded). - Stefan

3 Answers

1
votes

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

1
votes

I hade the same error, and I noticed that mysql didn't export all tables database; still can't figure the reason, but I started to exporting and importing the tables as groups

enter image description here

After exporting the tables, you can import them, without any problems.

0
votes

I too had the same problem even after downloading in the sql form. My problem was with wp_comments table I exported all the other tables and for wp_comments table I just downloaded the structure only then manually inserted the values. My problem got solved