On 2007-02-19 abhishek jain wrote:
> I want to copy paste the data files of Innodb database, is it possible, i
> mean can i just copy the data files like that we do for myisam tables

If you mean for a daily backup while the server is running: No!
You often end up with corrupted tables doing that with MyISAM, too.
Use mysqlhotcopy or mysqldump for that.

If you stop the server, then copy the files and make sure that you have
the same innodb_data_file_path statements at the target host, it maybe works.

bye,

-christian-