Learning MySQL

Carlwill · 2010-06-20 19:34:40

I have a server at home and would really like to learn basic DBA tasks and administration so I installed MySQL on Linux & read their FAQ page which shows me how I can secure and properly configure MySQL post installation. That was very fun and straight forward. My question is now that I have MySQL up and running, I really don't have any need or functionality for it yet simply because I am still learning how it works and how to properly use it. I would like to know if anyone has any suggestions for easy tasks I can do with MySQL that will give me some goals and learn how to become a DBA in the process? I am just looking for some generic basic tasks I can use MySQL for that will allow me to create tables, databases, queries, and other tasks.

Thanks for any assistance...

rwd · 2010-06-20 20:48:24

I'd say build a little test-website, with a php or python front-end. You'll learn most by just experimenting and reading the documentation. Or install a ready-made web application like Wordpress and mess with it.

Carlwill · 2010-06-20 21:35:23

I installed MediaWiki which had a web based installer and it uses a MySQL backend. I manually created the database and a user with grants on that specific database for the Wiki. Then the MediaWiki installer created all the tables and data with in the database. It was pretty point and click easy but for the most part interesting.

my0pic · 2010-06-21 02:21:39

Carlwill wrote:

I have a server at home and would really like to learn basic DBA tasks and administration so I installed MySQL on Linux & read their FAQ page which shows me how I can secure and properly configure MySQL post installation. That was very fun and straight forward. My question is now that I have MySQL up and running, I really don't have any need or functionality for it yet simply because I am still learning how it works and how to properly use it. I would like to know if anyone has any suggestions for easy tasks I can do with MySQL that will give me some goals and learn how to become a DBA in the process? I am just looking for some generic basic tasks I can use MySQL for that will allow me to create tables, databases, queries, and other tasks.
Thanks for any assistance...

Last summer I combined the learning with our large digital pics collection. Using bash scripts, exiftool and imagemagick the home server processes
pics placed in a watch folder: extracts required exifdata according to camera model (creation date, faces detected, geolocation, unique id's etc) creates resized copies of the originals for everyday use then inputs all data into mysql.

I designed (I use the term very loosely!) a php frontend to search by date and then went on to add taging and album sorting to it.
It has been a great project to work on. I've gained a much better understanding of mysql, php, bash, apache, html5, etc

Can do the same for music or any other collection you can think of.

There's also alot of tutorial sites out there (php mainly) that run thru examples creating different databases for employees, stock, media etc, both basic and relational. Just google your heart out

Carlwill · 2010-06-21 02:28:04

Thanks man. I think that sounds fun and music would be a fun place for me to start...

Arch Linux

#1 2010-06-20 19:34:40

Learning MySQL

#2 2010-06-20 20:48:24

Re: Learning MySQL

#3 2010-06-20 21:35:23

Re: Learning MySQL

#4 2010-06-21 02:21:39

Re: Learning MySQL

#5 2010-06-21 02:28:04

Re: Learning MySQL

Board footer