<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-8660262373296199534</id><updated>2024-09-24T20:08:23.585-07:00</updated><category term="Unix Shell Commands"/><category term="MYSQL"/><category term="Network"/><category term="Linux Performance"/><category term="Setup"/><category term="path shell"/><category term="Nginx"/><category term="PHP"/><category term="Php-cgi"/><category term="System"/><category term="Antiddos"/><category term="Apache"/><category term="Centos"/><category term="Extensions"/><category term="FTP"/><category term="Fast-Cgi"/><category term="Firewall"/><category term="Hardware"/><category term="Hostname"/><category term="LAMP"/><category term="Security"/><category term="Text Editors"/><category term="Timezone"/><category term="Virtual Host"/><category term="Webmin"/><category term="ftp server"/><category term="iptables"/><category term="memcached"/><category term="vsftp"/><title type='text'>Virtual Private Server Life</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>32</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-3032641801041633074</id><published>2012-05-05T15:56:00.003-07:00</published><updated>2012-05-05T15:56:51.326-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="path shell"/><category scheme="http://www.blogger.com/atom/ns#" term="Unix Shell Commands"/><title type='text'>How to run a unix command as a USER on startup?</title><summary type="text">To run a unix command on startup you may use the command below (add it to the /etc/rc.local file):

su USER -c &#39;your_command &amp;amp;&#39;</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/3032641801041633074/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/3032641801041633074' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/3032641801041633074'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/3032641801041633074'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2012/05/how-to-run-unix-command-as-user-on.html' title='How to run a unix command as a USER on startup?'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-2144501024964593829</id><published>2012-05-05T02:29:00.000-07:00</published><updated>2012-05-05T02:35:18.443-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="path shell"/><category scheme="http://www.blogger.com/atom/ns#" term="System"/><category scheme="http://www.blogger.com/atom/ns#" term="Unix Shell Commands"/><title type='text'>How to make stable $PATH when using sudo command?</title><summary type="text">To make your sudo commands works with the $PATH of your logged-in user you just type the following command and then close all your terminals and login again:


echo &quot;alias sudo=&#39;sudo env PATH=$PATH&#39;&quot; &amp;gt;&amp;gt; ~/.bashrc</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/2144501024964593829/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/2144501024964593829' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2144501024964593829'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2144501024964593829'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2012/05/how-to-make-stable-path-when-using-sudo.html' title='How to make stable $PATH when using sudo command?'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-4758058350359427035</id><published>2012-01-25T04:42:00.000-08:00</published><updated>2012-01-25T04:42:30.894-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="iptables"/><category scheme="http://www.blogger.com/atom/ns#" term="memcached"/><title type='text'>securing memcache</title><summary type="text">Simply iptables rules can be added to secure memcached server from the out sources.

/sbin/iptables -A INPUT -m tcp -p tcp -s 127.0.0.1 --dport 11221 -j ACCEPT/sbin/iptables -A INPUT -m tcp -p tcp -s&amp;nbsp;CLIENT_IP_2&amp;nbsp;--dport 11221 -j ACCEPT/sbin/iptables -A INPUT -m tcp -p tcp -s CLIENT_IP_1 --dport 11221 -j ACCEPT/sbin/iptables -A INPUT -m tcp -p tcp --dport 11221 -j DROPTo make it run when</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/4758058350359427035/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/4758058350359427035' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/4758058350359427035'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/4758058350359427035'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2012/01/securing-memcache.html' title='securing memcache'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-6576164450964006744</id><published>2011-10-16T05:07:00.000-07:00</published><updated>2011-10-16T05:07:25.425-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="path shell"/><title type='text'>Learn path and shell of current user on unix</title><summary type="text">To find the shell type of current user: 
echo $SHELL
To find the paths of current user:
echo&amp;nbsp;$PATH</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/6576164450964006744/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/6576164450964006744' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/6576164450964006744'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/6576164450964006744'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2011/10/learn-path-and-shell-of-current-user-on.html' title='Learn path and shell of current user on unix'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-3584309637937227999</id><published>2010-07-09T14:10:00.000-07:00</published><updated>2010-07-09T14:19:20.572-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Network"/><category scheme="http://www.blogger.com/atom/ns#" term="Unix Shell Commands"/><title type='text'>Simple SH script to monitor basic connection counts on *nix systems</title><summary type="text">I wrote near a year ago a sh script to see my traffic information which can be used to see basic connection counts like unix connection count, tcp connection count, http inbound and outgoing request counts and ftp connection count, ssh connection count.
Save as mycons.sh then run the command
chmod +x mycons.shFor short access run
ln mycons.sh /bin/mycons Sample usage after shortcut
mycons -hlHere</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/3584309637937227999/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/3584309637937227999' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/3584309637937227999'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/3584309637937227999'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2010/07/simple-sh-script-to-monitor-basic.html' title='Simple SH script to monitor basic connection counts on *nix systems'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-6641113382771402553</id><published>2010-07-09T13:49:00.000-07:00</published><updated>2010-07-09T14:21:33.111-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Network"/><title type='text'>VNSTAT: Network Traffic Monitor for *nix Systems</title><summary type="text">Vnstat is a network stats software, an opensource project for *nix systems and can be downloaded from http://humdi.net/vnstat/. For more than a year I am using Vnstat and it works silently without using too much resources and gives required stats when it is needed. 
In details, it is possible to see your network adapters&#39; traffic data based on years, months, weeks, days, hours and even real time </summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/6641113382771402553/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/6641113382771402553' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/6641113382771402553'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/6641113382771402553'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2010/07/vnstat-network-traffic-monitor-for-nix.html' title='VNSTAT: Network Traffic Monitor for *nix Systems'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-940233246751161140</id><published>2010-02-26T08:33:00.000-08:00</published><updated>2010-02-26T08:33:44.296-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Antiddos"/><category scheme="http://www.blogger.com/atom/ns#" term="Nginx"/><category scheme="http://www.blogger.com/atom/ns#" term="Php-cgi"/><title type='text'>Anti-DDOS NGINX Server Configuration includes PHP config</title><summary type="text">Here is my NGINX configuration for DDOS Attacks to PHP and my lovely NGINX server:
nginx.conf
user www-data www-data;
worker_processes 10;

error_log /var/log/nginx/error.log;
pid /var/run/nginx.pid;

events {
worker_connections 1024;
}

http {
include /etc/nginx/mime.types;
default_type application/octet-stream;

access_log /var/log/nginx/access.log;

sendfile on;

#keepalive_timeout 0;
</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/940233246751161140/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/940233246751161140' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/940233246751161140'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/940233246751161140'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2010/02/anti-ddos-nginx-server-configuration.html' title='Anti-DDOS NGINX Server Configuration includes PHP config'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-8608073258110557261</id><published>2010-02-01T09:33:00.001-08:00</published><updated>2010-02-01T09:33:59.365-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Unix Shell Commands"/><title type='text'>Findout Linux Distrubution Name of your Linux</title><summary type="text">lsb_release -a</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/8608073258110557261/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/8608073258110557261' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/8608073258110557261'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/8608073258110557261'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2010/02/findout-linux-distrubution-name-of-your.html' title='Findout Linux Distrubution Name of your Linux'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-4140826680553447548</id><published>2010-02-01T05:38:00.000-08:00</published><updated>2010-02-01T05:38:04.488-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Timezone"/><title type='text'>Change the timezone, date time on linux</title><summary type="text">ln -sf /usr/share/zoneinfo/Europe/Berlin /etc/localtimeIn this command important part is giving the path of your timezone(bold one in example).</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/4140826680553447548/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/4140826680553447548' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/4140826680553447548'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/4140826680553447548'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2010/02/change-timezone-date-time-on-linux.html' title='Change the timezone, date time on linux'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-8802784820459814373</id><published>2010-01-18T14:26:00.000-08:00</published><updated>2010-01-18T14:26:46.813-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Text Editors"/><title type='text'>Change Default Editor on Linux</title><summary type="text">#set | grep EDITOREDITOR=/bin/pico
# which vi/usr/bin/vi
# export EDITOR=/usr/bin/vi# set | grep EDITOREDITOR=/usr/bin/vi
_=EDITOR</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/8802784820459814373/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/8802784820459814373' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/8802784820459814373'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/8802784820459814373'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2010/01/change-default-editor-on-linux.html' title='Change Default Editor on Linux'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-8242219651919489004</id><published>2009-10-21T08:47:00.000-07:00</published><updated>2009-10-21T08:47:28.918-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Unix Shell Commands"/><title type='text'>Deleting Files Based on Date Time</title><summary type="text">Today I needed to delete files based on date and time:
Here is the command I used for deleting file last modified on 21 Oct 2009 16:30:
ls -lh | sed -n &#39;/Oct\ 21\ 16:30/p&#39; | awk &#39;{print $9}&#39; &amp;gt;&amp;gt; 1.txt
rm -f `cat 1.txt` 
Explanations:&amp;nbsp;
ls -lh (lists all files)
sed -n&amp;nbsp; &#39;/Oct\ 21\ 16:30/p&#39; (find files at given date from list)
awk &#39;{print $9}&#39; (print only file names on list) and &amp;gt;&amp;</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/8242219651919489004/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/8242219651919489004' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/8242219651919489004'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/8242219651919489004'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/10/deleting-files-based-on-date-time.html' title='Deleting Files Based on Date Time'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-1669463737113057014</id><published>2009-10-14T07:23:00.000-07:00</published><updated>2009-10-14T07:23:47.609-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="FTP"/><title type='text'>Recursively Download FTP</title><summary type="text">Sometimes, you may need to move one server to another. At that time, you may use wget command to move your files without any pain.
Here is the command for recursive download on ftp via wget:

wget -r ftp://username:password@ftp.example.com/ 
Yes, thats all folks!</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/1669463737113057014/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/1669463737113057014' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/1669463737113057014'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/1669463737113057014'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/10/recursively-download-ftp.html' title='Recursively Download FTP'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-7660457084961972690</id><published>2009-10-08T09:48:00.001-07:00</published><updated>2009-10-08T09:48:56.760-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Unix Shell Commands"/><title type='text'>List of users on Linux</title><summary type="text">To list the users in linux you may use following command:

cat /etc/passwd | cut -d &quot;:&quot; -f1
</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/7660457084961972690/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/7660457084961972690' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/7660457084961972690'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/7660457084961972690'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/10/list-of-users-on-linux.html' title='List of users on Linux'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-1266106406832715838</id><published>2009-09-16T05:47:00.000-07:00</published><updated>2009-09-16T09:11:25.413-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Fast-Cgi"/><category scheme="http://www.blogger.com/atom/ns#" term="Nginx"/><category scheme="http://www.blogger.com/atom/ns#" term="Php-cgi"/><category scheme="http://www.blogger.com/atom/ns#" term="Setup"/><category scheme="http://www.blogger.com/atom/ns#" term="Virtual Host"/><title type='text'>NGINX, PHP-CGI, SPAWN-FCI, FTP, VHOSTS, MYSQL | centos-fedora-redhat</title><summary type="text">Setup is done under a clean Centos 5.2 32bit serveryum -y updateyum -y upgradePART 0###################################################### start with php-5 setup and mysql setup ######################################################yum -y install mysql-server mysql-clientyum -y install php-cgi php-mysql php-curl php-gd php-idn php-pear php-imagick php-imap php-mcrypt php-memcache php-mhash </summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/1266106406832715838/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/1266106406832715838' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/1266106406832715838'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/1266106406832715838'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/09/nginx-php-cgi-spawn-fci-ftp-vhosts.html' title='NGINX, PHP-CGI, SPAWN-FCI, FTP, VHOSTS, MYSQL | centos-fedora-redhat'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-6574631586604293157</id><published>2009-09-16T05:36:00.000-07:00</published><updated>2009-09-16T05:46:51.576-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ftp server"/><category scheme="http://www.blogger.com/atom/ns#" term="Setup"/><category scheme="http://www.blogger.com/atom/ns#" term="vsftp"/><title type='text'>Setting Up a secure fast ftp server for linux | VSFTP</title><summary type="text">################################################## setting up a ftp server      ## http://vpslife.blogspot.com/ &amp;amp; http://vpswatch.com/#################################################wget ftp://vsftpd.beasts.org/users/cevans/vsftpd-2.2.0.tar.gztar zxvf vsftpd-2.2.0.tar.gzcd vsftpd-2.2.0makeadduser nobodyadduser: user nobody existsmkdir /var/ftp/useradd -d /var/ftp ftp(the next two are useful </summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/6574631586604293157/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/6574631586604293157' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/6574631586604293157'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/6574631586604293157'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/09/setting-up-secure-fast-ftp-server-for.html' title='Setting Up a secure fast ftp server for linux | VSFTP'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-2282640688611413717</id><published>2009-04-04T14:14:00.000-07:00</published><updated>2009-04-04T14:23:10.146-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Extensions"/><category scheme="http://www.blogger.com/atom/ns#" term="PHP"/><category scheme="http://www.blogger.com/atom/ns#" term="Setup"/><title type='text'>PHP Upload Progress installation-setup</title><summary type="text">This article covers installation of PHP Upload Progress extension.#SETUP guide is done by Mustafa TURAN(http://vpslife.blogspot.com/)##SETUP Software:##--PHP 5.2 or more##--Any OS#Downloadwget http://pecl.php.net/get/uploadprogress-*.tgzUntartar zxvf uploadprogress-*.tgzGo to dircd uploadprogress-*Setupphpize./configuremakemake installLearn php ini pathphp --ini;to ini file add these two lines:[</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/2282640688611413717/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/2282640688611413717' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2282640688611413717'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2282640688611413717'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/04/php-uploadprogress-installion.html' title='PHP Upload Progress installation-setup'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-2228830351038729994</id><published>2009-04-04T14:08:00.000-07:00</published><updated>2009-04-04T14:11:14.189-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Webmin"/><title type='text'>How to uninstall Webmin?</title><summary type="text">Just run the command/etc/webmin/uninstall.shIf you have installed the RPM version of Webmin, you can also use rpm -e webminOr if you have installed the Solaris package you can use pkgrm WSwebminWebmin FAQ: http://www.webmin.com/faq.html</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/2228830351038729994/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/2228830351038729994' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2228830351038729994'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2228830351038729994'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/04/how-to-uninstall-webmin.html' title='How to uninstall Webmin?'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-747342855461343046</id><published>2009-04-04T13:48:00.000-07:00</published><updated>2009-04-04T14:11:42.520-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="LAMP"/><title type='text'>How to uninstall LAMP?</title><summary type="text">Sometimes, we need to uninstall current Apache Mysql PHP collections and re install them. In this article I will show how to remove a LAMP system(for RHEL,Fedora, CENTOS):Check the existence of LAMP system:rpm -qa | grep -i mysqlrpm -qa | grep -i apacherpm -qa | grep -i httpdrpm -qa | grep -i phpIf you get list then remove via rpmrpm -e &quot;file name&quot;or with &quot;yum -y uninstall&quot;yum remove &quot;file name&quot;</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/747342855461343046/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/747342855461343046' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/747342855461343046'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/747342855461343046'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/04/how-to-uninstall-lamp.html' title='How to uninstall LAMP?'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-5537310760115104828</id><published>2009-03-17T17:02:00.000-07:00</published><updated>2009-03-17T17:44:12.195-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Linux Performance"/><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><title type='text'>Mysql Nested Query Tweak</title><summary type="text">Do not use mysql nested queries for performance. Here I will share a little database table and two queries and their response times:#Experiment is done by Mustafa TURAN(http://vpslife.blogspot.com/)##Experiment purpose to see how a nested query affects MYSQL Performance ##Experiment Hardware:##--RAM: 1.5GB##--CPU: AMD Athlon(tm) 64 X2 Dual Core Processor 4000##Experiment Software:##--MYSQL 5(</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/5537310760115104828/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/5537310760115104828' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/5537310760115104828'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/5537310760115104828'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/03/mysql-nested-query-tweak.html' title='Mysql Nested Query Tweak'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-2537902596417873275</id><published>2009-03-16T14:57:00.000-07:00</published><updated>2009-03-16T15:05:47.964-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Hardware"/><category scheme="http://www.blogger.com/atom/ns#" term="System"/><title type='text'>How to learn linux system(hardware) properties?</title><summary type="text">To learn system(hardware,sofware) properties linux has such commands:Operating System Version:uname -rMemory Information:cat /proc/meminfoCPU Information:cat /proc/cpuinfoEasy Way(smart info):uname -rs;less /proc/meminfo grep MemTotal;less /proc/cpuinfo grep&quot;model name&quot;Aktive System Resource Usages:(all users and all activity)top -s(specified user)top -u username</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/2537902596417873275/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/2537902596417873275' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2537902596417873275'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2537902596417873275'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/03/how-to-learn-linux-systemhardware.html' title='How to learn linux system(hardware) properties?'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-9174935178750475960</id><published>2009-03-15T16:42:00.000-07:00</published><updated>2009-03-15T16:50:31.254-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Centos"/><category scheme="http://www.blogger.com/atom/ns#" term="Hostname"/><category scheme="http://www.blogger.com/atom/ns#" term="Network"/><title type='text'>Change Hostname on Centos 5x</title><summary type="text">On terminal screen apply the commands:vi /etc/sysconfig/networkThen change HOSTNAME=xxxx.xxx line to HOSTNAME=your_desired_hostnameYou have to save the data and quit(thats all!):wq!</summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/9174935178750475960/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/9174935178750475960' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/9174935178750475960'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/9174935178750475960'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/03/change-hostname-on-centos-5x.html' title='Change Hostname on Centos 5x'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-4203840330697225472</id><published>2009-03-10T10:02:00.000-07:00</published><updated>2009-03-10T10:11:12.473-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><category scheme="http://www.blogger.com/atom/ns#" term="Network"/><title type='text'>Copy Remote Database to Local Database</title><summary type="text">Remote mysqldumpRun this one line command as a user:mysqldump --opt --compress --user=REMOTE_DB_USERNAME --password=REMOTE_DB_PASS --host=REMOTE_DB_HOSTNAME REMOTE_DB_NAME mysql --user=LOCAL_DB_USERNAME --password=LOCAL_DB_PASSWORD --host=LOCAL_DB_HOSTNAME -D LOCAL_DB_NAME -C LOCAL_DB_NAME Notes: You have to enable remote mysql on remote computer! (To do this you have to add ip address of local </summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/4203840330697225472/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/4203840330697225472' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/4203840330697225472'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/4203840330697225472'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2009/03/copy-remote-database-to-local-database.html' title='Copy Remote Database to Local Database'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-408889192246367653</id><published>2008-10-07T07:18:00.000-07:00</published><updated>2008-10-07T07:27:10.025-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><title type='text'>How to reset root password on MySql?</title><summary type="text">Pass the root mode on terminal.To stop mysql:# /etc/init.d/mysql stopAccess without privalages to mysql# mysqld_safe --skip-grant-tables &amp;amp;Pass to the mysql# mysql -u root# use mysql;# mysql -u root# mysql&gt;INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, </summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/408889192246367653/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/408889192246367653' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/408889192246367653'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/408889192246367653'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2008/10/how-to-reset-root-password-on-mysql.html' title='How to reset root password on MySql?'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-2905360310014299827</id><published>2008-10-06T09:10:00.000-07:00</published><updated>2008-10-06T09:18:56.268-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Linux Performance"/><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><title type='text'>How to fix mysql thread_stack overrun?</title><summary type="text">Today I faced a problem about running my stored procedure code and I got the error message :#1436: Thread stack overrun: 4136 bytes used of a 131072 byte stack, and 131072 bytes needed. Use &#39;mysqld -O thread_stack=#&#39; to specify a bigger stack.I tried the command mysqld -O thread_stack=# but it did not worked. Then I entered my.cnf file which is at /etc/my.cnf I found the value of thread_stack </summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/2905360310014299827/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/2905360310014299827' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2905360310014299827'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/2905360310014299827'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2008/10/how-to-fix-mysql-threadstack-overrun.html' title='How to fix mysql thread_stack overrun?'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8660262373296199534.post-5133779096605249891</id><published>2008-10-04T05:51:00.000-07:00</published><updated>2008-10-04T06:00:42.227-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Apache"/><category scheme="http://www.blogger.com/atom/ns#" term="Linux Performance"/><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><title type='text'>Low Memory Mysql / Apache configurations</title><summary type="text">Configurations will be good for 64Mb - 256Mb RAM If you would like to convert your InnoDB tables to MyISAM, you can use the shell script to automatically convert InnoDB tables to MyISAM.  #!/bin/bashMYSQLCMD=mysqlfor db in `echo show databases | $MYSQLCMD | grep -v Database`; do     for table in `echo show tables | $MYSQLCMD $db | grep -v Tables_in_`; do             TABLE_TYPE=`echo show create </summary><link rel='replies' type='application/atom+xml' href='http://vpslife.blogspot.com/feeds/5133779096605249891/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8660262373296199534/5133779096605249891' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/5133779096605249891'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8660262373296199534/posts/default/5133779096605249891'/><link rel='alternate' type='text/html' href='http://vpslife.blogspot.com/2008/10/low-memory-mysql-apache-configurations.html' title='Low Memory Mysql / Apache configurations'/><author><name>Mustafa Turan</name><uri>http://www.blogger.com/profile/05943511792734083068</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkPQiUKlCCnvgl0YLMT66BZujjVsrGHK2vtXpdCNvLHUDPBnv-y-2dZ9t0ufygiOEJYSQeJdi-oH4ppGLjUgy8Woj5vre4ys9PkajpD2Tq44Nwd9TuFIzXP6cELsYTJsI/s1600/0100a9e749c87840e52a6096c09380104c1c-pp70_bigger.jpg'/></author><thr:total>0</thr:total></entry></feed>