Database

Database
Debian
Featured
Linux
Open Source
Technology
Tips and Tricks
Tutorial
Ubuntu

How to Fix MySQL Error “Stopping MySQL database server : mysqld failed!” on Debian Squeeze

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 restart mysql daemon if the password is not correct. We have to update the password for that user. First, we check the password: Login to mysql shell as root Now use the following […]

Read More
Database
Debian
Featured
Linux
Open Source
PHP
Technology
Tutorial
Ubuntu

How to Install PhpMyAdmin on Ubuntu / Debian

PhpMyAdmin is a web-based tool written in PHP to handle administration of MySQL database. To install PhpMyAdmin on Ubuntu / Debian, execute this command: After that, you can access it on http://your_ip/phpmyadmin/

Read More
Database
Linux
Technology
Tutorial
Ubuntu

How to Downgrade to PostgreSQL 8.2 on Ubuntu 11.10

Ubuntu 11.10 comes with PostgreSQL 8.4. I did this downgrade because my web application, Hospital Management System, was developed using PostgreSQL 8.2 database and it will throw SQL query error if running on version 8.4. This is step by step guide how to install PostgreSQL 8.2 on Ubuntu 11.10 1.Download source code from http://www.postgresql.org/ftp/source/ and […]

Read More
Database
Featured
Technology
Tips and Tricks
Tutorial
Windows

How to Repair Corrupted MySQL (MyISAM) Table

Platform: Windows (should work on Linux) Database name: activity Table name: mamain 1. Copy myisamchk.exe to database folder C:\xampp\mysql\bin>copy myisamchk.exe ..\data\activity 2. Run the executable C:\xampp\mysql\bin>cd ..\data\activity C:\xampp\mysql\data\activity>myisamchk -r mamain – recovering (with sort) MyISAM-table ‘mamain’ Data records: 81619 – Fixing index 1 Data records: 81618 3. Finish Note: Make sure you have turned off […]

Read More