The 'mysqldump' command is used to Dump databases managed by MySQL. Let's consider three the most useful cases of MySQL database dumping.

1. The simplest case is the whole database dumping:

   1	mysqldump -u username -ppassword database_name > the_whole_database_dump.sql

   Related Articles

   Step-by-Step Guide on How to Apply fo…
   Yoast SEO Configuration in WordPress
   Governo Provincial proíbe estacionam…
   Indian Man Leaves Tech Job to Become …
   How To Make Homemade Peeps
   

2. Sometimes, there's a need to dump a single table from your database. You can do it in the next way:

   1	mysqldump -u username -ppassword database_name table_name > single_table_dump.sql

   You can also specify several tables separated by whitespace to dump these tables only.

3. If you want to dump only rows that meet a specific criteria, you can add 'where' option to your mysqldump command. For example, dump only rows where date_created is today:

   1	mysqldump -u username -ppassword database_name table_name --where="date_created='2013-06-25'" > few_rows_dump.sql