Support

Admin Tools

#22456 Missing Database table prefix editor on Version 3.5.x

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 nicholas on Tuesday, 14 April 2015 02:16 CDT

[email protected]
Hello Nicholas, Hello Akeeba Team

I missing in the new Admintools Version 3.5.x the "Database table prefix Editor".
I works many about Installatron. Installatron is a Server Software Installations Tool. Installatron
installed joomla with _jos as prefix.

I works many with "Database table prefix Editor" in Admintools. Now i missing it.

I wish that you can add this plugin it in the next admintools Version.

that would be great

best regards

Adi

nicholas
Akeeba Staff
Manager
There are two reasons why this feature was removed:

1. This feature was designed to let you change the table prefix to something other than jos_ which was used in Joomla! 1.5 and 1.6. Joomla! 1.7 and later use, by default, a random database table name prefix when installing. This made this feature obsolete. If you are using a third party installer which uses jos_ it is a major security bug in the third party installer and the proper long term course of action is getting in touch with its developers and ask them to fix it.

2. The proper way to change the database prefix without risking bricking your site is:
- Take a backup with Akeeba Backup
- Restore the backup. In the Database Restoration page choose a different prefix.
- Delete the tables with the jos_ prefix from your site using phpMyAdmin, Adminer or any similar tool provided by your host

If you are wondering why using Akeeba Backup is the recommended way, it has to do with PHP timeouts and foreign keys. Admin Tools is a Joomla! component. This meant that it has to change all database tables' names at once, otherwise it would result in an unusable site. However, if the PHP timeout limit is reached before that process is complete it does result in an unusable site. Furthermore, the process will fail if there are foreign key relations between tables. Akeeba Backup is designed to overcome this and many other issues MUCH BETTER than Admin Tools. In fact, the only reason it can work around these issues is that the restoration script (ANGIE) is a standalone PHP application which doesn't rely on the Joomla! site's tables. This means that we can perform a staggered database restoration (many page loads) without resulting in a bricked site.

TL;DR Use Akeeba Backup to backup and restore your site, changing the database prefix in the Database Restoration page. It is the most stable and recommended method.

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!

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!