:)
Being the original poster of this thread,
I just wanted to refresh everyone's
memory and repost what I settled upon:
# WARNING: Much code was deleted for brevity...
# CREATE TABLE
if (/CREATE\s+TABLE/) {
print NFILE "\n\n$_\n";
$flag++;
next;
}
# End of segment
if (/Dumping.+table/) {
--$flag;
next;
}
# Get data, while $flag
if ($flag) {
print NFILE "$_\n ";
next;
}
# Everything else is skipped
# during natural looping...
# WARNING: Much code was deleted for brevity...
__END__
Example of the snapshot -
# Table structure for table 'addressbook'
#
CREATE TABLE addressbook (
.
. Get everything here ...
.
PRIMARY KEY (pk1,sos_id_pk2),
KEY addrbk_users_fk_i (users_pk1,users_sos_id_pk2)
);
#
# Dumping data for table 'addressbook'
The line above denotes end of this segment;
skip all data until next CREATE TABLE area...
It has the virtue of having gotten the
job done quickly. I do appreciate everyone
postings and thoughts, however;
-Sx- :]
