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
18
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
•
Regular commands for brew
Brew update
This updates Homebrew itself....
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 database, database user, and password, as well as, assign all privileges to the user for the database.
Knowing your credentials, before beginning you will need to know the following:
user: {user}
password: {password}
database: {database}
For my local environment, I'll be using these credentials
user
root
password
root
database
safs
Walkthrough the steps to build your database:
The initial step is to...
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
•
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
•
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
•
Step 1: Install Homebrew
Homebrew is the missing package manager for macOS.
As...