Execute a command similar to the following to create a database dump:

mysqldump -u root -p -e --default-character-set=utf8 --add-drop-table cascade > cascade_backup.sql

Note: the example above assumes that the database name is cascade.

Did this answer your question?