Is there anyway to change all of the vB SQL tables to include a prefix after you have installed vBulletin and it has been used in a live environment? Of course I could alter each table manually but with 170+ tables* this would be time consuming.
This may be more of an SQL question but figured since it is relative for vBulletin* I should post here first.
Also* to be more clear* I'll give an example: I have been using vB version 3.8x in a live environment (many threads/posts) and did NOT select to use an SQL prefix when I first installed it. Now I have installed a separate vB version 4 RC 4 (not an upgrade) and DID select to use an SQL prefix for this install. I want to import the tables from my v3.8x install to v4RC4 but when I import* of course I need to add this prefix to those tables now. Is it possible to do this in mass form* not individually?