#22633 – Joom 3.4.1- Admin 3.5.1 - No more Database Prefix Change Tool?

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.
Friday, 15 May 2015 09:26 CDT
 Can’t see the “Change Database Prefix” Anymore ?
Custom Fields
Which documentation pages did you read?
Which troubleshooter articles did you read?
Have you searched the tickets before posting?
Joomla! version (in x.y.z format)
PHP version (in x.y.z format)
MySQL/database version
Host (who is hosting your site, not your domain)
Admin Tools version (x.y.z format)
Friday, 15 May 2015 09:48 CDT
Ok this was already answer Here…..

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

The “ way to change the database prefix” given here is a good tip but not really a practical way as restoring a complete web site even using Akeeba can become rapidly a complex method.

Remember that using PHPMyAdmin you can easily change de prefix by selecting the tables and use the “Replace Table Prefix” command
On Mamp PHPMyAdmin, you have to enter the old prefix … Say —> a3fyo (I enter without the underscore) to the new one... Say —> v5s5f

Remember to change the configuration.php to reflect your change
public $dbprefix = 'v5s5f_';

You can close that ticket
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: 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!

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.