Skip to main content
27
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
To add ejabberd and run MYSQL to the server I needed to update the server...
Andrew Fletcher
How to apply a gradient tint over a background image? Set the background image The first step is to set the background image.  I wanted the image to cover the entire device, so scale aspect fill will be required. self.backgroundImage = UIImageView(image: UIImage(named: "bgkMain")) self.backgroundImage.contentMode = .scaleAspectFill self.view.insertSubview(self.backgroundImage, at: 0)  Set the tint layer With the background in place, next construct the tint layer.  To make...
Andrew Fletcher
Working on formatting the date in Xcode, and you come across the situation where...
Andrew Fletcher
Adding a floating decimal point for n number of places is quite easy to achieve....
Andrew Fletcher
The starting point is to read through and follow the notes outlined on the...
Andrew Fletcher
During the process of building the app, there are warnings about the code....
Andrew Fletcher
https://github.com/kylebrowning/waterwheel.swift After a short amount searching I came across Kyle Browning Waterwheel Pod.  I flipped down to installation and there it is in three steps.  Super.  But wait.  Step one, CocoaPods.  What are pods? https://cocoapods.org/ Easy to follow, in no time cocoapods are added. Using terminal you need to initialise the pod to the directory where the Xcode project is located. cd ~/Path/To/Your/Project/ pod init pod update This...
Andrew Fletcher
If you have this error, the core issue is the dyld issue. dyld dyld is a...