38
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
•
These steps are for Drupal 8 and 9.
Export your database
Order here is...
Andrew Fletcher
•
Lando is a local development environment tool, and it might not directly support...
Andrew Fletcher
•
Lando is a development environment tool that makes it easier to set up and...
Andrew Fletcher
•
Create a Lando setup running Drupal 10.
The command you provided appears to be a...
Andrew Fletcher
•
Install the CKAN package
Begin by cleaning up your server environment. Do this by updating Ubuntu’s package index:
sudo apt updateNow you can install the packages that CKAN requires (including ‘git’, which will allow you to install CKAN extensions):
sudo apt install -y libpq5 redis-server nginx supervisorResponse
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
fontconfig-config...
Andrew Fletcher
•
If you're planning to create extensions, generating CKAN from source is the...
Andrew Fletcher
•
CKAN extensions - adding to your installation
Following the information...
Andrew Fletcher
•
Goal: Restrict content access through username and password entry on an Nginx...
Andrew Fletcher
•
This page will be a progressive outline of moving those regular run scripts that...
Andrew Fletcher
•
Goal: I want to download a table list to a txt or csv file.
Initially, as a root user I tried using drush
drush sql-dump --tables-list=media_field_data > db-list.sqlOf course as a root user and Drush set-up not as root. failed with
Command 'drush' not found, did you mean:
command 'rush' from deb rush (1.8+dfsg-1.1)My bad.
Changing the user away from root and running the command again
drush sql-dump --tables-list=media_field_data > db-list.sqlProduced a permission error
bash:...
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...
Andrew Fletcher
•
Reviewing CKAN extensions and listing the extensions that have been created /...
Andrew Fletcher
•
Location of the base templates
cd...