Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject.
I also wish to note performance issues with the two suggested solutions, and offer improvements.
Problem relevance
While the problem is interesting, I just want to note that it [...]
When working with InnoDB, you have two ways for managing the tablespace storage:
Throw everything in one big file (optionally split).
Have one file per table.
I will discuss the advantages and disadvantages of the two options, and will strive to convince that innodb_file_per_table is preferable.
A single tablespace
Having everything in one big file means all tables and indexes, [...]
mysqldump is commonly used for making a MySQL database backup or for setting up a replication.
As in all mysql binaries, there are quite a few parameters to mysqldump. Some are just niceties but some flags are a must. Of course, choosing the parameters to use greatly depends on your requirements, database setup, network capacity etc.
Here [...]