If you've got a website with a database or a custom database running for your applications, it is imperative that you make regular backups of the database...

Following examples are using mysqldump

1. You can use mysqldump to create a simple backup of your database. Here is an example..mysqldump -u username --password=password databasename > backup.sql
   
   • username - this is your database username
   • password - this is the password for your database
   • databasename - the name of your database
   • backupfile.sql - the file to which the backup should be written.


2. To backup multiple databases, you will have to do the following example.
   
   • mysqldump -u test1 --password=pass1 --databases world universe >world_and_universe.sql


3. Now what if we want to back up all of our databases. To do that follow the next example.
   • mysqldump -u test1 --password=pass1 --all-databases >alldb.sql


4. Here we are going to show you another way of backing up a databases and certain tables using the --add-drop-table. This essentially adds a drop table statement before every create statement. The purpose of this is so that it will remove any previous copies of the table before recreating it.
   
   • This example will add a drop statement before every create statement.
     mysqldump --add-drop-table -u test1 --password=pass1 world > world.sql
   • This statement will add a drop statement before the following tables only.
     mysqldump --add-drop-table -u test1 --password=pass1 Customers world_users world_passwd> world.sql

---

Add this page to your favorite Social Bookmarking websites