Showing posts from May, 2011

How to increase the size of import in phpmyadmin(other parameters also)

PhpMyAdmin gives the import size of 2mb only and if you had to import the database of larger than this size it does not except it so we can increase the size of the import option by following steps..

go to:
#vi /etc/php.ini       //php main setting file

find the following lines and replace these by the requirements you have i am giving you an example.

Original lines:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change it to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time =5000
memory_limit = 1000M

restart your httpd service and refresh your phpmyadmin to take effect.

How to install phpMyAdmin in Linux(Redhat or equivalent)

PhpMyAdmin is very important thing for any DBA or System admin as it gives full execess to our Mysql database as well as php configuration. The best part is it has GUI mode for handling all the related issues.

First install all the reated files to run Mysql, php, Apache

#Yum install apache
#yum install php-mysql
#yum install mysql-server

configure your Apache web server( If you have any problem regarding that you can look in my post "How to configure Apache wb server")

check in the /etc/httpd/conf.d that there is php.conf file is present

start all the required services

#service httpd start
#service mysqld start

Download the required phpMyAdmin interface from the net(just google phpmyadmin download u will get it)

After downloading it uncompress it

#tar -xjvf php.......(depending upon the version u downloaded)

move this folder to your web directory in which your site is located and remane it to your likings as i have done php.
move to the folder and open the configuration file…

How to install openfiler

Openfiler is Linux based kernel which runs on anaconda also, here are the steps to install openfiler, i have installed it in through VmWare but same process will work in physical system also.

*boot the openfiler

*check your CD media if you want

*after that boot loader will start

*you will set a welcome screen ->next

*select your keyboard type

select automatic if you want openfiler to do default setting else manual for doing user define disk spacing,iam choosing manual.  

*you will get the disk setup menu

 *using new add new mount points according to your requirements

*add swap memory also in this  and required fields

*click yes to confirm it

*if you have DHCP configured use that to assign IP or you can enter manually by going to edit 

*enter the IP and network mask which you want to assign 

*Do rest of setting as you have your network 

 *select your region

*select yes to confirm it

*enter the password for the openfiler

*next to confirm it

*system installation will star…