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 […]...
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 […]...
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 […]...
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) […]...
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 […]...
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 […]...
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 […]...
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 […]...
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 […]...
{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 […]...