cybermomcafe Posted March 17, 2003 Share Posted March 17, 2003 The server that my site was on was on the recieving end of a DOS attack and they found the LMK Trojan virus on the server too... so they wiped the server clean...all data was lost. I don\'t have SSH or Telnet access so the only back up of my database that I have is from the admin panel of vbulletin... Last time I restored the database (when I transferred to this server last week) I used the same file I\'m using now I did it thru phpMyAdmin, I copied and pasted the mySQL queries like 4000 lines at a time thru myPHPadmin, and it worked fine. I\'m trying this again and now when I enter the queries I get an invalid syntax error... This is the format that I\'m copying it from the backup file: INSERT INTO adminlog VALUES(\'1\', \'1\', \'1044752280\', \'index.php\', \'\', \'\', \'24.208.160.38\'); This is the error message that I get: You have an error in your SQL syntax near \'\'1\', \'1\', \'1044752280\', \'index.php\', \'\', \'\', \'24.208.160.38\')\' at line 1 When it comes back with the error why is there so many more ? Is that what the problem is? It looks like it may be a newer version of phpMyAdmin because there are more options at the bottom... other than that I have no idea... Any suggestions would be great! Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/233-invalid-syntax-question/ Share on other sites More sharing options...
Iklekid Posted March 17, 2003 Share Posted March 17, 2003 Cant you setup the database backup through the Vbulletin admin control panel? Surely there msut be a way to jsut upload the file to restore it! I havent used vbulletin (adminCp) anyways, I use IPB and i can easily backup/restore a database in their! Am i following you right on this or have i read your post wrong? Quote Link to comment https://forums.phpfreaks.com/topic/233-invalid-syntax-question/#findComment-697 Share on other sites More sharing options...
cybermomcafe Posted March 17, 2003 Author Share Posted March 17, 2003 nope... the vBulletin admin panel doesn\'t have a restore feature... only backup Quote Link to comment https://forums.phpfreaks.com/topic/233-invalid-syntax-question/#findComment-699 Share on other sites More sharing options...
pallevillesen Posted March 18, 2003 Share Posted March 18, 2003 Hmm.... Not easy, I just tested INSERT INTO `tbl_Person` VALUES (143, \'Jepp\', \'Tha\', \'1973\', \'\', \'Sjælland 73 st.\', \'\', \'\', \'8000\', \'Ås C\', \'thas@i.au.dk\', \'\', \'venteliste\', \'8619\', \'2191\', \'\', \'\'); Which worked fine (don\'t worry about the data). The only difference I see is the backquotes around the table name. Which version of phpmyadmin are you using? P. Quote Link to comment https://forums.phpfreaks.com/topic/233-invalid-syntax-question/#findComment-706 Share on other sites More sharing options...
cybermomcafe Posted March 18, 2003 Author Share Posted March 18, 2003 It\'s phpMyAdmin 2.2.0 I\'ve found that only some of the tables are giving me errors... I can do the entire user table with no problem... but the posts I get invalid syntax...? It\'s all from the same backup file... Quote Link to comment https://forums.phpfreaks.com/topic/233-invalid-syntax-question/#findComment-708 Share on other sites More sharing options...
Iklekid Posted March 18, 2003 Share Posted March 18, 2003 how about uploading via ssh/telnet? I went to the vbulletin forum board and they said to switch servers to use ssh/telnet Do you have this facility? Quote Link to comment https://forums.phpfreaks.com/topic/233-invalid-syntax-question/#findComment-709 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.