SQL to delete an entire store?
dormando at rydia.net
Thu Mar 20 23:38:57 UTC 2008
We should probably cook up an interface for doing bulk deletes/re
replicates/checks via the tracker, somewhat safely.
Yes, on some level I believe it would work if you selected the fids into
file_to_delete. It could still take a while, but you could also add a
few extra delete jobs.
I'd be paranoid enough to stop the trackers while doing the bulk load
into file_to_delete... Not sure offhand if doing a delete through a
tracker ensures you're not doing anything awful if a fid is locked by
Clinton Goudie-Nice wrote:
> I'm looking for some quick sql to delete the entire list of files in my
> mogile store. Can I just do a select into files_to_delete from file?
> In my bulk testing, I often fill up the store with garbage, and I'd
> rather tear it down this way than have to issue all the delete commands
> through the tracker; through the tracker it just takes too long.
> Twelve Horses <http://web.twelvehorses.com/> Mobile
> <http://web.twelvehorses.com/info_center/whitepaper/> Social
> <http://web.twelvehorses.com/solutions/blogging_for_business/> Web
> <http://web.twelvehorses.com/solutions/website_design/> Email
> *Clinton Goudie-Nice*
> Architect / Senior Software Engineer
> cgoudie at twelvehorses.com <mailto:cgoudie at twelvehorses.com>
> Phone: +1.801.571.2665 ext 3264
> Mobile: +1.801.915.0629
> Fax: +1.801.571.2669
> LinkedIn: http://www.linkedin.com/in/cgoudie
> *Twelve Horses*
> 13961 Minuteman Drive
> Suite 125
> Draper, UT 84020
> *www.twelvehorses.com <http://www.twelvehorses.com>*
More information about the mogilefs