33
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
•
When executing the following command, the response I'm getting is
npm ERR! code...
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 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
•
Resources - changing Drush
Type
Version
Drush (current)
11.6.0
Drush...
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 install Drush from command line as follows:
composer require drush/drushTo check your version of Drush, use
drush --version
Status check
drush statusWill output something similar to
Drupal version : 10.1.1
Site URI : http://default
DB driver : mysql
DB hostname : mysql
DB port ...
Andrew Fletcher
•
I've recently upgraded the server Ubuntu 20.04 updating the PHP version from 7.4...
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...