The Client Server Approach for MySql Database Backup

Client Server Approach for MySql Database Backup

Installing MySQL 5 Server on Ubuntu is a quick and easy process. Open a terminal window, and use the following command which can Install the Mysql Client

$ sudo apt-get install mysql-client

To Setup Mysql Database Backup on Ubuntu, Open a terminal window, and use the following command which will create the database backup dump file for restoration

$ mysql -h IPorNameOfMySQLServer -u YourUserName -p
mysql> show databases;
mysql> use NameOfDatabase;
mysql> show tables;
mysql> quit
$ mysqldump -h IPorNameOfMySQLServer -u YourUserName -p –all-databases > mysql.backup