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
113
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
•
Working in Twig, I had to add classes to a pre-existing array. Whilst I've...
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 do, install and familiarise yourself. Below is a working list:
Products
URL / install path
Notes
Homebrew
https://brew.sh
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
Docker
https://docs.docker.com/docker-for-mac/install/
Visual Studio Code
https://code.visualstudio.com
Sequel Ace
App Store
1Password
App...
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...