Summary
In this chapter, we discussed two techniques to take database backups and restore them.
First we discussed how to generate a CSV file using SELECT ... INTO OUTFILE, and restore it with LOAD DATA INFILE. The flexibility provided by the SELECT statement can be a great advantage.
We also discussed the mysqldump tool that can be used to take a dump of our database. Then, we can run these files like any other file containing SQL statements.
In the final part, we learned some small tricks that can be used to speed up the loading of a backup.
In the next chapter, we will learn how to use views and virtual columns to have some data logic in your database instead of your application.
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.
