UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Forum database - Table prefix question

Hi

I am annoyed by the fact I changed settings for the forum database - Table prefix when I created the forum many years ago.
everytime I read instructions how to change things I need to remember to add three letters to the sql queries
like this

original example

my setting

My question is there a possibility to remove the "ubbt_bbf" from the table prefix and set it as standard "ubbt_" if so how would i be able to do it?

Thanks for your input

Close your forums, then go in via PHPMyAdmin and rename all of the databases with the new prefix, then change the prefix in the config file.

Hi Gizmo,
I opened CP for my website >> PHPMyAdmin >> and looked at the database but don't know how to rename the tables.
Is that an easy and secure fix or what can I expect?
I understand I will have to do it manually with each tables.

When viewing a table the rename option will be under operations. Nothing is really easy and fast, it's slow and steady as you're making huge changes to container names that house your forum data.

You can expect your forum to continue trying to write data as you are changing the table names, so be sure that you both close your forums and back up the data before make any changes.

Thank you for your input that is one step closer.

So open ea table and go to operations, change name and hit go.

My database is 1,3 GB and what would be the best way to do a backup?
I believe i tried before to Gzip but it failed.
I am running daily website backups thru my host interservers whm would that be enought?

Thanks

OK here is the status, I-
- closed the forum
- did back up on the database
- in PHPAdmin I changed (removed "bbf") from each table name
- downloaded a new backup
- removed "bbf" from the table prefix in the config.inc.php file. now it reads "ubbt_"

I could login as admin and checked the Control Panel / Database & Paths >> and table prefix reads ubbt_
I can see various topics and replies

I then went to Control Panel / Cache Manager and clicked on update cache and got this
Control Panel Message


Is there something to be worried about or do I need to alter any other files???
I have not turned on the forum yet and awaits your input while you are a sleep. That's the beauty with 9 hours diferences in timezones.

Thanks

When you say website backups you mean just the folders and files correct.?
If so that does not include databases.
See if you have a option on whm to backup and restore databases.
I know cpanel does.

PHPadmin is okay for small databases but it usually has a very small kb limit to import back to restore.
Which means even if it works to export it probably will fail if you need to restore your database.
of course the best way is if they provide you command line access to your server.

portalbox46 is one of your islands that has a query in it.
You need to figure out which one it is.
Because it would be one of your custom islands try to edit it in the control panel.
The numbers on the left side would be 46.
if notthe quick way would be to ftp to the site and view the file and edit it if needed.

Ruben the VWM is doing backups on all and yes one can choose
I will go to ftp and check portalbox46

Ruben I found portalbox46 in the admin cp it was in a Random Gallery photo script and removed "bbf" and tested.
it worked fine to clear the cashe. Thanks alot for your input

I wonder if I need to test anything else before I turn on the forum again?

Only thing I can think of is another custom island or if you used a query in say the html includes.

I don't follow you there ( query in say the html includes ) where is it located?

Since I fixed the portalbox46 I have had no errors in the log so I guess I could turn it on again. fingers crossed knock on wood

Its now open, i posted a thread and posted a reply, it seems to work. puh.. Thanks for all input folks!