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

Setup DHCP Server on Linux

Image
How to configure dhcp server in Linux DHCP, or  Dynamic Host Configuration Protocol,  allows an administrator to configure network settings for all clients on a central server. The DHCP clients request an IP address and other network settings from the  DHCP server  on the network. The  DHCP server  in turn leases the client an IP address within a given range or leases the client an IP address based on the MAC address of the client's network interface card (NIC). The information includes its IP address, along with the network's name server, gateway, and proxy addresses,including the netmask. Nothing has to be configured manually on the local system, except to specify the  DHCP server  it should get its network configuration from. If an IP address is assigned according to the MAC address of the client's NIC, the same IP address can be leased to the client every time the client requests one. DHCP makes network administration easier an...
Read more

Set Manually IP Address (Ubuntu 14.04) Desktop env.

#sudo nano /etc/NetworkManager/system-connections/Wired\ connection\ 1 [802-3-ethernet] duplex=full mac-address=00:19:D1:AB:10:FA [connection] id=Wired connection 1 uuid=896c15c0-4542-4443-8153-72d1c1211849 type=802-3-ethernet timestamp=1484646948 [ipv6] method=auto [ipv4] method=manual dns=192.168.5.251;192.168.5.234; address1=192.168.5.78/24,192.168.5.1 #address2=192.168.6.78/24,0.0.0.0 #address3=192.168.7.78/24,0.0.0.0 #end Example dns=192.168.5.251;192.168.5.234;     (Primary_DNS;Secondary_DNS) address1=192.168.5.78/24,192.168.5.1 (IP/Netmask,Gateway) address2=192.168.6.78/24,0.0.0.0    (IP/Netmask,Gateway) address3=192.168.7.78/24,0.0.0.0    (IP/Netmask,Gateway)
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