Removing database table prefix to improve stability on older installations

The database table prefix has not been a default for some years now and can often cause issues with upgrades, we recommend removing the table prefix to reduce errors and improve stability of upgrades.

It is easy to do following these steps and a simple rename of tables should be quick:

  1. Enable phpmyadmin mediacp phpmyadmin enable
  2. Login and select the "mediacp" database
  3. Scroll down, press "Check All"
  4. Click on the "With selected:" dropdown and select Replace table prefix"
  5. Enter "cc_" in the first field, leaving the second empty then pressing "Continue" to apply the change
  6. Open /usr/local/mediacp/htdocs/database.php and replace the $db_prefix = 'cc_'; with $db_prefix = ''; and save the file
  • Stability, Maintenance
  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

Liquidsoap reinstall

Liquidsoap has a large quantity of dependencies and can easily fail installation or upgrade...

Remove database table prefix

A database table prefix was originally used in the MediaCP software many years ago and has since...

Why do I see 'An error occurred' message in the MedicaCP?

This is a generic error and can be the result of several problems listed below.- Underperforming...

Fast DNS resolution and connection to license server failed test

The System Health check has failed the following test: Fast DNS resolution and connection to...