My SQL command to create SQL Dump

mysqldump command is used to create a text version of the database. This creates a SQL file that contains all SQL statements  which we can use to restore/recreate the original database.

Below is the command:

$ mysqldump -u [uname] -p[pass] [dbname] > [backupfile.sql]