AntiSaby
Member
Posted 2 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
What you're importing isn't an .sql database dump - it's a web page!
AntiSaby
Member
Posted 2 years ago #
but i am importing a .sql database.......
planethax
Member
Posted 2 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.
AntiSaby
Member
Posted 2 years ago #
thnx for replies.....but i importing that very same db that i exported few days ago.....whats the problem then?
planethax
Member
Posted 2 years ago #
must not have export db correctly as what you are trying to import is NOT a db but a webpage itself.
AntiSaby
Member
Posted 2 years ago #
i followed WP tutorial for exposrting db........anyway, thnx all
nikairos
Member
Posted 1 year 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?
