developer resources
Codebales holds an ever growing number of solutions to problems that we have experienced in our day to day code writing
Selected filter
53
results
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
•
Recently I have been investigating one of my Linux server's speed using the...
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 -h database
This action will change the prompt as you are now in mysql. The prompt will start with
mysql>Now change to the database that you want to use
use doj;If you want to know what databases exist, then run
show databases;Response
+--------------------+
| Database |
+--------------------+
| information_schema |
| doj |
| mysql |
| performance_schema |
| sys ...
Andrew Fletcher
•
I had generated a backup of key directories on the server - see Create a...
Andrew Fletcher
•
Currently, I have a situation where I have two repositories. The first is...
Andrew Fletcher
•
Creating a bash script
Bash scripts are files containing code that tell your...
Andrew Fletcher
•
Accessing a remote server using PEM key, and I had the following...
Andrew Fletcher
•
How do you generate a .pem file from an existing .ppk key?
Is putty on your mac?
Check by running the command
puttygen -VWhich will generate a response similar to
puttygen: Release 0.76
Build platform: 64-bit Unix
Compiler: clang 12.0.5 (clang-1205.0.22.9)
Source commit: 1fd7baa7344bb....Don't have Putty, well easily fixed with homebrew.
brew install putty
Generate the key
We will use puttygen to generate the key.
puttygen key.ppk -O private-openssh -o key.pem
key.ppk
the...
Andrew Fletcher
•
How do you rebuild node access permissions using CLI?
To rebuild permissions...
Andrew Fletcher
•
Attempting to update the database, irrespective whether I run update.php or...
Andrew Fletcher
•
How do you exclude the current node from a list view?
In some situations, for...
Andrew Fletcher
•
Currently I'm working through an app that has been abandoned by the developers....