37
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
•
Goal: I want to download a table list to a txt or csv file.
Initially, as a root...
Andrew Fletcher
•
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
lando drush cex
If you know your MySQL filename, you can always chain these commands:
lando drush sql-drop -y && lando db-import riverdev.2022-10-03-1664769553.sql.gz && lando drush cr &&...
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...
Andrew Fletcher
•
Finding the issue with a server 500 error
The Nginx error logs are showing too...