Hmm.. Thanks. Using the new files, the only error shown was a PHP notice which isn't really important:
Notice: Undefined index: line in C:\Program Files\Apache Group\Apache2\htdocs\SMF\restore_backup.php on line 191
Although same problem as last time- Comparing the two databases everything after log_topics seems to not have been restored.. So I make the changes you mentioned above, and now get:
Some of the queries were not executed properly. Technical information about the queries:
Line #23395: 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 '(30) NOT NULL default '',
`gender` tinyint(4) unsigned NOT NUL
Line #x: Table 'smf.yabbse_members' doesn't exist
Line #24746: 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 '(30)
`posterName` tinytext NOT NULL default '',
`posterEmail
Line #x: Table 'smf.yabbse_messages' doesn't exist
The odd thing with this is that, now, all tables have been fully restored, apart from the members and messages tables- which have been deleted and so SMF won't open ("Table 'smf.yabbse_members' doesn't exist") The key lengths are there which is what is confusing me.
I realize these files aren't stable yet, and so I appreciate the help lots but if the errors can't be easily fixed, I fully understand
