≡ Menu

The following is a table comparison between InnoDB with MyISAM

There is minor problem that MyISAM did not support Transactions and innoDB are more relialbe on atomicity. But you can solve that problem by your own programmming design, you can achieve that by random no method, you can achieve parallelism also

Here is a simple shell script to automatically Convert MySql Database from InnoDB to MyISAM.

{ 0 comments }

How to Update FreeBSD Software Package

freebsd logoTo Update FreeBSD sofware package and apply security patches, please follow the following step

Step 1: Upgrade FreeBSD ports collection

step 2: install FreeBSD portmanager

Step 3: Check outdated ports list

Step 4: Update FreeBSD packages / software

How do I apply update again?
In order to update system again just type the following command:

How do I apply binary security updates for FreeBSD?

Latest version includes a tool called freebsd-update (thanks to Bok for pointing out this tool). The freebsd-update tool is used to fetch, install, and rollback binary updates to the FreeBSD base system.

Use fetch option to get all available binary updates:

Install Update
Install the most recently fetched updates:

Rollback updates

Optional: You can uninstall most recently installed updates:

Ref: www.cyberciti.biz

{ 0 comments }

To upgrade Freebsd, we will be using freebsd-update, a great piece of software that fetches and installs binary updates to FreeBSD.

Step 1 : Fetch updates

If any updates where installed above – reboot your system before continuing.
Step 2 : Upgrade FreeBSD

The system must now be rebooted with the newly installed kernel before the non-kernel components are updated.

Step 3: Install Update
After rebooting, freebsd-update(8) needs to be run again to install the new userland components:
# freebsd-update install
Step 4: Finally, reboot into 9.1-RELEASE
# reboot

ref: bsdguides.org

{ 0 comments }

mysql logoHere is step by step explanation on How to Check and Repair a MySQL Database Through Console SSH with Mysqlcheck and Myisamchk are similar in purpose, there are some essential differences. Mysqlcheck as well as Myisamchk can check, repair and analyze MyISAM tables. Mysqlcheck can also check InnoDB tables.

step 1: Log in as ‘root’ via SSH and:
step 2: Shows you if any need repair:

step 3: Recover MySql Database
try ‘safe-recover’ first:

and, if neither that nor this works:

Then use the ‘force’ flag:

If those are not MyISAM tables try Mysqlcheck:

to repair one database:

to repair one table in database:

ref: vps.net

{ 1 comment }

If you try to upload a file through http to your web site running on Apache2/PHP5/mod_fcgid, and in your browser you get the error:

In Apache’s error log you see something like

First check in your php.ini that upload_max_filesize has a big enough value for your upload. By default it’s

Then open your Apache vhost configuration and add the FcgidMaxRequestLen directive with a big enough value (in bytes), for example

which equals roughly 2 MB.

The default value is

which is very small (see http://httpd.apache.org/mod_fcgid/mod/mod_fcgid.html#fcgidmaxrequestlen).

Finally restart Apache.

{ 0 comments }

How to CHMOD Files and Folder

Set chmod a Folder or a file

Set chmod all folders and files

If you really want to do is set the directories to 755 and either leave the files alone or set them to 644 for this you can use the find command e.g.

to change all the directories to 755:

to change all the files to 644:

{ 0 comments }

If got message like MySQL Error: 1 (Can’t create/write to file ‘/tmp/#sql_7425_0.MYD’ (Errcode: 17)) or Warning: session_write_close(): write failed: No space left on device

you can check:

  • Make sure that /tmp isn’t out of space
  • Make sure that /tmp is chmod 1777
  • If you’re using a virtual /tmp partition (/tmpDSK) make sure it’s not corrupt – if so replace it

If your /usr/tmpDSK is corrupted. You should stop all processes that have files open on /tmp such as MySQL and other applications using:

Delete all un-necessary files and then run the following command:

{ 0 comments }

If you can not access into your server via ssh, and said : Connection refused

First step check your firewall whether the firewall has allowed ssh port ?

If you don’t have any firewall configuration, check your ssh server status

and then checking log at

if there is logs like the following errors.

Fixed by :

Restart your ssh server

{ 0 comments }

How to Fix FTP Not Working or FTP Connection Refused in Kloxo, please try the following command.

{ 0 comments }

If you run yum update on your centOS and get an error like this:

You can fix this eror with this command:

1. Check for processes holding the rpm database open:

If it finds any, kill -9 them all.

2. Delete any temporary DB files:

3. Rebuild your RPM database:

If you still have problems, a reboot is probably quickest, then repeat steps 2 and 3 above.

{ 0 comments }