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
98
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
•
Updating Drupal from 8.7.10 to 8.8.x or 8.9.x has seen a significant change as it has now moved into 9.x. It has integrated more with composer, and you can be caught by fatal errors occurring during the update process. One of these errors for me was the php version.
Site version as set through Plesk is PHP 7.3.12
Using ssh via Terminal the command
php -v
PHP 7.1.33 (cli) (built: Oct 25 2019 11:33:58) ( NTS )
Whereas, composer update was showing
Problem...
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...
Andrew Fletcher
•
I need to set the default php-version of a subscription to php7.3. The...