Skip to main content
31
results
Andrew Fletcher
Working on an Azure server I ran a mysqldump command to generate a copy of the db.  No issues, the file downloaded on to the serve without cause.   The Problem On my local environment, using Sequel Ace I imported the file, but it suddenly it stopped with a red message “Unknown collation: ‘utf8mb4_0900_ai_ci‘” [ERROR in query 14] Unknown collation: 'utf8mb4_0900_ai_ci'“Collation is the assembly of written information into a standard order. Many systems of collation are based on...
Andrew Fletcher
When attempting to backup mysql using the mysqldump command mysqldump -u root...
Andrew Fletcher
How to Create New MySQL User Before you can create a new MySQL user, you need to...
Andrew Fletcher
The generally accepted answer to a mysqldump is: mysqldump -h [host] -u...
Andrew Fletcher
A recent attempt to run an update composer (regular activity for many of...
Andrew Fletcher
I'm writing these steps primarily for myself as a reference.  However, if someone else finds them useful to great. Adding XMPP framework to your server.  Initially I was going to add Prosody, however as I'm working off an Apache server with Centos 6.10 this quickly proved to a goal that was out of reach.  Instead, I pivoted and redirected to Erlang.   Is your server hardware running Linux, BSD, OS X, or Windows? Can you use Java or Python or another language if the server...
Andrew Fletcher
I need to set the default php-version of a subscription to php7.3.  The...
Andrew Fletcher
Attempting to load changes in a staging site and the bountiful error page...
Andrew Fletcher
(104)Connection reset by peer: mod_fcgid: error reading data from FastCGI...
Andrew Fletcher
To add ejabberd and run MYSQL to the server I needed to update the server...
Andrew Fletcher
This page shows a growing list of common commands for viewing and managing your Centos server. ls syntax $ ls [options] [file|dir] ls command main options: ls -a list all files including hidden file starting with '.' ls --color colored list [=always/never/auto] ls -d list directories - with ' */' ls -F add one char of */=>@| to enteries ls -i list file's inode index number ls -l list with long format - show permissions ls -la list long format including hidden files ls...
Andrew Fletcher
Whilst updating nodejs and npm on a Centos 6 or 7 server running Apache, I...
Andrew Fletcher
Installing Laravel on an Apache server was going to be a no fuss process said no...
Andrew Fletcher
Registering a user via REST is an important process particularly when the...
Andrew Fletcher
The starting point is to read through and follow the notes outlined on the...