Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been running mysqldump on my set of MySQL databases (MyISAM and INNDOB). Recently I wanted to restore the databases to another server, and so I created the databases and imported the dump file. It was then that I rezlied that the IBD files were not created.

I was under the impressions that what I was doing was a backup, but in the case of INNODB it seems I have to do a backup of /var/lib/mysql//.ibd as well -- right?

If that's the case, then what is the point of a dumpfile if I have to take a backup of IBD files as well?

I am sure I am missing the obvious...

share|improve this question
up vote 2 down vote accepted

I might be wrong, but I think the usage of .IBD files depend on InnoDB settings&version. They are needed in newer InnoDB innstallations in addition of ibdata file.

If you have dumps you do not need either.

share|improve this answer
The .ibd files are not needed in any version of mysql/innodb i know of. It's a matter of configuration if innodb stores data per table in .idb-files (which doesn't mean the 'global' ibdata isn't used / is obsolete) or not. – Jan 22 '11 at 15:18 thanks, +1 – anttiR Jan 22 '11 at 17:44

The .ibd files your a talking about are only used/generated for all tables you generate after setting innodb_file_per_table = 1 in your mysqld's configuration. Otherwise all InnoDB table's stuff will be stored in the global ibdata* file.

So i guess, the server you did your restore on, was not using innodb_file_per_table, which per se is no problem ...

share|improve this answer

mysqldump is sufficient. there are other tools like innodb hot copy or xtrabackup that can make backup based on ibd files... but they are alternative solution to regular mysql dump.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.