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
17
results
Andrew Fletcher
•
These steps are for Drupal 8 and 9.
Export your database
Order here is important. First you want to clear all the Drupal caches. Then export / dump the db the sql database to a file in your home directory.
drush cr
drush sql-dump > path/to/your/file/ourpout/sql-dump-file-name.sqlor
drush sql-dump --extra-dump=--no-tablespaces --result-file=../sql/db-2022-12-07.sqlWithout having to manually set the date
drush sql-dump --extra-dump=--no-tablespaces...
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
•
Looking to install Solr on your server? Not sure if it worth the...
Andrew Fletcher
•
Trying to have a chat recently, and Microsoft Teams would not open on MAC OS....
Andrew Fletcher
•
How do you generate a .pem file from an existing .ppk key?
Is putty on your mac?
Check by running the command
puttygen -VWhich will generate a response similar to
puttygen: Release 0.76
Build platform: 64-bit Unix
Compiler: clang 12.0.5 (clang-1205.0.22.9)
Source commit: 1fd7baa7344bb....Don't have Putty, well easily fixed with homebrew.
brew install putty
Generate the key
We will use puttygen to generate the key.
puttygen key.ppk -O private-openssh -o key.pem
key.ppk
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
•
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 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
•
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...
Andrew Fletcher
•
To add ejabberd and run MYSQL to the server I needed to update the server...