30
results
Andrew Fletcher
•
Recently I came across this piece of gold when dealing with databases, particularly relational ones like MySQL, managing transactions efficiently is crucial to ensure data integrity and consistency. In MySQL, transactions are used to group several SQL commands into a single unit that either completely succeeds or completely fails, ensuring that a database remains in a consistent state.
Managing transactions efficiently in databases like MySQL is crucial for ensuring data integrity and...
Andrew Fletcher
•
Continuing on from the Drupal 9 to Drupal 10 upgrade outline written...
Andrew Fletcher
•
To run a SQL command using Drush, use the following sql-query command
drush...
Andrew Fletcher
•
Drush open_basedir restriction error
PHP Warning: include(): open_basedir...
Andrew Fletcher
•
These steps are for Drupal 8 and 9.
Export your database
Order here is...
Andrew Fletcher
•
Resources - changing Drush
Type
Version
Drush (current)
11.6.0
Drush (update)
12.2.0
Updating Drush went OK on all testing environments until on to the staging environment.
The initial error that I saw was
PHP Fatal error: Declaration of Drush\Style\DrushStyle::confirm($question, $default = true) must be compatible with Symfony\Component\Console\Style\SymfonyStyle::confirm(string $question, bool $default = true): bool in...
Andrew Fletcher
•
How to set the Private file path in Drupal using the following steps:
Create a...
Andrew Fletcher
•
Using Composer to Manage Projects and if required their dependencies
In this...
Andrew Fletcher
•
Goal: I want to download a table list to a txt or csv file.
Initially, as a root...
Andrew Fletcher
•
If your Composer project doesn't have Drush listed as a dependency, you can...
Andrew Fletcher
•
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
> mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227)
In SqlCommands.php line 242:
Unable to dump...
Andrew Fletcher
•
Working through and importing JSON data into a content type.
Drush...
Andrew Fletcher
•
After cloning a site, next you will want to import the config file. Which...
Andrew Fletcher
•
This is a relatively quick process, beginning with dropping the database...
Andrew Fletcher
•
Import a database
lando db-import doj.sqlEnter the MySQL database
lando mysql...