Jump to content

Featured Replies

Posted

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.

 

Solved by Marc

Go to solution
  • 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.

  • 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.

 

  • 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.

 

  • 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. 🙂

  • 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.

  • 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.

 

  • 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

Recently Browsing 0

  • No registered users viewing this page.