Problem in Importing database

  • Resolved Tony.N

    (@tonyn-1)


    9 years, 4 months ago

    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

    (@radices)

    9 years, 4 months ago

    I’d try exporting it again. Perhaps a corruption occurred.

    RossMitchell

    (@rossmitchell)

    9 years, 4 months ago

    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

    (@tonyn-1)

    9 years, 4 months ago

    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

    (@senff)

    9 years, 4 months ago

    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

    (@ccarfi)

    9 years, 4 months ago

    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

    (@tonyn-1)

    9 years, 4 months ago

    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

    (@tonyn-1)

    9 years, 4 months ago

    Hi ccarfi,

    thanks for your reply.

    I’m on a shared hosting. “Deluxe Web Hosting Linux”

    Thanks

    ccarfi

    (@ccarfi)

    9 years, 4 months ago

    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

    Thread Starter Tony.N

    (@tonyn-1)

    9 years, 4 months ago

    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

    (@ccarfi)

    9 years, 4 months ago

    Can you please drop me an email? Redacted email

    Thread Starter Tony.N

    (@tonyn-1)

    9 years, 4 months ago

    ccarfi, email sent

    ccarfi

    (@ccarfi)

    9 years, 4 months ago

    Hi Tony- There’s some odd stuff in the file. I’ll respond via email.

    Thread Starter Tony.N

    (@tonyn-1)

    9 years, 4 months ago

    Bluehost sucks, I cancelled & migrated all websites to godaddy not just the single website on the post.

    Thanks ccarfi, thanks Godaddy.

    ccarfi

    (@ccarfi)

    9 years, 4 months ago

    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.