Creat Backup of MYSQL (Ubuntu 14.04)


                ----------------------------------------------------------------------------
                Bakup/Main server 192.168.5.227        |        restore server 13.71.117.185
                ----------------------------------------------------------------------------

(192.168.5.227)                                                              
----------------------------------------------------------------------------          
Create Backups of an Entire DBMS Using Copies of the MySQL Data Directory
----------------------------------------------------------------------------          
                                              
STEP 1                                                  
----------------------------------------------------------------------------                  
Stop you mysql by below given commands                               
----------------------------------------------------------------------------          
#/etc/init.d/mysql stop                                      
Step 2                                              
----------------------------------------------------------------------------      
Use below commands to find out where is your mysql main directory like mine          
is here /var/lib/mysql                                      
----------------------------------------------------------------------------          
#find / -name mysql                                          
                                                  
                                              
STEP 3                                                          
-----------------------------------------------------------------------------                              
Create Directory where you want to keep backup file.. like mine /opt/backup
-----------------------------------------------------------------------------
#mkdir /opt/backup

STEP 4
-----------------------------------------------------------------------------
Use below command to copy your mysql fies..
-----------------------------------------------------------------------------
#cp -R /var/lib/mysql/* /opt/backup

STEP 5
-----------------------------------------------------------------------------
Make tar/zip of your backup files
-----------------------------------------------------------------------------
#tar -zcvf backup.tar /opt/backup

STEP 6
-----------------------------------------------------------------------------
Copy your tar file on (192.168.5.228) In /opt directory
-----------------------------------------------------------------------------


(192.168.5.228)
STEP 1
-----------------------------------------------------------------------------
First change (mysql to mysqlold )your primary /var/lib/mysql
-----------------------------------------------------------------------------
#mv /var/lib/mysq /var/lib/mysqlold

STEP 2
-----------------------------------------------------------------------------
Creat new directory in /var/lib/mysql
-----------------------------------------------------------------------------
#mkdir /var/lib/mysql

STEP 3
-----------------------------------------------------------------------------
Give permission on your direcroty /var/lib/mysql
-----------------------------------------------------------------------------
#chown -R mysql:mysql /var/lib/mysql

STEP 4
-----------------------------------------------------------------------------
Past your backuped file here /var/libe/mysql after extract your tar file
-----------------------------------------------------------------------------
#mv /opt/backup/* /var/libe/mysql

here we done just start your mysql
#/etc/init.d/mysql start

#Arvind

Popular posts from this blog

Install Node,Angular2 and Sublime 3

Help https://www.npmjs.com/package/angular-cli#installation Install Node and Angular-cli and @Angular/cli Globally- npm install -g @angular/cli Locally -npm install -save --dev @angular/cli or Globally -npm install -g angular-cli  Locally- npm install -save --dev angular-cli Requirement Node https://nodejs.org/dist/v8.4.0/node-v8.4.0-x64.msi https://nodejs.org/dist/v6.11.2/node-v6.11.2-x64.msi https://nodejs.org/dist/v8.4.0/node-v8.4.0-x86.msi Install  angular-cli  globally:  npm install -g angular-cli Install  angular-cli  in your project:  npm install --save-dev  angular-cli Upgrade to the latest CLI globally: npm uninstall -g angular-cli npm uninstall -g @angular/cli npm cache clean  npm install -g angular-cli@latest This should get a working version. If you tried this and it does not work, please submit your package.json as that will probably contain something that gets in the way from this working correct...
Read more

To change the owenership of any folder for domain user !!

To change the owenership of any folder for domain user !! here i'm changing owenership of my "lampp" folder... the new owener is google\\user43 #sudo chown -R Google\\user43:root /opt/lampp/ Expl... sudo chown -R google\\user43:root /opt/lampp/ Give full permission of any folder for all #sudo chmod 777 /your folder location/ -R Expl.. sudo chmod 777 /opt/lampp/ -R
Read more

How to set Java Path if you want to put your java any directory in linux Computer

NOte !!!  Thursday 12 January 2017 03:36:52 PM IST You have to change you username !!! here above is user6 !!! You have to change your extrated folder location of JAVA !!! here above is /home/user6/software/jdk1.8.0_111 !!! Matarial Need.. Tar/zip file of Java and extract it on below location /home/user6/software/jdk1.8.0_111 Step 1 edite profile #sudo gedit /etc/profile type past bleow lines JAVA_HOME=/home/user6/software/jdk1.8.0_111 JRE_HOME=/home/user6/software/jdk1.8.0_111/jre PATH=$PATH:$JRE_HOME/bin:$JAVA_HOME/bin export JAVA_HOME export JRE_HOME export PATH Step 2 run below command after extrat your java /home/user12/software/ Note = Your java extrated location /home/user64/software/jdk1.8.0_111 Run blow command in sudo mode for say ubuntu where is your java installed/extrated file sudo update-alternatives --install "/usr/bin/java" "java" "/home/user6/software/jdk1.8.0_111/bin/java" 1 sudo update-alternatives --install...
Read more