Any phpbb gurus?

We were hacked by some stupid russian person, but we had previous backups of the database.

However we cant restore them through phpbb it takes ages and doesnt work.

We went to the phpbb website forum and they told us it doesnt work well on databases above 2mb, instead use a staggered SQL loader such as BigDump.

We did that but it seems to crash half way through, our forum structure was restored but members and posts werent.

We just want to get the forum restored and running again, any help would be grand, this is the error BigDump is showing.

Error at the line 42104: INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('124', '524',d_id, title_match) VALUES('186', '135', '0');

Query: INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('124', '524',d_id, title_match) VALUES('186', '135', '0');


MySQL: 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 'VALUES('186', '135', '0')' at line 1
 
upload your database via ftp then email your host with the mysql login details. They will be able to insert the sql from the commandline which is much more reliable.
 
Topgun said:
upload your database via ftp then email your host with the mysql login details. They will be able to insert the sql from the commandline which is much more reliable.

Is it easy enough for me to do? Can i not access this command line alternative myself?
 
Back
Top Bottom