41
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
•
When Solr is displaying results on the site, first step is to log in the server...
Andrew Fletcher
•
Having updated Solr, re-indexing wasn't working. The error in the logs...
Andrew Fletcher
•
On an Ubuntu 20.02 system with Nginx, you can utilize the following commands to...
Andrew Fletcher
•
Cleaning out or clearing data in Solr can be done in a few different ways,...
Andrew Fletcher
•
In an environment that is running
Ubuntu 20.02
Nginx
Solr
The default Nginx conf is located /etc/nginx/sites-available/ and contains something similar to:
server {
listen 80;
listen [::]:80;
server_name uat.oursite.com;
return 301 http://uat.oursite.com$request_uri;
}
server {
listen 80;
listen [::]:80;
listen 443 ssl;
ssl_certificate /etc/ssl/certs/Bundle.crt;
ssl_certificate_key /etc/ssl/private/MultidomainWildcard.key;
# Security...
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
•
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
•
Whilst attempting to download the latest config.zip file for Solr, I was greeted...
Andrew Fletcher
•
Setting up the admin password.
Process:
1. Edit jetty.xml
To begin you...
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...