Package: Filesystem corruption? Deleted rows? Deleted files? Dropped tables? We can help. We can recover data for MyISAM and InnoDB, and we can also recover from corrupted binary logs or general query logs if available.

We can typically recover lost InnoDB data very well (because of InnoDB's page layout), though recovery for MyISAM tables is also possible. We have recovery procedures for InnoDB in REDUNDANT format (MySQL 4.1 and below) as well as the new COMPACT format, which is used in MySQL 5.0 both in single-tablespace and file-per-table modes.

Our service is secure: we always encrypt your sensitive data, and we destroy our copy of it after we're done.

We may be able to help you to recover data under the following circumstances:

• You have accidentally deleted data from your InnoDB or MyISAM tables.
• You have dropped your tables.
• You have truncated or recreated your tables.
• You have InnoDB tablespace corruption that you can't repair with the innodb_force_recovery option.
• You have filesystem corruption.

What should you do if you need MySQL data recovery?

• Stop the MySQL Server immediately. Consider killing it with kill -9 to minimize any modifications made to the database. The goal is to prevent the disk from being written to anymore.
• If you have filesystem corruption, or you have dropped tables in innodb_file_per_table format, unmount the filesystem or make it read only.
• Make sure to make a copy of the original data (all MySQL data, including tablespaces and logs, or a full partition copy) before you perform any attempts manually.
• Note the MySQL server version and the circumstances that led to the data loss.

What data will we need to help you with MySQL data recovery?

• We will need access to the data that needs to be recovered, either on your server or ours.
• Make sure you specify exactly which data you need to be recovered, or tell us what's highest priority. We typically need to recover your data one table at a time.
• If the table was dropped, we typically need information about the table structure. We can work from a backup of the table, SHOW CREATE TABLE or .frm file.
• If you have an old backup for the data to be recovered, that helps a lot.
• If you have data samples for the data that needs to be recovered, please provide them as well.

The Process: We will perform data recovery in two stages. First we analyze your data to see if it can be recovered, and to estimate how much of the data we can recover. Sometimes full recovery is impossible, because your data was already overwritten by MySQL or the operating system. We will also estimate how long recovery will take, based on the data you provided. If everything is acceptable to you, we go ahead with the recovery.

Cost: At least $400/hour, varies with the job and your required schedule. More for urgent cases.

Availability: Data recovery services are usually treated as urgent, so we can start immediately. Please call us to get the best response time. We don't monitor email 24/7, but your phone call will reach us right away.