Maybe I missed it in your description, but what tech is the wiki based on? Worpress, or something else? I'd be careful of deleting stuff willy-nilly, for fear of causing dangling foreign keys (or whatever the term is when you delete something that another table references). Of course, if you have that backup copy of the DB, you can always put the original back and start over. But I'd be more inclined to study the DB schema before trying to delete anything. Or, use a wiki API if one exists to do the deletes. It may just move stuff over to an archive table, but then it might be easier to identify what to actually delete and you can do it properly, deleting the content and the references to it. But it seems I always seem to look for doing things the hard way ; -( bjb On Fri, Mar 31, 2017 at 03:51:34PM -0400, Robert P. J. Day wrote: > > i'm in the process of relocating my domain crashcourse.ca and, > apparently, one of the databases (the one for my wiki) has gotten > monstrously large, i'm assuming because of all the history, so that's > it's now over 10G. most of that is just history and i have no interest > in keeping previous revisions, just the current pages. > > i've logged into cpanel for my domain and, via phpmyadmin, i can see > all of the tables in the wiki database ... i'm wondering which of all > these tables i can just scrap to drag down the size of the underlying > SQL database without losing just the current pages. > > i suspect i haven't specified all the info necessary to get a > meaningful answer to this, so any guidance would be appreciated. where > should i start? > > rday > > -- > > ======================================================================== > Robert P. J. Day Ottawa, Ontario, CANADA > http://crashcourse.ca > > Twitter: http://twitter.com/rpjday > LinkedIn: http://ca.linkedin.com/in/rpjday > ======================================================================== > > _______________________________________________ > Linux mailing list > Linux [ at ] lists [ dot ] oclug [ dot ] on [ dot ] ca > http://oclug.on.ca/mailman/listinfo/linux ---end quoted text---