XF 1.2 Recovering from failed drive

[eccentricson]

I have almost everything working, except I have a DB file that won't transfer. It's the .ibd file. Is there a way to rebuild this table?

xf_email_template_compiled is the table.

 

[eccentricson]

Along with the xf_permission table.

 

[Paul B]

What do you mean by it "won't transfer"?
Have you tried doing a database dump and restore?
Are any of the tables marked as crashed? If so, have you tried repairing them?

 

[eccentricson]

I'm getting IO errors so I can't copy, move, move, etc.

Repair won't work either.

 

[Luke F]

I'm getting IO errors so I can't copy, move, move, etc.

Repair won't work either.

You're not trying to work from the failed drive directly are you? Take a partition image/clone and work from that

 

[eccentricson]

Can't because dd fails because of Io errors.

 

[Biker]

Because nobody else has, I'm going to ask the obvious. Where are your backups?

 

[eccentricson]

They exist.... But apparently the backup database button wasn't checked. The site files are all there but the actual database isn't...

 

[Paul B]

Well without a recent backup of the database and a failed/corrupt hard drive, you don't really have a lot of options.

 

[eccentricson]

I have all of the tables except permissions and email_template_compiled. There's no way to rebuild these tables?

 

[eccentricson]

Everything is working, thanks to Mike from Xenforo. I dropped the table (still had the frm file), and was able to recreate the tables from the specs file (library/XenForo/Install/Data/MySql.php).