Blog

Guides from the NOC

Written from running the hardware — what breaks, why, and the command that fixes it.

46 posts matching “database” · Clear

cPanel phpMyAdmin Export Timing Out? Fix Large Database Backups

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.

8 August 2026 · 6 min · 3 views
WordPress WordPress: 'One or More Database Tables Are Unavailable' Fix

Seeing 'One or more database tables are unavailable' in WordPress? Fix it with WP_ALLOW_REPAIR, wp-admin's repair tool, or WP-CLI — safely, no data loss.

8 August 2026 · 6 min · 5 views
WordPress WordPress Database Bloat: How to Clean It Up Safely

Bloated WordPress database slowing down wp-admin and backups? Learn how to safely clean up revisions, transients, and autoloaded options with WP-CLI.

15 July 2026 · 5 min
Hosting cPanel Remote MySQL: Allow External Database Connections

Learn how to allow external MySQL connections in cPanel with Remote MySQL, fix error 1130/2003, and secure remote database access the right way.

15 July 2026 · 6 min
Hosting Managing MySQL Databases in cPanel with phpMyAdmin

Learn to create MySQL databases and users in cPanel, fix #1045 access denied errors, and import or export large databases through phpMyAdmin without timeouts.

12 July 2026 · 5 min · 1 view
WordPress Fix 'Error Establishing a Database Connection' in WordPress

Seeing 'Error establishing a database connection' in WordPress? Diagnose wp-config.php, restart MySQL and repair the database with step-by-step cPanel fixes.

11 July 2026 · 6 min · 4 views
WordPress Migrating a WordPress Site from Kinsta to Getwebup

Moving off Kinsta? Step-by-step guide to migrate WordPress files, database, and DNS to Getwebup hosting without downtime or breaking email delivery.

28 August 2026 · 6 min · 4 views
WordPress Migrating a WordPress Site from Cloudways to Getwebup

Move a WordPress site from Cloudways to Getwebup step by step — SSH export, database transfer, cache reset, and a safe DNS cutover with zero downtime.

27 August 2026 · 5 min · 3 views
cPanel Fix Foreign Key Constraint Errors in phpMyAdmin Imports

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.

24 August 2026 · 6 min · 4 views
WordPress WooCommerce Flash Sale Traffic Spike: A Hosting Checklist

Planning a WooCommerce flash sale? Use this hosting checklist to prep caching, database connections, PHP-FPM, CDN, and webhooks before the traffic hits.

23 August 2026 · 5 min · 2 views
VPS MySQL Point-in-Time Recovery on a VPS Using Binary Logs

Restore MySQL to the exact second before a bad query hit with binary log point-in-time recovery. Setup, restore steps, and mistakes to avoid.

22 August 2026 · 7 min · 3 views
WordPress WordPress wp_options Bloat: Find and Fix Autoload Data

A bloated wp_options table with too much autoloaded data slows every WordPress page load. Here's how to find the worst offenders and clean it up safely.

22 August 2026 · 5 min · 4 views
cPanel MySQL "Unknown Collation" Error After Migration: Causes & Fix

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.

21 August 2026 · 5 min · 5 views
cPanel Softaculous Installation Stuck or Failed: Causes and the Fix

Softaculous install stuck or failing in cPanel? Here's every real cause - disk quota, database limits, PHP version, mod_security - and how to fix each one.

21 August 2026 · 6 min · 6 views
Troubleshooting MySQL max_user_connections Error: Causes and the Fix

MySQL error 1226 'max_user_connections' exceeded on cPanel or WHM hosting? Here's exactly why it happens and how to raise the limit and fix it for good.

21 August 2026 · 5 min · 8 views
Hosting Convert MyISAM to InnoDB in phpMyAdmin the Safe Way

Learn why old MyISAM tables cause crashes and locking issues, and how to safely convert them to InnoDB in phpMyAdmin without breaking WordPress or WooCommerce.

19 August 2026 · 6 min · 4 views
Troubleshooting MySQL "Access Denied for User" in cPanel: Causes & Fix

Getting 'Access denied for user' connecting to MySQL in cPanel? Fix unlinked users, host mismatches, wrong username prefixes, and stale credentials fast.

18 August 2026 · 6 min · 4 views
Troubleshooting WooCommerce Slow? Fix a Bloated Action Scheduler Queue

WooCommerce site crawling to a halt? A bloated Action Scheduler queue is often the hidden cause. Learn how to diagnose, clear, and prevent it for good.

11 August 2026 · 5 min · 4 views
cPanel Upgrading MySQL/MariaDB in WHM Without Breaking cPanel Sites

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.

10 August 2026 · 6 min · 5 views
cPanel cPanel MySQL Privileges: Give Users Only What They Need

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

9 August 2026 · 6 min · 3 views
cPanel phpMyAdmin Import Failing? Fix 'max_allowed_packet' Errors

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

9 August 2026 · 6 min · 5 views
cPanel Fix MySQL “Definer Does Not Exist” Errors After Migration

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.

8 August 2026 · 6 min · 6 views
cPanel phpMyAdmin Import Stuck or Failing on Large SQL Files? Fix It

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.

6 August 2026 · 6 min · 5 views
Troubleshooting MySQL Deadlock Found: Causes and How to Fix It Fast

Getting 'Deadlock found when trying to get lock' in MySQL on WooCommerce or WordPress? Learn why it happens and how to fix and prevent it for good.

29 July 2026 · 6 min · 3 views