Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
dutchsnowden Posted January 8, 2022 Posted January 8, 2022 Can I delete original tables the one starting with orig_ ? Are these needed anymore? I WILL do a backup before delete, but want to be sure those are not needed anymore.
Miss_B Posted January 8, 2022 Posted January 8, 2022 32 minutes ago, dutchsnowden said: Can I delete original tables the one starting with orig_ ? Are these needed anymore? I WILL do a backup before delete, but want to be sure those are not needed anymore. What tables are those? If you do not have any use for them anymore you can delete them.
dutchsnowden Posted January 8, 2022 Author Posted January 8, 2022 I am not sure, I assume upgrade process created them, but as I said, not sure. I have my tables and a new set of ones prefixed with orig_ ... not sure when these where created and why those are still there. Backing up is large enough on a clean database, I'd rather delete those if not needed anymore. I just wanted to ask someone from Invision to be sure.
dutchsnowden Posted January 8, 2022 Author Posted January 8, 2022 I dropped them all using a custom MySQL script. Backed up database before and after. Seems that everything works as normal. I got now 261 tables in database. all starting with MY prefix, and two of them with x_utf_ + my prefix. But now the backups are more than half smaller.
Randy Calvert Posted January 9, 2022 Posted January 9, 2022 Yeah. The orig was used as a fall back in the 3 to 4 conversion so people did not lose everything. Since you’re safely on 4, it’s good to remove. 🙂
Solution Marc Posted January 10, 2022 Solution Posted January 10, 2022 Incidentally, the admin CP support area would prompt you if you have these and is a one click process to remove them. Just adding in case anyone sees this in the future.
dutchsnowden Posted January 10, 2022 Author Posted January 10, 2022 Well, my admin support page did not. I removed those tables manually. First thing I did when in Admin CP was to SOLVE EVERYTHING in there. From PHP warnings to customization and leave everything at defaults. I did not get any option to delete orig_ tables. Sorry.
Marc Posted January 10, 2022 Posted January 10, 2022 1 minute ago, dutchsnowden said: Well, my admin support page did not. I removed those tables manually. First thing I did when in Admin CP was to SOLVE EVERYTHING in there. From PHP warnings to customization and leave everything at defaults. I did not get any option to delete orig_ tables. Sorry. I will get that looked into. Thank you for letting us know dutchsnowden 1
Recommended Posts