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
freedns.afraid.org

How to Build Linux Web Server with Dynamic IP Address

Requirements: Ubuntu GNU/Linux Account at freedns.afraid.org Easy Hosting Control Panel (EHCP) Router How to: 1. Install Ubuntu. We set local IP Address to 192.168.0.1 $ sudo nano /etc/network/interfaces Type in the following lines: auto eth0 iface eth0 inet static address 192.168.0.1 netmask 255.255.255.0 gateway 192.168.0.254 192.168.0.254 is the gateway / modem’s IP Address. 2. Install…

Read More

How to Fix WordPress Error “Briefly unavailable for scheduled maintenance. Check back in a minute”

This maintenance message shows when WordPress updating its version, theme or plugin. Sometimes the updating process gets interrupted or fails for any reason. To fix this problem, delete .maintenance file in root directory of your WordPress folder. That’s all. Simple as it gets. In case the “. maintenance” file was not there at all. Started…

Read More

How to Create Bandwidth Usage Script on Linux

Using a tool called iftop we can monitor bandwidth usage via command line on Linux. But here we will create our own shell script to monitor bandwidth usage. The idea is to read rx_bytes and tx_bytes files inside /sys/class/net/[interface]/statistics/ folder. Create netspeed script in /usr/local/bin/ and copy and paste below script. Script content: Exit nano…

Read More