Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 8, 20223 yr 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.
January 8, 20223 yr Community Expert 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.
January 8, 20223 yr Author 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.
January 8, 20223 yr Author 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.
January 9, 20223 yr Community Expert 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. 🙂
January 10, 20223 yr Community Expert Solution 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.
January 10, 20223 yr Author 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.
January 10, 20223 yr Community Expert 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