developer resources
Codebales holds an ever growing number of solutions to problems that we have experienced in our day to day code writing
Selected filter
113
results
Andrew Fletcher
•
Working on an Azure server I ran a mysqldump command to generate a copy of the db. No issues, the file downloaded on to the serve without cause.
The Problem
On my local environment, using Sequel Ace I imported the file, but it suddenly it stopped with a red message “Unknown collation: ‘utf8mb4_0900_ai_ci‘”
[ERROR in query 14] Unknown collation: 'utf8mb4_0900_ai_ci'“Collation is the assembly of written information into a standard order. Many systems of collation are based on...
Andrew Fletcher
•
The migrate process saves the status of each running migration in the...
Andrew Fletcher
•
When attempting to backup mysql using the mysqldump command
mysqldump -u root...
Andrew Fletcher
•
To remove all the contents from a directory, you need to ask yourself:
Do I want...
Andrew Fletcher
•
How to Create New MySQL User
Before you can create a new MySQL user, you need to...
Andrew Fletcher
•
This short guide explains to you how to extract/unzip .zip archive files to a specific or different directory in Linux.
Install zip
sudo apt-get install zip
Zip a directory
Zip your folder:
zip -r {filename.zip} {directory}
Unzip
unzip {filename.zip}
Extract zip file to a different directory
mkdir -p /tmp/unziped
$ unzip {filename.zip} -d...
Andrew Fletcher
•
I prefer htop over top on my Linux server. Running a Solr index got...
Andrew Fletcher
•
The generally accepted answer to a mysqldump is:
mysqldump -h [host] -u...
Andrew Fletcher
•
Wanting to create a new repository on GitHub, add in a few of the available...
Andrew Fletcher
•
On a git pull from remote dev environment to a staging environment running off...
Andrew Fletcher
•
I needed the check if a file existed in a directory as the migrate script wasn't recognising the file. To check if a file exists:
FILE={your-directory-path}
if test -f "$FILE"; then
echo "$FILE exists."
fi
If your directory path is /Users/{your name}/Sites/migrate/local_dest_dir/fish/../media/apple-store.png
FILE=/Users/{your name}/Sites/migrate/local_dest_dir/fish/../media/apple-store.png
if test -f "$FILE"; then
echo "$FILE...
Andrew Fletcher
•
Joining a new company / team there is always a lot of new items to...
Andrew Fletcher
•
Updating Drupal from 8.7.10 to 8.8.x or 8.9.x has seen a significant change...
Andrew Fletcher
•
As outlined in an earlier article composer php version, when installing the...
Andrew Fletcher
•
I had been running a few Centos 6 servers just past their EOL (30th November...