This is a fairly common situation. The short answer is that you usually don’t need to fix anything. This is a non-issue. As long as your MySQL and MySQL Client have the same major version, you can and probably should just...
Installing memcached on a server for use with W3Total cache can seem daunting if you haven’t done it before. Once you’ve done it enough to work out a method and know the speed bumps you can come across, you can ...
A customer wanted a piece of code that allowed a page to be refreshed once the client has remained on the page after a certain amount of time. They’d used a refresh command previously, but the problem was that this interrupted...
When doing exports of large databases using mysqldump, it is common to get errors that are along the lines of: mysqldump: Got error: 1016: Can’t open file: ‘./databasename/tablename.frm’ (errno: 24) when using LOCK TABLES or maybe mysqldump: Got error: 23: Out...
First – Breathe. “notty” stands for “no teletypewriter”. Programs that connect to the server but don’t want the output displayed any where use a “No TTY” connection. So if you see “ssh: *@notty” on a task list somewhere, it just means...
Unfortunately there are lots of registrars that don’t allow you full access to your DNS settings. 1and1.com is one of these. If you host your site with 1and1.com and you want to add a TXT record to your domain for verification...
I’ve improved my earlier random string generation procedures to better suit my needs. So I created a Random Name Generator for MySQL. I’ve created two new procedures. They pick from the 100 most popular first names (well actually the 50 most...
There are lots of quick and dirty ways to create a random strings in mysql. If you want letters and numbers, just do this: SELECT LOWER( SUBSTRING( md5( RAND( 4 ) ) , FLOOR ( 7 + ( RAND( ) *...
Sometimes you just have to start over. I had a database that had a bunch of tables in it, almost 9000. The problem was that I didn’t know if they were the right tables. I had a mysqldump files that did...
{EAV_BLOG_VER:cf05756ccfd5297d} The need for this routine comes up every now and then and it confuses people because they thing date(“W”) will do the trick. Once they realize that’s the week of the year, they start to get all elaborate in finding...