MySQL Custom Install on Windows Startup Issue

OS: MS Windows 10

MySQL: Developer Computer configuration 8.0

Other: Custom path install, configured to NOT work as a service

Considerations: The software was recently installed, and ran properly when it was started through the installer. Nothing was changed on the installation of the software, but the host has been restarted

Issue: MySQL server will not start through the Workbench, and running

%MYSQL_HOME%\bin\mysqld.exe

will generate issue with missing data directory. If this data directory is not the correct %Program Data% specified, this means that the mysqld.exe does not have access to configuration file

my.ini

Solution: Place a copy of file my.ini in the root directory of Windows

(ie "C:\Windows").

Execute mysqld.exe once again and minimize its terminal

SOURCE: https://dev.mysql.com/doc/refman/5.5/en/windows-troubleshooting.html

 

Advertisements

xmlTreeParse Fails with error “XML content does not seem to be XML”

Code below is run in RSTUDIO.

  • fileURL is the variable that holds the internet location of the XML file in question
  • doc is the variable to store the output of xmlTreeParse

> fileUrl doc <- xmlTreeParse(fileUrl,useInternal=TRUE)
Error: XML content does not seem to be XML: ‘https://www.w3schools.com/xml/simple.xml&#8217;

SOLUTION: Install package RCurl and use function getURL on the link to the XML file  first

install.packages(“RCurl”)
WARNING: Rtools is required to build R packages but is not currently installed. Please download and install the appropriate version of Rtools before proceeding:

https://cran.rstudio.com/bin/windows/Rtools/
also installing the dependency ‘bitops’

trying URL ‘https://cran.rstudio.com/bin/windows/contrib/3.5/bitops_1.0-6.zip&#8217;
Content type ‘application/zip’ length 38894 bytes (37 KB)
downloaded 37 KB

trying URL ‘https://cran.rstudio.com/bin/windows/contrib/3.5/RCurl_1.95-4.12.zip&#8217;
Content type ‘application/zip’ length 2968691 bytes (2.8 MB)
downloaded 2.8 MB
> library(RCurl)
Loading required package: bitops
> xData <- getURL (fileUrl)
> doc <- xmlTreeParse(xData)
> doc
$doc
$file
[1]

My Top 5 Excuses for Not Sticking with my Online Training Schedule

NUMBER 1: It is one of the following seasons: Summer / Autumn / Winter / Spring

Let’s face it: It is NEVER a good time to study. All of the seasons are our favorites. Summer wants us out under the sun, battling skin cancer and fighting with all the other people on their short vacation leaves, aggressively claiming right of territory to any camping spot, any mountain trail, any shade on the beach. Nights are hot, and the fan is making too much noise to let us indulge into some self improvement. Winter? Finally, some chill weather to do some training, maybe play in the snow, enjoy nature without anybody else. Nights are spent getting those precious calories, which will better help us deal with the cold. Spring, Autumn? PLEASE… The nature at its best, the forest alive and vibrant with colors, the pool waiting for us to shed all that weight we got consuming all that ice cream (in the summer) or all that un-necessary fat we instinctively got through the winter

NUMBER 2: Unable to Focus

Despite being totally the wrong season, you set the training course on the right screen, and Gmail to the left screen. Roughly 1 minute into the course, a Hangout message or an email (from a site that complains you have not used it for ages) is enough to disrupt the force and have you thinking of supermarket duties in no time. Or what about the painful moment at work, that miraculously comes back to mind, the moment you attempt to dive into your course? And are all the bills of the month paid?

NUMBER 3: There is Always Tomorrow

…until, 4 months later, you realize you have been dutifully paying your online subscription, for no reason whatsoever

NUMBER 4: The Speaker Allegedly Sucks

Listening to somebody speak in public, whether it is an office meeting room, an auditorium, a car or a living room, is vastly different from having somebody directly inject sound into your ears, through headphones or speakers. It is a much more direct and personal communication, which might seem intrusive. And that without saying anything about speech tempo, voice pitch and any passive sounds that get into the recording (breathing, environment noises, bodily sounds) that might be off-putting for a certain listener

NUMBER 5: Rationalizing Incorrect Decisions

We have all done it, right? Did something wrong, then tried to convince ourselves that it was right. One of those “adult” traits, to bind ourselves to a habit in the fear of replacing it with something worse. I try to think of it like this: If I am attempting to decide in the opposite way of something I have already decided in the past upon, then I am rationalizing an incorrect decision. Getting OFF a schedule in the end, proves as equally painful as staying ON the schedule, with the added problem that no progress is being made

Here is how Dr. Sketch, the good genie of this blog, puts it:

img_0124

 

 

 

 

COURSERA On-Again, Off-Again

I have been dwelling with keeping a solid training regiment the past few months. I see in my payments for the site that i had 4 months paid, with no progress or certificates earned whatsoever. It has been hard, to stay on schedule, studying and making posts here. There was no motivation. There was no mood, no inspiration. And nothing moved ahead. And it came at a cost. There was a question during an interview that I could have replied, and I did not. This last part, could lead to an entirely different topic, the sheer amount of unsuccessful interviews i have gone through. Maybe it is a different topic. Maybe it is two “Communication Vessels”, my discipline to do online training at home, and job interviews and the liquid of the experiment is the frustration from the lack of progress.

Here is below a scientific depiction of the issue:

img_0109