Syntax:

Example:

This will give you a text file containing all the commands required to recreate the database.

RELATED: How to Export a CSV file from MySQL Command Line