18 Apr Database, MySQL, Tips and Tricks, Ubuntu Ubuntu: How to Troubleshoot High CPU in MySQL April 28, 2024 By kumkum 0 comments Run 'top' to check PID of mysqld causes high CPU load Continue reading
22 Jul Database, MySQL MySQL: How to Fix “Field Doesn’t Have A Default Value” Error July 22, 2022 By kumkum 0 comments MySQL or MariaDB install has default value of sql mode named STRICT_TRANS_TABLES. Continue reading
13 Mar Database, Debian, Linux, Open Source, Tips and Tricks, Tutorial, Ubuntu How to Fix MySQL Error “Stopping MySQL database server : mysqld failed!” on Debian Squeeze April 28, 2024 By kumkum 2 comments This problem happens when you modify user table in mysql database. In Debian system, there is a user named debian-sys-maint. We can't r...Continue reading
09 Mar Database, Debian, Linux, Open Source, PHP, Tutorial, Ubuntu How to Install PhpMyAdmin on Ubuntu / Debian March 9, 2012 By kumkum 0 comments PhpMyAdmin is a web-based tool written in PHP to handle administration of MySQL database. To install PhpMyAdmin on Ubuntu / Debi...Continue reading
23 Feb Database, Linux, Tutorial, Ubuntu How to Downgrade to PostgreSQL 8.2 on Ubuntu 11.10 August 22, 2013 By kumkum 0 comments Ubuntu 11.10 comes with PostgreSQL 8.4. I did this downgrade because my web application, Hospital Management System, was develop...Continue reading
02 Nov Database, Tips and Tricks, Tutorial, Windows How to Repair Corrupted MySQL (MyISAM) Table November 11, 2011 By kumkum 0 comments Platform: Windows (should work on Linux) Database name: activity Table name: mamain 1. Copy myisamchk.exe to database folder C:xa...Continue reading