MySQL Enterprise Backup User's Guide (Version 3.11.1)
Before backing up a particular database server for the first time, gather some information and decide on some directory names, as outlined in the following table.
Table 3.1 Information Needed to Back Up a Database
Information to Gather | Where to Find It | How Used |
---|---|---|
Path to MySQL configuration file |
Default system locations, hardcoded application
default locations, or from
|
This is the preferred way to convey database
configuration information to the
mysqlbackup command, using the
|
MySQL port | MySQL configuration file or mysqld startup script. |
Used to connect to the database instance during backup
operations. Specified via the |
Path to MySQL data directory | MySQL configuration file or mysqld startup script. | Used to retrieve files from the database instance during backup operations, and to copy files back to the database instance during restore operations. Automatically retrieved from database connection for hot and warm backups. Taken from MySQL configuration file for cold backups. |
ID and password of privileged MySQL user | You record this during installation of your own databases, or get it from the DBA when backing up databases you do not own. Not needed when doing an offline (cold) backup, which works directly on the files using OS-level file permissions. For cold backups, you log in as an administrative user. |
Specified via the |
Path under which to store backup data | You choose this. See Section 3.1.3, “Designate a Location for Backup Data” for details. |
By default, this directory must be empty for
mysqlbackup to write data into it,
to avoid overwriting old backups or mixing up data
from different backups. Use the
|
Owner and permission information for backed-up files (for Linux, Unix, and OS X systems) | In the MySQL data directory. |
If you do the backup using a different OS user ID or a
different |
Size of InnoDB redo log files |
Calculated from the values of the
|
Only needed if you perform incremental backups using
the
|
Rate at which redo data is generated |
Calculated from the values of the InnoDB
logical sequence
number at different points in time. Use the
technique explained for the
|
Only needed if you perform incremental backups using
the
|