INNODB hotbackup recovery issues

[csgonan]

I am trying to restore the data captured in an innodb hotbackup to a new mysql server.

The source server is Solaris 8, mysql verion 5.0.22-log.
The new server is Solaris 10, mysql version 5.0.37-log

Whether I use an ODBC windows tool or the command line, when I try to optimize the database, I get the following error

mysql> use OUR_DB
Database changed
mysql> optimize local table Bio;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> help

I can connect to the tables and query them at the command line, but this error appears no matter what I use to optimize the database.

Any suggestions would be helpfule.

Thank you

 

[Kozusnik]

I wasn't sure innodb tables could be backed up hot except for a mysqldump. Maybe I was mistaken.

How did you restore the files? i.e. copy to dir or ftp.
Are they mysqlhotcopy files or sql dumps?

Mark

 

[csgonan]

I'm finding the issue is more with losing the connection to the database. Even if I tried to create a simple two-field table, and once again, was hit by the same infamous Error 2013

Do you know what that is?

I compiled this on Solaris 10, 64 bit. I will probably post this as a separate question but if you know, a suggestion would be appreciated.

Thanks