Re: Perl and MySQL

"Charles A. Landemaine" <landemaine@xxxxxxxxx> wrote:
I have a MySQL table that is used to store comments on my blog. I just
found out it's filled with spam. The table itself is 2 GB big, with
more than half a million spam backlinks. I haven't found much material
on how to interact between Perl and MySQL. What I'd like to do is do a
simple Perl script that opens the DB table, goes through all rows and
deletes all those which contain "<a href". I'll have to do that during
the night, not to disrupt the server. How could I do that?
Thanks,

I don't know why you would do this in Perl rather from the mysql client,
but anyway I'd use DBI and DBD::mysql

Xho

--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB
.

Relevant Pages

  • Re: Perl and MySQL
    ... more than half a million spam backlinks. ... on how to interact between Perl and MySQL. ... case a Perl solution might become necessary. ... the data in there to refuse to store data containing a link in ...
    (comp.lang.perl.misc)
  • Re: Perl and MySQL
    ... Charles A. Landemaine wrote: ... more than half a million spam backlinks. ... on how to interact between Perl and MySQL. ...
    (comp.lang.perl.misc)
  • Re: using perl ot connect to a database
    ... using perl ot connect to a database ... Any idea why I need the old_password set to on to use this script? ... It sounds like DBD::MySQL is still setup to use the old MySQL client ...
    (perl.beginners)