Tuesday, November 20, 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

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

mysql -uroot -pmypasswd < /opt/alldatabases.sql

Vishal Vyas

Wednesday, November 7, 2012

Ultimate Windows Genuine Advantage (WGA) Remover

Here is the ultimate Windows Genuine Advantage (WGA) remover for those who are getting annoyed by the Windows Genuine Advantage popping up every few second.

You did install the latest updates recommended by Windows, now you get a message saying: this copy of Windows is not genuine, you may be victim of software counterfeiting.
To disable Ultimate Windows Genuine Advantage (WGA) once for all, simply download and install WGA remover.

WGA Remover (1,0 MiB)
Windows XP WGA remover additional setup information are inserted into the packet!

 Windows 7 2011 WGA Remover and is, recommended for Windows 7!

Windows 7 WGA Service Pack 1 (SP1) pro remover 2011!

registry cleaner to fix and speed your PC!
downloadRegistry Easy

Or ..... Try This Best .....

Vishal Vyas

Friday, November 2, 2012

Redmine on centos6

How To Install Redmine On CentOs 6 
Install Packages :-  
yum -y install zlib-devel curl-devel openssl-devel httpd-devel apr-devel apr-util-devel mysql-devel 
Download and Install Ruby :- 
 # FTP to where you will download ruby from.
# When asked to login use user/password of anonymous/anonymous
ftp ftp.ruby-lang.org 
Name (ftp.ruby-lang.org:root): 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
make install

# Verify ruby installation
ruby -v
which ruby

# Change back into your downloads directory
cd ..

  Download and Install Gems 1.4.2

wget http://production.cf.rubygems.org/rubygems/rubygems-1.4.2.tgz
tar zxvf rubygems-1.4.2.tgz
cd rubygems-1.4.2
ruby setup.rb
gem -v
which gem
cd ..

Passenger Install :- 

gem install passenger
You can install rpm here :-

rpm -Uvh http://passenger.stealthymonkeys.com/rhel/5/passenger-release.noarch.rpm
yum install mod_passenger
rpm --import http://passenger.stealthymonkeys.com/RPM-GPG-KEY-stealthymonkeys.asc
yum install http://passenger.stealthymonkeys.com/rhel/6/passenger-release.noarch.rpm
yum install mod_passenger

Restart Apache Service :-

service httpd restart

Download Redmine

Download page: http://rubyforge.org/frs/?group_id=1850
wget http://rubyforge.org/frs/download.php/75597/redmine-1.3.0.tar.gz 
tar zxvf redmine-1.3.0.tar.gz 

cp -av redmine-1.3.0/* /var/www/redmine

Install Bundler :-

gem install bundler

Add the Bundler Boot and preinitializer code

Create New Gemfile and register these gems

vi /var/www/redmine/Gemfile
# file: /var/www/redmine/Gemfile
source "http://rubygems.org" 
gem "rake", "0.8.3" 
gem "rack", "1.1.0" 
gem "i18n", "0.4.2" 
gem "rubytree", "0.5.2", :require => "tree" 
gem "RedCloth", "~>4.2.3", :require => "redcloth" # for CodeRay
gem "mysql" 
gem "coderay", "~>0.9.7" 
bundle install

Create the Redmine MySQL database

yum install mysql-server
chkconfig mysqld on
service mysqld start

start the mysql client (mysql -u root -p) and enter the following commands
create database redmine character set utf8;
create user 'redmine'@'localhost' identified by 'my_password';
grant all privileges on redmine.* to 'redmine'@'localhost'; 

Configure /var/www/redmine/config/database.yml (rename database.yml.example)

Set the production environment (optional)

Uncomment the following line in file redmine/config/environment.rb:
ENV['RAILS_ENV'] ||= 'production'

Generate the session store

RAILS_ENV=production bundle exec rake generate_session_store

Migrate the database models

RAILS_ENV=production bundle exec rake db:migrate

Load default data (optional)

RAILS_ENV=production bundle exec rake redmine:load_default_data
Follow instructions.

Rename  files in /var/www/redmine/public/

mv dispatch.cgi.example dispatch.cgi
mv dispatch.fcgi.example dispatch.fcgi
mv dispatch.rb.example dispatch.rb

Edit .htaccess file for CGI dispatch configuration

mv htaccess.fcgi.example .htaccess
Edit httpd.conf
# vim /etc/httpd/httpd.cong and add this :- 
LoadModule passenger_module /usr/local/lib/ruby/gems/1.8/gems/passenger-3.0.17/ext/apache2/mod_passenger.so
   PassengerRoot /usr/local/lib/ruby/gems/1.8/gems/passenger-3.0.17
   PassengerRuby /usr/local/bin/ruby
   PassengerTempDir /tmp/passenger
<VirtualHost *:80>
      ServerName vishalvyas.com
      # !!! Be sure to point DocumentRoot to 'public'!
      DocumentRoot /home/redmine/redmine/public
      <Directory /home/redmine/redmine/public>
         # This relaxes Apache security settings.
         AllowOverride all
         # MultiViews must be turned off.
         Options -MultiViews


Chown and Chmod files for read/write access for the Apache user

cd ..
chown -R apache:apache redmine-1.x
chmod -R 755 redmine-1.x 
Now you can use redmine . 
Vishal Vyas   

How to Install docker-compose CentOS7

 Install Docker-compose on CentOs7 Linux. yum install -y epel-release yum install -y python-pip pip install --upgrade pip pip install ...