Three Rock Songs That Influenced Me

I may have written about this in my blog already, but I can do it again.

In the early 1970s instead of getting a Yamaha Electone organ from my Dad, I got instead a plain chord organ.

I did play this chord organ a bit...firstly learning to play Christmas carols, then in the mid-1970s could play ABBA material ear.

But it wasn't until about 1979 when the chord organ was in the basement and I had basically gotten over my fear of going downstairs. There was a demon jinn named Aern there and he used to scare me just by being there and watching me.

In fact, even in '79 when I'd be all alone in the early evening, where I got the courage to go downstairs, turn on the table radio and play the chord organ to the music on FM radio.

The three songs that I really got to like playing along with were:

Gerry Rafferty
Baker Street
Rel. Feb. 1978
Video: link

Dire Straits
Sultans of Swing
Rel. Jan. 1979
Video: link

Herb  Alpert
Rise
Rel. Sept. 1979
Video: link

and also this one

Blondie
The Tide Is High
Rel. 1978
Video: link

I used to get soooo emotional when I played these songs, especially Rise, because it is such a feel good melody.

Importing MySQL Database Into LibreOffice Base

Ten years ago I had played around with MySQL in Linux.

I had designed a few flat-file tables to catalogue my book collection as well as my family's book collection.

These files have been backed up over the years and have the .sql filename suffix.

The tables were created using MySQLAdmin and MySQLWorkbench.

Somewhere near the time that Oracle bought Sun, MySQL was updated and the way to initially set up MySQL had changed.

So I stopped using it.

In the intervening years I had learned a lot about spreadsheets - MS Excel 2010 and LibreOffice Calc 3, 4, and now 5.

So now I'd like to import these tables into LibreOffice Calc  by connecting via MySQL.

I know as a first step I needed to install MySQL server. DONE.

I know that I also needed to install PHP. DONE.

MySQLPHPAdmin is where I'm having problems with. This is the newer way of setting up and maintaining tables and access lists (Access Control List) in the DBMS.

I regret now not making any notes here or in a Writer file, something that I could have used to help me regain access to the MyBooks.sql file.

Getting it to work will require manually editing the .php file and I believe once I do get that that the Admin console will work.

Until then I'm just learning LO Base 5 and viewing MS Excel and Access tutorials on YouTube.

The database engine that LibreOffice Base uses is the Java-based HSQLDB 2.x.

To make a query on some data in a table, for example, use:

SELECT "Business Name", "Full Address", "Postal Code" FROM "Database Table"

The box to enter and edit queries in SQL format directly isn't as good as in MySQLQuery. That is because the text box font is super super tiny on my screen.

Toddler Tantrums - Boys Town Center for Behavioral Health