Linux Server and Workstation Configuration How To

To export a MySQL database into a dump file, simply type the following command syntax in the shell.

Replace username, password, database_name and dump.sql as your needs. All data, tables, structures and database of database_name will be backed up into a mentioned file dump.sql.
IMPORTANT: Don't put space after -p and the password