News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Reinstall but keep members/posts/threads/membergroups

Started by kittonium, June 26, 2018, 06:18:53 PM

Previous topic - Next topic

kittonium

Quote from: Kindred on June 26, 2018, 10:22:51 PM
You really can't do that easily. There are things shared between multiple tables.

You can remove the prettyurls table, but seriously you should not be mucking about in the database

done that before you posted your message :O

i imported only the biggest tables (posts, members, member_groups, permissions, etc), seems to be working so far, right now im doing the routines in Maintenance and see if it's good :)

also noticed some columns made by addons in the tables, going to remove them too soon

Kindred

So, in other words, no matter how much we tell you that it's a bad idea, you should not do that and you don't need to do that - you are going to do it anyway.

So, tell me again, why did you even bother to ask?
Слова
Украина

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Aleksi "Lex" Kilpinen

Just out of curiosity, why? When nothing in the database is causing issues, I'd rather not go poking around it. The amount of space saved is gonna be rather small compared to all the stuff you want to keep, and the amount of work (not to mention risk of breaking things) is pretty big for that small saving.
Slava
Ukraini!


"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

kittonium

Quote from: Kindred on June 26, 2018, 11:18:32 PM
So, in other words, no matter how much we tell you that it's a bad idea, you should not do that and you don't need to do that - you are going to do it anyway.

So, tell me again, why did you even bother to ask?

incase someone knew of a utility that helps clean a SMF database  :P
maybe this thread will inspire someone to make one..

Quote from: Aleksi "Lex" Kilpinen on June 26, 2018, 11:19:54 PM
Just out of curiosity, why? When nothing in the database is causing issues, I'd rather not go poking around it. The amount of space saved is gonna be rather small compared to all the stuff you want to keep, and the amount of work (not to mention risk of breaking things) is pretty big for that small saving.

well, i tried not deleting anything from the database and had issues with themes, and basically if i want to install some of the mods that i previously had, they would already be using the settings i have now, which probably isn't a good idea if  i install them way into the future.

either way, i have a backup of the forum and database before everything got fugged, so if the host allows PHP 5.4 or whatever it was at again it would be all good :)

kittonium

NVM.. IT LOOKS like it working, but its REALLY  not  ???


anyway, i made a few UniServerZ's, installed php 5 and php 7 on them and then went to php5 mode, loaded up the backup i have of my forum, uninstalled all mods, then changed to php7, and it worked.

so.... im thinking of uploading the modified backup back to the server :)


Sir Osis of Liver

Mods can add tables and/or settings to db.  When uninstalled, some remove tables/settings, some give you an option to do so, and some don't bother to clean up and leave stuff behind.  If you reinstall a mod that already has tables/settings in the db, it will inherit whatever content is there.  That's good if you want the mod to come up running as previously installed.  If not, you'd have to clear content and reconfigure settings, usually in mod cp.  If you don't reinstall the mod, the stuff it left in the db is ignored.  There's no harm in deleting tables that are obviously from a mod; messing with settings is really not a good idea, they don't cause any problems and take up very little space.

"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Advertisement: