[rt-users] Restoring data after a system crash

2011-01-06 Thread Chris Barnes
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

Re: [rt-users] Restoring data after a system crash

2011-01-06 Thread Ruslan Zakirov
On Thu, Jan 6, 2011 at 10:42 PM, Chris Barnes chris-bar...@tamu.edu wrote: 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.

Re: [rt-users] Restoring data after a system crash

2011-01-06 Thread Chris Barnes
On 1/6/2011 6:58 PM, Ruslan Zakirov wrote: On Thu, Jan 6, 2011 at 10:42 PM, Chris Barneschris-bar...@tamu.edu wrote: 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.