japhy has asked for the wisdom of the Perl Monks concerning the following question:
The prodigal hacker returns. I've been in Perl Purgatory (where I have to use PHP a lot)...
I have a 42 GB mysql table which appears to be SLIGHTLY corrupted (due to disk space running out, I think). The last record in the table ends abruptly (I know this by 'tail'ing the file). mysql seems to be able to repair the DATA, but it fails to rebuild its index (sort_buffer is too small, it says, even though I've got it maxed out at 4 GB).
I'd very much like to use the .frm (table format) file and the .MYD (data) file and go through extracting the data for insertion into a new table. Is there a module out there for doing that already?
Jeff japhy Pinyan, P.L., P.M., P.O.D, X.S.: Perl, regex, and perl hacker
Nos autem praedicamus Christum crucifixum (1 Cor. 1:23) -- The Cross Reference (My Blog)
I have a 42 GB mysql table which appears to be SLIGHTLY corrupted (due to disk space running out, I think). The last record in the table ends abruptly (I know this by 'tail'ing the file). mysql seems to be able to repair the DATA, but it fails to rebuild its index (sort_buffer is too small, it says, even though I've got it maxed out at 4 GB).
I'd very much like to use the .frm (table format) file and the .MYD (data) file and go through extracting the data for insertion into a new table. Is there a module out there for doing that already?
Jeff japhy Pinyan, P.L., P.M., P.O.D, X.S.: Perl, regex, and perl hacker
Nos autem praedicamus Christum crucifixum (1 Cor. 1:23) -- The Cross Reference (My Blog)
Back to
Seekers of Perl Wisdom