If you have a lot of WordPress posts and might want to find all posts containing a certain keyword for any reason, you can start by using the following SQL code, which was taken from this post. I used this in phpMyAdmin for a MySQL database. Make sure you are in the correct database first! …
Tag Archive: MySQL
Permanent link to this article: http://mikebeach.org/2011/10/02/how-to-find-a-keyword-in-your-wordpress-posts-using-sql/
Basic Ubuntu VPS server backup via FTP or SSH SFTP
In my quest for the perfect “in my dreams” backup solution for my Ubuntu VPS, I created this very simple script which can be run as a cron job and can be easily modified to backup any amount of data to any remote FTP or SFTP server. You could very easily include a database backup …
Permanent link to this article: http://mikebeach.org/2011/10/02/basic-ubuntu-vps-server-backup-via-ftp-or-ssh-sftp/
Backing up your server using JungleDisk Server Edition – part 2
In part 1, I told you how to set up JungleDisk backup for your Linux server. In this part 2, I’ll tell you how to automatically have it dump and backup your MySQL databases (correctly)! There are security implications if this permissions are not set correctly on the files, as you’re storing your MySQL password …
Permanent link to this article: http://mikebeach.org/2011/03/30/backing-up-your-server-using-jungledisk-server-edition-part-2/
Backing up your server using JungleDisk Server Edition – part 1
This guide assumes you’re using a Debian-based (Ubuntu, Debian) build of Linux, and we’ll be using the 64-bit download from JungleDisk. The instructions don’t really change for the 32-bit version, except for the installer file name. The first steps: Go over to the JungleDisk Business page and sign up for, and download, the server …
Permanent link to this article: http://mikebeach.org/2011/03/28/backing-up-your-server-using-jungledisk-server-edition-part-1/
How to automatically purge Piwik logs using a cron job
If you’re using Piwik Analytics, you may know that over time your Piwik database will continue to grow over time. The piwik log tables as well as the archive tables will continue to grow until you purge them. The Piwik developers are aware of this and a ticket has been in their system for a …
Permanent link to this article: http://mikebeach.org/2011/03/27/how-to-automatically-purge-piwik-logs-using-a-cron-job/
Beware of poorly-written CMS plugins.
CMS systems like WordPress, Drupal, Joomla, etc are rife with plug-ins and modules you can add for extra functionality, but it’s really hard to tell the load that some of those add-ons place on your system and database. When you want to have a website that won’t collapse under load (or take the server down …
Permanent link to this article: http://mikebeach.org/2010/06/27/beware-of-poorly-written-cms-plugins/
Show your support
If you found information on my blog useful, please consider a small donation to show your support and appreciation. A small donation of even just a few dollars is very much appreciated and can be made quickly and securely through PayPal.
If you're feeling especially generous, or prefer to give a gift, please consider something from my Amazon.com Wish List.
Recent Comments