Title: Problem in Importing database
Last modified: August 22, 2016

---

# Problem in Importing database

 *  Resolved [Tony.N](https://wordpress.org/support/users/tonyn-1/)
 * (@tonyn-1)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/)
 * Hello,
    I’ve a working wordpress website in a bluehost hosting.
 * I’m trying to migrate to godaddy. After exporting database from bluehost and 
   trying to import it to godaddy, I get this error:
 *     ```
       {
       Error
       SQL query:
   
       <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" 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?server=1&token=6966799c25798a14ed63f4d251d82d5d&js_frame=right&nocache=5409463157" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.custom.css" /> <meta name="robots" content="noindex,nofollow" /> <script src="./js/cross_framing_protection.js?ts=1344778698" type="text/javascript"></script> <script src="./js/jquery/jquery-1.4.4.js?ts=1344778[...]
   
       MySQL said: Documentation
   
       #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 &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot;
           &quot;http://www.w' at line 1
       }
       ```
   
 * I’m not sure what is that error and what is the reason of the error, I mean either
   a problem in my database, or either hostings? taking in consideration that the
   same database is still live and working fine in bluehost.
 * Thanks,
 * Best Regards..

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

 *  [Radices](https://wordpress.org/support/users/radices/)
 * (@radices)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578325)
 * I’d try exporting it again. Perhaps a corruption occurred.
 *  [RossMitchell](https://wordpress.org/support/users/rossmitchell/)
 * (@rossmitchell)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578329)
 * There is an excellent plugin for migrating WordPress installations it is called
   DUPLICATOR.
 * Your error is quite serious, somehow an HTML type file is being examined for 
   database SQL commands, this is very wrong. Most likely you are trying to import
   the wrong file.
    If it is not a simple fix, I would suggest that you delete this
   failed transfer and start again from scratch.
 *  Thread Starter [Tony.N](https://wordpress.org/support/users/tonyn-1/)
 * (@tonyn-1)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578341)
 * Thanks all for your reply.
 * Unfortunately, I’ve repeated the process again and again with no result.
 * I also used the duplicator and didn’t work with me. Most of the items were giving
   warning though my website’s database is just 5 MB.
 * when I try to import on bluehost, there is no error shows. Only in godaddy error
   shows!
 * any help with that please?
 *  [Senff – a11n](https://wordpress.org/support/users/senff/)
 * (@senff)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578346)
 * It looks like you’re not importing a database file, but an HTML file.
 * I’m not all too familiar with the Godaddy importing process, but are you pointing
   to a file online or are you uploading a file? How large is the file, and are 
   you able to view it’s contents in some way?
 *  [ccarfi](https://wordpress.org/support/users/ccarfi/)
 * (@ccarfi)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578348)
 * Hi Tony.N. I work at GoDaddy. Is your GoDaddy hosting account a shared hosting
   account (e.g. cPanel), or is it on Managed WordPress?
 *  Thread Starter [Tony.N](https://wordpress.org/support/users/tonyn-1/)
 * (@tonyn-1)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578353)
 * Thanks for your reply.
 * I’m importing .sql file
 * When I import it into bluehost, I don’t get any problems. When I import it with
   godaddy, I get problems.
 * The file is only 5 MB.
 * Regards..
 *  Thread Starter [Tony.N](https://wordpress.org/support/users/tonyn-1/)
 * (@tonyn-1)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578354)
 * Hi ccarfi,
 * thanks for your reply.
 * I’m on a shared hosting. “Deluxe Web Hosting Linux”
 * Thanks
 *  [ccarfi](https://wordpress.org/support/users/ccarfi/)
 * (@ccarfi)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578358)
 * Here is the step-by-step on how to do it. [https://support.godaddy.com/help/article/6117/moving-your-wordpress-site-to-us-from-another-host](https://support.godaddy.com/help/article/6117/moving-your-wordpress-site-to-us-from-another-host)
 *  Thread Starter [Tony.N](https://wordpress.org/support/users/tonyn-1/)
 * (@tonyn-1)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578360)
 * Thanks ccarfi for your reply.
 * I have done all those steps. The problem is on importing database to godaddy.
   When I try to import it to other servers (bluehost), it works fine.
 * Thanks
 *  [ccarfi](https://wordpress.org/support/users/ccarfi/)
 * (@ccarfi)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578372)
 * Can you please drop me an email? Redacted email
 *  Thread Starter [Tony.N](https://wordpress.org/support/users/tonyn-1/)
 * (@tonyn-1)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578380)
 * ccarfi, email sent
 *  [ccarfi](https://wordpress.org/support/users/ccarfi/)
 * (@ccarfi)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578398)
 * Hi Tony- There’s some odd stuff in the file. I’ll respond via email.
 *  Thread Starter [Tony.N](https://wordpress.org/support/users/tonyn-1/)
 * (@tonyn-1)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578564)
 * Bluehost sucks, I cancelled & migrated all websites to godaddy not just the single
   website on the post.
 * Thanks ccarfi, thanks Godaddy.
 *  [ccarfi](https://wordpress.org/support/users/ccarfi/)
 * (@ccarfi)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578565)
 * You’re welcome! Glad we could help.

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

The topic ‘Problem in Importing database’ is closed to new replies.

## Tags

 * [export database](https://wordpress.org/support/topic-tag/export-database/)
 * [godaddy](https://wordpress.org/support/topic-tag/godaddy/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 14 replies
 * 5 participants
 * Last reply from: [ccarfi](https://wordpress.org/support/users/ccarfi/)
 * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/problem-in-importing-database/#post-5578565)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
