-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Jon Drukman
Sent: Thursday, August 21, 2003 9:24 PM
To: [EMAIL PROTECTED]
Subject: Re: RAID or not?
Lefevre, Steven wrote:
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace. It offers
no performance benefit, and actually the computer might have to work harder
to make sure the drives are in sync.
Disk striping makes things *fast*, BUT THERE IS NO PROTECTION.
Hey folks -
Thanks to everyone who gave input to my concerns. Of course, we don't intend
to have the mysql port open to the world. We will have Apache/PHP connect on
a unix socket, or to another machine with a cross-cable on non-routeable
IPs.
But now I have another question. We are working on
Hey folks -
While contemplating the design of a secure web database, an idea struck me.
I'm thinking of submitting it as a feature request, so please critique it.
I'm having php handle user logon with it's .htaccess emulation. I'm storing
usernames and password hashes in a table. The problem is
I'm working on a website/database deal, and right now I'm designing the
security model.
It's using LAMP(HP), so all the tricks are going to be through PHP.
First off, this will be behind a firewall with SSL encryption. We may also
setup some kind of VPN tunneling.I'll be ignoring other security
Hey folks-
'nother question.
I'm not an SQL expert, and I think I need a subselect, which means I need a
workaround on MySQL 3.23 or whatever version it is.
Here's the tables I have, with the relevant columns:
Students
- Name
- StudentID (PK)
- ClassID
Classes
- ClassID (PK)
- Name
Each
I'm developing a web-site database. There is a form on one page where a user
can search for a student by typing in a last name and submitting it.
Sometimes there can be more than one student with the same last name, so I
want the user to be able to type in Smith, J (where normally they type
Can you post this script? (Minus the passwords, etc.)
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: 'Jonas Widarsson' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 11:18 AM
Subject: RE: Backups mechanism
What we have done it right a small script:
- Original Message -
From: Ryan Fox [EMAIL PROTECTED]
To: Lefevre, Steven [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 11:33 AM
Subject: Re: Weird WHERE clause possible?
Backing up, is the problem that you need to uniquely identify the
student's
name after
mysql still doesn't own the mysql directory.
OK, I changed that for /usr/libexec
[root@server /]# ls -la /usr/libexec/
total 4008
drwxr-xr-x7 root root 4096 Dec 11 15:28 .
drwxr-xr-x 16 root root 4096 Nov 27 09:32 ..
...
drwxr-xr-x3 mysqlmysql
OK, I'm making progess on my MySQL problem. The log file says this:
021211 15:32:05 mysqld started
021211 15:32:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
021211 15:32:05 mysqld ended
I've run the mysql_install_db script when I first installed mysql. I ran it
Hey folks -
Linux newbie here.
I have RH 8.0 installed on a machine. I did an RPM installation of MySQL
3.23 (or whatever the current 3 series is).
When I try to start the safe daemon, I get this:
[root@server ]# /usr/bin/safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
Before I get 1000 RTFMs,
I found on google references to an error file. I did a search (after
rebuilding the 'locate' database) and found no error file! :(
Also, no results returned on the mysql mailing list archive.
- Original Message -
From: Lefevre, Steven [EMAIL PROTECTED
13 matches
Mail list logo