mysql record pruning

[Noiz Pollution]

Hi folks,

Just wondering if somebody can have a look at the queries in Jake's post in [this thread (http://www.vbulletin.com/forum/showthread.php?t=107924)] and possibly come up with another query I can run?

I'm getting quite desperate with this.


Cheers,
Robert

[Modin]

DELETE FROM pm, pmtext, pmreceipt USING pm, pmtext, pmreceipt WHERE pmtext.dateline < '1032632190' AND pmtext.pmtextid=pm.pmtext AND pm.pmid = pmreceipt.pmid;

Not sure if this will work, but according to the mysql manual it should... backup and give it a try ;)

[Noiz Pollution]

Your reply is much appreciated but I've since gone through the db and removed the entries manually, thanks anyway :)


Cheers,
Robert

[Modin]

too bad I wasn't on here sooner, would have saved you the trouble...