13
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
•
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
•
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
•
Creating a new account in Mail on OSX Big Sur (11.2) and complete the required...
Andrew Fletcher
•
To add ejabberd and run MYSQL to the server I needed to update the server version of mysql from 5.5 to 5.7. Fortunately, there are great instructions on the Plesk support page regarding how to achieve this outcome.
https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux
As a point of reference, as I worked through the steps... step 10 you need to restart the MYSQL server. This is a quick progress by...
Andrew Fletcher
•
Images
For some time, when looking for images online for your app or site I have...
Andrew Fletcher
•
The starting point is to read through and follow the notes outlined on the...