Skip to main content
18
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
Finalising a deployment to Drupal 10 and reviewing the latest log...
Andrew Fletcher
Goal: I want to download a table list to a txt or csv file. Initially, as a root...
Andrew Fletcher
After cloning a site, next you will want to import the config file.  Which...
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
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
The cache system in Drupal 9 delivers the API with the elements required for...
Andrew Fletcher
Installing Varnish to increase the speed of the page load. Install varnish using...
Andrew Fletcher
Clear DNS Cache The DNS (Domain Name Service) cache on your Mac helps browsers locate and connect to web addresses quickly. If your browser Safari or Chrome still fails to load websites, this can be the result of an obsolete DNS cache may be causing the issue. In this instance you want to focus clearing the cache.  Using Terminal or iTerm2 enter the following command: sudo killall -HUP mDNSResponder 
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...