O'Reilly logo

MariaDB Crash Course by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

29. Database Maintenance

In this chapter, you learn how to perform common database maintenance tasks.

Backing Up Data

Like all data, MariaDB data must be backed up regularly. As MariaDB databases are disk-based files, normal backup systems and routines can back up MariaDB data. However, as those files are always open and in use, normal file copy backup may not always work as is not recommended.

Here are possible solutions to this problem:

• Use the command line mysqldump utility to dump all database contents to an external file. This utility should ideally be run before regular backups occur so the dumped file will be backed up properly.

• The command line mysqlhotcopy utility can be used to copy all data from a database (this one is not supported ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required