PDA

View Full Version : Add table prefix?


djxcee
10-30-2008, 11:21 PM
I forgot to add a prefix when I first installed vBulletin and was wondering if it's possible to add a prefix to all existing vBulletin tables using phpmyadmin.

Antivirus
10-30-2008, 11:33 PM
i don't believe you will have any issues, so long as you update your config.php file with the table prefix. do a db backup beforehand just in case.

djxcee
10-31-2008, 08:33 AM
Thanks Antivirus but not exactly the answer I'm looking for :p. Sorry if I made it sound confusing.

I have existing tables and would like to add prefixes to all of them.

cono1717
10-31-2008, 03:59 PM
I hope this is what you are looking for
https://vborg.vbsupport.ru/external/2008/10/1.png


Note this was taken from http://www.electrictoolbox.com/rename-table-mysql/

Sorry you have to do it one by one. As Antivirus said make sure you add the new prefix in your config.php otherwise you will get a database error.

Connor