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

How to Manually Install Virtualbox Guest Additions for Linux Host

There is a problem in Virtualbox for Linux in which it can not download Virtualbox Guest Additions automatically. It shows error message with download link, but the link doesn’t work. You have to download it manually from http://download.virtualbox.org/virtualbox/. Go to desired folder and download the .iso file. After that, mount the .iso file and install…

Read More

How to Install OpenVPN in Ubuntu 11.04

Few days ago I bought VPS account which I installed Ubuntu 11.04. This is how I installed OpenVPN into the VPS. The network configuration: # ifconfig lo        Link encap:Local Loopback inet addr:127.0.0.1  Mask:255.0.0.0 UP LOOPBACK RUNNING  MTU:16436  Metric:1 RX packets:11947 errors:0 dropped:0 overruns:0 frame:0 TX packets:11947 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:1287068 (1.2…

Read More

Build FreeBSD Kernel

Make sure kernel source is installed. If it is not installed, use ‘sysinstall’ command. Copy kernel GENERIC configuration: # cd /usr/src/sys/i386/conf/ # cp GENERIC KERNELNEW Edit KERNELNEW configuration as your needed: # ee KERNELNEW And then, build the kernel: # cd /usr/src # make buildkernel KERNCONF=KERNELNEW # make installkernel KERNCONF=KERNELNEW Finish. Reboot PC. To build…

Read More