Fwd: NDN: automatic server start paramaters
Dear MySQL list monitors... Please do something about the following address that has apparently joined the list. every time I send a message to the list, I get a bouned message saying that the message is undeliverable. Thanks >From: "Mailer-Daemon" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: NDN: automatic server start paramaters >Date: Thu, 16 May 2002 15:25:44 +0200 > >Sorry. Your message could not be delivered to: > >w3d3demo (Mailbox or Conference is full.) P.S hey filter, MySQL, query, and SQL _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
automatic server start paramaters
On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql 3.23.??, I think) I have a testing and programming box, only one user is connecting to the database at a time. Now, the mysqld startup sequence automatically starts 5 occurances of the mysqld server. Id like to conserve memory resources a little better and only start 1 automatically and let the program spawn child processes if load requires. 1. Is this advisable? possible? or just plain stupid? 2. How do I go about making the requested change? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Get the next AUTO INCREMENT value for a column
To the originator of this thread:
While what you are asking is possible, Id like to put my two cents in and
ask you please not to do it.
If this is a production database, you have no idea how helpful it will be
for you to know by those missing pk numbers that something was deleted
manually from the database as opposed to an index error, or some other more
disasterous problem. In my experiece leave those holes in the pk sequence,
and then later on when someone complains that a record is missing, you can
say with some confidence that someone actually deleted it.
AS a followup note, I would never allow user permissions to let a regular
user delete a record in the first place, and I would stop it with either
code, or database user access privelages. Instead create an active/inactive
status field and then you can rewrite some code to add a "where status =
'active'" or similar line of code
Then create a "purge records' function in your app so that admins who are
supposed to know what they are doing can delete records if they really want
to.
Just my opinion.
Rance
PS. hey filter, chew on this, MySQL, SQL,
>From: "Arthur Fuller" <[EMAIL PROTECTED]>
>To: "Harrison C. Fisk" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, "Paul
>DuBois" <[EMAIL PROTECTED]>
>Subject: Re: Get the next AUTO INCREMENT value for a column
>Date: Sun, 5 May 2002 14:06:43 -0400
>
>IMO the desire to know this answer suggests that something is wrong with
>the
>design. Again IMO, a PK must be absolutely meaningless. Any attempt to
>impost meaning on it is by definition wrong.
>
>By my lights, the only PK you want to know is the one just added. That's
>enough information to let you start adding rows to child tables. And that
>value you can easily obtain.
>
>Arthur
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Harrison C. Fisk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, May 04, 2002 12:34 PM
>Subject: Re: Get the next AUTO INCREMENT value for a column
>
>
> > At 12:29 -0400 5/4/02, Harrison C. Fisk wrote:
> > >Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can
>show
> > >you the next auto_increment value.
> >
> > There is no guarantee that this value will actually be used for the
> > next AUTO_INCREMENT value. Suppose another client issues the following
> > query:
> >
> > ALTER TABLE tbl_name AUTO_INCREMENT = 123456;
> >
> > If you were relying on what SHOW TABLE STATUS said, you'd be hosed. :-)
> >
> >
> > >Although I can say I wouldn't really ever use it except for personal
>use,
> > >not in an actual application.
> > >
> > >Harrison
> > >- Original Message -
> > >From: "Paul DuBois" <[EMAIL PROTECTED]>
> > >To: "Son Nguyen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > >Sent: Saturday, May 04, 2002 12:16 PM
> > >Subject: Re: Get the next AUTO INCREMENT value for a column
> > >
> > >
> > >> At 9:01 -0700 5/4/02, Son Nguyen wrote:
> > >> > CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text,
>value
> > >> >text, Primary Key (ID));
> > >> >
> > >> > INSERT into test1 (name, value) values ("test1", "value1");
> > >> >
> > >> > INSERT into test1 (name, value) values ("test2", "value2");
> > >> >
> > >> > DELETE from test1 where ID=2;
> > >> >
> > >> > How can obtain the CURRENT value of next ID AUTO INCREMENT value
> > >> >(which is 3 right now)
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > Son Nguyen
> > >> >mysql, query
> > >>
> > >> You can't. AUTO_INCREMENT values are not available until you
>generate
> > > > them.
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: GUI managers for Linux
Victoria,
You asked me to be sure that the information going into the MyCC dialog box
about the server was correct, and it is, port, user, password, and host, but
still no connect, php can even connect to the database with the
server/user/password triple.
so back to my original question, why cant mycc connect to the database, and
why is the server refusing an apparently valid connection request.
MyCC does support connection via sockets, and Im not using sockets, should I
change just to get it running?
Rance
>From: Victoria Reznichenko <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Re: GUI managers for Linux
>Date: Wed, 1 May 2002 13:00:01 +0300
>
>Rance,
>Wednesday, May 01, 2002, 12:19:42 AM, you wrote:
>
>RH> Victoria, sorry it has taken so long to get back to you, Ive had a
>partition
>RH> table problem that has taken a couple of days to fix
>
>RH> anyway,
>
>RH> Using MyCC, in the database connection dialog, I have the host
>"localhost"
>RH> a valid user name, and password
>
>RH> Identified the port as the default 3306 but dont know if this is the
>right
>RH> answer for my server, or how to find out.
>
>You can check it by command:
> SHOW VARIABLES LIKE 'port';
>
>RH> no other boxes checked on the front page of the connection dialog.
>
>RH> When I try to connect using this information, I get Error 10061:
>Connection
>RH> to Mysql Server Failed.
>
>This error occures when server refused connection ...
>Rance, check if all data (username, password, host, port) is
>correctly. I know it's a bit of bore request, but I ask you to check
>it.
>
> >>From: Victoria Reznichenko <[EMAIL PROTECTED]>
> >>To: [EMAIL PROTECTED]
> >>Subject: Re: GUI managers for Linux
> >>Date: Mon, 29 Apr 2002 16:48:02 +0300
> >>
> >>Rance,
> >>Sunday, April 28, 2002, 2:44:45 AM, you wrote:
> >>
> >>RH> Ive downloaded and sucessfully installed both mysqlgui, and mycc
>from
> >>the
> >>RH> mysql.com site
> >>
> >>RH> for some wierd reason I cant connect to the database with either of
> >>them
> >>
> >>RH> I can with the text mysql client, and the text mysqladmin
> >>
> >>RH> I have created a database, and granted rights to that database to a
> >>user.
> >>
> >>RH> that user can log in using "mysql -u username -p"
> >>
> >>RH> This is a Mandrake Linux 8.2 box running mysql 3.23.47
> >>
> >>RH> mysqlgui version 1.7.4
> >>
> >>RH> mycc version 0.8.2 alpha
> >>
> >>Did you fill up entries for connection? ("Database Connection Dialog" in
> >>MyCC and "Options" in MySQLGUI)
> >>
> >>What errors did you receive?
> >>
> >>RH> any hints much appreciated
> >>RH> Rance
>
>
>
>
>--
>For technical support contracts, goto https://order.mysql.com/
>This email is sponsored by Ensita.net http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
><___/ www.mysql.com
>
>
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GUI managers for Linux
Victoria, sorry it has taken so long to get back to you, Ive had a partition
table problem that has taken a couple of days to fix
anyway,
Using MyCC, in the database connection dialog, I have the host "localhost"
a valid user name, and password
Identified the port as the default 3306 but dont know if this is the right
answer for my server, or how to find out.
no other boxes checked on the front page of the connection dialog.
When I try to connect using this information, I get Error 10061: Connection
to Mysql Server Failed.
>From: Victoria Reznichenko <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: GUI managers for Linux
>Date: Mon, 29 Apr 2002 16:48:02 +0300
>
>Rance,
>Sunday, April 28, 2002, 2:44:45 AM, you wrote:
>
>RH> Ive downloaded and sucessfully installed both mysqlgui, and mycc from
>the
>RH> mysql.com site
>
>RH> for some wierd reason I cant connect to the database with either of
>them
>
>RH> I can with the text mysql client, and the text mysqladmin
>
>RH> I have created a database, and granted rights to that database to a
>user.
>
>RH> that user can log in using "mysql -u username -p"
>
>RH> This is a Mandrake Linux 8.2 box running mysql 3.23.47
>
>RH> mysqlgui version 1.7.4
>
>RH> mycc version 0.8.2 alpha
>
>Did you fill up entries for connection? ("Database Connection Dialog" in
>MyCC and "Options" in MySQLGUI)
>
>What errors did you receive?
>
>RH> any hints much appreciated
>RH> Rance
>
>
>
>
>--
>For technical support contracts, goto https://order.mysql.com/
>This email is sponsored by Ensita.net http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
><___/ www.mysql.com
>
>
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GUI managers for Linux
Ive downloaded and sucessfully installed both mysqlgui, and mycc from the mysql.com site for some wierd reason I cant connect to the database with either of them I can with the text mysql client, and the text mysqladmin I have created a database, and granted rights to that database to a user. that user can log in using "mysql -u username -p" This is a Mandrake Linux 8.2 box running mysql 3.23.47 mysqlgui version 1.7.4 mycc version 0.8.2 alpha any hints much appreciated Rance _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL and innoDB
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:48 PM
> To: Christopher Thompson; [EMAIL PROTECTED]
> Cc: Rance Hall
> Subject: Re: mySQL and innoDB
>
>
> I am just testing mySQL so I will be able to use it instead
> of Oracle Sybase
> ...
>
> I am not saying a PK can be NULL wich is impossible
> But a FK can be NULL and I'd like to know how to do that with mySQL
>
>
> A concrete example could be:
>
> table employee
> column 1 : employee_id - primary key
> column 2 : employee_name - name of the employee
>
> table hierarchy
> column 1 : hierarchy_id - primary key
> column 2 : hierarchy_employee_id_son - a foreign key referencing
> employee.employee_id
> column 3 : hierarchy_employee_id_father- a foreign key referencing
> employee.employee_id
>
>
> Now I want to use that:
>
> I have 6 employee
> employeeA
> employeeB
> employeeC
> employeeD
> employeeE
> employeeF
>
> I have 2 hierarchies X and Y
>
> For hierachie X
> employeeA is the manager of employee C
> employeeC is the manager of employee F
>
> For hierachie Y
> employeeB is the manager of employee D and E
>
> So i have in my tables
>
> insert into table employee values ('A','employeeA');
> insert into table employee values ('B','employeeB');
> insert into table employee values ('C','employeeC');
> insert into table employee values ('D','employeeD');
> insert into table employee values ('E','employeeE');
> insert into table employee values ('F','employeeF');
>
> insert into table hierarchy values ('X','A',NULL);
> insert into table hierarchy values ('X','C','A');
> insert into table hierarchy values ('X','F','C');
> insert into table hierarchy values ('X','B',NULL);
> insert into table hierarchy values ('X','D','B');
> insert into table hierarchy values ('X','E','B');
>
> The employee who is at the top of the hierarchy as no manager ...
> so for A and B in the hierarchy table the foreign key referencing
> employee.employee_id is NULL
>
> Alain
>
I dont see where what you are doing is allowed, and I think Chris mentioned it in
another note
But, Now I see where you are going, and I can think of Two different ideas
1. If the employee is a supervisor, then let him supervise himself/herself and
populate the field accordingly
2. Create a supervisor field in the employee table, and programmatically enforce that
an employees supervisor be in the select group of supervisor = yes employees
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL and innoDB
Well, I know I'm gonna catch flak for this, but oh well, here goes anyway I send an off list mail to Alain to ask for some more specific information about what he is trying to do so that we can find a way to do it. But this I will say to the whole list... What is the point of setting up a referential integrity constraint just to exploit it in the way Alain described? Given what the manual says about the limitations of these type of constraints (at least so far) seems to me that it is not desirable to use them. While I know that NULL is by definition a part of every column (just like in set theory math where you have the null set is a subset of every set), NULL is not rendered as an actual entry in any column when looking at the output of any select * or similar SQL statement. Clearly NULL is both there and not there at the same time, and it depends greatly on context which understanding is used for any given command. >From a very practical standpoint, I think that the output Alain described is >desirable in over 90% of implementation ideas (and 100% desirable in all of my >previous implementations) Standards be what Standards be, but standards can be either changed or ignored, depending on if it benefits one to do so. This is especially true when dealing with NULL, heck, some databases don't even support the NULL concept at all Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:05 PM To: Alain Del Giust; [EMAIL PROTECTED] Subject: Re: mySQL and innoDB On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote: > "if you have a foreign key constraint, that field must be one of the values > of the referenced column and that column, being an index, is never NULL" > > OK so my understanding is that it is impossible with mySQL to do such > things wich are basic with at least: > Oracle > Sybase Adaptive Server Enterprise > Sybase Adaptive Server Anywhere What are you saying? If you are saying these databases allow a primary key column (or a unique key column) to contain a NULL, they are violating SQL92. By extension, any column that is a foreign key can also not be NULL. Perhaps you are saying something else. But if you are saying this, you can hardly take MySQL to task for properly supporting SQL92 (at least, in this instance). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL and innoDB
well, your right about one thing, I did misread the order of your SQL statement, but
if you have a foreign key constraint, that field must be one of the values of the
referenced column, and that column, being an index, is never NULL
so inserting NULL into a properly configured foreign key column should fail
inserting anything into that column that isn't in the referenced column should fail,
and it does.
so my apologies for my mistake from earlier
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:45 AM
To: Rance Hall; [EMAIL PROTECTED]
Subject: Re: mySQL and innoDB
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:25 PM
Subject: RE: mySQL and innoDB
The "insert into b values ('BBB', NULL)" statement should fail under the
conditions you describe, BBB was not inserted into the A table, and
therefore the foreign key constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
index idx_b_a_id (a_id), foreign key (a_id) references a (id),
primary key(id) )
TYPE=INNODB;
insert into b values ('AAA','aaa');
insert into b values ('BBB',null);
the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
foreign key constraint fails
I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
"mysqld-max --standalone --console"
Thanks,
Alain
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL and innoDB
The "insert into b values ('BBB', NULL)" statement should fail under the conditions
you describe, BBB was not inserted into the A table, and therefore the foreign key
constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
index idx_b_a_id (a_id), foreign key (a_id) references a (id),
primary key(id) )
TYPE=INNODB;
insert into b values ('AAA','aaa');
insert into b values ('BBB',null);
the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
foreign key constraint fails
I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
"mysqld-max --standalone --console"
Thanks,
Alain
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Script stopping
looks to me like the error is with the semicolon at the end of the Service CHAR (80); That would indicate the end of the statement, not that something follows Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:07 AM To: [EMAIL PROTECTED] Subject: SQL Script stopping I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20),<--- here Can anyone tell me what's wrong with this line? I dumped the tables, changed Category to ctg, still the same error. I'm running a fresh install of Mandrake 8.2. Thanks in advance. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: question
sounds like you have a problem in your phpmyadmin config file, I forget the syntax I stopped using phpmyadmin some time ago, but I remember those error messages. opinion: if the mysql database is on your network, you can try mysql front as a tool to add databases, tables, users, and everything else, I think its a great tool, and it saves all that web clicking. Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: question i got a problem thats keep on coming and coming, it's like this: first time i run WINmySqladmin and try to make a database on my localhost (http:/localhost:82/PHPmyadmin/index), it will give no problem, so i make my database and connect it to my PHP scripts, so it worked :). But now, when i restart my computer en try to do open http:/localhost:82/PHPmyadmin/index en try to create a db, i got this message: Warning: Cannot add header information - headers already sent by (output started at c:\www\apache\htdocs\phpmyadmin\libraries\auth\config.auth.lib.php:92) in c:\www\apache\htdocs\phpmyadmin\header.inc.php on line 23 Warning: Cannot add header information - headers already sent by (output started at c:\www\apache\htdocs\phpmyadmin\libraries\auth\config.auth.lib.php:92) in c:\www\apache\htdocs\phpmyadmin\header.inc.php on line 24 Warning: Cannot add header information - headers already sent by (output started at c:\www\apache\htdocs\phpmyadmin\libraries\auth\config.auth.lib.php:92) in c:\www\apache\htdocs\phpmyadmin\header.inc.php on line 25 Warning: Cannot add header information - headers already sent by (output started at c:\www\apache\htdocs\phpmyadmin\libraries\auth\config.auth.lib.php:92) in c:\www\apache\htdocs\phpmyadmin\header.inc.php on line 26 Warning: Cannot add header information - headers already sent by (output started at c:\www\apache\htdocs\phpmyadmin\libraries\auth\config.auth.lib.php:92) in c:\www\apache\htdocs\phpmyadmin\header.inc.php on line 27 Warning: Cannot add header information - headers already sent by (output started at c:\www\apache\htdocs\phpmyadmin\libraries\auth\config.auth.lib.php:92) in c:\www\apache\htdocs\phpmyadmin\header.inc.php on line 29 Fout MySQL retourneerde: Can't connect to MySQL server on 'localhost' (10061) so it says cant connect to MySQL server on localhost>>with appache running and WINmySqladmin. what to do ? thanks for you time :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: running the server problem
I had the exact same problem. when you install mysql there is a database that stores all the user permissions and that table is created for you. the mysql server can start without that permissions file but you have to send a -Sg option to the server if you are on unix, linux or the like This option allows the server to start without checking for the grant tables. This is bad form if you want a production database. I was never able to fix my installation when I had this problem. I had to uninstall and reinstall and then specify the custom data path to the .configure file from a source install. Good Luck Rance Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Bob Lockie [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:50 PM To: mysql mailing list Subject: running the server problem ./safe_mysqld --user=mysqld --datadir=/db/ ./safe_mysqld --user=mysqld --datadir=/db/ 020401 16:55:04 mysqld started 020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020401 16:55:04 mysqld ended My unix user is called mysqld and I want databases to go in /db/. Does anybody know what it is trying to do? I put in a non-standard location (/d2/usr2/local/) and I used a non-standard user (mysqld). I have no scripts nor var directories as the documentation says I should. "scripts/mysql_install_db". I have version 3.23.49 of the source. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Using MySQL text column with PHP4
nl2br() works, thanks for the info manual stinks on this subject example code should be something like: $newtext = nl2br($oldtext); Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Mat Murdock [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:03 AM To: Rance Hall Cc: [EMAIL PROTECTED] Subject: Re: Using MySQL text column with PHP4 Try this function nl2br() Mat - Original Message - From: "Rance Hall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 01, 2002 7:51 AM Subject: Using MySQL text column with PHP4 > I need some help formatting a MySQL longtext column for presentation via PHP > > When I pull the data with PHP the line feeds are not respected unless I use the HTML tags around my data field. > > This does not have the desired effect. > > how can I pull the data into the php web page and maintain line feeds/carriage returns while still respecting other text layout commands? > > Rance Hall > 308.238.2455 > Internal Office Extensions: 2455 or 6655 > PC Programmer, The Buckle, Inc. > [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using MySQL text column with PHP4
I need some help formatting a MySQL longtext column for presentation via PHP When I pull the data with PHP the line feeds are not respected unless I use the HTML tags around my data field. This does not have the desired effect. how can I pull the data into the php web page and maintain line feeds/carriage returns while still respecting other text layout commands? Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Server startup error on Linux
Egor: Yes, im sure that the host.xxx tables are in the directory I specified to the mysql_install_db script. One thing to note.. This is a software package for my distro... I did not compile from source so I dont know what options were used in the compile process. It may be that the server is unable to look in the dir where the files are... if this is the case then this would explain why the server cant find the host.xxx databases. I have tried to run safe_mysqld --datadir=/path/to/data but that doesnt help Do you think I should just uninstall the package, and download the sources and start over? Im at the end of my rope with this, Its just dumb to me that the server cant find something that I can find, even after I tell it where to look. There must be something more wrong that just a simple chown command, or file permissions or something like that. Just my opinion. Thoughts? >From: Egor Egorov <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Server startup error on Linux >Date: Fri, 22 Mar 2002 20:32:00 +0200 > >Rance, >Friday, March 22, 2002, 4:53:41 PM, you wrote: > >RH> here goes (not that it will give you any better information than I did >RH> already but since you asked...) > >RH> <<>> >RH> 020318 14:30:48 mysqld started >RH> 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't >exist >RH> 020318 14:30:49 mysqld ended >RH> <<>> > >RH> because I have about 18 similar blocks in my .err file for each time I >tried >RH> to start the server to see if I fixed the problem coping the entire >.err >RH> file didnt make any sense. > >RH> Again, this is after running the mysql_install_db and verifing that >RH> permissions to the files created by mysql_install_db are correct. > >RH> --skip-grant-tables will allow the server to start, but a normal start >is >RH> impossible > >Rance, are you sure that table 'host' really exists? >Take a look at mysql datadir if there are the grant tables like >'host.frm', 'host.MYD', 'host.MYI'. > >RH> Rance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Server startup error on Linux
Ok Egor, here goes (not that it will give you any better information than I did already but since you asked...) <<>> 020318 14:30:48 mysqld started 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 020318 14:30:49 mysqld ended <<>> because I have about 18 similar blocks in my .err file for each time I tried to start the server to see if I fixed the problem coping the entire .err file didnt make any sense. Again, this is after running the mysql_install_db and verifing that permissions to the files created by mysql_install_db are correct. --skip-grant-tables will allow the server to start, but a normal start is impossible Rance >From: Egor Egorov <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Server startup error on Linux >Date: Fri, 22 Mar 2002 15:38:03 +0200 > >Rance, >Thursday, March 21, 2002, 9:30:26 PM, you wrote: > >RH> I issued the chown command as indicated by Andreas >RH> but it doesnt help >RH> I still get the "Table mysql.hosts doesnt exist" > >RH> I know that all the tables created by mysql_install_db are infact owned >by >RH> mysql >RH> but the server daemon still cant find them > >Give me complete output of the error message - show us the >contents of the .err file > >RH> what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Server startup error on Linux
I issued the chown command as indicated by Andreas but it doesnt help I still get the "Table mysql.hosts doesnt exist" I know that all the tables created by mysql_install_db are infact owned by mysql but the server daemon still cant find them what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
server startup error on linux
Ok, I guess Im gonna have to do this again I have a Slackware 8.0 distro with the apache, php, and mysql install pkgs off of the cd I am logged in as root (not su'ed to root) and run the mysql_install_db script I run it with or without the --user=mysql qualifier in either case the databases are corrected, and the file permissions and ownership show that root owns all the database files with read and write access to the owner and the group. running safe_mysqld with or without the --user=mysql qualifier results in the same error "Table mysql.host doesnt exist" There are two tables created by the mysql_install_db script that are called host.xxx I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Help. Rance _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: server startup error
Folks: I think you are on the right track with that Gerald.. I deleted all the files in my data directory (they were just the ones that mysql_install_db creates) and then ran mysql_install_db --user=mysql This time, nothing was created, no files, or anything, cant even find an error message that would say why. So since I know that the server is running under safe_mysqld --user=mysql it couldnt find the files cause under that account name apparently they dont exist. The mysql user is part of what group, so I can chown the dir, and start again? Gerald Clark wrote >Does mysql own the mysql database directory, and all its files? > >You should have run it as >mysql_install_db --user=mysql > >Rance Hall wrote: > >> >>Hello all >> >>I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at >>that computer now, so that could be wrong slighly) install pkg >> >>I have installed it, and I can get it to run with the >>--skip-grant-tables option. >> >>When I try to run safe_mysqld without the skip option I get the >>following error: Table 'mysql.host' doesn't exist >> >>Now, I ran the mysql_install_db script and it made a bunch of >>databases including two called host.xxx >> >>Question, what is the proper syntax for a creation of the mysql.host >>table so that I can create it and get past this error. >> >>If anyone else has any experience with this, could this be a bug in >>the install_db script? >> >>Thanks for all your help >> >>Rance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
server startup error
Hello all I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that computer now, so that could be wrong slighly) install pkg I have installed it, and I can get it to run with the --skip-grant-tables option. When I try to run safe_mysqld without the skip option I get the following error: Table 'mysql.host' doesn't exist Now, I ran the mysql_install_db script and it made a bunch of databases including two called host.xxx Question, what is the proper syntax for a creation of the mysql.host table so that I can create it and get past this error. If anyone else has any experience with this, could this be a bug in the install_db script? Thanks for all your help Rance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
