
98 vFoglight
Administration and Configuration Guide
ibbackup: Compressed 210 MB of data files to 36 MB
(compression 82%).
080922 15:29:54 ibbackup: Full backup completed!
5
View the contents of the backup directory by issuing the following command:
C:\Vizioncore\vFoglight\mysql\bin>dir
C:\Vizioncore\vFoglight\backup\data
Volume in drive C is System
Volume Serial Number is BCD1-A216
Directory of C:\Vizioncore\vFoglight\backup\data
10/24/2008 10:55 AM <DIR> .
10/24/2008 10:55 AM <DIR> ..
10/24/2008 10:55 AM 5,632 ibbackup_logfile
10/24/2008 10:55 AM 02:16 PM 77,594,624 ibdata1
2 File(s) 77,600,256 bytes
2 Dir(s) 49,386,782,720 bytes free
Note The above example illustrates the process of backing up a MySQL database on
Windows, which uses the back slash character as a directory separator and the
dir command to list files.
The backup directory contains one data file, ibdata1, and a log file,
ibbackup_logfile. The backup process copies different database pages at different
times. The log file, ibbackup_logfile, specifies the order in which the pages are
backed up. Applying the log file to the backup data associates each database page
with a sequence in the log file, and creates one or more log files for each data file,
allowing you to successfully restore the database from the backup data when
required.
6
Apply the log file to the backup data by issuing the following command:
Note The example below illustrates the process of backing up a MySQL database on
Windows, which uses the back slash character as a directory separator.
C:\Vizioncore\vFoglight\mysql\bin>ibbackup --apply-log
C:\Vizioncore\vFoglight\backup\config\backup.cnf.txt
Comentarios a estos manuales