Browsing: Database

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…

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…