A database dump (also: SQL dump) contains a record of the table structure and/or the data from a database and is usually in the form of a list of SQL statements. A database dump is most often used for backing up a database so that its contents can be restored in the event of data loss.

What is data dump method?

If your database is large or takes too long to pack, dumping a database is the preferred backup method. This method creates a dump ( . dmp ) file containing only the database metadata, instead of producing a pack file that contains the file system data as well as the metadata.

What is binary backup?

Binary backup produces a copy of the database files, and is performed at the filesystem level. The output of a binary backup is a set of binary files containing all entries, indexes, the change log, and the transaction log. A binary backup does not contain configuration data.