![]() Furthermore, logical backups can copy portions of the database, giving you more flexibility and a quicker resolution when you’re dealing with data corruption problems in specific parts of the database. Logical backups tend to be more common because, as we’ll find out in a minute, tools that can create them are usually readily available. Your backup strategy should be determined by a number of different factors including the hosting setup, the size of the database, and your needs. Hence, they aren’t always suitable for moving a database from one environment to another. Physical backups are quicker but can only work if they are restored from the same database engine on the same MySQL version. All the tables and the data inside them are copied in their original file formats and can be restored in a fully functioning database as long as the structure is maintained. Physical backupsĪ physical backup is a copy of the database’s datadir directory. Because SQL statements tend to be universal, logical backups are often used to move databases from one host to another. The SQL file itself contains the SQL statements (e.g., CREATE DATABASE, CREATE TABLE, etc.) required to rebuild the database. ![]() There are two main types of database backups in MySQL: Logical backupsĪ logical backup exports (or dumps) the data and the data structure to an SQL file. In effect, these relations build the structure of the database.Ī working backup of a database must be able to recreate the tables and the relations between them in the way they are originally organized. The information is stored in tables, with relations between the different datasets. ![]() MySQL is a relational database management system. Today, we’ll look into the different types of database backups, and we’ll see some of the most popular techniques for creating and restoring a safe copy of your website’s data. When it comes to generating a backups of your MySQL databases, however, things are a bit more complicated. In essence, you put them all in an archive, which you can later extract and restore everything. Backing up your site’s files is relatively straightforward.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |