Guides from the NOC

Getting a #1005 or foreign key constraint fails error during a phpMyAdmin import? Here's exactly why it happens on cPanel and the steps to fix it safely.

phpMyAdmin keeps kicking you back to login or showing 'Loading Failed' mid-query in cPanel? Here's what actually causes it and how to fix it for good.

phpMyAdmin import stuck or showing 'MySQL server has gone away'? Fix max_allowed_packet errors on shared cPanel hosting and VPS, with prevention tips.

phpMyAdmin export stuck, blank, or crashing on a large cPanel database? Fix the timeout, memory limit, and CDN causes and get a reliable backup out safely.

phpMyAdmin import stuck, timing out, or erroring on a big .sql file in cPanel? Fix upload limits, timeouts, and packet size, or import via SSH instead.

Getting 'Unknown collation utf8mb4_0900_ai_ci' when importing a MySQL 8 database dump into cPanel's older MariaDB? Here's the exact cause and fix, step by step.

Upgrading MySQL or MariaDB from WHM? Here's how to use the built-in upgrade tool safely, without corrupting cPanel databases, phpMyAdmin, or client sites.

Grant cPanel MySQL database users only the privileges they actually need. Read-only, backup, and app-specific access explained with GRANT/REVOKE examples.

Import throwing #1449 'definer does not exist' on MySQL views or triggers? Fix it on shared cPanel hosting without SUPER privileges, step by step, for good.