Error while importing database! urgent!

  • AntiSaby

    (@antisaby)


    13 years, 5 months ago

    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; <html xmlns=”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; at line 1

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

    (@esmi)

    13 years, 5 months ago

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

    Thread Starter AntiSaby

    (@antisaby)

    13 years, 5 months ago

    but i am importing a .sql database…….

    planethax

    (@planethax)

    13 years, 5 months ago

    <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt; <html xmlns=”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

    (@antisaby)

    13 years, 5 months ago

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

    planethax

    (@planethax)

    13 years, 5 months ago

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

    Thread Starter AntiSaby

    (@antisaby)

    13 years, 5 months ago

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

    KAIROS_Canada

    (@nikairos)

    12 years, 7 months ago

    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)

    12 years, 7 months ago

    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