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
Linux service restart shell script Rumi, November 29, 2013November 29, 2013 I badly needed a script that would check if my running services (in this script it'll check varnish and apache2 services) are alive- if not, it'll restart the dead service and write a log. Pretty handy! Continue Reading
.htaccess URL redirect Rumi, November 13, 2013 # This allows you to redirect your entire website to any other domain Redirect 301 / http://mt-example.com/ # This allows you to redirect your entire website to any other domain Redirect 302 / http://mt-example.com/ # This allows you to redirect index.html to a specific subfolder Redirect /index.html http://example.com/newdirectory/ # Redirect… Continue Reading
OpenFiler Installation On Headless NAS Rumi, November 12, 2013 So, you have a Dell 715N nas or similar and wish to install OpenFiler onto it? This nas is headless, it has no USB ports, no CDROM, no floppy. It’s only connection to the outside world is it’s serial port and it’s network interfaces (2). You may or may not… Continue Reading
Nginx wordpress fancy URL or permalink fixing Rumi, November 12, 2013 If your wordpress is installed in the root directory i.e. yourdomain.com, you can use the following directives- location / { try_files $uri $uri/ /index.php?$args; } # Add trailing slash to */wp-admin requests. rewrite /wp-admin$ $scheme://$host$uri/ permanent; location ~* \.(jpg|jpeg|png|gif|css|js|ico)$ { expires max; log_not_found off; } Or if your wordpress is… Continue Reading
Reset the root password in Debian or Ubuntu Rumi, November 9, 2013 In order to boot into the recovery mode on Debian or Ubuntu, hold down SHIFT key after powering on your Linux machine. You will then be presented with GRUB menu. Select “recovery menu” option by pressing down arrow key. Do not press ENTER at this point, but rather press “e”… Continue Reading
How to clear the yum cache Rumi, October 20, 2013 When a package is downloaded, installed and is removed there is a chance that the package may still be saved/stored in the yum’s cache. So to clean all the cached packages from the enabled repository cache directory, login as root and execute the following: yum clean packages To purge the… Continue Reading