Join Sheeri Cabral for an in-depth discussion in this video Connecting to an INI file, part of Understanding MariaDB for MySQL Users.
- View Offline
…CSV is not the only type of text file you can connect to.…An INI file is a configuration file,…also known as a CNF file that has pairs of variables and their values.…One example of this is MySQL's own my.cnf file.…We have provided an example in the exercises.…So let's take a look at it.…It should be in var/temp/my.cnf.…You can see that there are three groups, mysqld, mysql.server, and mysqld_safe.…
In each group, there are variables set to specific values.…Each group sets the log error and pin file options, which we will look at in a bit.…We can make this configuration file into a table quite easily with the CONNECT…storage engine.…In fact, there are two different ways to do that.…With a column layout or with a row layout.…I will start with an example of the row layout because it works better with…configuration files that have sections with a lot of different items.…In a row layout, each row is a key value pair.…So, let's connect to our database giving the PASSWORD.…
And database is the connect database.…So let's CREATE a TABLE, we can give it any name we want.…
- Why use dynamic columns?
- Creating, updating, and querying dynamic columns
- Installing the CONNECT storage engine
- Connecting to remote data
- Connecting to CSV, INI, and XML files
- Using PIVOT tables
- Accessing database metadata
- Working with the Cassandra storage engine