I am new to mysql and unix and need to take up responsibilites as dba - until now a vb developer

Posted on 2011-10-21
Last Modified: 2012-06-16
How much of unix I need to know,
and what is the good way to start learning MYSQL and gaining confidence on both unix and MYSQL for this functioning. Thank you
Question by:Jsara
    1 Comment
    LVL 19

    Accepted Solution

    With your VB background, shell scripting shouldn't be too much of a reach.  If you're still into non-screen based knowledge, the O'Reilly series of box (Unix shell scripting, Running Linux, etc.) are incredibly good resources.  They also publish an intro one for MySQL, and several more advanced ones (Stored Procedures, etc.)

    I know this is kind of a vague answer to a wide question, but I was where you are about 15 years ago, and am a fully self taught Unix admin/DBA now - the key is to play, play, play!  Get an old laptop or server or something, and installed Linux - Apache - MySQL - PHP (aka "LAMP") and write some simple web sites that display the contents of your database in table form - really helps you to see how it all fits together.

    Good luck, and welcome!

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    This video discusses moving either the default database or any database to a new volume.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now