Support

Admin Tools

#26910 cant find the database table prefix editor

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Friday, 17 February 2017 17:17 CST

bobpit
I can't find the Database table prefix editor button. Is it disabled because it cannot run on my database?

I have Mysqli.
Database Version 10.0.27-MariaDB-cll-lve
Web Server LiteSpeed
Host: MDDhost

I've read old posts and I have a suggestion on the interface:
Instead of hidding the button, make it gray (dissabled) but also display an explanation message on hover, so admins know why the feature is not available.

nicholas
Akeeba Staff
Manager
It's not a matter of "hiding" the button. We completely removed this feature in version 4 since it's obsolete and outright dangerous with modern sites. The reliable way to change your database prefix is backing up your site with Akeeba Backup and restoring it. You can select a different prefix during restoration.

Changing the prefix on the tables while the site is running was fine in the Joomla! 1.5 days but nowadays it is NOT a good idea. If your server times out (we can't run it in smaller steps as this would break your site!) or if you have tables with foreign keys the process will fail before it completes. This will leave some of the tables converted and some not. The end result is that your site is broken and you need to use phpMyAdmin (or a similar tool) to fix it. This completely beats the purpose of using a tool to do this operation.

On the other hand, restoring a backup means that at this point the site does not run. We can do whatever we want in the database on our own time, knowing full well that any failure is not catastrophic: you can simply retry the process, probably with different time settings.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

bobpit
I understand.

How come it is not evident in the documentation?

I had searched in google for more than 30min different support tickets and video tutorials in the subject. I read this guide and just the existence of it lead me to believe the feature is still on:
https://www.akeebabackup.com/documentation/admin-tools/dbprefix.html

nicholas
Akeeba Staff
Manager
How did you end up on that page? This page is not linked to from the documentation. The page you're looking for is this https://www.akeebabackup.com/documentation/admin-tools/dbprefix.html which doesn't mention the prefix editor at all.

The old page is still available if you have a direct link as doing otherwise would break the help pages of older versions of the software which are currently in limited support status.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

bobpit
>>>>
How did you end up on that page?
<<<<
From google, it was very high up in the results.

Thank you Nichola.

nicholas
Akeeba Staff
Manager
Ugh, Google. Of course. That makes sense. I'll add a note on that page that this feature is no longer available. Thank you for the heads up!

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!