InnoDB Website

Downloading InnoDB

Starting with version 3.23 (first released in May 12, 2001), binary and source downloads of MySQL contain InnoDB. Select an appropriate version of MySQL from the MySQL download page.

Plugin

Downloading InnoDB Plugin for MySQL

Source and binary downloads for the Early Adopter release of the InnoDB Plugin are available for a variety of platforms here.

Hot Backup

Instructions for ordering an evaluation copy of InnoDB Hot Backup can be found here.

Innobackup script

The wrapper script innobackup for InnoDB Hot Backup automates the backup of both MyISAM and InnoDB tables. You can download the “innobackup” Perl script. Also, see section 5 of the documentation for InnoDB Hot Backup.

NOTE: innobackup is a Perl script used in conjunction with InnoDB Hot Backup to automate the procedure of backing up both MyISAM and InnoDB tables. This script is not available on Windows. However, the procedure can be performed using manual (or scripted) steps in combination with the ibbackup utility. See sections 2.3 and 5.0 of the InnoDB Hot Backup manual.

The innobackup Perl script is licensed under the GPL, and may be freely modified and redistributed. Please contact us if you make revisions, including porting this script to Windows (or translate it to other languages).

Hot Backup workaround for corrupted InnoDB data file pages

Sometimes the operating system or the hardware can corrupt a data file page. If the page is not used in InnoDB tables, then mysqld may run ok. But when you try to back up the tablespace with ibbackup, you get errors like below and ibbackup refuses to make the backup.

The little C program, innodb_page_checksum_reset.c, available here, allows you to reset the LSN and the checksum fields in one page, so that ibbackup will no longer complain about the corruption. Of course, your main task is to find out what is wrong with the OS or the hardware that causes corrupt pages to appear. This C program will not fix the corruption!