MediaCP Manual
    1. Getting Started
    2. Sales Questions
    3. Frequently Asked Questions
    4. Transcoder System Benchmarks
    5. Start your own streaming platform
    1. Change account currency
    2. Product Licensing
    1. Introduction
    2. Installation & Upgrade
      1. System Requirements
      2. Versions & Releases
      3. Installation
      4. Upgrading
      5. Streaming Servers
        1. Nginx-Rtmp Video Server
        2. Wowza Streaming Engine
        3. Flussonic Media Server
        4. Video Feature Comparison
        5. Icecast 2 / Icecast KH
        6. Shoutcast 2
      6. SSL Certificates
    3. Billing Integration
      1. WHMCS Integration Guide
      2. Clientexec Integration Guide
      3. Blesta Integration Guide
      4. WiseCP Integration Guide
      5. Billing Platform Comparision
    4. Migrate from other software
      1. Migrate From Centovacast
      2. Migrate From AzuraCast
    5. Backup & Restoration
      1. Backup MediaCP
      2. Restore MediaCP
      3. Transfer to another server
    6. Administration
      1. MediaCP System Commands
      2. Admin Tools
      3. Custom Web Service Configurations
      4. Change MediaCP domain name
      5. Port 80 / 443 Proxy
      6. Move media to another hard disk
      7. Custom Language Translations
      8. Custom Facebook App
      9. Branding Your Panel
      10. Secure your server
      11. Setup CSF Firewall
      12. Troubleshooting Login Errors
      13. Reset Admin Password
    7. Scaling
      1. Scale with Wowza and CloudFront CDN
      2. Nginx-Rtmp with CloudFront CDN
      3. Nginx-Rtmp with CDN Proxy
    8. Troubleshooting
      1. Troubleshooting Liquidsoap AutoDJ
      2. Video Relay Troubleshooting
      3. Disk Troubleshooting
      4. Grant access to support team
      5. Troubleshooting Wowza Streaming Engine
      6. FTP Troubleshooting
      7. MySQL Database Troubleshooting
      8. Reporting Troubleshooting
    1. Introduction
    2. Administrators Dashboard
    3. System Configuration
      1. General
      2. Services
      3. Video Players
      4. Albums
      5. Email
      6. Plugins
      7. Statistics
      8. Backups
      9. Custom HTML
      10. Misc
    4. Customer Accounts
      1. Managing existing Customers
      2. Create a new Customer
      3. Deleting a Customer
      4. Login as another Customer
      5. Send email to Customer
      6. Reset Customer Password
    5. Reseller Accounts
      1. Reseller Plans
      2. Create a Reseller Account
    6. Administrator Accounts
      1. Create a new Administrator
    7. Media Services
      1. Creating a Media Service
      2. Deleting a Media Service
    8. Announcements
      1. Managing Announcements
      2. Creating Announcement
      3. Deleting Announcement
    9. Statistics
    10. Software Health
    11. Software Updates
    12. Email Templates
    13. API
    1. Introduction
    2. Audio Operation Manual
      1. Basics 101
      2. Station Overview
      3. Media Library
      4. Playlists
        1. General Rotation
        2. Jingles & Advertising
        3. Scheduling
        4. Repeat Protection
      5. Live DJ Connections
      6. Live Stream Recording
      7. DJ Manager
      8. Country Blocking
      9. Fallback, Backup and Intro Files
      10. Stream Proxy
      11. AutoDJ Crossfade
      12. Public Page
      13. HTML5 Player
      14. Stream Authentication
      15. Widgets & Links
      16. Reporting
    3. Video Operation Manual
      1. Basics 101
      2. Service Overview
      3. File Manager
      4. Scheduling
      5. Stream Targets
      6. Streaming to Your Service
      7. GeoIP Country Locking
      8. Public Page
      9. Widgets & Links
      10. Reporting
    4. Reseller Operations Manual
      1. Reseller Dashboard
      2. Customers
      3. Media Services
    5. API
    1. Custom Domain Names
    2. Shoutcast 2 Admin Guide
    3. Wowza and Flussonic on same system
    4. Submit a feature request
    1. Getting started with Audio Streaming
    2. Icecast Live Broadcasting
    3. Shoutcast 2 Live Broadcasting
    4. Broadcasting with AutoDJ
    5. DJ Accounts
    6. GeoIP Country Locking
    7. HTML5 Audio Player
    8. Mount Points
    9. Managing Your Media
    10. Managing Media Using FTP
    11. Statistics
    12. Shoutcast 2 Premium
    1. Getting started with video streaming
    2. Live Streaming Overview
    3. TV Station Overview
    4. Ondemand Video Streaming
    5. VAST Advertising
    6. Relay & IP Camera
    7. Stream Recording
    8. GeoIP Country Locking
    9. Connecting your encoder
    10. Preparing Your Media Files
    11. Managing Media Using FTP
    12. Understanding Video Playlists
    13. Embedding player on your website
    14. Smooth Streaming and Content Transition
    15. Video Transcoding (Adaptive Bitrate Streaming)
    16. Stream Watermark​
    17. DVR Rewind
    18. Statistics
    19. Facebook Live Streaming
    20. Youtube Stream Publishing
    21. Twitch Stream Publishing
    22. Shoutcast 2 Stream Publishing
    23. Icecast Stream Publishing
    24. RTMP Stream Publishing
    1. Cloud Video Overview
    2. Admin Manual - Cloud Video
      1. WHMCS Billing Provisioning Module
      2. Login to your cloud platform
      3. Dashboard - A First Look
      4. Branding your platform
      5. Team & Staff Members
      6. Plans & Customers
      7. Activating VOD on Customer Plan
      8. API
    3. User Manual - Cloud Video
      1. Login to your video platform
      2. First Look
      3. Creating a Channel
      4. Channel Overview
      5. Broadcasting
      6. Recording
      7. Media Content
      8. Live Events
      9. 30 Minute Rewind
      10. Fallback Video
      11. TV Channels - 24x7 UGC
        1. TV Event Scheduling
        2. Channel Guide Widgets
      12. Video on Demand
      13. Relay Channels
      14. VOD Playlists
      15. Publishing
      16. Viewing Analytics
      17. Bandwidth Utilisation
      18. Publish Zoom Meetings
      19. Advertising
      20. Restreaming IP Cameras
    4. Video Guide Series
    5. Streaming Best Practices
    6. Feature Comparison
    7. Roadmap & Release Notes
MySQL Database Troubleshooting

Last updated 1 year ago

Mysql Server Unreachable Error

This error refers to the database server being unavailable on the system. It is most likely that the process has stopped and is not running.

Generally this occurs when your system has run out of memory and the System Out Of Memory Management (OOM) process has stopped MySQL to save memory*.

You can determine if the system OOM process has interfered by running the following on your system:

cat /var/log/messages* | grep 'Out of memory'

Resolution:

  1. Restart MediaCP database service using the following command as root in SSH:
    mediacp restart mysql
  2. Ensure that MediaCP is the only application running on the system.
    Other applications such as cPanel/WHM, Plesk will also consume CPU, Disk and Memory. We recommend that MediaCP is the only application on the system to ensure it runs fast and stable.
  3. Increase the amount of memory available to your system.
    You should consult the System Requirements documentation to ensure your system meets the Minimum Requirements, however you should also aim to meet the Recommended Hardware requirements.
*Please note that the other disks on your server may still have space, however the partition with the mediacp is full, that is what is causing the problem. If you have secondary disks with large storage we advise considering moving all mediacp media content to the secondary disk, our “Move media to another hard disk” documentation outlines the steps here.

Mysql Server will not start

If the MySQL Server is failing to start after issuing mediacp restart mysql, then you can attempt to start the process manually in your shell to expose any error messages:

/usr/local/mediacp/mysql/bin/mysqld --defaults-file=/usr/local/mediacp/mysql/my.cnf --user=mediacp --basedir=/usr/local/mediacp/mysql --datadir=/usr/local/mediacp/mysql/data --socket=/usr/local/mediacp/mysql/data/mysql.sock --log-error --skip-networking

Attempt repair of crashed tables

How do I know the tables have crashed

Common errors that you might see include:

  • General Error: 126 Incorrect key file for table ‘tablename‘; try to repair it
  • Table ‘tablename‘ is marked as crashed and should be repaired 

Why do database tables crash?

The major cause of the database corruption is the lack of free disk space on the server. Other possible causes of MySQL table crashes include operating system problems, power failures, hardware issues, unexpected MySQL server termination, data corruption due to external programs, etc.

How do I repair database tables?

You can attempt to repair the database tables by running the command below, however in some cases this might not resolve the problem (See section below What if i cannot repair the database?). Pay attention to the output in case there are errors:

/usr/local/mediacp/mysql/bin/mysqlcheck --protocol=SOCKET --socket=/usr/local/mediacp/mysql/data/mysql.sock --user=root --password= -A --auto-repair --all-databases

It might be required to restart MySQL, pay attention to the output in case there are errors:

mediacp restart mysql

Can MediaCP repair it for me?

Please contact us and our level 2 staff can complete this for you for a 1 hour service fee. Please note that the service fee will be charged regardless if the repair is successful, however we will help you restore or reinstall your MediaCP if a repair cannot be successful.

What if I cannot repair the database?

Unfortunately if the database has crashed and is not repairable then you will need to either:

Table of Contents