Dropped a table, instead of line...help?

[Chief Corn]

Was "trying" to cleanup my forum's mysql of old hacks, etc that were'nt in use using phpmyadmin. Searched for "Shoutbox" (vbShoutbox 1.03 non-htl) which never worked and started deleting phrases and such. Where i screwed up was deleting lines from the "setting" table where there were shoutbox lines and dropped the table. Now I can't do anything on the site. So I tried making a new database and installed a seperate forum to export the setting table to my old....but it didn't do a thing. Is there a way to export my forums usernames, posts, threads, etc. into the new database? Both installations of vB are running 3.03.

[Dark_Wizard]

Originally Posted by Chief Corn

Was "trying" to cleanup my forum's mysql of old hacks, etc that were'nt in use using phpmyadmin. Searched for "Shoutbox" (vbShoutbox 1.03 non-htl) which never worked and started deleting phrases and such. Where i screwed up was deleting lines from the "setting" table where there were shoutbox lines and dropped the table. Now I can't do anything on the site. So I tried making a new database and installed a seperate forum to export the setting table to my old....but it didn't do a thing. Is there a way to export my forums usernames, posts, threads, etc. into the new database? Both installations of vB are running 3.03.

Ouch...I take it you didn't backup your database before doing this did you? Here is what you would need to do:

• * on the new install reinstall all the hacks that were on the other db.
  * export the data from all the table except the settings table which you deleted and import the data to the new forum.
  * Check out the functionality of the new forum if everything is fine then...
  * Backup the old forum's db and after that dump all data.
  * export data only from new forum and import into old forums db...
  * Good Luck!

[Andreas]

Hmm ... I just made a little test (dropped my setting table) and the board is still working fine, except there are some DB erros in the admin control panel.

For normal operation, the setting table is not required AFAIK as all settings are cached in datastore.

So it should be possible to export a default setting table into you production board to get it back working, you might also want to replace the values in this fresh table with the cashed ones.

[Chief Corn]

:disappointed: no luck. reinstalled all hacks except for vbportal since i'm going with vbadvanced cmps now. imported a few of the big tables (forum, user, usergroup, post, thread, forumpermission, pm, pmtext) but get errors in the admincp, and viewing the forum gives the error "header already sent". i can see all the members in the member list, but forums doesn't show the categories or posts. threads show though in vbadnanced from the last 10 threads but i don't have permission to view.

well i'm back on a fresh install. any idea if importing to phpbb or invisionboard (which ever imports the most) just pulls the tables or does it have to have a fully functional board? if so i can import to another board, then import everything to my new vb3 installation.