Importing Big mysqldump with Progress Bar PV Rumi, June 6, 2014 I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place: $ rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Install pv using yum: $ yum install -y pv Installation done. Let the importing begin! $ pv /home/user/my_big_dump.sql | mysql -uroot -p For Ubuntu/Debian distribution intall PV… Continue Reading
OpenVZ on Debain Squeeze Rumi, June 6, 2014 As soon as your Debian OS server is ready, login using the received credentials. We first will do an update/upgrade: apt-get update && apt-get -y upgrade && apt-get -y dist-upgrade which will upgrade our server to latest version. We install some additional packages to: apt-get -y install nano wget… Continue Reading
TimeZone adjust in Linux Rumi, June 6, 2014 For Redhat/CentOS/Fedora/SL distribution Type the redhat-config-date command at the command line to start the time and date properties tool, run: # redhat-config-date OR type setup and select time zone configuration. This tool is recommended for remote ssh text based sessions. # setup Select timezone configuration. Just follow on screen… Continue Reading
Update PHP 5.1 to PHP 5.4 in CentOS Rumi, June 6, 2014 Update Yum repos For 32 bit CentOS- wget http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm For 64 bit CentOS- wget http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm Now it’s time to update our PHP to the latest one yum –enablerepo=remi update php php-* /etc/init.d/httpd restart And that’s it! You can check your installed PHP version executing: php… Continue Reading
LAMP on CentOS Rumi, June 6, 2014September 8, 2016 Installing MySQL 5 To install MySQL, we do this: yum -y install mysql mysql-server Then we create the system startup links for MySQL (so that MySQL starts automatically whenever the system boots) and start the MySQL server: chkconfig –levels 235 mysqld on /etc/init.d/mysqld start Set passwords for the MySQL root… Continue Reading
Update PHP 5.4 on Debian 6 Squeeze Rumi, June 6, 2014 Set up Dotdeb First add Dotdeb to your Apt sources: sudo vim /etc/apt/sources.list /etc/apt/sources.list deb http://packages.dotdeb.org squeeze all deb-src http://packages.dotdeb.org squeeze all deb http://packages.dotdeb.org squeeze-php54 all deb-src http://packages.dotdeb.org squeeze-php54 all Save & Exit. Now go for the next- Continue Reading
Reinstall Openssh server on Debian 6/7 Rumi, June 6, 2014 Linux: Debian / Ubuntu Linux Remove SSHD Server Type the following commands: # apt-get –purge remove openssh-server Now reinstall the openssh again using- # apt-get install openssh-server Voila Src: http://www.cyberciti.biz/faq/howto-unix-linux-remove-delete-opensshd-server/ Continue Reading
Install Phalcon framework in Debain 6/7 Rumi, June 6, 2014 This repo can be used additionally to the squeeze-php54 repo of dotdeb.org. Add the following into /etc/apt/sources.list deb http://debrepo.frbit.com/ frbit-squeeze main Add the key, update apt and install packages wget -O – http://debrepo.frbit.com/frbit.gpg | sudo apt-key add – aptitude update aptitude install php5-igbinary php5-mongo php5-oauth php5-phalcon php5-runkit php5-stats php5-stomp php5-yaf… Continue Reading
Reset root password in Centos/Redhat/SL linux Rumi, June 6, 2014 1. Boot the system and when you see the following message “Press any key to enter the menu”, press any key. (You will see the list of available kernel versions.) 2. Press e in order to edit commands before booting. 3. Highlight the list item with vmlinuz in it by… Continue Reading
Importing Big mysqldump with Progress Bar PV Rumi, December 12, 2013 I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place: $ rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Install pv using yum: $ yum install -y pv Installation done. Let the importing begin! $ pv /home/user/my_big_dump.sql | mysql -uroot -p For Ubuntu/Debian distribution intall PV using-… Continue Reading