Category Archives: Tools

Database size phpadmin wordpress

WordPress Database size in phpMyAdmin

How to show WordPress database size in pypmyadminI got an email from my hosting provider that I was exceeding my wordpress database space of 1000MB, which I thought was very strange. Had 2 dabases in which I each imported content of about 50MB (gzip format). I could not find the actual database size so I did some digging around and found the SQL code below which does the trick:

SELECT table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;

Continue reading WordPress Database size in phpMyAdmin

Exporting Browser history (Chrome)

Once a month I need to administer hours I spend on my business. I try to put most activities in my agenda but as I often browse and read up online it is for me also usefull to have a look at my browsing history. Although chrome does provide a browser history it is not very user friendly. Going back sevevaral weeks is a pain in the ass. Plus, sometimes I like to delete my history or reinstall my computer for example. Continue reading Exporting Browser history (Chrome)