Showing posts from November, 2012

How to Backup a MySQL Database

Backup a Single and All the MysQl Databases. Single database: mysqldump -u root -pmypasswd vishalvyas > /opt/vishalvyas.sql Restore: mysql -uroot -pmypasswd vishalvyas < /opt/vishalvyas.sql To back up all databases on a particular server, use the mysqldump command:   Backup all the databases: mysqldump -u root -pmypasswd --all-databases > /opt/alldatabase.sql Restore: mysql -uroot -pmypasswd < /opt/alldatabases.sql Thanks, Vishal Vyas

Redmine on centos6

How To Install Redmine On CentOs 6            Redmine is a free and open source, web-based project management and issue tracking tool. It allows users to manage multiple projects and associated subprojects Install Pack ages :- yum -y install zlib-devel curl-devel openssl-devel httpd-devel apr-devel apr-util-devel mysql-devel    Download and Install Rub y :-    # FTP to where you will download ruby from. # When asked to login use user/password of anonymous/anonymous ftp Name ( anonymous Password: anonymous    ftp> cd /pub/ruby ftp> get ruby-1.8.7-pXXX.tar.gz ftp> quit # You have now downloaded ruby and need to untar it tar zxvf ruby-1.8.7-pXXX.tar.gz # Compile ruby cd ruby-1.8.7-pXXX ./configure make make install # Verify ruby installation ruby -v which ruby # Change back into your downloads directory cd ..   Down load and Install Gems 1.4.2 wget t