RE: Unix and Apache Administration

From: "DaShiell, Jude T. CIV NAVAIR 1490, 1, 26" <jude.dashiell@xxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Date: Mon, 1 Feb 2010 15:44:21 -0500
With mysql, after you get it installed, you can't just go around
creating databases because mysql won't let you do that for a very good
reason.  First you must create a user with the createuser program then
you can use the createdb program to create a database for that user that
was just created.  Then you have to be that user and can type mysql <cr>
in which case you'll be brought up using the sql monitor in that
database.  If a user has more than one database, mysql database-name
<cr> will get you the particular database you want.  Then it's time to
create tables and operate on them and their contents.  The first
database created for a user must match that user's login id otherwise no
automatic association gets done to that user's account. 


Rot47: <;F56]52D9:6==@?2GJ]>:=>
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Homme, James
Sent: Monday, February 01, 2010 15:09
To: programmingblind@xxxxxxxxxxxxx
Subject: Unix and Apache Administration

Hi,

Lately the books I've looked at tell how to do work on a Unix system in
a GUI environment. Does anyone have guidance about what I can read to do
tasks from the command line? Here's a partial list. I don't know what
else I may need. I'd be fine with instructions on a shell script to
combine stuff if necessary or whatever.

 

Download a compressed tar file from the web.

Unpack and untar it so that it goes into a folder.

Use MySQL to create a database.

Back up a MySQL database regularly. I want to make this incremental
backups so I don't have to totally restore, but can roll back to a
particular day, as in just bring back everything since yesterday.

Back up files or folders regularly Into a compressed tar archive

Restore a MySQL database if necessary.

Restore files or folders regularly.

Run a PHP file using cron on a schedule.

Make small edits to the Apache configuration files or other files as
needed.

Delete backed up files or incremental database files after a certain
time period to save space.

 

That's all I know of so far.

 

Thanks.

 

Jim Homme,

Usability Services,

Phone: 412-544-1810

 

Internal recipients,  Read my accessibility blog
<http://mysites.highmark.com/personal/lidikki/Blog/default.aspx> 

 


________________________________

This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed.
If you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended recipient,
you must not keep, use, disclose, copy or distribute this e-mail without
the author's prior permission. The views expressed in this e-mail
message do not necessarily represent the views of Highmark Inc., its
subsidiaries, or affiliates.

__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
References:
- Unix and Apache Administration
  - From: Homme, James
RE: Unix and Apache Administration

Other related posts:
