I want to copy and 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.
Answer No: 1
To take data back up for InnoDB tables like copy paste can be unsafe by some ways. If you mean for a daily backup while the server is running then it is impossible! 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 may work.
Related MySQL FAQs to the Above FAQ