Tylor Eddy Posted May 14, 2011 Report Posted May 14, 2011 G'day Guys, I have run into a bit of trouble with my databases, when trying to integrate a new forum. I made a backup in .sql format of the websites data, and old forums data, so i could slowly put it all back the way it was, with the new forum too. What has happened is that i removed the data from all the tables, as i couldn't install the new forum, thinking this would all be ok as i made backups of the tables, but when i went to upload it all back onto phpmyadmin, the website wont identify any of the tables information, and apparently i have lost everything. i tried the backups i have made, but none of these work either, can someone please help me resolve this issue ASAP. i recieve this error continuously when i attempt to upload the backup. <!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=5fd3e87a126346d64a01a3ab2a6ca902&js_frame=right&nocache=3894806898" /> <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: Documentation #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 I really hope i haven't lost everything Quote
Jeff Posted May 14, 2011 Report Posted May 14, 2011 That's going to be Nabeel's department. You might be Ok, but don't touch anything until you hear from him. you can always open a ticket if you are signed up to FiveDev.net and he can get to you quicker. Quote
Tylor Eddy Posted May 14, 2011 Author Report Posted May 14, 2011 That's going to be Nabeel's department. You might be Ok, but don't touch anything until you hear from him. you can always open a ticket if you are signed up to FiveDev.net and he can get to you quicker. Unfortunately im not with fivedev, but ill leave everything as is, just had a look inside the sql file, and everything is in there, it just wont upload back the way it was. Quote
Administrators simpilot Posted May 14, 2011 Administrators Report Posted May 14, 2011 Have you made sure to use the correct sql upload format, there are some choices when you go to import the file. Quote
Tylor Eddy Posted May 14, 2011 Author Report Posted May 14, 2011 Have you made sure to use the correct sql upload format, there are some choices when you go to import the file. i have left the format unchanged, when i uploaded. Quote
Tylor Eddy Posted May 15, 2011 Author Report Posted May 15, 2011 i have left the format unchanged, when i uploaded. Ok what i end up doin was reinstalling the website from scratch, adding my skin, and adding data from the sql file manually to the tables, i couldnt get any information on pilots, so i'm going to have to get the to register and i'll have to manually add the hours they had gained before the incident. Thanks for the help Tylor Quote
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.