Hi,
In answer to your questions:
1) mysqldump should be available from the command line, i.e:
From windows:
c:\> mysqldump --options
Or Linux/Unix:
shell> mysqldump --options
If the MySQL installation is not included in your PATH sytem variable then you may have to use the full path to the utility, e.g.:
C:/> c:\mysql\bin\mysqldump --options
For information on how to use mysqldump and what the options are, see:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
2) By default, the InnoDB engine stores information as follows:
Table format information is stored in a table.frm file in the database directory. So, for tables named table1 and table2 in a database named database1 the following files will exist:
path/to/mysql/data/database1/table1.frm
path/to/mysql/data/database1/table2.frm
Note: these store table format information - not data or indexes.
The data and indexes for all databases & tables will be stored in a single InnoDB tablespace which can comprise either a single file or multiple files. By default, the tablespace file(s) are stored in the server's data directory, i.e.:
path/to/mysql/data/
You can in fact copy the tablespace and format files from one server to another, but you should be aware that this will not allow you to transfer a specific database - as the tablespace file(s) encompass all databases. If you just want to transfer a single database, then use a separate utility. Other conditions that apply are as follows:
Both machines must use two's-compliment integer arithmetic
Either both machines must use IEEE floating-point format, or none of of the InnoDB tables must contain floating-point columns.
If you need to transfer between Windows & non-Windows operating systems, then you must use lowercase names for databases and tables.
If you are transferring MyISAM files, then you should also take precautions to ensure that the tables are not being used by any client processes when you perform the copy.
The best source of information on all this is the MySQL Reference documentation at:
http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html
Hope this helps,
Nick
--
Nick Roper