Skip to main content
21
results
Andrew Fletcher
Recently I came across this piece of gold when dealing with databases, particularly relational ones like MySQL, managing transactions efficiently is crucial to ensure data integrity and consistency. In MySQL, transactions are used to group several SQL commands into a single unit that either completely succeeds or completely fails, ensuring that a database remains in a consistent state. Managing transactions efficiently in databases like MySQL is crucial for ensuring data integrity and...
Andrew Fletcher
These steps are for Drupal 8 and 9.   Export your database Order here is...
Andrew Fletcher
A summary of Node package commands Short cut commands npm install...
Andrew Fletcher
Updating NPM packages using npm update and I'm seeing the following response npm...
Andrew Fletcher
Goal: I want to download a table list to a txt or csv file. Initially, as a root...
Andrew Fletcher
Recently I have been investigating one of my Linux server's speed using the copy [cp] command.  This came about due to 'upgrading' the server from Centos 6 to 7.  Once I had migrated a domain, I ran the following command yes | cp -rf 'stg/core' 'tmpdir'To my surprise, the first run of this command took over 38 minutes to complete.  Crap!  Yes a simple cp -a command is a very painful and slow process.  Read more about the pain and times under Centos 7 in this...
Andrew Fletcher
Looking to install Solr on your server?  Not sure if it worth the...
Andrew Fletcher
On your local OSX environment using Terminal or iTerm you can create a MySQL...
Andrew Fletcher
This article assumes that you are running Docker and Lando already.  Don't...
Andrew Fletcher
Installing Varnish to increase the speed of the page load. Install varnish using...
Andrew Fletcher
Currently I'm working through an app that has been abandoned by the developers.  The client was getting no response from the dev company, when they asked if I could have a look.  The app hadn't been updated for 18 months.  So of course, a product that hasn't been updated in that timeframe is going to have a suite of npm update issues / conflicts.   What is the difference between dependancy and devDependancy packages? When you install an npm package using npm install...
Andrew Fletcher
Running Docker and attempting to install a web proxy environment where I'm...
Andrew Fletcher
Working on an Azure server I ran a mysqldump command to generate a copy of the...
Andrew Fletcher
When attempting to backup mysql using the mysqldump command mysqldump -u root...
Andrew Fletcher
How to Create New MySQL User Before you can create a new MySQL user, you need to...