I think this would be a very handy hack.......
But to achieve this through phpMyAdmin read below
Thanks to Pogo :
To remove old attachments:
To see them :
select * from attachment where dateline < UNIX_TIMESTAMP('yyyy-mm-dd hh:mm:ss')
To delete them:
Delete from attachment where dateline < UNIX_TIMESTAMP('yyyy-mm-dd hh:mm:ss')
i.e
Delete from attachment where dateline < UNIX_TIMESTAMP('2002-01-20 02:00:00')
Removed all the attachments posted before 20th of Jan 2002
I shaved a nice 45MB of my Database using this.
|