Re: A new Machine

2004-08-23 Thread Egor Egorov
Info [EMAIL PROTECTED] wrote: After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to = rob the piggy bank and build a new linux mysql server. This seem to be a good fruit of your repentance. :) I'm not rich, but what hardware and distro do you experts suggest? (My =

RE: A new Machine

2004-08-23 Thread christopher . l . hood
. -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 7:24 AM To: [EMAIL PROTECTED] Subject: Re: A new Machine Info [EMAIL PROTECTED] wrote: After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to = rob the piggy bank and build a new linux mysql

Re: A new Machine

2004-08-22 Thread Mike Wexler
Chris McKeever wrote: On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote: After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy bank and build a new linux mysql server. Here's my problem: I have, at present, two rather large databases. (A:

Re: A new Machine

2004-08-22 Thread Chris McKeever
On Sun, 22 Aug 2004 16:40:24 -0700, Mike Wexler [EMAIL PROTECTED] wrote: Chris McKeever wrote: On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote: After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy bank and build a new linux mysql server.

Re: A new Machine

2004-08-22 Thread Mike Wexler
Chris McKeever wrote: RAID 5 is the wrong answer. If reliability is a big deal do mirroring. Otherwise get as much memory as you can afford and use any money left over to get the fastest disk drives you can afford. If you have multiple disks, spread things between different drives. OS on

A new Machine

2004-08-21 Thread Info
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy bank and build a new linux mysql server. Here's my problem: I have, at present, two rather large databases. (A: 4Million records in one table, 15 Million in another; B: 1.5Million and 5Million) The

Re: A new Machine

2004-08-21 Thread Chris McKeever
On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote: After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy bank and build a new linux mysql server. Here's my problem: I have, at present, two rather large databases. (A: 4Million records in one

Re: A new Machine

2004-08-21 Thread Larry Lowry
ASUS MB out that supports dual channel ddr memory for the Athlon 64. Should be really good. Just my 2 cents worth. Larry - Original Message - From: Chris McKeever [EMAIL PROTECTED] To: Info [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 1:19 PM Subject: Re: A new

Re: Moved MySQL to new machine.

2001-07-27 Thread Sommai Fongnamthip
try to see more detail in INSTALL, it tell us about file and directory permission. If you have more problem with /var/any dir why did not use /statedir=/usr/mysql/data while configure to relocate MySQL data directory insteady use in /var/... Sommai Fongnamthip At 11:47 26/7/2001 -0500,

Re: Moved MySQL to new machine.

2001-07-27 Thread Stefan Hinz
, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Jeremy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:29 AM Subject: Moved MySQL to new machine. I recently moved my MySQL databases from one RedHat Linux 6.x machine

Re: Moved MySQL to new machine.

2001-07-26 Thread Gerald Clark
13 is access denied. Your /var/lib/mysql ( Or whatever ) is owned by root, and mysql can not create a new directory. Jeremy wrote: I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat 7.0 machine. Now, I can't seem to add databases. I get the following

Moved MySQL to new machine.

2001-07-25 Thread Jeremy
I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat 7.0 machine. Now, I can't seem to add databases. I get the following error message: mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'jrtest'. (errno: 13)' And, I think I lost some