Title: Error while importing database! urgent!
Last modified: August 19, 2016

---

# Error while importing database! urgent!

 *  [AntiSaby](https://wordpress.org/support/users/antisaby/)
 * (@antisaby)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/)
 * Hello
    I exported my wp database about 3 weeks ago which was hosted on x10hosting.
   there services are crap so i changed to another webhost. i tried importing database
   but while uploading, i get this error. please help
 * Error
    SQL query:
 * <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “[http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt](http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt);
   <html xmlns=”[http://www.w3.org/1999/xhtml&#8221](http://www.w3.org/1999/xhtml&#8221);
   xml:lang=”en” lang=”en” dir=”ltr”> <head> <meta http-equiv=”Content-Type” content
   =”text/html; charset=utf-8″ /> <link rel=”icon” href=”./favicon.ico” type=”image/
   x-icon” /> <link rel=”shortcut icon” href=”./favicon.ico” type=”image/x-icon”/
   > <title>phpMyAdmin</title> <link rel=”stylesheet” type=”text/css” href=”phpmyadmin.
   css.php?token=f464f289e2f82b298ea323e6e8df5213&js_frame=right&nocache=3802253108″/
   > <link rel=”stylesheet” type=”text/css” href=”print.css” media=”print” /> <meta
   name=”robots” content=”noindex,nofollow” /> <script type=”text/javascript”> try{//
   can’t access this if on a different domain var topdomain = top.document.domain;//
   double-check just for sure if (topdomain != self.document.domain) { alert(“Redirecting…”);
   top.location[…]
 * 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 ‘<!DOCTYPE html
   PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "[http://www.w&#8217](http://www.w&#8217);
   at line 1

Viewing 8 replies - 1 through 8 (of 8 total)

 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770750)
 * What you’re importing isn’t an .sql database dump – it’s a web page!
 *  Thread Starter [AntiSaby](https://wordpress.org/support/users/antisaby/)
 * (@antisaby)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770802)
 * but i am importing a .sql database…….
 *  [planethax](https://wordpress.org/support/users/planethax/)
 * (@planethax)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770804)
 * > <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “[http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt](http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt);
   > <html xmlns=”[http://www.w3.org/1999/xhtml&#8221](http://www.w3.org/1999/xhtml&#8221);
   > xml:lang=”en” lang=”en” dir=”ltr”> <head> <meta http-equiv=”Content-Type” content
   > =”text/html; charset=utf-8″ /> <link rel=”icon” href=”./favicon.ico” type=”
   > image/x-icon” /> <link rel=”shortcut icon” href=”./favicon.ico” type=”image/
   > x-icon” /> <title>phpMyAdmin</title> <link rel=”stylesheet” type=”text/css”
   > href=”phpmyadmin.css.php?token=f464f289e2f82b298ea323e6e8df5213&js_frame=right&
   > nocache=3802253108″ /> <link rel=”stylesheet” type=”text/css” href=”print.css”
   > media=”print” /> <meta name=”robots” content=”noindex,nofollow” /> <script 
   > type=”text/javascript”> try { // can’t access this if on a different domain
   > var topdomain = top.document.domain; // double-check just for sure if (topdomain!
   > = self.document.domain) { alert(“Redirecting…”); top.location[…]
 * That is a Webpage, not a sql db though.
 *  Thread Starter [AntiSaby](https://wordpress.org/support/users/antisaby/)
 * (@antisaby)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770843)
 * thnx for replies…..but i importing that very same db that i exported few days
   ago…..whats the problem then?
 *  [planethax](https://wordpress.org/support/users/planethax/)
 * (@planethax)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770859)
 * must not have export db correctly as what you are trying to import is NOT a db
   but a webpage itself.
 *  Thread Starter [AntiSaby](https://wordpress.org/support/users/antisaby/)
 * (@antisaby)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770862)
 * i followed WP tutorial for exposrting db……..anyway, thnx all
 *  [KAIROS_Canada](https://wordpress.org/support/users/nikairos/)
 * (@nikairos)
 * [14 years, 9 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770975)
 * I’ve had the exact same problem.
 * Exported clearly and directly from PHP MyAdmin, then tried to re-import same 
   database 10 minutes later, and have the same error notification.
 * Anyone have any further thoughts on what could be wrong?
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [14 years, 9 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770976)
 * Please post a new topic.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Error while importing database! urgent!’ is closed to new replies.

## Tags

 * [my](https://wordpress.org/support/topic-tag/my/)
 * [problem](https://wordpress.org/support/topic-tag/problem/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 8 replies
 * 4 participants
 * Last reply from: [esmi](https://wordpress.org/support/users/esmi/)
 * Last activity: [14 years, 9 months ago](https://wordpress.org/support/topic/error-while-importing-database-urgent/#post-1770976)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
