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

Posted in ‘Akeeba Admin Tools for Joomla!’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Tuesday, 14 April 2015 02:06 CDT
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
Custom Fields
Which documentation pages did you read?
None
Which troubleshooter articles did you read?
None
Have you searched the tickets before posting?
Yes
Joomla! version (in x.y.z format)
3.4.1
PHP version (in x.y.z format)
5.4
MySQL/database version
 
Host (who is hosting your site, not your domain)
 
Admin Tools version (x.y.z format)
3.5.1
Tuesday, 14 April 2015 02:16 CDT
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






Please keep in mind my timezone and cultural differences when reading my replies. Thank you!






This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: Read the complete support policy which is part of our Terms of Service. We kindly remind our subscribers that they have already explicitly and unconditionally accepted the Terms of Service.

Cookies Notification - Action required

This website uses cookies to provide user authentication and improve your user experience. Please indicate whether you consent to our site placing these cookies on your device. You can change your preference later, from the controls which will be made available to you at the bottom of every page of our site.