Category Archives: MySQL

Add A WordPress User Manually To The Database

WordPress 4.0, Direct Access To The MySQL Database Recently I needed to gain access to a hacked WordPress installation. I didn’t have any usernames or passwords for the dashboard. Here’s a manual way that I used to create a user account, which sysadmins may find useful. Hang on; if you’re a hacker, stop reading, go […]

Speed Up Your Database Using MySQL Query Cache

MySQL 5.1.69 Modern web applications place a massive load on the database. I’ve been working extensively with Magento lately and the demand on the database is enormous. We could argue all day about which language is easier on the database in terms of access routines and read/write cycles. Ruby (Sinatra)? Regardless of the application’s structure, […]

MySQL Dump Script For Database Backups

Mac OS X (10.6.8), CentOS, Linux Do you perform regular database backups? Maybe you take copies of your live database and push that data somewhere else (like, your staging site)? And maybe you’ve accidentally overwritten your live database coz you typed something wrong? Yeah, well I have. And after the second time, I decided to […]