Can’t see the “Change Database Prefix” Anymore ?
#22633 Joom 3.4.1- Admin 3.5.1 - No more Database Prefix Change Tool?
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 Chacapamac on Friday, 15 May 2015 09:48 CDT
Friday, 15 May 2015 09:26 CDT
Chacapamac
Friday, 15 May 2015 09:48 CDT
Chacapamac
Ok this was already answer Here…..
https://www.akeebabackup.com/support/admin-tools/22456-missing-database-table-prefix-editor-on-version-3-5-x.html
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
https://www.akeebabackup.com/support/admin-tools/22456-missing-database-table-prefix-editor-on-version-3-5-x.html
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