Drush

I've recently upgraded the server Ubuntu 20.04 updating the PHP version from 7.4 to 8.1.  However, when I've attempted to export the MySQL database using the command

drush sql-dump --extra-dump=--no-tablespaces --result-file=../sql/db-2023-02-25.sql

I seeing the following response

After cloning a site, next you will want to import the config file.  Which you can do so by running the command:

drush cim -y

Hopefully it worked for you.  As it didn't work out so well for me as the response was:

Working through and importing JSON data into a content type.

Drush migration commands

Check the status of the migration data

lando drush migrate-status

Reset the migration status 

lando drush migrate-reset-status  migratable_riverdata_json

Import JSON data

This is a relatively quick process, beginning with dropping the database tables

lando drush sql-drop -y

Import a MySQL database

lando db-import {filename}

such as 

lando db-import riverdev.2022-10-03-1664769553.sql.gz

Rebuild cache

lando drush cr

Finally, export your config

Import a database

lando db-import doj.sql

Enter the MySQL database

lando mysql -h database

This action will change the prompt as you are now in mysql.  The prompt will start with

mysql>

Now change to the database that you want to use

use doj;

If you want to know what databases exist, then run

How do you rebuild node access permissions using CLI?

To rebuild permissions from the command-line using Drush:

drush php-eval 'node_access_rebuild();'

Or using Drupal Console:

drupal node:access:rebuild

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.sql

or

Attempting to update the database, irrespective whether I run update.php or preferred method drush updb the following errors were appearing:

Is Docker installed?

Check if your installation is ok and spin up Docker as well:

docker -D info

Using Docker

Now it's time to download and install docker images. Using the official images of MariaDB and Drupal. If you don’t specify the absolute URL to the image it will be searched and downloaded from Docker Hub. Tag 'latest' will be used by default.

Having Drupal Solr Search APi running, I thought adding synonyms to the mix would be a smooth process.

Install synonym module

I cam across a synonym module created by Jens Beltofte - Search API Synonym.  Working on a Drupal 9.3.x installation, this module needs to be accessed via Git Search API Synonym,