Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 10 Feb 2012, 10:22
dreamygirl dreamygirl is offline
 
Join Date: Jan 2007
Deleting threads in PhpMyAdmin or mysql command line

Can I delete lots of threads this way, or will it be a hassles because of counters and so many affected tables? I want to be able to repeat the process many times, so the speed matters. Also the database is big and I want to only keep a fraction of the threads.

It's great if I could simply tell mysql to drop all the data that matches my time stamp criteria. Could I just run that on the big tables (post, postedithistory, postparsed, and thread) and leave the other data? For this purpose it's fine if my data tables are bloated with extraneous data, as long as it doesn't cause errors. I really want a quick way and don't mind the extra disk space or the DB being a little slower.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:33.

Layout Options | Width: Wide Color: