PDA

View Full Version : How to change database prefix



Sunka
Fri 5th Jun '09, 5:38am
Is it possible to delete my database prefix?
For now is vb_
But I wanted my database without prefix. Is it possible to somehow delete that?

Steve Machol
Fri 5th Jun '09, 2:46pm
You can use the install/tableprefix.php script to change your prefixes on the vB table. Just run it from the browser.

Be sure to also make the appropriate change to config.php.

Sunka
Fri 5th Jun '09, 5:58pm
You can use the install/tableprefix.php script to change your prefixes on the vB table. Just run it from the browser.

Be sure to also make the appropriate change to config.php.

So, steps will be:



Close forum
Point browser to www.myforum/install/tableprefix.php
Change prefix (just want to delete prefix, and have database without prefix at all)
Change database name in config.php

Is that all I have to do? Nothing else after that, or before that?

Steve Machol
Fri 5th Jun '09, 6:03pm
4. Change prefix in config.php, not database name.

Also I would make a backup of the database first.

Sunka
Fri 5th Jun '09, 6:08pm
Yes, database prefix not database name in config.php
I mean that but write wrong.
OK, I'll try to see what will be.

Sunka
Fri 5th Jun '09, 6:39pm
It seems that all working OK for now :D