Day: November 2, 2011

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
Featured
Linux
Tips and Tricks
Tutorial

How to Disable SSH Root Login in Linux

It is important to disable root login in your SSH service. To do this, edit /etc/ssh/sshd_config: # pico /etc/ssh/sshd_config And add in the following line: PermitRootLogin no Restart SSH service: # /etc/init.d/sshd restart

Read More