How to install memcache

Definition:

Memcache is a high-performance memory object caching system intended to speed up dynamic web applications by alleviating database load. Memcache is extremely fast. It uses libevent, which provides a mechanism to execute a callback function when a specific event occurs on a file descriptor, to scale to any number of open connections. On a modern Linux system memcached utilizes epoll, is completely non-blocking for network I/O, ensures memory never gets fragmented, and uses its own slab allocator and hash table to achieve 0(1) virtual memory allocation.

How it install memcache:

#curl -O http://monkey.org/~provos/libevent-1.4.9-stable.tar.gz

#tar -xzvf libevent-1.4.9-stable.tar.gz

#cd libevent*

#./configure

#make

#make install

Now let’s download the newest Memcached source

#curl -O http://www.danga.com/memcached/dist/memcached-1.3.0.tar.gz

#tar zxf memcached-1.3.0.tar.gz

#cd memcached-1.3.0

#./configure

#make

#make install

Then add /usr/local/lib to LD_LIBRARY_PATH in your .bash_profile

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH

Add the below link in php.ini of the server

extension=memcache.so

Now restart Apache:

Service httpd restart

Once it sucussfully install you can create phpinfo() on your webserver should now confirm that memcache is installed.

How to take Database Backup using phpMyAdmin.

First you need phpMyAdmin which is a MySQL Database Administration Tool.

1 – Open phpMyAdmin

2 – Click on Export

3 – Under Export – Select the database you want to backup

4 – Select SQL

5 – Select Structure, Add DROP TABLE, Add IF NO EXISTS, Add AUTO_INCREMENT VALUE and Enclose table and field names with backquotes.

6 – Select Data, Complete inserts, Extended inserts and Use hexadecimal for binary fields.

7 – Select Save as file your data base. Here you can use any name you want.

9 – In Compression specify your choice.

10 – Click Go.

How to restore a Database using phpMyAdmin.

1 – Open phpMyAdmin

2 – On the far right hand side, click on the little SQL box and a window should open

3 – In this window click on Import Files

4 – Use the browse button to find the database file.

5 – In Compression Select the option you chose to export the database

6 – Click Go.

Mysql Commands:

How to check mysql connection or login to your Database using shell
=========================
[email protected][#] mysql -u username -p
=========================
it will ask for password then provide the correct password.

Create Database on the Mysql Server
=========================
mysql> create database [databasename];
=========================
ex : mysql>create database Dresses;

List all databases on the sql server.
===========================
mysql> show databases;
===========================

To List all tables in the Database.

==========================
mysql> show tables;
==========================

To check the table Constraints or Describe table
==========================
mysql> describe [table name];
==========================

To Delete a Database
==========================
mysql> drop database [database name];
==========================

To delete a table.
==========================
mysql> drop table [table name];
==========================

Command to give privileges to the user

[email protected][#]mysql

grant all privileges on test_wrdp1.* to [email protected] identified by ‘test123’;

database name = test_wrdp1
db user name = test_wrdp1
db pass = test123

How to download the files forcefully using .htaccess without displaying it in browser

Create .htacceses file under your accout and insert the below code.

AddType application/octet-stream .avi

AddType application/octet-stream .mpg

save and quit the file.

How to install APC for php in linux server

You can use the below steps to install it manually.

Command to check  server inode value

Fire the below command in shell.
[email protected][~]# df -i

It will provide the below output.
Filesystem            Inodes               IUsed             IFree              IUse          %      Mounted on
/dev/sda4            182796288     58405          24 1769           55764     4%       /
/dev/sdb1            244154368      5659             751 238          494617   3%      /backup
/dev/sda2             183264              540               182724                             1%      /tmp
/dev/sda1              24480             77                     24403                             1%       /boot

The inode value of server is : 182796288

 How to enable php.ini for all the folders under one account

404 error code for all third party applications

IPtables:

iptables -nL | grep 49.248.23.83

DROP all — 49.248.23.83 0.0.0.0/0
DROP all — 0.0.0.0/0 49.248.23.83

iptables -I INPUT -s 49.248.23.83 -j ACCEPT

iptables -A INPUT -d 49.248.23.83 -j DROP

service iptables save

service iptables restart

iptables -I INPUT -p tcp –dport 2082 -j ACCEPT

iptables -I INPUT -p udp –dport 2082 -j ACCEPT

iptables -I OUTPUT -p tcp –dport 2082 -j ACCEPT

iptables -I OUTPUT -p udp –dport 2082 -j ACCEPT

iptables -I INPUT -p tcp –dport 2082 -j DROP

iptables -I INPUT -p udp –dport 2082 -j DROP

iptables -I OUTPUT -p tcp –dport 2082 -j DROP

iptables -I OUTPUT -p udp –dport 2082 -j DROP

• service iptables save

• service iptables restart

iptables -A INPUT -p tcp –destination-port 1568:1570 -j ACCEPT

iptables -A OUTPUT -p tcp –source-port 1568:1570 -j ACCEPT

• service iptables save

• service iptables restart

To redirect the page without changing web address. You can use the below code:

Create the index page and insert the below code:

[notice]Change your domain.com to your actual domain name. [/notice]