WordPress.org

Ready to get started?Download WordPress

Forums

[closed] Error while importing database! urgent! (9 posts)

  1. AntiSaby
    Member
    Posted 3 years 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"> <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

  2. esmi
    Forum Moderator
    Posted 3 years ago #

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

  3. AntiSaby
    Member
    Posted 3 years ago #

    but i am importing a .sql database.......

  4. planethax
    Member
    Posted 3 years ago #

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

  5. AntiSaby
    Member
    Posted 3 years ago #

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

  6. planethax
    Member
    Posted 3 years ago #

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

  7. AntiSaby
    Member
    Posted 3 years ago #

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

  8. nikairos
    Member
    Posted 2 years 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?

  9. esmi
    Forum Moderator
    Posted 2 years ago #

    Please post a new topic.

Topic Closed

This topic has been closed to new replies.

About this Topic