Restoring data after a system crash

Today we had a disk crash of my mysql server.

After I restored the machine (from Dec 31), I then tried to restore the
nightly backup of the mysql data itself. It almost worked.

… the backup of the data is done using mysqlhotcopy, tar the copy,
then scp over to another computer.

All but 1 of my tables seems to have restored. What I did was
(1) copy the tar file to the restored server
(2) untar the hotcopy into /tmp/restored
(3) stop mysql,
(4) copy the tables (directories) from /tmp/restored to /var/lib/mysql
(5) restart mysql.

All but 1 of the databases is now using the restored data. The database
that did not restore is… (the reason I am asking here) the RT
database. For that 1 database, when I look at the contents I get the
data from Dec 31 (not last night).

Ideas?

Chris Barnes AOL IM: CNBarnes
chris-barnes@tamu.edu Yahoo IM: chrisnbarnes
Computer Systems Manager MSN IM: chris@txbarnes.com
Department of Physics ph: 979-845-1379
Texas A&M University fax: 979-845-2590

mysqlhotcopy

http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html

mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables

RT runs on InnoDB tables.

Best regards, Ruslan.

mysqlhotcopy

http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html

mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables

RT runs on InnoDB tables.

Welllll… alrighty then.

Chris Barnes AOL IM: CNBarnes
chris-barnes@tamu.edu Yahoo IM: chrisnbarnes
Computer Systems Manager MSN IM: chris@txbarnes.com
Department of Physics ph: 979-845-1379
Texas A&M University fax: 979-845-2590