Creating and importing a dump file
A dump file, or simply a dump, is a text file containing the SQL queries that are necessary to recreate a database or all the databases in a MariaDB instance.
Dump files can be created with a tool called mysqldump, a tool distributed along with MariaDB. This program will be discussed in the next subsection. A dump can later be imported into MariaDB by passing it to the mysql command-line client. We have already discussed this technique in Chapter 1, Installing MariaDB, and we will not repeat it here. However, the restoring of dump files is covered in the final examples.
Dumps generated with mysqldump make use of executable comments for any MariaDB or MySQL-specific features. These executable comments include the ...
Get MariaDB Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
