-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ryan Leavengood wrote: > On 4/19/06, Dick Dishkuvek <dishkuvek / 0xf00d.com> wrote: > >>Is this an insane way to do things? I have a feeling I am doing a lot >>more work than necessary. Does anyone have any suggestions? > > > If the dumped SQL is fairly simple and regular, I'd just write a > script to parse it and add things to the right tables. I think it is > overkill to import it into a new table just so you can later select > and re-insert it. > Depending on how big the table was, you could do this all from within a mysql batch script, by using "insert ... select" statements. Zach -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFERv3pMyx0fW1d8G0RAmNbAJwOaBKouHWL0xDJh5WjmG0uKnj1IgCfb+RM B5NCP6dClBplgDzh+LIQhW4= =L1Pr -----END PGP SIGNATURE-----