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 MySQL on Ubuntu Droplet getting error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

sudo /etc/init.d/mysql stop Now start up MySQL in safe mode, so you'll skip the privileges table: sudo mysqld_safe --skip-grant-tables & Login with root: mysql -uroot And assign the DB that needs to be used: use mysql; Now all you have to do is reset your root password of the MySQL user and restart the MySQL service: update user set password=PASSWORD("YOURPASSWORDHERE") where User='root'; flush privileges; quit and restart MySQL: quit sudo /etc/init.d/mysql stop sudo /etc/init.d/mysql start Now your root password should be working with the one you just set, check it with: mysql -u root -p
Read more

Remote Desktop Sharing Dconf Tool in Linux (Ubuntu 14.04)

To install software that allow to remote access your computer desktop of ubuntu 14.04 !!dconf-tools!! Step 1 Install #sudo apt-get install dconf-tools Step 2 Configure Search dconf and in deconf box popup Chose below steps !! org    gnome         desktop                remote-access uncheck all and again check on enable and close.. Step 3 goto terminal and type below command #sudo vino-pereference and set you allow sharing and your security.. To remove the dconf-tools following command is used: #sudo apt-get remove  dconf-tools Following command is used to remove the dconf-tools package along with its dependencies: #sudo apt-get remove --auto-remove dconf-tools #sudo apt-get purge dconf-tools #sudo apt-get purge --auto-remove dconf-tools
Read more

Configure Telnet & SSH on Router for Remote access.

To configure Telnet we have to do some steps... Step1- #line vty 0 4 Step2- #password mypassword Step3- #login local To configure SSH on Router we have to do some extra task.. Step1- # ip domain-name <mydomainname> Step2-# crypto key generate rsa Step3-# ip ssh version 2       ------------------------------------------- (No required) Step4# username <myusername> secret <mypassword> Step5-# line vty 0 15 Step6-# transport input ssh Step7-#login local
Read more