Huge Databases

[bobnew32]

Say I have a remote site, how would I go about "reuploading" a 2gb database that was crashed. I had to delete one as the records were skewed, and I have a backup on my computer. But doing like 15 million queries, that doesn't sounds like the best way to have this database back up and running.

How do you guys handle crashes to that magnitude?

[jollymcfats]

Had to do this occasionally on a huge MySQL installation (1/2 tb) when tables went bad. The most expedient way I found is to copy over the binary table file from the backup's database directory.