mySQL questions

[deathwantsme]

I screwed up my mySQL database. I want to just install a new forum so everything is there, but with the same member groups, permissions, boards and child boards. I dont care if the few topics that were started by me get lost, the board im working on now isnt online yet. What databases would i need to "move" from the current forum I have to the new one, and how would i go about doing that? Is there a way to just copy it and paste it into the new database? Im trying to save myself from having to re make around 200 catagories, boards, and child boards, so help would be REALLY appricated.

[kegobeer]

It depends on how badly you "screwed up" your database.  What happened?

[deathwantsme]

I messed up a lot of the databases. The child boards, boards, and catagories are still there.

[Daniel15]

So you're saying that some of the tables are messed up, but some still work? If so, go into phpMyAdmin and choose your SMF database. Click 'Export' at the top of the page, and choose the tables that are not corrupted. Only export the tables that are still working fine!. In your case, I think you want to export the smf_categories table, as well as a few more (if you want). Save the exported data to your computer somewhere.

Next, go to phpMyAdmin again, this time choosing the new database. Delete all the tables you wish to overwrite, and then click on 'SQL'. Find where you saved the file, and then submit. The old data should now be in the new database.

Hope this helped you