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
PHP enable error reporting Rumi, December 11, 2013 You can set PHP error reporting on in php.ini file (in case you have access to this file). Set the following lines: error_reporting = E_ALL display_errors = On If you have no access to php.ini file but you can modify .htaccess file on your server (in root of your public_hml… Continue Reading
Installing Apache2, PHP5, MySQL and PHPMyadmin On Debian Rumi, December 8, 2013 First we install MySQL 5 like this: apt-get install mysql-server mysql-client You will be asked to provide a password for the MySQL root user – this password is valid for the user root@localhost as well as root@server1.example.com, so we don't have to specify a MySQL root password manually later on:… Continue Reading
Install VNCServer on Centos 5 Rumi, December 5, 2013 Install VNC Server to operate CentOS with GUI remotely from Windows client. VNC is already installed if you already build Desktop Environment. If it's not installed, Install by a command 'yum -y install vnc-server'. [root@ns ~]# yum -y install vnc-server [root@ns ~]# vi /etc/sysconfig/vncservers # line 20: make valid and… Continue Reading