For those who want to know:
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. (Wikipedia)
If you would like help with a MySQL setup, contact Silicon Dales.
Sometimes, we need to find and replace certain strings or pieces of data in MySQL on the fly, for example if we’ve changed a Top Level domain (TLD) and want to update a bunch of links all in one go. For those times, the following command can be issued: The code from the Gist above …
If you use a lot – or even just one – EC2 instance on Amazon Web Services (AWS), from time-to-time, you might find that an instance becomes unresponsive, you can’t get in via SSH, and, when in the AWS console, the instance just won’t stop! When this happens, you select “Stop” in the console, and …
If you’re recently installed WordPress onto a new server (we do this a lot on Amazon EC2 instances of varying sizes) and you notice that your image uploads aren’t auto-thumbnailing (when WordPress “crunches” your images into “thumbnail” “medium” and “large” sizes for use throughout your website) then chances are your server doesn’t have the GD …
Some time ago, I wrote a short blog post explaining how to go about installing XCache on an Amazon EC2 instance to help with opcode caching. More recently, we’ve begun using APC for similar reasons, with excellent results, including on Amazon EC2 Micro instances, which can be used under their free usage tier to run …
Sometimes, either because we’ve got a puny amount of RAM available, or because we’ve recently boosted available RAM, we want to allow MySQL a different amount of memory for it’s innodb logs. However, when we change this, restarting MySQLd can cause a hiccup or two. Namely, the MySQL service won’t restart. If this happens, what …
Scaling WordPress websites to stupidly big levels is something that makes us very, very happy. Over the past 10 years, I’ve overseen some fairly significant web applications, powered by WordPress, which pushed the envelope in terms of what the CMS can do. One instance saw us taking 5,000+ XML (NewsML + other types) files pushed …
Just the code you need for responding to this error. The following message can sometime prevent MySQL from (re)starting: Another MySQL daemon already running with the same unix socket. Sometimes, this message displays when you KNOW there is not another MySQL daemon running on the same unix socket, because you just issued a “stop” command …
We’ve been asked to troubleshoot Amazon Web Services Elastic Compute Cloud (AWS EC2) instances for a number of reasons. Recently, we took a look at an Amazon EC2 instance which was being used as a MySQL server and the task was to see why several MySQL innodb tables were crashing. The situation had got so …
We often install the Open source (free, and developed by a community of programmers, rather than one, paid, team) Content Management System (CMS), WordPress. WordPress was originally a blogging platform developed by Matt Mullenweg, but, in its short history, the software, which runs on (also Open source) PHP and MySQL, has developed into far more …
Some time ago, we told you how to Find & Replace Data using MySQL – today I am going to explain how to use this query to update specific custom fields in WordPress databases, in bulk, on-the-fly, without having to login, open, and edit every single WordPress post you’ve got! Remember, before doing anything to …
