Fix MySQL Server Issue: “Another MySQL daemon already running with the same unix socket.”

Fix MySQL Server Issue: “Another MySQL daemon already running with the same unix socket.” featured image

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 […]

How Do You Pronounce “MySQL”?

How Do You Pronounce “MySQL”? featured image

We sometimes talk on the telephone with various technology companies, and their representatives. The people on the telephone fall into one of two camps: technical and non-technical. Nobody, however, seems to be sure exactly how to pronounce the abbreviation “MySQL”. The people who made and host MySQL have been quite clear about this. It is […]

How to Find & Replace in MySQL

How to Find & Replace in MySQL featured image

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: update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); […]

WordPress – Using MySQL to Update Specific Custom Fields

WordPress – Using MySQL to Update Specific Custom Fields featured image

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 […]

How to Restart MySQL After Editing innodb Log Size

How to Restart MySQL After Editing innodb Log Size featured image

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 MySQL(d) can cause a hiccup or two. Namely, the MySQL service won’t restart. If this happens, what […]

Silicon Dales