Re: mysqld-max-nt.exe as a service

2003-02-23 Thread Stefan Hinz
Rob, > How do I open mysqld-max-nt.exe as a service (so I don't have to see a DOS > console open for it all the time). Here is the command I use to open it > currently: > mysqld-max-nt.exe --console --standalone > Any help would be appreciated! Of the many ways to accomplish this, I prefer this

mirar

2003-02-23 Thread Alex Garcia
t e s t On Sun, 23 Feb 2003, Stefan Hinz wrote: > Rob, > > > How do I open mysqld-max-nt.exe as a service (so I don't have to see a DOS > > console open for it all the time). Here is the command I use to open it > > currently: > > > mysqld-max-nt.exe --console --standalone > > > Any help would

inquiry

2003-02-23 Thread Alex Garcia
I have installed mysql form the rpm files that are on rpm finder, acording to the installation it is working, and if I check with redhat-config-services it is running, how do I get mysql on the path so I can call mysql from any where? btw after checking my pc well I am too new to linux so sorry

Re: inquiry

2003-02-23 Thread KH Chiu
Your problems are really very common when switching from MS to Linux. Don't worry, as your experience with Linux grow all these problem will gone. First of all, MySQL database work in a Client/Server fashion. It means that you need to get the server up and running. To doing that, you can type th

Re: inquiry

2003-02-23 Thread Andreas
Alex Garcia wrote: I have installed mysql form the rpm files that are on rpm finder, acording to the installation it is working, and if I check with redhat-config-services it is running, how do I get mysql on the path so I can call mysql from any where? There are a few ways to do that. I've got

RE: Very basic question from a total newbie! MORE INFO

2003-02-23 Thread Stitchin'
I did exactly what Paul described ... I changed the directory at the dos prompt to c:\program files\apache group\apache2\htdocs\phpcatalog\admin and typed in mysql testcatalog < createdb_mysql my dos prompt brought up this error: 'mysql' is not recognized as an internal or external command, op

missing scripts

2003-02-23 Thread shirly cohen
Hi all, I installed mysql 3.23.41 on windows 2000 and in the scripts directory that created after the unzip i don't have the scripts "mysqlaccess" and mysql_install_db". The manual mentioned that they should be there. So where are they? Thanks

Re: Very basic question from a total newbie! MORE INFO

2003-02-23 Thread Solid Plasma (slpl)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Stitchin', Sunday, February 23, 2003, 3:39:41 PM, you wrote: > I did exactly what Paul described ... I changed the directory at the dos > prompt to > c:\program files\apache group\apache2\htdocs\phpcatalog\admin > and typed in > mysql testca

Re: LOCK TABLES error , on a select without any update ?

2003-02-23 Thread Heikki Tuuri
Steff, I am carbon copying this to [EMAIL PROTECTED] so that people see the problem was probably found. - Original Message - From: <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 23, 2003 5

Help to install Mysql on Macos X 10.2

2003-02-23 Thread [EMAIL PROTECTED]
I'm trying to install Mysql in Macos X 10.2 following the quick install steps. I'm a pro in the Unix command line and the configure command show this error in the configuration: [Akira:~/mysql-3.23.53] jeffreys% ./configure --prefix=/usr/local/mysql checking build system type... powerpc-apple-da

RE: Very basic question from a total newbie! MORE INFO

2003-02-23 Thread Stitchin'
When you say mysql.exe isn't in your path, what do you mean? It is right where it was installed - c:\mysql\bin\mysql.exe Should I move it somewhere else or copy it to somewhere else? Thanks so much! Renee :) -Original Message- From: Solid Plasma (slpl) [mailto:[EMAIL PROTECTED] Sent:

Re[2]: Very basic question from a total newbie! MORE INFO

2003-02-23 Thread Stefan Hinz
Stitchin', I don't want to be impolite, but please check some basics of your operating system (e.g. what a "path" is). Anyway, here's what you should enter (in a DOS window; C:\> is the initial DOS prompt): C:\> cd \program files\apache group\apache2\htdocs\phpcatalog\admin C:\program files\apa

Re: missing scripts

2003-02-23 Thread Stefan Hinz
Shirly, > I installed mysql 3.23.41 on windows 2000 > and in the scripts directory that created after the unzip i don't have the > scripts "mysqlaccess" and mysql_install_db". > The manual mentioned that they should be there. These scripts are needed for Unix-like systems. With the Windows insta

Re: Help to install Mysql on Macos X 10.2

2003-02-23 Thread Jeff Mao
By default, even on OS X servers, you do not have the C compilers. You need to install the Developer Tools which may have come on a CD with your Jaguar CD sets. Otherwise, it's a free download from Apple (http://www.apple.com/developer). You'll need to register to become a "developer", but it's f

RE: Re[2]: Very basic question from a total newbie! MORE INFO

2003-02-23 Thread Stitchin'
Thank you Stefan I don't mean to clutter the forum with such basic questions, but I haven't goofed around with dos prompt commands since the late 80's. The last decade or so I have to admit I've been trapped in the Microsoft world in my old career as a CPA and Controller. The last time I did

Re: Very basic question from a total newbie! MORE INFO

2003-02-23 Thread Solid Plasma (slpl)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Stitchin', Sunday, February 23, 2003, 4:38:17 PM, you wrote: > When you say mysql.exe isn't in your path, what do you mean? It is right > where it was installed - by that i understand/mean System Environment Variable Path > c:\mysql\bin\m

Speed improvment with packet proceeding!?

2003-02-23 Thread Julian
Speed improvement with packet proceeding!? I'm not quite sure is it possible with Mysql but it could be "easy" to be implemented. For example: select * from table where id=52 and name='some' select * from table where id=23 and email='[EMAIL PROTECTED]' these two queries select row(s) from table

Re: when to normalize out to a table

2003-02-23 Thread Michael T. Babcock
David T-G wrote: Well, I do, though I'm not surprised that I shouldn't. I still don't know anything about left, right, inner, and outer joins; they sound like belly buttons to me :-) The best thing to do is find a website with some sample data and sample queries and see how they actually work yo

Re: Help to install Mysql on Macos X 10.2

2003-02-23 Thread Jeff Shapiro
My guess is that you don't have the developer's tools loaded on your machine, or that there is something wrong with their configuration. You may want to try using Aaron Faby's Complete MySQL. It uses the Apple Installer to install MySQL 3.23.55. (That is double click on a installer package and foll

RE: Very basic question from a total newbie! MORE INFO

2003-02-23 Thread Paul DuBois
I did exactly what Paul described ... I changed the directory at the dos prompt to c:\program files\apache group\apache2\htdocs\phpcatalog\admin and typed in mysql testcatalog < createdb_mysql my dos prompt brought up this error: 'mysql' is not recognized as an internal or external command, ope

foreign keys across databases?

2003-02-23 Thread Tor R. Skoglund (NextG)
This might be a stupid question, but is it possible to have a foreign key reference to a table.column in another database? E.g.: FOREIGN KEY (parent_id) REFERENCES databasename.parent(id) Probably not, but are there any other ways to enforce such relations? Best regards Tor Rune Skoglund [EMAIL

Linuxthreads not found

2003-02-23 Thread Teddy
>Description: If glibc is installed under /usr/local the configure script does not find the Linuxthreads >How-To-Repeat: Install glibc under /usr/local (default) and run configure of mysql >Fix: Change the test of file /usr/include/pthread.h to /usr/local/include/pthread.h

mysql@lists.mysql.com

2003-02-23 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mys

Speed improvement with packet proceeding!?

2003-02-23 Thread Julian
Speed improvement with packet proceeding!? 1. Packet proceeding: I'm not quite sure is it possible with Mysql but it could be "easy" to be implemented. For example: select * from table where id=52 and name='some' select * from table where id=23 and email='[EMAIL PROTECTED]' these two queries

mysql@lists.mysql.com

2003-02-23 Thread aditya
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:aditya >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: foreign keys across databases?

2003-02-23 Thread Heo, Jungsu
You can do this. > E.g.: FOREIGN KEY (parent_id) REFERENCES databasename.parent(id) and I'm already using this kind of foreign key. Try yourself ! - Original Message - From: "Tor R. Skoglund (NextG)" <[EMAIL PROTECTED]> To: "mysql users" <[EMAIL PROTECTED]> Sent: Monday, February 24, 20

additions to mysqlimport?

2003-02-23 Thread Ray Kiddy
Hello - I am curious what extensions to mysqlimport people might be interested in seeing. I am importing some data with inconsistencies and and I find that mysqlimport helps one not at all. It seems to me that there are things it could do. For example: -rejected_lines= : would put all lines

RE: Speed improvement with packet proceeding!?

2003-02-23 Thread Don Read
On 23-Feb-2003 Julian wrote: > Speed improvement with packet proceeding!? > > 1. Packet proceeding: > > I'm not quite sure is it possible with Mysql but it could be "easy" to > be implemented. > For example: > > select * from table where id=52 and name='some' > select * from table where id=23

Re: additions to mysqlimport?

2003-02-23 Thread Paul DuBois
At 16:50 -0800 2/23/03, Ray Kiddy wrote: Hello - I am curious what extensions to mysqlimport people might be interested in seeing. I am importing some data with inconsistencies and and I find that mysqlimport helps one not at all. It seems to me that there are things it could do. For example:

MyISAM Database on multiple partitons

2003-02-23 Thread Anirudha Kukreti
hi, i have MyISAM database on my root pattition which is now getting full, however i have an empty 5Gb partion, how configure MySQL to now start storing my DB on to the new partition. In nut shell my question is how can we have a MyIsam database on multiple partions? thanks anirudh mysql, query

Re: MyISAM Database on multiple partitons

2003-02-23 Thread Bhavin Vyas
In my.cnf you can configure the Data dir path. Else, symlinks might work. - Original Message - From: "Anirudha Kukreti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 23, 2003 11:36 PM Subject: MyISAM Database on multiple partitons > hi, > i have MyISAM database on my

ANN: EMS MySQL Manager new release!

2003-02-23 Thread EMS HiTech Team
EMS HiTech company is very glad to announce MySQL Manager for Windows 2.1 and MySQL Manager for Linux 1.1 -- the new versions of our powerful tools for MySQL administration and development! You can download the latest versions and user's guides from http://www.mysqlmanager.com/download.phtml What

MySQL & ZeosDBO - A newcomer question

2003-02-23 Thread Crescendo Napitupulu
Hi, I'm a newcomer and very interested to use MySQL with ZeosDBO. I would like to ask to anyone in this list who has experience in using ZeosDBO, what component(s) and settings should I make in order to use INSERT, DELETE and UPDATE ? I would also really appreciated for an example. Best Regard

RE: Speed improvement with packet proceeding!?

2003-02-23 Thread KH Chiu
I know very LITTLE about the internal working of MySQL. So, I am not the right people to comment it. However, from my experience MySQL is quite optimized for some operation but not for all. I think Julian actual suggested a very good idea on the searching optimization for single user. At presen