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


Related Topic List of Mysql Error Code and Description
PHP Functions for MySQL
Basic Dynamic Web Client Server Request and Response Sequence
Remote Mysql Server SSH Login
Struts FAQs
SQL  SEO  ubuntu  mysql  database  

nScraps.com © 2011   Privacy Policy  Terms of Service  Feedback