Sunday

How to back up MySQL database

     MySQL is  an efficient backend software and it is also an open source .
Usually there are two ways to backup a database or the tables in database
 1.  Using commands
 2.  Using Phpmyadmin
Using phpmyadmin will be easier and better method .

   Phpmyadmin make you to create,update,delete,backup database with easy clicks ...

1.) Install phpmyadmin in your system
                -For Linux system
                        sudo apt-get install phpmyadmin
2.) Open the installed phpmyadmin software in your browser
                               http://localhost/phpmyadmin

 3.)  Login us  a root , give the password that you have set during installation

       
         Now you have various options like creating database and tables , import and export database .

0 comments:

Post a Comment