MySQL Workbench saves the day and space
October 6, 2012
No luck gaining access the site for a couple of days, no biggy, an email exchange later & my ip is apparently added to the firewall exclusion & I’m in… I thought the issue was too much space been taken up on server, as I’ve revived warnings & had just backed up files to server.
After a couple of googles, searching for peoples preferences on a linux mysql editor I chose & installed MySQL Workbench… but with no connection to my ftp files I only had a demo database to play with.
Site back up & I have a connection from my host MySQL database to MySQL Workbench… w00t I am in the zone 🙂
I work with sql server on a daily basis, so one bit of code later, clears the old posts & frees up a bit of space.
The extract below burns the posts created from feeds, keeping blog et al live for another day.
DELETE FROM `wp_posts`
WHERE `post_type` = 'post'
AND DATEDIFF(NOW(), `post_date`) > 30
AND `post_author` > 3
So now I have a local sql client to play with, connected to the web server… wonder if I can connect also to Google Fusion Tables?