'Error import mysql database

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

mysqlphpmyadmin


Solution 1:[1]

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.

Solution 2:[2]

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

Solution 3:[3]

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

Solution 4:[4]

I had the same problem when I want to migrate my wordpress to a new doamin, so I tried many options; the best one that fixes my problem is trying exporting/importing database using the command line in the terminal.

Export DB: mysqldump -u usernameDB -p name_DB > /home/file.sql
Importing DB: mysql -u username_newDB -p name_newDB < /home/file.sql

NOTICE ALL COMMAND ARE EXECUTED IN TERMINAL not logged in Mysql DB.

Solution 5:[5]

You SQL is not exported properly.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Al-Amin Sarker
Solution 2
Solution 3 Juice
Solution 4 PM 77-1
Solution 5 Misbakh Ahmed

Related Questions