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!