Paul Sissons Wrote:
-------------------------------------------------------
> We need to recover a innoDB database from a backup
> where the backup was mistakenly created using
> mysqlhotcopy. When this was set up for an
> ActiveCollab set-up it was assumed at the time
> that it was MYISAM.
>
> How, if possible can we now recover this
> mysqlhotcopy backup.
mysqlhotcopy won't have copied any of the InnoDB files, so the very short answer is "no you can't".
Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at
http://openquery.com/blog/ &
http://twitter.com/openquery