When moving an older MySQL-based project to a new server instance, one of the SQL query errors bound to immediately strike is that of triggering the sql_mode=only_full_group error, caused by your SQL select statements referring to columns that are not functionally… Continue Reading →
The chance of remembering your MySQL root user account password when coming back to an Ubuntu server after a long period of time is pretty much zero – after all, this is seldom a username/password combo that you actually use… Continue Reading →
Sometimes you don’t want to expose your MySQL root user or password to a third party, but do need to give that party access to a super user or administrator account that has full control over the MySQL server instance…. Continue Reading →
I needed a quick fix to an urgent problem the other day, and the best solution for that particular challenge turned out to be artificially manipulating tables’ ID primary keys in order to avoid clashes in a shared table when… Continue Reading →
CSV (comma separated value) files are often used as a way to transfer data between two different systems – it’s a simple, verbose, and difficult to break (if you double quote every single string of course) way of saving grouped… Continue Reading →
If you are a web developer, then installing the Apache, MySQL and PHP stack is of paramount importance, something that becomes apparent when you look around and see how many customised LAMP and WAMP installers there are out and about at the moment.
When backing up or copying across a MySQL database, the command line mysqldump executable is invaluable in automating the creation of SQL dump files which can be used to create or populate database instances. Now there are a myriad of… Continue Reading →
It is not very common but sometimes you’ll find yourself working on a project that features multiple databases holding all the information we need. Now of course we know that when making an initial database connection we get a identifier… Continue Reading →