How to backup mysql database.
If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss
You can take backup
Through command line.
Back up From the Command Line (using mysqldump)
If you have shell or telnet access to your web server, you can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file.
the syntax is
$ mysqldump –opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
For example, to backup a database named ‘Tutorials’ with the username ‘root’ and with no password to a file tut_backup.sql, you should accomplish this command:
With mysqldump command you can specify certain tables of your database you want to backup. For example, to back up only php_tutorials and asp_tutorials tables from the ‘Tutorials’ database accomplish the command below. Each table name has to be separated by space.
If you want to back up all the databases in the server at one time you should use the –all-databases option. It tells MySQL to dump all the databases it has in storage.
