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.