peteyg Posted May 25, 2011 Share Posted May 25, 2011 Hi all I recently got a virus on my web hosting so had to reinstall all my sites I exported the databases using phpadmin before all was formatted However now when im importing i get the following error on each website 3 in total php versions are all the same to 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=911e17b2778b6a3a0c9296fe8820c558&js_frame=right&nocache=3894719230" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <meta name="robots" content="noindex,nofollow" /> <script type="text/javascript"> //<![CDATA[ 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..."); [...] 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 Quote Link to comment https://forums.phpfreaks.com/topic/237426-myqsl-1064-error/ Share on other sites More sharing options...
gristoi Posted May 25, 2011 Share Posted May 25, 2011 why are you trying to import html direct into the database? Quote Link to comment https://forums.phpfreaks.com/topic/237426-myqsl-1064-error/#findComment-1219984 Share on other sites More sharing options...
peteyg Posted May 25, 2011 Author Share Posted May 25, 2011 I just exported the whole database... using php admin Do you want me to upload one of them? They are saved as sql Quote Link to comment https://forums.phpfreaks.com/topic/237426-myqsl-1064-error/#findComment-1219991 Share on other sites More sharing options...
peteyg Posted May 25, 2011 Author Share Posted May 25, 2011 Anybody fit to help me? Quote Link to comment https://forums.phpfreaks.com/topic/237426-myqsl-1064-error/#findComment-1220108 Share on other sites More sharing options...
fenway Posted May 27, 2011 Share Posted May 27, 2011 I don't see an SQL statement anywhere. Quote Link to comment https://forums.phpfreaks.com/topic/237426-myqsl-1064-error/#findComment-1221099 Share on other sites More sharing options...
gristoi Posted May 27, 2011 Share Posted May 27, 2011 looks like your trying to upload your code files into your database, not your sql dump. Quote Link to comment https://forums.phpfreaks.com/topic/237426-myqsl-1064-error/#findComment-1221107 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.