How to Create Simple Mysql Database Dump Backup on Ubuntu

Simple Mysql Database Dump Backup File on Ubuntu

Just log into your terminal and type the below command
$ cd ~
$ mysqldump -u yourusername -p –all-databases > mysql.backup

cd ~ simply changes directory to your home directory, where user can have all the necessary permissions to create a file mysql.backup

Replace the yourusername with the Mysql database username

The –all-databases flag will dump all the databases in MySQL to the file mysql.backup

To make a targeted database backup Dump file is

$ cd ~
$ mysqldump -u yourusername -p NameOfDatabase > mysql.backup

Replace NameOfDatabase by the Specific database name
This command will then dump all the contents, including the structure of the database into mysql.backup


Related Topic How to Restore Dumped Mysql Database Backup on Ubuntu
The Client Server Approach for MySql Database Backup
List of Mysql Error Code and Description
Mysql Import Dump file in Command line
How to Create registered User Login for Website in PHP & MySQL
SQL  ubuntu  mysql  database  

nScraps.com © 2011   Privacy Policy  Terms of Service  Feedback