Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Aiheen aloitti: deathwantsme - maaliskuu 03, 2006, 09:33:20 AP

Otsikko: mySQL questions
Kirjoitti: deathwantsme - maaliskuu 03, 2006, 09:33:20 AP
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.
Otsikko: Re: mySQL questions
Kirjoitti: kegobeer - maaliskuu 03, 2006, 11:57:55 AP
It depends on how badly you "screwed up" your database.  What happened?
Otsikko: Re: mySQL questions
Kirjoitti: deathwantsme - maaliskuu 03, 2006, 07:12:33 IP
I messed up a lot of the databases. The child boards, boards, and catagories are still there.
Otsikko: Re: mySQL questions
Kirjoitti: Daniel15 - maaliskuu 03, 2006, 07:41:59 IP
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 ;)