Skip to main content
36
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
Goal: I want to download a table list to a txt or csv file. Initially, as a root...
Andrew Fletcher
Installing PHP on OSX and it installed PHP 8.2.x.  However, for my...
Andrew Fletcher
Regular commands for brew   Brew update This updates Homebrew itself....
Andrew Fletcher
The challenge I was facing, I had written a script to scan barcodes and use Google book API to view the contents.  However, a snippet of the JSON response { "contentVersion": "0.2.0.0.preview.0", "panelizationSummary": { "containsEpubBubbles": false, "containsImageBubbles": false }, "imageLinks": { "smallThumbnail": "http://books.google.com/books/content?id=VktTDwAAQBAJ&printsec=frontcover&img=1&zoom=5&source=gbs_api", "thumbnail":...
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
In terminal I ran a regular command - compose update.  Something I've...
Andrew Fletcher
Running Docker and attempting to install a web proxy environment where I'm...
Andrew Fletcher
Have you noticed through your Google account that there are items being indexed that shouldn't have been?   One for me was taxonomy terms.  Not important to be followed. Being indexed on my sitemap (do I just erase those entries on the XML file?) Being crawled (I am guessing this is with a robots.txt file though I have never created one before) Being viewed (stumbled upon) -> if this even possible to block?   Resolve these quickly by simply adding disallow in robots.txt...
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...
Andrew Fletcher
The generally accepted answer to a mysqldump is: mysqldump -h [host] -u...