WordPress.org

Support

Support » How-To and Troubleshooting » Error while importing database! urgent!

Error while importing database! urgent!

  • AntiSaby

    @antisaby

    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”> <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?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‘ at line 1

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

    @esmi

    Forum Moderator

    What you’re importing isn’t an .sql database dump – it’s a web page!

    AntiSaby

    @antisaby

    but i am importing a .sql database…….

    planethax

    @planethax

    <!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?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.

    AntiSaby

    @antisaby

    thnx for replies…..but i importing that very same db that i exported few days ago…..whats the problem then?

    planethax

    @planethax

    must not have export db correctly as what you are trying to import is NOT a db but a webpage itself.

    AntiSaby

    @antisaby

    i followed WP tutorial for exposrting db……..anyway, thnx all

    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

    @esmi

    Forum Moderator

    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.
Skip to toolbar