Linux Today: Linux News On Internet Time.

MySQL 101: Working with the MySQL DB on Linux

Aug 31, 2010, 03:05 (0 Talkback[s])
(Other stories by Joe 'Zonker' Brockmeier)

" Some people are born to be a database administrator, and others have database administration thrust upon them. If you're in the former group and you need to perform some very basic operations, like creating and backing up databases, you'll find it's much easier than it sounds. Let's take a look at some very basic MySQL administration to get started.

"When I say basic, I do mean basic. This tutorial will not make you a database administrator or MySQL expert. But you'll have enough MySQL to get by for some standard scenarios like setting up WordPress or doing a quick backup of a MySQL database.

"You can also do these things with phpMyAdmin, and many folks do, so why look at the command line? The first reason is that using the command line client provides one less piece of software to install, maintain, and worry about. If you find yourself interacting with MySQL infrequently, there's not much reason to worry about installing a separate piece of software to interact with it."

Complete Story

Related Stories: