One of the things I see a lot of in log files for WordPress site is scans for ?author=1. These are scans for admin users and can reveal the user name. Some security plugin will change the user ID for 1, but does not handle multiple user IDs that could be 2, 3 or 4. […]
Change Admin User IDs Read More »
Using the command line prompt to backup and restore a database can be quicker using the command line. If you get an error message about tablespaces, use the following command To restore the SQL file dump use the following command: For any of these commands, you will be prompted for the password for the database
Command Line mysqldump and restore Read More »
I came across this little snippet for querying records where a date field matches today’s date. Using the date function to make sure that only the date portion is returned without the time makes it a quick query that does not require using an external programming language to try and format today’s date correctly for
SELECT records with Today’s Date Read More »
I recently worked on a large wordpress blog site that had character encoding problems with the content. It’s not that big a deal to fix one or two instances where you see funny looking characters displayed on the page, but when you have hundreds of them, it’s time to turn to mysql queries to fix
Character Encoding Problems with Content Read More »
Occasionally I have new clients that don’t have access to their control panel, so that a dump of the database cannot easily be performed from a nice GUI interface (Very useful when I want to setup their site for local development). If the server allows executing mysqldump from in php, the following code can be
Using mysqldump to Backup a Database Read More »
I recently had a project where I needed to display all the rows from a mySQL database where the a date field occurred in the current week (From Sunday to Saturday). To keep from building out a complete query in php, I went with a little less complex query all in the SQL query. Using
Get All Rows For the Current Week (Sunday to Saturday) Read More »