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-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
