Databases

Quick Answer: To repair and optimize MySQL tables in WordPress, use WP-CLI by running wp db repair followed by wp db optimize. In phpMyAdmin, select all tables in your database and choose “Repair table” and “Optimize table” from the bottom action dropdown. On Linux VPS, execute mysqlcheck -u root -p –auto-repair –optimize –all-databases. ⏱️ 5 … Read more

Quick Answer: The “Error Establishing a Database Connection” screen occurs when WordPress cannot communicate with its MySQL/MariaDB database. To fix it: 1) Verify database credentials in wp-config.php (DB_NAME, DB_USER, DB_PASSWORD, DB_HOST), 2) Verify your MySQL server daemon is active and running (sudo systemctl restart mariadb), 3) Enable native WordPress repair mode (define(‘WP_ALLOW_REPAIR’, true);), and 4) … Read more

Quick Answer: To optimize MariaDB or MySQL for a 2GB or 4GB Linux VPS, edit /etc/mysql/my.cnf and allocate 65% to 70% of available RAM to the innodb_buffer_pool_size (1.4GB on a 2GB VPS, 2.8GB on a 4GB VPS), limit max_connections = 80, set innodb_log_file_size = 256M, and increase table_open_cache = 4000 to prevent disk I/O bottlenecks. … Read more

Quick Answer: To increase the phpMyAdmin upload file size limit from the default 2MB to 512MB+, adjust 4 core PHP directives in your active php.ini file: set upload_max_filesize = 512M, post_max_size = 512M, memory_limit = 512M, and max_execution_time = 300. In cPanel, navigate to Select PHP Version > Options or MultiPHP INI Editor to apply … Read more

Quick Answer: To export a large MySQL database without locking production tables, execute mysqldump -u username -p –single-transaction –quick dbname > backup.sql. To import a large SQL dump without web browser timeout errors, execute mysql -u username -p dbname < backup.sql (or pipe through pv backup.sql | mysql -u username -p dbname for live progress … Read more

Compare the best free cPanel web hosting providers in 2026 featuring PHP 8.3 runtime, MySQL databases, phpMyAdmin, and free SSL with no ads.