Robert: You could do a select count (*) from table; for tables you think might be large. Or select * from table limit 2; to see the first two rows of a table and decide how 'heavy' a row is.
Mysqlworkbench is good for browsing. And does the wiki have a control panel other than cpanel? Then you will start deleting rows when you see what is in there! Maybe delete older stuff with delete from table where createdate lt 2015/01/01 (Sorry, I have the syntax wrong on that for sure and I do not know your field names). The log files will be large if you have not been rotating them. But 10G is not much in these days of terabyte disks. Save some time by letting it be. Cheers -- Rick On March 31, 2017 3:51:34 PM EDT, "Robert P. J. Day" <[email protected]> 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 >[email protected] >http://oclug.on.ca/mailman/listinfo/linux -- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ Linux mailing list [email protected] http://oclug.on.ca/mailman/listinfo/linux
