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