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
128
results
Andrew Fletcher
•
When attempting to backup mysql using the mysqldump command
mysqldump -u root -p database_name > backup.sqlHowever, it is throwing an error:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespacesWhat to do?
Reading through the mysqldump documentation, you need use --no-tablespaces. So the command becomes
mysqldump -u root -p database_name > backup.sql...
Andrew Fletcher
•
To remove all the contents from a directory, you need to ask yourself:
Do I want...
Andrew Fletcher
•
How to Create New MySQL User
Before you can create a new MySQL user, you need to...
Andrew Fletcher
•
This short guide explains to you how to extract/unzip .zip archive files to a...
Andrew Fletcher
•
I prefer htop over top on my Linux server. Running a Solr index got...
Andrew Fletcher
•
The generally accepted answer to a mysqldump is:
mysqldump -h [host] -u [user] -p [database_name] [table_name] > [file].sqlOr a variant there of... Of course if you are logged in to the server and working from it you don't need to express the -h [host]
mysqldump -u [user] -p [database_name] [table_name] > [file].sql
But no not for me. I wasn't seeing the success story of a downloaded database file. Instead I was warmly embraced by error land:
mysqldump: Got...
Andrew Fletcher
•
Wanting to create a new repository on GitHub, add in a few of the available...
Andrew Fletcher
•
On a git pull from remote dev environment to a staging environment running off...
Andrew Fletcher
•
I needed the check if a file existed in a directory as the migrate script wasn't...
Andrew Fletcher
•
Joining a new company / team there is always a lot of new items to...
Andrew Fletcher
•
A bug bear that I have had for a while with Drupal content is how come the author of an article is actually their username. I have an array of reasons to vent my dislike for this strategy... however, instead I will show you how to change it. Albeit, programmatically! Don't stress there actually isn't a huge amount of code to add. In time I'll create a module so no coding is required.
Setting up account fields in the admin area
To begin let's add new fields for...
Andrew Fletcher
•
Updating Drupal from 8.7.10 to 8.8.x or 8.9.x has seen a significant change...
Andrew Fletcher
•
As outlined in an earlier article composer php version, when installing the...
Andrew Fletcher
•
I had been running a few Centos 6 servers just past their EOL (30th November...
Andrew Fletcher
•
Regular expressions (regex) are extremely useful in extracting information from...