mysql dump FLUSH TABLES access denied
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.sqlI seeing the following response
Drupal toc_js explode() deprecated function
A recent upgrade to PHP 8.1, has highlighted an error that hadn't been appearing previously.
Deprecated function : explode(): Passing null to parameter #2 ($string) of type string is deprecated in toc_js_node_view()(line 130 of modules/contrib/toc_js/toc_js.module).In the top_js.module file from L124
Call to a member function getCacheTags() on null in Drupal\views\Plugin\views\query\Sql->getCacheTags()
Drupal 9 Fatal error: Declaration of Drupal\entity_reference_views\...\Select2ViewsWidget
Working in Drupal admin, going to a content type > manage form display and I'm seeing the following error
Drupal: how to import the configuration on a different site
After cloning a site, next you will want to import the config file. Which you can do so by running the command:
drush cim -yHopefully it worked for you. As it didn't work out so well for me as the response was:
Drush a few common commands to import and reset
Working through and importing JSON data into a content type.
Drush migration commands
Check the status of the migration data
lando drush migrate-statusReset the migration status
lando drush migrate-reset-status migratable_riverdata_jsonImport JSON data
Docker - Warning: copy(): SSL operation failed with code 1. OpenSSL Error messages:
Build the PHP base image with apache-buster using the Dockerfile.base
Since JN blocks some libraries update and pull, follow the following steps to build the base image locally.
Run the following command to build the base PHP image:
Make sure you are in the project root directory before running the command and its a fresh window after changing the proxy
CLI using drush to drop tables in your db and reload
This is a relatively quick process, beginning with dropping the database tables
lando drush sql-drop -yImport a MySQL database
lando db-import {filename}
such as
lando db-import riverdev.2022-10-03-1664769553.sql.gzRebuild cache
lando drush crFinally, export your config
Selecting a search methodology
Currently, we are upgrading a site from Drupal 7 to Drupal 9. During this upgrade, we have the opportunity to the site's search functionality and select a tool that is most suited to the website's requirements.
Running Drupal 9 locally with lando using remote files and db
Import a database
lando db-import doj.sqlEnter 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