MySql, Uncategorized

How to take Database Backup using phpMyAdmin

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 …

MySql, Uncategorized

Mysql Commands

Mysql Commands: How to check mysql connection or login to your Database using shell ========================= root@server[#] 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 …

Uncategorized

How to download the files forcefully using .htaccess

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.  

Installation, PHP

How to install APC for php in linux server

How to install APC for php in linux server pecl install php   You can use the below steps to install it manually. wget http://pecl.php.net/get/APC tar -zxf APC-3.1.9.tgz cd APC-3.1.9 whereis php-config ./configure –enable-apc –enable-apc-mmap –with-apxs–with-php-config=/usr/bin/php-config make make install restart the apche /etc/init.d/httpd restart     If you are getting below error message : /root/tmp/pear/APC/apc.c:454: …