2011-07-22, 10:13 PM
Hello,
I am new to this forum stuff, so please be patient....
I am running version 1.6.3 and it performs nicely. I didn't have any problems with installation and use.
My problem is that I have been attacked by spammers and my host is "requesting" that I reduce my database size (3GB+) or face being suspended.
I tried to remove/prune the posts, but in most cases, it bombs with an SQL error. It seems to work with 300 or less posts, but any more, no dice. I have a couple spammers that got me for over 7,000 posts!!! I need direction. AsI see it, I have 2 options:
1. Find a tool or query that can possibly delete the postings from the MySQL management facility on the host.
2. Ditch the database(s). I don't really want to do this, but if I can retain the user list, that would be nice.
3. My host has the ability to export the database to CSV. Perhaps, if it can be exported, I can modifiy it and import it back into the database.
I'm not an SQL guru at all. Some detailed guidance would be greatly appreciated.
Thanks,
Marc
If there are any other suggestions, I
I am new to this forum stuff, so please be patient....
I am running version 1.6.3 and it performs nicely. I didn't have any problems with installation and use.
My problem is that I have been attacked by spammers and my host is "requesting" that I reduce my database size (3GB+) or face being suspended.
I tried to remove/prune the posts, but in most cases, it bombs with an SQL error. It seems to work with 300 or less posts, but any more, no dice. I have a couple spammers that got me for over 7,000 posts!!! I need direction. AsI see it, I have 2 options:
1. Find a tool or query that can possibly delete the postings from the MySQL management facility on the host.
2. Ditch the database(s). I don't really want to do this, but if I can retain the user list, that would be nice.
3. My host has the ability to export the database to CSV. Perhaps, if it can be exported, I can modifiy it and import it back into the database.
I'm not an SQL guru at all. Some detailed guidance would be greatly appreciated.
Thanks,
Marc
If there are any other suggestions, I