Remove database table prefix

A database table prefix was originally used in the MediaCP software many years ago and has since been phased out of operation. Some installations may still be using a prefix which may cause problems in newer versions of the MediaCP. We highly recommend removing the prefix by using our script provided below.

You can also request that our skilled technicians complete this for you if preferred.

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
  • 6 Users Found This Useful
Was this answer helpful?

Related Articles

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...

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...

Got error 28 from storage engine

You may see this error Got error 28 from storage engine when accessing the Media Control Panel....

OpenVZ virtualization

During the installation or upgrade of MediaCP you might receive the following notice: ERROR:...

FAIL NginxRtmp - Liquidsoap ffmpeg video support

If you have recently upgraded or installed MediaCP without updating your system packages you will...