Join Sheeri Cabral for an in-depth discussion in this video Using the exercise files, part of MariaDB for MySQL Users.
If you're a member of Lynda.com, you have access to the exercise files I use in this course. I have the files here in a folder on my desktop called Exercise Files and you can download them from the course page. Because I am using a virtual machine, I need to transfer the files in order to use them. You should put them somewhere on your system where your MariaDB database server can access them. I'll use the Cyberduck FTP program and put the files on my server in the var/temp folder.
So I will connect to my server and then, instead of my home directory, I will go to var and then temp. And then I will copy all of the exercise files right into that directory. Then in the terminal on the virtual server, I'll change directory to var/temp using the cd, for change directory, var/temp command. I need to allow MariaDB to read and write these files. To do this I will change the ownership to the MySQL user using the chown command.
Because I am changing the files to an owner that's not me, I'll need to use the sudo command to run the chown command as the root user. And I'll have to enter my password. You will also need to make sure that MariaDB can at least read the exercise files. And if you want the database to be able to change the data inside of them, you'll need to make sure MariaDB can write to the files. Now that the exercise files are in place and allow MariaDB to access them, let's get going with MariaDB's great features.
- 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