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...