How to Save Your Data If Someone Deletes or Compresses Your InnoDB ibdata or *.ibd Files on Linux-like systems, MySQL Server

(Doc ID 1434414.1)

Last updated on MARCH 12, 2012

Applies to:

MySQL Server - Version: 4.0 and later   [Release: 4.0 and later ]
Information in this document applies to any platform.

Goal

Sometimes people not familiar with InnoDB will delete or compress its data files because they are big, to save space or for other reasons. This document explains what you must do to save your data if this happens.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms