Re: MySQL load problems.

[Heikki Tuuri]

Maximo,

- Original Message -
From: Maximo Migliari [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 11:31 PM
Subject: MySQL load problems.


 Hello all,

 I've been having some problems with MySQL crashing.  I use a mixture of
 MyISAM and InnoDB tables, but most of the data is under InnoDB tables.  My
 web applications all do relatively complex join queries.  Almost all
fields
 in the WHERE clauses of queries are indexed.

 I'm running RedHat 7.2, and MySQL version is 3.23.53a

 The server is:
 PIII-866 Mhz,
 512 MB RAM
 18 GIG SCSI drive (no RAID).

 The server acts as an Apache server AND as a MySQL server

 The server seems to work fine and has +- an uptime load of 1 - 1.5 when
 MySQL is running arround 20 queries/sec
 When it reaches about 30-40 queries/sec, the machine goes to 3-5 load in
 uptime, often registers slow queries, and eventually dies without any
error
 messages (except that the socket file doesn't exist - i.e. crash).

can you send me the error log

yourhostname.err

from the datadir of MySQL?

I could try to resolve stack traces from it if any.

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB




-
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

'mysqlbug

[Wong, Kee Lang]

Dear Sir,

I am very new to the mySQL product. I am trying to do some RD on the
possibility to port the MS SQL to mySQL for our system. I have tried with
mysql-3.23.53-win. I able to start the mySQL and run the mysqlshow command
and others.

However, if I try with the mysql-max-4.0.4-beta-win, I started the mysql
using mysqld -standalone.  When I try to execute the mysqlshow command,
there is no respond from the dos prompt. And then my PC become very slow in
responding.

Please help. Thank you very much.

Regards,
Kee Lang

-
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

simple query turned ugly

[Vince LaMonica]

Hi all,

I've been training someone on how to use MySQL, and apparently I'm 
suffering from brain fade big time. The user has created two tables; an 
authors table and a publications table.

The authors table has 4 cols: id [primary/smallint/autoincrement], 
last_name, middle_name, first_name. 

The publications table has several cols, but the ones most important to 
this question are: id [primary/smallint/autoincrement], author1 [smallint, 
foreign key to authors.id/default NULL], author2 [same], author3 [same], 
author4 [same], author5 [same], and year [char(4)].

The user has created multiple author cols in the publications table 
because the order of the author matters [eg: it is better for someone to 
be an author1 than an author2 or a dreaded author5]. Some publications 
have 1 author, some have up to five.

Putting together a simple query to find out the names of the author[s] for 
each publication:

SELECT author1, author2, author3, author4, author5, year
FROM `papers` GROUP BY papers.id ORDER BY `year` ASC

This produces a nice 'table' of each publication's 1-5 authors, listed by 
their id. 

How do I alter the query to replace their id with authors.last_name? I'm a 
php coder, but in this case, the user wishes to do this with straight sql 
queries. And for whatever reason, I can't come up with a solution to this.

If anyone has an idea or two to throw my way, I would really appreciate 
it!

/vjl/

-- 
Vince LaMonica   UC Irvine,  School  of  Social Ecology
 W3 Developer   *  116 Social Ecology I, Irvine, CA 92697
 [EMAIL PROTECTED]  http://www.seweb.uci.edu/techsupport

 If it be now, 'tis not to come; if it be not to come, it will be now;
 if it be not now, yet it will come: the readiness is all. 
   -- William Shakespeare, Hamlet. 


-
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: _rowid

[horizonx]

Hi Benjamin,

  Isn't _rowid some type of internal variable?  What is its exact
 purpose and
  significance?

Thanks for nailing the matter down.

   http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:39492:cnfpdcnkgalicmjgekef


My main concern is that if we would make ROWID's available for the end
user, some may use this instead of auto_increment columns and cause a
lot of problems.  Internally it shouldn't be that hard to allow one to
allow one to use a pseudo ROWID column to access a row but this would
only be really usable for some very special applications.  In most
cases the current keys are just fast enough.

Regards,
Monty

Somehow Oracle does not share this view and makes true rowid available.
Would some type of rowid feature lock help in making sure the user has read
the relevant manual section and understands the caveats associated with
rowid?

   Do you have an example where _rowid would be more useful than
   simply having an AUTO_INCREMENT column?

A software developer could use Mysql to manage a very large memory space
that needs indexing for certain variables (rows).  Since that space is
managed in the same way he RAM would be, stale data is simply marked and
made available for reuse.

The speed benefits make it worth loosing the ability to delete rows, use
ALTER or OPTIMIZE, although I can't do without REPAIR ...

As outlined in the link you found, true rowid takes no space whatsoever, no
row, no key.

Also what happens to an AUTO_INCREMENT column when there are over 4 billions
plus rows?

Regards,

Terry



-
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: _rowid

[Dean Harding]

Hey,

The thing with Oracle is that once a row is assigned a ROWID, it never
changes.  It doesn't matter if the row grows and has to move within the
block (or if it has to move to another block, for that matter).  That's
why ROWIDs work in Oracle.

But apparently, that's not the case with MySQL (personally, I see that
as a design flaw, but that's just my opinion :) so a ROWID in MySQL is
really just a synonym for the primary key, and is probably only useful
to people who are porting from Oracle (or some other database which has
ROWIDs).

Dean.

-Original Message-
From: [EMAIL PROTECTED] [mailto:horizonx;noos.fr] 
Sent: Thursday, 14 November 2002 9:52 pm
To: [EMAIL PROTECTED]
Subject: Re: _rowid

Hi Benjamin,

  Isn't _rowid some type of internal variable?  What is its exact
 purpose and
  significance?

Thanks for nailing the matter down.


http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:39492:cnfpdcnkgalicmjgekef


My main concern is that if we would make ROWID's available for the end
user, some may use this instead of auto_increment columns and cause a
lot of problems.  Internally it shouldn't be that hard to allow one to
allow one to use a pseudo ROWID column to access a row but this would
only be really usable for some very special applications.  In most
cases the current keys are just fast enough.

Regards,
Monty

Somehow Oracle does not share this view and makes true rowid available.
Would some type of rowid feature lock help in making sure the user has
read
the relevant manual section and understands the caveats associated with
rowid?

   Do you have an example where _rowid would be more useful than
   simply having an AUTO_INCREMENT column?

A software developer could use Mysql to manage a very large memory space
that needs indexing for certain variables (rows).  Since that space is
managed in the same way he RAM would be, stale data is simply marked and
made available for reuse.

The speed benefits make it worth loosing the ability to delete rows, use
ALTER or OPTIMIZE, although I can't do without REPAIR ...

As outlined in the link you found, true rowid takes no space whatsoever,
no
row, no key.

Also what happens to an AUTO_INCREMENT column when there are over 4
billions
plus rows?

Regards,

Terry



-
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

DROP PRIMARY KEY

[Silmara]

Thanks for the answers, but I have other problem...  
  
When I try to use the following command  
  
ALTER TABLE TABLE_1 DROP PRIMARY KEY;  
  
I get one error  
  
ERROR1114: The table '#sql-240_2' is full  

My table have 309195 records.
  
How can I resolve this problem?

Kind regards,
Sil


-
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: simple query turned ugly

[Roger Baklund]

* Vince LaMonica
[...]
 The authors table has 4 cols: id [primary/smallint/autoincrement],
 last_name, middle_name, first_name.

 The publications table has several cols, but the ones most important to
 this question are: id [primary/smallint/autoincrement], author1
 [smallint,
 foreign key to authors.id/default NULL], author2 [same], author3 [same],
 author4 [same], author5 [same], and year [char(4)].

 The user has created multiple author cols in the publications table
 because the order of the author matters [eg: it is better for someone to
 be an author1 than an author2 or a dreaded author5]. Some publications
 have 1 author, some have up to five.

hm... This is not good db design... I would use a third table:
'paper_authors' with the columns 'paper_id', 'author_id' and 'prio', where
'prio' is a tinyint with the values 1-5.

 Putting together a simple query to find out the names of the
 author[s] for each publication:

 SELECT author1, author2, author3, author4, author5, year
 FROM `papers` GROUP BY papers.id ORDER BY `year` ASC

 This produces a nice 'table' of each publication's 1-5 authors, listed by
 their id.

 How do I alter the query to replace their id with
 authors.last_name?

You need to JOIN with the authors table five times:

SELECT papers.id,
  concat(a1.first_name,' ',a1.middle_name,' ',a1.last_name) as author1,
  concat(a2.first_name,' ',a2.middle_name,' ',a2.last_name) as author2,
  concat(a3.first_name,' ',a3.middle_name,' ',a3.last_name) as author3,
  concat(a4.first_name,' ',a4.middle_name,' ',a4.last_name) as author4,
  concat(a5.first_name,' ',a5.middle_name,' ',a5.last_name) as author5,
  year
FROM papers
  LEFT JOIN authors a1 ON a1.id = papers.author1
  LEFT JOIN authors a2 ON a2.id = papers.author2
  LEFT JOIN authors a3 ON a3.id = papers.author3
  LEFT JOIN authors a4 ON a4.id = papers.author4
  LEFT JOIN authors a5 ON a5.id = papers.author5
ORDER BY year ASC

(Don't know why you would use GROUP BY in this case.)

LEFT JOIN is used because not all papers have five authors. Read more about
the different types of JOIN in the manual: URL:
http://www.mysql.com/doc/en/JOIN.html 

HTH,

--
Roger


-
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: DROP PRIMARY KEY

[Roger Baklund]

* Silmara
 When I try to use the following command

 ALTER TABLE TABLE_1 DROP PRIMARY KEY;

 I get one error

 ERROR1114: The table '#sql-240_2' is full

 My table have 309195 records.

 How can I resolve this problem?

You probably have a full disk.

When you ALTER a table, mysql will often recreate the entire table by
copying the existing one, thus you need to have more free disk space than
the size of the table you want to ALTER.

--
Roger


-
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

Certification

[Alexander Burbello]

Hi,

I would like to know if are there any certification for MySQL like DBA
Oracle or something like that?

Grettings

Alexander

sql,query


-
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: Certification

[Roger Baklund]

* Alexander Burbello 
 I would like to know if are there any certification for MySQL like DBA
 Oracle or something like that?

They are working on it:

URL: http://www.mysql.com/certification/index.html 

-- 
Roger

-
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: Lost connection...

[Egor Egorov]

Staffan,
Thursday, November 14, 2002, 9:44:05 AM, you wrote:

SH I'm using RedHat 8.0 and MySQL 3.23.52. I've also downloaded the MySQL Control 
Center (latest). On the Linux mashine everything works just fine, but when I try to 
connect to MySQLserver from
SH Win2k using alpha version of MySQL Control Center I get ERROR 2013: Lost 
connection to MySQL server during query. This is very odd. I know I have all the 
settings correct and I've tried
SH different users and pw. I'm using default port (3306) and checked that Linux 
computer really listens on that port. I've also installed the MySQL O
SH DBC driver. But the exact same error-message accours when I try to connect via the 
ODBC-driver in ASP from the Win2k computer.

Try to upgrade glibc:
https://rhn.redhat.com/errata/RHSA-2002-197.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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

re: mysql4 starts then stops

[Egor Egorov]

Kevin,
Thursday, November 14, 2002, 1:09:15 AM, you wrote:

KLG If this is a FAQ, I haven't been able to find it.  I am a newbie to MySQL,
KLG but I've followed the directions carefully and I get this whenever I start
KLG mysqld:

KLG   # bin/safe_mysqld --user=mysql 
KLG   [1] 24487
KLG   zaphod:/usr/local/mysql[15:02]# Starting mysqld daemon with databases from 
/var/lib/mysql
KLG   021113 15:02:18  mysqld ended
  
  
KLG   [1]  + 24487 done   bin/safe_mysqld --user=mysql

[skip]

KLG Also, why is this file lost? It appears that you *have* to be in /usr/local
KLG (or whereever your root is) to run mysqld.

KLG   # bin/!!
KLG   bin/mysqld version
KLG   021113 15:04:41  Can't find messagefile 
'src/mysql-max-4.0.3-beta-pc-linux-gnu-i686/share/mysql/english/errmsg.sys'
KLG   021113 15:04:41  Aborting

MySQL server can't fine error messages file. Check if one exists.

If this file is located in other dir than
src/mysql-max-4.0.3-beta-pc-linux-gnu-i686/share/mysql/english/ you
can set up path to the file with --language option of mysqld (or edit
my.cnf file).



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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

re: create database not replicated

[Victoria Reznichenko]

Mark,
Thursday, November 14, 2002, 12:02:31 AM, you wrote:

MI I am having a problem with replication. When I create a new database on
MI the master, the CREATE DATABASE command is not shipped to the slave.
MI Subsequent table creation and table updates on the new database on the
MI master are replicated on the slave, but since the new database was not
MI created on the slave, the slave thread hangs.

MI In this example the new database is called zzz. This is what I see in the 
MI binary log (via mysqlbinlog):

It works fine for me. What replication options are you using?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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

re: Certification

[Victoria Reznichenko]

Alexander,
Thursday, November 14, 2002, 2:49:56 PM, you wrote:

AB I would like to know if are there any certification for MySQL like DBA
AB Oracle or something like that?

Yes, MySQL AB is working on a certification program. Visit the following page
for more details:
 http://www.mysql.com/certification/


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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

re: Re: mysql server hardware

[Victoria Reznichenko]

Maximo,
Wednesday, November 13, 2002, 10:09:07 PM, you wrote:

MM Where can I get a tuning guide for MySQL (MyISAM and InnoDB)...
MM memory-wise and son on?

Some notes you can find in the MySQL and InnoDB manuals:
 http://www.innodb.com/ibman.html#InnoDB_tuning
 http://www.mysql.com/doc/en/System.html
 http://www.mysql.com/doc/en/Server_parameters.html
 http://www.mysql.com/doc/en/Memory_use.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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

Re: Sorting Records based on field

[ed]

This method will work alright for the time being. It's actually better
than the method they use now anyway.

Thanks for all the ideas.

Ed



 This looks like two different results... a SQL query returns _one_
 resultset.
 
 Try this:
 
 SELECT CompanyName,AgentName,count(*) as ads
   FROM table
   GROUP BY CompanyName,AgentName
   ORDER BY CompanyName,AgentName;
 
 URL: http://www.mysql.com/doc/en/SELECT.html 
 
 The output could be something like this:
 
 ComanyNameAgentName   ads
 -
 Realty Company 1  Agent 1  10
 Realty Company 1  Agent 2   8
 Realty Company 1  Agent 3  20
 Realty Company 2  Agent 1  15
 Realty Company 2  Agent 2   3
 
 If you really want separate result tables for each company, you would
 probably need to use some programming language.
 
 --
 Roger
 
 
 -
 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

mysql 2 servers on 1 DB

[Andrey Kotrekhov]

Hi, All! sql

Can I run 2 mysqld that use the same DB?
Not replication , 1 DB on my HDD but 2 mysqld work with this DB.

For example I have external RAID and I want decrease CPU usage.
I run 2 mysqld on different servers, but they use 1 DB.
Is this possible?

Sorry for my english.

Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44


-
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: turn off auto commit in MYSQL

[Devi Annisetty]

Hi Peter,

Thank you very much
I got one more question
Do I need to change the table type to transaction-safe tables (InnoDB
and BDB) ?
AS I am going thru  the manuals I read that tables should be of InnoDB
or BDB inorder to work for manual commit.


once again thanks in advance,
Devi


-Original Message-
From: Peter Brawley [mailto:peter.brawley;artfulsoftware.com]
Sent: Wednesday, November 13, 2002 6:04 PM
To: Devi Annisetty
Subject: Re: turn off auto commit in MYSQL


SET @@autocommit=0
or
BEGIN

-

Hi,
I am newbie to MYSQL and ODBC

I have to update more than 2 tables simultanously
currently my application uses ADOBC connection object.

How can turn off the autocommit option and set manaul commit.

what places I need to change inorder to work manual commit

Thanks in Advance for your time
Devi

-
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: turn off auto commit in MYSQL

[Natale Babbo]

is there any configuration that turn on auto commit
persistently ... i mean for each client connections?
(in my.cnf [client] or something else)

Thanks in advance.
Natale Babbo

 --- Devi Annisetty [EMAIL PROTECTED] ha
scritto:  Hi Peter,
 
 Thank you very much
 I got one more question
 Do I need to change the table type to
 transaction-safe tables (InnoDB
 and BDB) ?
 AS I am going thru  the manuals I read that tables
 should be of InnoDB
 or BDB inorder to work for manual commit.
 
 
 once again thanks in advance,
 Devi
 
 
 -Original Message-
 From: Peter Brawley
 [mailto:peter.brawley;artfulsoftware.com]
 Sent: Wednesday, November 13, 2002 6:04 PM
 To: Devi Annisetty
 Subject: Re: turn off auto commit in MYSQL
 
 
 SET @@autocommit=0
 or
 BEGIN
 
 -
 
 Hi,
 I am newbie to MYSQL and ODBC
 
 I have to update more than 2 tables simultanously
 currently my application uses ADOBC connection
 object.
 
 How can turn off the autocommit option and set
 manaul commit.
 
 what places I need to change inorder to work manual
 commit
 
 Thanks in Advance for your time
 Devi
 

-
 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
  

__
Per te Blu American Express è gratis!
http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo

-
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: _rowid

[Michael T. Babcock]

Dean Harding wrote:


The thing with Oracle is that once a row is assigned a ROWID, it never
changes.  It doesn't matter if the row grows and has to move within the
block (or if it has to move to another block, for that matter).  That's
why ROWIDs work in Oracle.



Neither does an auto_increment index value that you put in the table 
yourself.  I'm still waiting to hear a proponent of _rowid tell me why 
_rowid is _better_ for _database_admins_ than using an auto_increment 
column value.  The '_rowid takes no space' argument is hogwash; its 
stored by Oracle in space that MySQL doesn't allocate internally, so its 
still taking up a few bytes per row of memory, like it or not.

But apparently, that's not the case with MySQL (personally, I see that
as a design flaw, but that's just my opinion :) 


Like I said above, could you please clarify on why an internal row 
identifier even matters to you as a database admin?  How MyISAM and/or 
InnoDB and/or HEAP and/or Gemini decide to store their table structures 
is something I'm quite happy to ignore if they work -- why would it be 
intrinsically better to use an internal _rowid type value than to do 
what they do?  Oh, and make sure you show me that you understand the 
current structures first -- but more importantly, why does it matter to 
you, or me, or anyone else building DB software??

so a ROWID in MySQL is
really just a synonym for the primary key, and is probably only useful
to people who are porting from Oracle (or some other database which has
ROWIDs).



Precisely why it was added, as far as I can ascertain from the list 
archives.  It is otherwise completely pointless / useless because of a 
different in-memory/on-disk data structuring.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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

Scaling MySQL

[Alec . Cawley]

My application is intended to be scalable. In the eyes of the marketing
departments, it should be scalable from zero to infinity. But we all know
that this is not possible indefinitely - at some point you reach a
bottleneck. In the case of my system, that bottleneck will eventually be
the MySQL write side. I can split the system load by having replicated
read-only slaves, but I must (as far as I can see) have a single update
point, which must then also act as replication master for the read slaves.
(I don't mind a second or two of latency in the propagation of updates from
the write side to the read side.)

The question is how far I can allow the marketing department to extrapolate
the performance of my current systems. Should we get the orders of which
they dream, the budget will be generous. So the question is, in a way, how
much faster I can get MySQL to go by throwing money at it.

I plan to load test the system on the hardware I have - dual 1.7GHz Xeon
running Win2K, 2Gb, 15000 rpm Scsi disk.

I imagine that the fastest hardware would be a big multi-cpu Sun server
with Raided disks. If I (or rather, my marketing department) went to Sun
with an open chequebook, how many times faster than my reference system
would it run?

You will understand that, in the absence of an order, the built it and
try approach doesn't appeal.

I realise that it is beyond the wit of any man to give an exact answer, but
I really need only an order-of-magnitude: 4 times? 25 times? 100 times? (I
doubt the last.) Something to choke off the marketing people when they get
to carried away - or to force them to think about different system
configurations that allow multiple databases.

  Alec






-
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 Encryption

[Michael T. Babcock]

Fraser Stuart wrote:


From this I'm leaning towards DES encryption - only because I can store the
key on the server.
 


Don't use DES for any secure information.  If by secure you mean I 
don't care if they see it, but I'd prefer if they didn't, the go ahead. 
If by secure you mean No way!, then use AES, not DES.  DES is 
crackable on normal hardware ...

QUERY

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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: access db port to mysql

[Antoine]

I wanted to move the Access Database to Mysql..   I downloaded
MysqlFront and that did the trick... Thanks so much

On Thu, 2002-11-14 at 00:27, Chris Couture wrote:
 When you say port are you asking to export the access DB to mysql?  If
 so, Intelligent Converters makes one and you can also do it with EMS
 MySQL manager.
 
 If you wanting to view the mysql data in access; you can do this using
 myodbc and open it using external data using the ODBC source.
 
 -Original Message-
 From: Antoine [mailto:asolomon15;nyc.rr.com] 
 Sent: Wednesday, November 13, 2002 10:16 PM
 To: [EMAIL PROTECTED]
 Subject: access db port to mysql
 
 Hello everyone
 
 I was wondering if there are any tools that would allow me to port a
 access database to mysql?
 
 
 -
 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

Thread Memory Usage

[Nicholas Elliott]

Hey folks,

I've looked around, but haven't seen anything similar to _quite_ the problem
I have.  The symptoms are thus:  memory usage for each mysqld process in top
creeps up to around 13%, 274MB, and stays there, no matter what I set my
config to.

79 processes: 76 sleeping, 3 running, 0 zombie, 0 stopped
CPU0 states: 100.0% user,  0.1% system,  0.0% nice,  0.0% idle
CPU1 states: 98.2% user,  1.2% system,  0.0% nice,  0.0% idle
CPU2 states:  1.1% user,  2.0% system,  0.0% nice, 96.2% idle
CPU3 states:  0.0% user,  0.1% system,  0.0% nice, 99.4% idle
Mem:  2064836K av, 2053068K used,   11768K free,   0K shrd,   15836K
buff
Swap: 2096440K av,   35312K used, 2061128K free 1429524K
cached

  PID USER PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
18339 hunt  25   0  267M 267M   696 R99.9 13.2  64:53 framework
  985 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1015 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1016 mysql 18   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1017 mysql 16   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1018 mysql 17   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1019 mysql 20   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1044 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1045 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:09 mysqld
 1046 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
 1047 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:09 mysqld
 1196 mysql 15   0  274M 259M 14460 S 0.0 12.8  16:14 mysqld
 1288 mysql 25   0  274M 259M 14460 S 0.0 12.8  29:06 mysqld
25425 mysql 25   0  274M 259M 14460 R99.9 12.8  26:10 mysqld
29645 mysql 15   0  274M 259M 14460 S 0.0 12.8   1:04 mysqld

Now, I'm assuming some of that memory must be shared across
processes(threads?) since 14 processes * 12.8% is more than 100%, and
technically I still have 11.7M free.

My config has this:


set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8




Now, I've tried dropping all of the variables, cutting them in half, then
again, to no avail -- when I run a large query (via the DBI interface in
perl) the Mem usage jumps up to 13% (for all mysqld) and never comes back
down.  Most notibly I've dropped the key_buffer to 64M and the table_cache
to 32.

My thought was the query cache, since I thought that I read on the main site
that it will use about 13% per thread.  But no, I have that disabled:

| query_cache_limit   | 1048576
| query_cache_size| 0
| query_cache_type| ON

Size 0 supposedly means it is disabled -- or is this a bug?  Is is
query_cache_size 0' makes it think it is off but 'query_cache_type ON' makes
it cache anyway?  Regardless, flushing the tables and cache doesn't seem to
do anything.

I'm going to reduce the number of concurrent threads (it is set to 8 now)
but that's not the fix I want -- any helpful hints?

Actually, since it's set to 8, why do I get 14 processes?  Two of them are
parents to the other 12, but still?

Thanks,

Nick Elliott

Using MySQL 4.0.4-beta-log
Linux Kernel 2.4.18-17.7.xsmp


-
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 Encryption

[Roger Baklund]

* Fraser Stuart
 We are about to embark on a project that requires data encryption - mainly
 to stop sensitive information being viewed accidentally (ie viewing tables
 directly through odbc connections or standard mysql clients). The server
 (solaris) will not be publicly accessible.

Wouldn't you be better of using GRANT? If you encrypt the content of the
database, any searching must be done on the encrypted value, and sorting
would be difficult...

URL: http://www.mysql.com/doc/en/GRANT.html 

--
Roger


-
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 Encryption

[Michael T. Babcock]

Roger Baklund wrote:


Wouldn't you be better of using GRANT? If you encrypt the content of the
database, any searching must be done on the encrypted value, and sorting
would be difficult...
 


How would MySQL react to having some of its data files stored on 
encrypted loop-back devices that aren't available all the time, but are 
always available when a certain user logs in?

:-)

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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

MySQL and Open Directory RDF Data (UTF-8)

[Rick Root]

Has anyone here tried to put Open Directory RDF data (ie, www.dmoz.org) 
into MySQL?  I've done this fairly successfully with the exception of 
the non-English characters (primarily the stuff in the World 
category).  The data is in UTF-8 which is a character set that MySQL 
doesn't seem to support.

Any suggestions, besides using a different DB? :)

 - Rick


-
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: SPOOL

[Egor Egorov]

Silmara,
Wednesday, November 13, 2002, 6:45:51 PM, you wrote:

S The MySQL have SPOOL where can I stores query results in a file?
S How can I do this?

Sorry, your question is not clear enough for me.

Take a look at SELECT .. INTO OUTFILE command

or may be --tee option of mysql command-line client program is what
you want.

S How can I show my Indexes, Primary keys

SHOW INDEX FROM table_name;

S and Foreign Keys?

   SHOW TABLE STATUS ..
or
   SHOW CREATE TABLE ..



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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

re: version ?

[Egor Egorov]

P.,
Wednesday, November 13, 2002, 6:05:15 PM, you wrote:

PF what mysql version is recommended for running w/apache 1.3.26  php
PF 4.2.2?

PF i'm having trouble getting mysql config'd w/these  wonder if i should
PF avoid/lean to any particular versions?

3.23.53 is a stable version, 4.0.4 is declared as beta.

You can read more about these versions at:
http://www.mysql.com/doc/en/News-3.23.x.html
http://www.mysql.com/doc/en/News-4.0.x.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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

re: create database not replicated

[Mark Ito]

Victoria,

On Thu, 14 Nov 2002, Victoria Reznichenko wrote:

 Mark,
 Thursday, November 14, 2002, 12:02:31 AM, you wrote:
 
 MI I am having a problem with replication. When I create a new database on
 MI the master, the CREATE DATABASE command is not shipped to the slave.
 MI Subsequent table creation and table updates on the new database on the
 MI master are replicated on the slave, but since the new database was not
 MI created on the slave, the slave thread hangs.
 
 It works fine for me. What replication options are you using?

From the master:

  server-id=5
  log-bin=/group/clas/db/clasdb/logs/clasdb2-bin
  binlog-ignore-db=diskSpace
  binlog-ignore-db=mysql

From the slave:

  server-id=4
  master-host=clasdb2.jlab.org
  master-user=repl
  master-password=

So it is all pretty vanilla. The diskSpace database is excluded since it 
is used as a scratch pad for disk management. Since different mirrors may 
want different access privilege tables, the mysql database is excluded 
from replication.

I forgot to mention: the cure for this is to create the database (zzz in 
this case) by hand and start the slave again. It's just that I don't want 
to do this everytime a new database is created on the master.

  -- Mark



-
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

Time comparisons

[Mark Goodge]

Can anyone help with (what I hope is) a pretty simple time function
query? I need to extract a set of records from a table based on
separate date and time columns, where both the date and time are older
or equal to now.

For example, my sql query is going to look a bit like this:

  select ID, Live_Time, Live_Date from schedule
  where TO_DAYS(NOW()) = Live_Date
  and SOMETHING = Live_Time

and it's the SOMETHING that I need to know!

(Before you ask, there are reasons why the date and time are separate
columns rather than being a single datetime column, and I don't want
to rewrite the structure unless I have to)

Thanks

Mark

-
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: Time comparisons

[Ray]

your probably looking for curtime()
manual snip
   CURTIME()
   CURRENT_TIME
  Returns the current time as a value in 'HH:MM:SS' or HHMMSS
  format, depending on whether the function is used in a string
  or numeric context:
mysql select CURTIME();
- '23:50:26'
mysql select CURTIME() + 0;
- 235026
/manual snip

On Thursday 14 November 2002 8:36, you wrote:
 Can anyone help with (what I hope is) a pretty simple time function
 query? I need to extract a set of records from a table based on
 separate date and time columns, where both the date and time are older
 or equal to now.

 For example, my sql query is going to look a bit like this:

   select ID, Live_Time, Live_Date from schedule
   where TO_DAYS(NOW()) = Live_Date
   and SOMETHING = Live_Time

 and it's the SOMETHING that I need to know!

 (Before you ask, there are reasons why the date and time are separate
 columns rather than being a single datetime column, and I don't want
 to rewrite the structure unless I have to)

 Thanks

 Mark

 -
 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

-- 
mysql, sql, query

-
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

SQL statements howto

[FlashGuy]

Hi,

What SQL statements do I have to use to get the following results?


I have a preferences page that lists directories with check boxes. This is displaying 
by querying my database. It looks something like this:

Preferences: (Click to omit directories from listing)

[  ] dir1
[  ] dir2
[  ] dir3
[  ] dir4
[  ] dir5

[ UPDATE ]

Preferences: (Click to add directories to listing)

No directories selected.

[ UPDATE ]


So if the user checked on boxes dir2 and dir4 and clicks on the update I then want 
the screen to appear like:

[  ] dir1
[  ] dir3
[  ] dir5

[ UPDATE ]

Preferences: (Click to add directories to listing)

[  ] dir2
[  ] dir4

[ UPDATE ]

I'm not how to make this happen using my queries? 


---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---




-
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

Lost Connection During Query

[Insanely Great]

Greetings

I have a MySQL server with my ISP. Previously I was able to connect to the
server using any client. But now when I connect it says lost connection
during query ?

What is the reason ?

Rgds
Insane


-
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

INSERT INTO ... SELECT question

[Greg Macek]

Hello,

I recently stumbled upon the INSERT INTO..SELECT abilities. Basically
what I'm doing is archiving records into another table before deleting
them (inventory information). However, I'd like to have the archive
table to have one more field than the original table: a date_archived
function. So, for example if the tables looked like this: (quite
simplified)

Original:

carton_id
item_id
qty
status
date_recd

Archive

carton_id
item_id
qty
status
date_recd
date_archived *(new field)

Can I have the SQL query have a NOW() in there to insert today's date
when running this ? 

INSERT INTO archive
(carton_id,item_id,qty,status,date_recd,date_archived) 
SELECT carton_id,item_id,qty,status,date_recd, NOW() FROM original

Would this work? I'd like to know upfront before basing my code around
this or whether or not I'll have to track how many records are going
into the new table and manually updating the field. Thanks.

- Greg




-
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

Raising Max Datafile size for a table....

[Richard Idalski]

I'm looking for the proper way to raise the Max Datafile size for a table of
mine that's just about maxed out.

I've been trying various ALTER TABLES commands but none have worked, and I'm
even sure the alter tables is the way to go with this.

What is the proper way to raise that variable.

This is for Mysql 3.23.49

---
Richard Idalski
System Administrator
Nando Media
Office: 919.829.4805
AIM: Ryusonuke
www.nandomedia.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: INSERT INTO ... SELECT question

[Greg Macek]

Well, amazingly enough, it works great! I found a test box to try it on
first before implementing this on the production box. This will
definitely make life easier... 

On Thu, 2002-11-14 at 10:14, gerald_clark wrote:
 Did you try it?
 Did it work?
 
 Greg Macek wrote:
 
 Hello,
 
 I recently stumbled upon the INSERT INTO..SELECT abilities. Basically
 what I'm doing is archiving records into another table before deleting
 them (inventory information). However, I'd like to have the archive
 table to have one more field than the original table: a date_archived
 function. So, for example if the tables looked like this: (quite
 simplified)
 
 Original:
 
 carton_id
 item_id
 qty
 status
 date_recd
 
 Archive
 
 carton_id
 item_id
 qty
 status
 date_recd
 date_archived *(new field)
 
 Can I have the SQL query have a NOW() in there to insert today's date
 when running this ? 
 
 INSERT INTO archive
 (carton_id,item_id,qty,status,date_recd,date_archived) 
 SELECT carton_id,item_id,qty,status,date_recd, NOW() FROM original
 
 Would this work? I'd like to know upfront before basing my code around
 this or whether or not I'll have to track how many records are going
 into the new table and manually updating the field. Thanks.
 
 - Greg
 
 
 
 
 -
 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 2 servers on 1 DB

[Jeremy Zawodny]

On Thu, Nov 14, 2002 at 02:44:47PM +0200, Andrey Kotrekhov wrote:
 Hi, All! sql
 
 Can I run 2 mysqld that use the same DB?
 Not replication , 1 DB on my HDD but 2 mysqld work with this DB.
 
 For example I have external RAID and I want decrease CPU usage.
 I run 2 mysqld on different servers, but they use 1 DB.
 Is this possible?

If you enable MySQL's extenal locking support, yes.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 100 days, processed 2,121,676,852 queries (244/sec. avg)

-
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: INSERT INTO ... SELECT question

[Matthew Baranowski]

Hey Greg:

A slightly easier way to do this is to use a timestamp field. Timestamp is
just a standard mysql data type. When a record is added, it records the
current time. When a record is updated, the timestamp field will be set to
the time of the update.

http://www.mysql.com/doc/en/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
multiple TIMESTAMP columns, only the first one is updated automatically.

Thanks,

Matt

Matthew P Baranowski
Data Manager, Office of Educational Assessment
University of Washington

- Original Message -
From: Greg Macek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 8:06 AM
Subject: INSERT INTO ... SELECT question


 Hello,

 I recently stumbled upon the INSERT INTO..SELECT abilities. Basically
 what I'm doing is archiving records into another table before deleting
 them (inventory information). However, I'd like to have the archive
 table to have one more field than the original table: a date_archived
 function. So, for example if the tables looked like this: (quite
 simplified)

 Original:

 carton_id
 item_id
 qty
 status
 date_recd

 Archive

 carton_id
 item_id
 qty
 status
 date_recd
 date_archived *(new field)

 Can I have the SQL query have a NOW() in there to insert today's date
 when running this ?

 INSERT INTO archive
 (carton_id,item_id,qty,status,date_recd,date_archived)
 SELECT carton_id,item_id,qty,status,date_recd, NOW() FROM original

 Would this work? I'd like to know upfront before basing my code around
 this or whether or not I'll have to track how many records are going
 into the new table and manually updating the field. Thanks.

 - Greg




 -
 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: Re: update tablename

[Egor Egorov]

Rodrigo,
Tuesday, November 12, 2002, 10:44:38 PM, you wrote:

 I want to change a tablename in my database. How do i do that? I want to
RSM do
 it from a webpage so i need to use php.

Take a look at ALTER TABLE statement:
 http://www.mysql.com/doc/en/ALTER_TABLE.html

or RENAME TABLE statement:
 http://www.mysql.com/doc/en/RENAME_TABLE.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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

re: Index of packed table not used

[Victoria Reznichenko]

Bungarz,
Wednesday, November 13, 2002, 11:13:18 AM, you wrote:

BK Hi!
BK We are using mysql, version 4.0.4 beta on windows 2000 Server.
BK I packed a table with 100 million rows, using myisampack.
BK Now queries don't use the index of this table.
BK It's not possible for me, to work with table scan.
BK So, what can i do?  

Do you run myisamchk -rq on compressed table? Did MySQL used index
before?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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

Re: INSERT INTO ... SELECT question

[Greg Macek]

Thanks for the tip! Looks like I can change my date_archived field to
timestamp(8), since all I care about for this is the date information
(actual time is useless to me). My sql query all of a sudden got a lot
simpler. Thanks again for the help!


On Thu, 2002-11-14 at 11:07, Matthew Baranowski wrote:
 Hey Greg:
 
 A slightly easier way to do this is to use a timestamp field. Timestamp is
 just a standard mysql data type. When a record is added, it records the
 current time. When a record is updated, the timestamp field will be set to
 the time of the update.
 
 http://www.mysql.com/doc/en/DATETIME.html
 The TIMESTAMP column type provides a type that you can use to automatically
 mark INSERT or UPDATE operations with the current date and time. If you have
 multiple TIMESTAMP columns, only the first one is updated automatically.
 
 Thanks,
 
 Matt
 
 Matthew P Baranowski
 Data Manager, Office of Educational Assessment
 University of Washington
 
 - Original Message -
 From: Greg Macek [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, November 14, 2002 8:06 AM
 Subject: INSERT INTO ... SELECT question
 
 
  Hello,
 
  I recently stumbled upon the INSERT INTO..SELECT abilities. Basically
  what I'm doing is archiving records into another table before deleting
  them (inventory information). However, I'd like to have the archive
  table to have one more field than the original table: a date_archived
  function. So, for example if the tables looked like this: (quite
  simplified)
 
  Original:
 
  carton_id
  item_id
  qty
  status
  date_recd
 
  Archive
 
  carton_id
  item_id
  qty
  status
  date_recd
  date_archived *(new field)
 
  Can I have the SQL query have a NOW() in there to insert today's date
  when running this ?
 
  INSERT INTO archive
  (carton_id,item_id,qty,status,date_recd,date_archived)
  SELECT carton_id,item_id,qty,status,date_recd, NOW() FROM original
 
  Would this work? I'd like to know upfront before basing my code around
  this or whether or not I'll have to track how many records are going
  into the new table and manually updating the field. Thanks.
 
  - Greg
 
 
 
 
  -
  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: INSERT INTO ... SELECT question

[Paul DuBois]

At 11:15 -0600 11/14/02, Greg Macek wrote:

Thanks for the tip! Looks like I can change my date_archived field to
timestamp(8), since all I care about for this is the date information
(actual time is useless to me). My sql query all of a sudden got a lot
simpler. Thanks again for the help!


TIMESTAMP values are always stored to the full 14 digits.  The 8
affects display only, though that appears to be exactly what you want.




On Thu, 2002-11-14 at 11:07, Matthew Baranowski wrote:

 Hey Greg:

 A slightly easier way to do this is to use a timestamp field. Timestamp is
 just a standard mysql data type. When a record is added, it records the
 current time. When a record is updated, the timestamp field will be set to
 the time of the update.

 http://www.mysql.com/doc/en/DATETIME.html
 The TIMESTAMP column type provides a type that you can use to automatically
 mark INSERT or UPDATE operations with the current date and time. If you have
 multiple TIMESTAMP columns, only the first one is updated automatically.

 Thanks,

 Matt

 Matthew P Baranowski
 Data Manager, Office of Educational Assessment

  University of Washington



-
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: Thread Memory Usage

[Jeremy Zawodny]

On Thu, Nov 14, 2002 at 09:02:59AM -0500, Nicholas Elliott wrote:
 Hey folks,
 
 I've looked around, but haven't seen anything similar to _quite_ the problem
 I have.  The symptoms are thus:  memory usage for each mysqld process in top
 creeps up to around 13%, 274MB, and stays there, no matter what I set my
 config to.

 79 processes: 76 sleeping, 3 running, 0 zombie, 0 stopped
 CPU0 states: 100.0% user,  0.1% system,  0.0% nice,  0.0% idle
 CPU1 states: 98.2% user,  1.2% system,  0.0% nice,  0.0% idle
 CPU2 states:  1.1% user,  2.0% system,  0.0% nice, 96.2% idle
 CPU3 states:  0.0% user,  0.1% system,  0.0% nice, 99.4% idle
 Mem:  2064836K av, 2053068K used,   11768K free,   0K shrd,   15836K
 buff
 Swap: 2096440K av,   35312K used, 2061128K free 1429524K
 cached
 
   PID USER PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
 18339 hunt  25   0  267M 267M   696 R99.9 13.2  64:53 framework
   985 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1015 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1016 mysql 18   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1017 mysql 16   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1018 mysql 17   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1019 mysql 20   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1044 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1045 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:09 mysqld
  1046 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:00 mysqld
  1047 mysql 15   0  274M 259M 14460 S 0.0 12.8   0:09 mysqld
  1196 mysql 15   0  274M 259M 14460 S 0.0 12.8  16:14 mysqld
  1288 mysql 25   0  274M 259M 14460 S 0.0 12.8  29:06 mysqld
 25425 mysql 25   0  274M 259M 14460 R99.9 12.8  26:10 mysqld
 29645 mysql 15   0  274M 259M 14460 S 0.0 12.8   1:04 mysqld
 
 Now, I'm assuming some of that memory must be shared across
 processes(threads?) since 14 processes * 12.8% is more than 100%,
 and technically I still have 11.7M free.

Yes.

 My config has this:
 
 
 set-variable = key_buffer=256M
 set-variable = max_allowed_packet=1M
 set-variable = table_cache=64
 set-variable = sort_buffer=1M
 set-variable = record_buffer=1M
 set-variable = myisam_sort_buffer_size=64M
 set-variable = thread_cache=8
 # Try number of CPU's*2 for thread_concurrency
 set-variable = thread_concurrency=8
 
 
 
 
 Now, I've tried dropping all of the variables, cutting them in half, then
 again, to no avail -- when I run a large query (via the DBI interface in
 perl) the Mem usage jumps up to 13% (for all mysqld) and never comes back
 down.  Most notibly I've dropped the key_buffer to 64M and the table_cache
 to 32.

That tells me that you're my.cnf file isn't being read by MySQL.  Or
you're editing the wrong one.  Or something similar.

After you change the values and restart, run SHOW VARIABLES and make
sure the values agree with what you expect.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 100 days, processed 2,122,549,010 queries (244/sec. avg)

-
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: Raising Max Datafile size for a table....

[Paul DuBois]

At 11:17 -0500 11/14/02, Richard Idalski wrote:

I'm looking for the proper way to raise the Max Datafile size for a table of
mine that's just about maxed out.


What's the table type, and are you sure you're reaching the max table
size rather than running into a limit on your file system's file size?


I've been trying various ALTER TABLES commands but none have worked, and I'm
even sure the alter tables is the way to go with this.

What is the proper way to raise that variable.

This is for Mysql 3.23.49

---
Richard Idalski
System Administrator
Nando Media
Office: 919.829.4805
AIM: Ryusonuke
www.nandomedia.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: simple query turned ugly

[Jon Frisby]

 SELECT papers.id,
   concat(a1.first_name,' ',a1.middle_name,' ',a1.last_name) 
 as author1,
   concat(a2.first_name,' ',a2.middle_name,' ',a2.last_name) 
 as author2,
   concat(a3.first_name,' ',a3.middle_name,' ',a3.last_name) 
 as author3,
   concat(a4.first_name,' ',a4.middle_name,' ',a4.last_name) 
 as author4,
   concat(a5.first_name,' ',a5.middle_name,' ',a5.last_name) 
 as author5,
   year
 FROM papers
   LEFT JOIN authors a1 ON a1.id = papers.author1
   LEFT JOIN authors a2 ON a2.id = papers.author2
   LEFT JOIN authors a3 ON a3.id = papers.author3
   LEFT JOIN authors a4 ON a4.id = papers.author4
   LEFT JOIN authors a5 ON a5.id = papers.author5
 ORDER BY year ASC
 
 (Don't know why you would use GROUP BY in this case.)
 
 LEFT JOIN is used because not all papers have five authors. 
 Read more about
 the different types of JOIN in the manual: URL:
 http://www.mysql.com/doc/en/JOIN.html 

Purely as an informational point, this should work as well:

...
FROM 
  papers, 
  authors AS a1
  LEFT JOIN authors AS a2 ON a2.id = papers.author2
  LEFT JOIN authors AS a3 ON a3.id = papers.author3
  LEFT JOIN authors AS a4 ON a4.id = papers.author4
  LEFT JOIN authors AS a5 ON a5.id = papers.author5
WHERE
  a1.id = papers.author1
ORDER BY 
  year ASC


Note that the only difference is that the first LEFT JOIN has been
replaced with a plain JOIN.  I have no idea if this would be more
efficient in practice but it should make the nature of the data a tiny
bit clearer -- a publication presumably must have at least one author.
:)

-JF



-
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 statements howto

[Michael T. Babcock]

FlashGuy wrote:


What SQL statements do I have to use to get the following results?
 


http://www.google.com ... sql query howto ...

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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

mysql replication loop setup

[Gerald]

I've read the mysql replication documentation, and I've seen mentioned
only once setting up the replication loop: A - B - C - A.

I'd like to setup a simple version of the same: A - B so that if A goes
down my application can talk to whichever server is up and when A comes
back up he will resync and life will go on. There is not much instruction
or confirmation that this can work like I expect it too so I'm turning
here for the confirmation.

I currently have setup:

A - B
Where A is mysql-server-3.23.49 and B is mysql-server-3.23.52. I can yank
out the version offset if it is an issue, but for now I'm just trying to
set this up for failure possibilities.

The application is so low of a load 1 server would do fine, but with the
new replication features I would like to set this up from the start.

Since both of the servers are in sync at the moment is it just a matter of
pointing A to B for its master? The documentation kind of stops after you
have A - B.

Second Problem/Curiosity:

After A - B is setup, has anyone had problems with one bouncing and not
resyncing after returning to duty?

For anyone that cares the database will be for RADIUS
authentication/accounting with gnu-radius. A will be the master DB and B,
C, D, ... will be the Radius servers with mysql running on localhost. On
the off chance that the RAS boxes cannot talk to A to send accounting
records, I would like for them to pass the record to whichever DB is up
and I need mysql to fill the gap on keeping the data in sync. RAS has no
issue with passing the accounting information on to the next radius/mysql
server that will confirm receipt.

Thanks in advance for help,

Gerald


-
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

bug with the installation of mysql.

[Philippe Benchemoul]

Hello,

I have a problem with the installation of mysql.

The configure is ok but I have this message when I run the make command:
---
PIC -o .libs/libmysql.lo
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1325: too few arguments to function `gethostbyname_r'
libmysql.c:1325: warning: assignment makes pointer from integer without
a cast
make[2]: *** [libmysql.lo] Error 1
make[2]: Leaving directory `/usr/local/src/mysql-3.23.53/libmysql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/mysql-3.23.53'
make: *** [all-recursive-am] Error 2
---

It's mysql-3.23.53 with debian woody.

Thank's in advance if you can help me.

-
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: 'mysqlbug

[miguel solórzano]

At 18:06 14/11/2002 +0800, Wong, Kee Lang wrote:
Hi,

Sorry but I wasn't be able for to repeat the behavior reported:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.

D:\c:\mysql\bin\mysqld --standalone

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.

D:\c:\mysql\bin\mysql --version
c:\mysql\bin\mysql  Ver 12.14 Distrib 4.0.4-beta, for Win95/Win98 (i32)

D:\c:\mysql\bin\mysqlshow
+---+
| Databases |
+---+
| mysql |
| test  |
+---+

It is worked fine to me.


Dear Sir,

I am very new to the mySQL product. I am trying to do some RD on the
possibility to port the MS SQL to mySQL for our system. I have tried with
mysql-3.23.53-win. I able to start the mySQL and run the mysqlshow command
and others.

However, if I try with the mysql-max-4.0.4-beta-win, I started the mysql
using mysqld -standalone.  When I try to execute the mysqlshow command,
there is no respond from the dos prompt. And then my PC become very slow in
responding.

Please help. Thank you very much.

Regards,
Kee Lang

-
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


--
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   São Paulo - Brazil
   ___/   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

Copying one table to another

[ed]

Say I have 2 tables with the exact same formatting (fields, values, etc.)
Is there an easy way to dump the contents of one table to the other in SQL
rather than outputting the one to a .txt or .sql and inputing it into the
other table?

Thanks,

Ed



-
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: Copying one table to another

[Andrew Braithwaite]

Ed,

You could use the insert .. select syntax.

See: http://www.mysql.com/doc/en/INSERT_SELECT.html

Cheers,

Andrew

-Original Message-
From: [EMAIL PROTECTED] [mailto:ed;home.homes2see.com] 
Sent: Thursday, 14 November 2002 18:50
To: [EMAIL PROTECTED]
Subject: Copying one table to another



Say I have 2 tables with the exact same formatting (fields, values, etc.) Is
there an easy way to dump the contents of one table to the other in SQL
rather than outputting the one to a .txt or .sql and inputing it into the
other table?

Thanks,

Ed



-
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

FW: confirm unsubscribe from mysql@lists.mysql.com

[Black, Kelly W [PCS]]

Cute.

sql, query

~K Black

-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-help;lists.mysql.com]
Sent: Thursday, November 14, 2002 6:38 AM
To: Black, Kelly W [PCS]
Subject: confirm unsubscribe from [EMAIL PROTECTED]


Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.

To confirm that you would like

   [EMAIL PROTECTED]

removed from the mysql mailing list, please send an empty reply 
to this address:

 
[EMAIL PROTECTED]
ysql.com

Usually, this happens when you just hit the reply button.
If this does not work, simply copy the address and paste it into
the To: field of a new message.

I haven't checked whether your address is currently on the mailing list.
To see what address you used to subscribe, look at the messages you are
receiving from the mailing list. Each message has your address hidden
inside its return path; for example, [EMAIL PROTECTED] receives messages
with return path: mysql-return-number[EMAIL PROTECTED]

Some mail programs are broken and cannot handle long addresses. If you
cannot reply to this request, instead send a message to
[EMAIL PROTECTED] and put the entire address listed above
into the Subject: line.


--- Administrative commands for the mysql list ---

I can handle administrative requests automatically. Please
do not send them to the list address! Instead, send
your message to the correct command address:

To subscribe to the list, send a message to:
   [EMAIL PROTECTED]

To remove your address from the list, send a message to the address
in the List-Unsubscribe header of messages from the list. If you don't
know how to display headers and haven't changed E-mail addresses since
subscribing, you'll be successful with an e-mail to:
   [EMAIL PROTECTED]

Send mail to the following for info and FAQ for this list:
   [EMAIL PROTECTED]
   [EMAIL PROTECTED]

Similar addresses exist for the digest list:
   [EMAIL PROTECTED]
   [EMAIL PROTECTED]

To get messages 123 through 145 (a maximum of 100 per request), mail:
   [EMAIL PROTECTED]

To get an index with subject and author for messages 123-456 , mail:
   [EMAIL PROTECTED]

They are always returned as sets of 100, max 2000 per request,
so you'll actually get 100-499.

To receive all messages with the same subject as message 12345,
send an empty message to:
   [EMAIL PROTECTED]

The messages do not really need to be empty, but I will ignore
their content. Only the ADDRESS you send to is important.

You can start a subscription for an alternate address,
for example [EMAIL PROTECTED], just add a hyphen and your
address (with '=' instead of '@') after the command word:
[EMAIL PROTECTED]

To stop subscription for this address, mail:
[EMAIL PROTECTED]

In both cases, I'll send a confirmation message to that address. When
you receive it, simply reply to it to complete your subscription.

If despite following these instructions, you do not get the
desired results, please contact my owner at
[EMAIL PROTECTED] Please be patient, my owner is a
lot slower than I am ;-)

--- Enclosed is a copy of the request I received.

Return-Path: [EMAIL PROTECTED]
Received: (qmail 6789 invoked from network); 14 Nov 2002 14:38:00 -
Received: from esacom56-ext.estec.esa.int (HELO esacom56-int.estec.esa.int)
(131.176.107.3)
  by www.mysql.com with SMTP; 14 Nov 2002 14:38:00 -
Received: from esacom52.estec.esa.int. (esacom52.estec.esa.nl [131.176.7.7])
by esacom56-int.estec.esa.int (8.10.2/8.10.2/ESA-External-v2.0) with
ESMTP id gAEEbcX22596
for [EMAIL PROTECTED];
Thu, 14 Nov 2002 15:37:38 +0100 (MET)
Received: from estecmail4.estec.esa.int (estecmail4.estec.esa.nl
[131.176.7.65])
by esacom52.estec.esa.int. (8.9.2/8.9.2/ESA-ESTEC-mail-gw-v1.6) with
SMTP id OAA24083
for [EMAIL PROTECTED];
Thu, 14 Nov 2002 14:37:38 GMT
Received: by estecmail4.estec.esa.int(Lotus SMTP MTA v4.6.7  (934.1
12-30-1999))  id 41256C71.0055AD1A ; Thu, 14 Nov 2002 16:35:48 +0100
X-Lotus-FromDomain: ESA
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Date: Thu, 14 Nov 2002 15:37:29 +0100
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline




Erik F. van der Wenden
ESTEC/TOS-EMS
Postbus 299
2200 AG Noordwijk, The Netherlands
Keplerlaan 1
2201 AZ Noordwijk, The Netherlands

T: (31) 71 5653594
M: (31) 6 51608116
E: [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: Copying one table to another

[Gelu Gogancea]

Hi,

You can use :
INSERT INTO SELECT * FROM YOUR_TABLE

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 8:49 PM
Subject: Copying one table to another



 Say I have 2 tables with the exact same formatting (fields, values, etc.)
 Is there an easy way to dump the contents of one table to the other in SQL
 rather than outputting the one to a .txt or .sql and inputing it into the
 other table?

 Thanks,

 Ed



 -
 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

my host IP changed

[Chris Walcott]

I just got mysql up and running (I'm a new user).  I'm using it with ColdFusionMX.

Just as I was about to bind a database to coldfusion, my IT department decided to move 
my server to a new IP address.

Now I can't get a database to bind to coldFusion and I'm wondering if it's because the 
IP address changed.  Is this something that is stored in the mysql database?  

If so, how so I change that?  I'd rather not have to rerun mysql_install_db.

- chris

-
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

assigning a user/passwd to a database

[Chris Walcott]

How do I set a username/passwd to a specific database for authentication?

I know how to create users but I can't find anything in the docs about how to password 
protect a database that is publicly available.

I'm using mysql with ColdFusion and one of the things you are aupposed to supply when 
binding a database to CF is a username and password

- chris

-
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

The mysql.db table

[Rick Root]

What is the mysql.db table for?

It looks like it contains user and database permissions of some kind.. 
but.. many of the rows in the db table refer to databases and/or users 
that don't exist on my server anymore, which were dropped with drop 
database.

Also, is the proper way to REMOVE a user from the system to delete them 
from the mysql.user table?  Ie, delete from user where user='foo'?

Thanks!

Rick Root


-
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: my host IP changed

[Bruce Lewis]

It is very possible.  Your network may need an update as to what the new IP
address is.  Most networks take anywhere from 20-30 minutes to get the
updates (depends upon your network administrators configuration).  Another
may be with your code.  If you are using ODBC, you may need to change the
code in that area as well if you are specifying an IP address.

This is for a Windows environment though, but it should be similar to Unix
as well.

Bruce



- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 1:22 PM
Subject: my host IP changed


 I just got mysql up and running (I'm a new user).  I'm using it with
ColdFusionMX.

 Just as I was about to bind a database to coldfusion, my IT department
decided to move my server to a new IP address.

 Now I can't get a database to bind to coldFusion and I'm wondering if it's
because the IP address changed.  Is this something that is stored in the
mysql database?

 If so, how so I change that?  I'd rather not have to rerun
mysql_install_db.

 - chris

 -
 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

CRASHING my machine on close

[CoastResearch]

if ANYONE has any suggestions for this I would greatly appreciate  
it :) I just dont know where else to turn for help ... 


If I launch MySQL 3.23.38, everything is fine. If I open tables,  
 creat db,  
 add records whatever, no problem. When I close MySQL my hard  
 drive is ? alot and I can do nothing except a hard reboot. 
  

 I have tried quitting immediatly after launching MySQLadmin and  
 then there is no problem. but after I have connected and  
 disconnected a few times and done stuff to my database this  
 problem happens. 
  

  
After a while the machine hesitates as im working while  is  
going on cant even move the mouse. 

Ive run scan disc befor i install and done a full virus check befor  
install. I have 3 processes running including QuickLaunch and  
Black Ice. 

Someone else must have noticed something like this before. My  
machine is not unique (400mhz e-machine) 

Regards
Mike

Regards
Mike

-
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: my host IP changed

[Gelu Gogancea]

Hi,

It's possible that in mysql.user table to exist the old IP address of your
machine.You should check the field Host using:

use mysql;
select Host,User from user where User='YOUR_USER_NAME';

If in the Host field you see the '%' character that means your problem is
not from MySQL... else you should to update the new IP address in the
mysql.user table using update or replace.
Finally you must do:
flush privileges;

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 9:22 PM
Subject: my host IP changed


 I just got mysql up and running (I'm a new user).  I'm using it with
ColdFusionMX.

 Just as I was about to bind a database to coldfusion, my IT department
decided to move my server to a new IP address.

 Now I can't get a database to bind to coldFusion and I'm wondering if it's
because the IP address changed.  Is this something that is stored in the
mysql database?

 If so, how so I change that?  I'd rather not have to rerun
mysql_install_db.

 - chris

 -
 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: my host IP changed

[Chris Walcott]

right now the host field has 2 entries: localhost and newpop (the name of the server). 
 There are no IP numbers.  Should I replace the host name entry with the new IP 
address?

thanks!

- chris

 -Original Message-
 From: Gelu Gogancea [mailto:ggelu;arctic.ro]
 Sent: Thursday, November 14, 2002 11:47 AM
 To: Chris Walcott; Mysql-L (E-mail)
 Subject: Re: my host IP changed
 
 
 Hi,
 
 It's possible that in mysql.user table to exist the old IP 
 address of your
 machine.You should check the field Host using:
 
 use mysql;
 select Host,User from user where User='YOUR_USER_NAME';
 
 If in the Host field you see the '%' character that means 
 your problem is
 not from MySQL... else you should to update the new IP address in the
 mysql.user table using update or replace.
 Finally you must do:
 flush privileges;
 
 Regards,
 
 Gelu
 _
 G.NET SOFTWARE COMPANY
 
 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Chris Walcott [EMAIL PROTECTED]
 To: Mysql-L (E-mail) [EMAIL PROTECTED]
 Sent: Thursday, November 14, 2002 9:22 PM
 Subject: my host IP changed
 
 
  I just got mysql up and running (I'm a new user).  I'm using it with
 ColdFusionMX.
 
  Just as I was about to bind a database to coldfusion, my IT 
 department
 decided to move my server to a new IP address.
 
  Now I can't get a database to bind to coldFusion and I'm 
 wondering if it's
 because the IP address changed.  Is this something that is 
 stored in the
 mysql database?
 
  If so, how so I change that?  I'd rather not have to rerun
 mysql_install_db.
 
  - chris
 
  
 -
  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: my host IP changed

[Gelu Gogancea]

Yes.You can put the new IP address instead of the name (no localhost).When
you make update, you must be sure that YOU DON'T REPLACE and the record
where the Host field is 'localhost'.You must replace only the record where
in Host field is the name of computer/server which must connect to the
MySQL.
You can use :
update user SET Host='YOUR_IP_ADDRESS' where User='YOUR_USER_NAME' and
Host='THE_NAME_OF_HOST';

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott
[EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 9:52 PM
Subject: RE: my host IP changed


 right now the host field has 2 entries: localhost and newpop (the name of
the server).  There are no IP numbers.  Should I replace the host name entry
with the new IP address?

 thanks!

 - chris

  -Original Message-
  From: Gelu Gogancea [mailto:ggelu;arctic.ro]
  Sent: Thursday, November 14, 2002 11:47 AM
  To: Chris Walcott; Mysql-L (E-mail)
  Subject: Re: my host IP changed
 
 
  Hi,
 
  It's possible that in mysql.user table to exist the old IP
  address of your
  machine.You should check the field Host using:
 
  use mysql;
  select Host,User from user where User='YOUR_USER_NAME';
 
  If in the Host field you see the '%' character that means
  your problem is
  not from MySQL... else you should to update the new IP address in the
  mysql.user table using update or replace.
  Finally you must do:
  flush privileges;
 
  Regards,
 
  Gelu
  _
  G.NET SOFTWARE COMPANY
 
  Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
  - Original Message -
  From: Chris Walcott [EMAIL PROTECTED]
  To: Mysql-L (E-mail) [EMAIL PROTECTED]
  Sent: Thursday, November 14, 2002 9:22 PM
  Subject: my host IP changed
 
 
   I just got mysql up and running (I'm a new user).  I'm using it with
  ColdFusionMX.
  
   Just as I was about to bind a database to coldfusion, my IT
  department
  decided to move my server to a new IP address.
  
   Now I can't get a database to bind to coldFusion and I'm
  wondering if it's
  because the IP address changed.  Is this something that is
  stored in the
  mysql database?
  
   If so, how so I change that?  I'd rather not have to rerun
  mysql_install_db.
  
   - chris
  
  
  -
   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: my host IP changed

[Bruce Lewis]

One other simple task that you can try is to just perform a ping.  If you
can ping the server with the new IP address, then your network is not the
problem.

Bruce



- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Chris Walcott [EMAIL PROTECTED]; Mysql-L (E-mail)
[EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 2:05 PM
Subject: Re: my host IP changed


 Yes.You can put the new IP address instead of the name (no localhost).When
 you make update, you must be sure that YOU DON'T REPLACE and the record
 where the Host field is 'localhost'.You must replace only the record where
 in Host field is the name of computer/server which must connect to the
 MySQL.
 You can use :
 update user SET Host='YOUR_IP_ADDRESS' where User='YOUR_USER_NAME' and
 Host='THE_NAME_OF_HOST';

 Regards,

 Gelu
 _
 G.NET SOFTWARE COMPANY

 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Chris Walcott [EMAIL PROTECTED]
 To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott
 [EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED]
 Sent: Thursday, November 14, 2002 9:52 PM
 Subject: RE: my host IP changed


  right now the host field has 2 entries: localhost and newpop (the name
of
 the server).  There are no IP numbers.  Should I replace the host name
entry
 with the new IP address?
 
  thanks!
 
  - chris
 
   -Original Message-
   From: Gelu Gogancea [mailto:ggelu;arctic.ro]
   Sent: Thursday, November 14, 2002 11:47 AM
   To: Chris Walcott; Mysql-L (E-mail)
   Subject: Re: my host IP changed
  
  
   Hi,
  
   It's possible that in mysql.user table to exist the old IP
   address of your
   machine.You should check the field Host using:
  
   use mysql;
   select Host,User from user where User='YOUR_USER_NAME';
  
   If in the Host field you see the '%' character that means
   your problem is
   not from MySQL... else you should to update the new IP address in the
   mysql.user table using update or replace.
   Finally you must do:
   flush privileges;
  
   Regards,
  
   Gelu
   _
   G.NET SOFTWARE COMPANY
  
   Permanent e-mail address : [EMAIL PROTECTED]
 [EMAIL PROTECTED]
   - Original Message -
   From: Chris Walcott [EMAIL PROTECTED]
   To: Mysql-L (E-mail) [EMAIL PROTECTED]
   Sent: Thursday, November 14, 2002 9:22 PM
   Subject: my host IP changed
  
  
I just got mysql up and running (I'm a new user).  I'm using it with
   ColdFusionMX.
   
Just as I was about to bind a database to coldfusion, my IT
   department
   decided to move my server to a new IP address.
   
Now I can't get a database to bind to coldFusion and I'm
   wondering if it's
   because the IP address changed.  Is this something that is
   stored in the
   mysql database?
   
If so, how so I change that?  I'd rather not have to rerun
   mysql_install_db.
   
- chris
   
   
   -
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





-
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

epayroll

[Kenneth Illingsworth]

Anyone have experience with Hotscripts Enterprise Timesheet and Payroll application? 
It's my first attempt at running a MySQL aplication. Here is the link:

http://www.hotscripts.com/Detailed/14498.html 

The installation seemed to go flawlessly. Apache webserver was running as well as 
MySQL v3.2.3.x, and the payroll.sql script created the tables as advertised. However, 
I could not seem to authenticate with uid admin and pw eps as per instructions. Anyone 
with working samples of this appication? I would like to see what your datacon.php and 
settings.php files look like.

Thanks in advance for your time.

Regards,
Ken Illingsworth


-
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 with Perl 5.8?

[miguel solórzano]

At 12:58 13/11/2002 +0200, Octavian Rasnita wrote:
Hi,

Hi all,

I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under
Windows 2000) but after installing Perl 5.8, ppm can't find this module
anymore.


I had the same issue, then I removed Perl and re-installed the
below early version:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.

D:\perl --version

This is perl, v5.6.0 built for MSWin32-x86-multi-thread
(with 1 registered patch, see perl -V for more detail)

Copyright 1987-2000, Larry Wall

Binary build 623 provided by ActiveState Tool Corp. http://www.ActiveState.com
Built 16:27:07 Dec 15 2000

Instead to use:

ppmInstall DBI
ppmInstall DBD::mysql

I did at prompt command:

ppm install 
http://www.perl.com/CPAN-local/authors/id/JWIED/DBD-mysql-1.2212.x86.ppd

and I was be able for to make my tests with MySQL.

Maybe there is other best option, but just now the above option is
enough to me, hope it help you too.


I could find only the module DBD::mysqlPP for pure Perl.
I don't understand what pure perl means but I've seen that this module
accepts less functions than DBD::mysql.

Do you know if DBD::mysql works with Perl 5.8 and how can I install it?

Thank you.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [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


--
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   São Paulo - Brazil
   ___/   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

RE: _rowid

[Dean Harding]

 The thing with Oracle is that once a row is assigned a ROWID, it
never
 changes.  It doesn't matter if the row grows and has to move within
the
 block (or if it has to move to another block, for that matter).
That's
 why ROWIDs work in Oracle.
 
 
 Neither does an auto_increment index value that you put in the table
 yourself.  I'm still waiting to hear a proponent of _rowid tell me why
 _rowid is _better_ for _database_admins_ than using an auto_increment
 column value.  The '_rowid takes no space' argument is hogwash; its
 stored by Oracle in space that MySQL doesn't allocate internally, so
its
 still taking up a few bytes per row of memory, like it or not.

The ROWID isn't stored by Oracle (except in your indexes).  The ROWID is
the *physical address* of the row (datafile + block # + offset in the
block).  It's stored in the same space that MySQL would allocate for
it's addresses.  And I'm not saying that the ROWID is of any value to
admins, because it really doesn't make a difference to an admin.  It's
useful for developers, perhaps.

In Oracle, because the ROWID is the actual physical address of the row,
it provides O(1) access to a row, as opposed to O(log(n)) that an index
provides.  That's a pretty good benefit if you ask me.  There's also no
overhead required when inserting new rows if you're using the ROWID as
your key, because there's no maintenance of an index required by the DB.
Of course, neither of those things is the case with MySQL's _rowid type,
so like I said, the only benefit for MySQL is in migration from
Oracle...

Oh, one more point, I'm not advocating the use of ROWID in Oracle
either.  Generally, an index *is* fast enough, and since about Oracle 8i
(or maybe it was 9i...), the format of the ROWID changed, because they
upped the limit on the number of datafiles, and hence had to increase
the size of the ROWID.  The old ROWID type is still there, but you just
can't use it if you've got more than 1022 datafiles. 

Dean.




-
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

1067

[Brock Taylor]

Hi,
I have installed mysqld-max-nt on my Win NT (SP 6) machine.  I got a message
of success.  When I try to start mysql (NET START MYSQL) I get an error
1067.  Reading the documentation I see that maybe I should be starting it
with named pipes.  Not sure...  But when I enter the command
mysqld-max-nt --enable-named-pipe my command window hangs forever.
Help!
Brock


-
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

Update help

[Beauford]

Hi,

I'm trying to update a table from my webpage but not having much luck,
although it works from the command line. Obviously I am missing
something and would appreciate any help.

Also. Is there a good tutorial or help page for Mysql. I find the one at
www.mysql.com not very helpful.

TIA

The code:

?

$db =mysql_connect(url,name,pass);
mysql_select_db(dbasename);
$query = UPDATE counter SET number=number+1; 

  
?



-
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: Update help

[Jennifer Goodie]

You might want to try actually running the query.
mysql_query ($query);
or
mysql_query ($query,$db);
depending on your preference.

-Original Message-
From: Beauford [mailto:beauford.2003;rogers.com]
Sent: Thursday, November 14, 2002 1:53 PM
To: [EMAIL PROTECTED]
Subject: Update help


Hi,

I'm trying to update a table from my webpage but not having much luck,
although it works from the command line. Obviously I am missing
something and would appreciate any help.

Also. Is there a good tutorial or help page for Mysql. I find the one at
www.mysql.com not very helpful.

TIA

The code:

?

$db =mysql_connect(url,name,pass);
mysql_select_db(dbasename);
$query = UPDATE counter SET number=number+1;


?



-
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: 1067

[Paul DuBois]

At 14:49 -0700 11/14/02, Brock Taylor wrote:

Hi,
I have installed mysqld-max-nt on my Win NT (SP 6) machine.  I got a message
of success.  When I try to start mysql (NET START MYSQL) I get an error
1067.  Reading the documentation I see that maybe I should be starting it
with named pipes.  Not sure...  But when I enter the command
mysqld-max-nt --enable-named-pipe my command window hangs forever.
Help!
Brock


Open another window and try to connect to the server with mysql.
The server may not be hung -- just running.

-
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

Error 2013

[Tom Morgan]

Hello,
I have installed Red Hat 8.0 and Mysql from the CD's.  I am able to telnet
to localhost at port 3306.  However I can not telnet to the external ip
address at port 3306.  netstat -a lists *:mysql listening.  When I run a
mysql from a Win 2k box I get : ERROR 2013: Lost connection to MySQL server
during query.

Thanks,
Tom Morgan

-
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

mysql_install_db fails mysqld cannot find libgthreads.so

[john]

Description:

Running the mysql_install_db or configure scripts fail to install
database tables. mysqld cannot find libgthreads.so even though it is
in /usr/local/lib. Script also complains that libc are not 100 %
compatible; I think I have the latest version. The out put from the
script follows.

# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

dynamic linker : ./bin/my_print_defaults : error opening libgthreads.so
./scripts/mysql_install_db: 3740 Killed
./scripts/mysql_install_db: 3742 Killed
./scripts/mysql_install_db: 3743 Killed
WARNING: The host 'curly.vtms.nawcad.navy.mil' could not be looked up with
resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL deamon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
dynamic linker : ./bin/mysqld : error opening libgthreads.so
./scripts/mysql_install_db: 3744 Killed
Installation of grant tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant 
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell ./bin/mysql -u root mysql
mysql show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
#

How-To-Repeat:
Install binary mysql package from 
mysql-max-3.23.53a-pc-sco3.2v5.0.6-i686.tar
Follow instrutions in INSTALL-BINARY text file. Fails at running
mysql_install_db.

Fix:

unknown


Submitter-Id:  submitter ID
Originator:John Griffiths
Organization:

MySQL support: [none | licence | email support | extended email support ]
Synopsis:  mysql_install_db fails mysqld can't find libgthreads.so
Severity:  
Priority:  
Category:  mysql
Class: 
Release:   mysql-3.23.53a-max (Official MySQL-max binary)

Environment:

Hewlett-Packard Vectra XU
SCO OpenServer 5.0.6
System: SCO_SV curly 3.2 5.0.6 i386


Some paths:  /usr/bin/perl /udk/usr/ccs/bin/make /usr/local/bin/gcc /udk/usr/ccs/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-sco3.2v5.0.5/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS='-O3 -mpentium '  CXX='gcc'  CXXFLAGS='-O3 
-mpentium -felide-constructors'  LDFLAGS='-static'
LIBC: 
lrwxrwxrwx   1 root root  41 Aug 21  2001 /usr/lib/libc.so.1 - 
/opt/K/SCO/Unix/5.0.6Ga/usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official 
MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max 
--enable-thread-safe-client --enable-local-infile --with-named-z-libs=no 
--enable-thread-safe-client --disable-shared --with-innodb 'CFLAGS=-O3 -mpentium' 
'CXXFLAGS=-O3 -mpentium -felide-constructors' CXX=gcc LDFLAGS=-static


-
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

Mysql SELECT question (LEFT JOIN?)

[Eric Anderson]

Assume two tables:

CREATE TABLE block_ip (
  datestamp int(11) NOT NULL default '0',
  remote_addr char(15) NOT NULL default '',
  PRIMARY KEY  (remote_addr),
  KEY datestamp (datestamp)
) TYPE=MyISAM;

CREATE TABLE brute_force (
  datestamp int(11) NOT NULL default '0',
  remote_addr char(15) NOT NULL default '',
  remote_user char(35) NOT NULL default '',
  KEY remote_addr (remote_addr),
  KEY datestamp (datestamp),
  KEY remote_user (remote_user)
) TYPE=MyISAM;

Contents of the 'brute_force' table (remote_addr):

1.2.3.4
2.3.4.5
3.4.5.6
4.5.6.7
5.6.7.8
6.7.8.9

Contents of the 'block_ip' table (remote_addr):

2.3.4.5
4.5.6.7

Can someone help me with the query that will select all the
'remote_addr' rows from 'brute_force' that are NOT in the 'block_ip'
table?

Something like:

select brute_force.* from brute_force, block_ip where
brute_force.remote_addr != block_ip.remote_addr

maybe?  I have a feeling it's some sort of left join, and I was never
very good at those.  :-/



-
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_install_db fails mysqld cannot find libgthreads.so

[Lance Prais]

I have a question about using count in an Intersect Statement.  I want to
get the total count of the following SQL Statement:  How would I do this?
SELECT
  nvl((c.sr_num),0)),
FROM
  s_evt_act a,
  s_srv_req c
WHERE
  a.sra_sr_id = c.row_id and
  a.priv_flg = 'N' and
  a.x_cp_created between (sysdate-1) and
  sysdate
intersect
SELECT
  (nvl((b.sr_num),0))
FROM
  s_srv_req b
WHERE
   b.x_cp_updated between (sysdate-1) and sysdate


-
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

Exciting new Replication Error

[Eric]

 Slave SQL thread initialized, starting replication in log 
'www200-bin.008' at position 38717817, relay log 
'./s142-17-103-3-relay-bin.056' position: 9212273
021114 16:34:12  Error in Log_event::read_log_event(): 'read error', 
data_len=161,event_type=2
021114 16:34:12  Slave SQL thread: I/O error reading event(errno: 
-1  cur_log-error: 122)
021114 16:34:12  Error reading relay log event: Aborting slave SQL thread 
because of partial event read
021114 16:34:12  Could not parse log event entry, check the master for 
binlog corruption
This may also be a network problem, or just a bug in the master or slave code.
021114 16:34:12  Error running query, slave SQL thread aborted. Fix the 
problem, and restart the slave SQL thread with SLAVE START. We stopped at 
log 'www200-bin.008' position 38717817
021114 16:34:12  Slave SQL thread exiting, replication stopped in 
log  'www200-bin.008' at position 38717817
021114 16:34:17  Slave I/O thread: connected to master 
'[EMAIL PROTECTED]:3306',  replication started in log 
'www200-bin.008' at position 38748768


I don't have a clue what this could mean. I had a screw up where I made a 
unique index on the master, but the database table on the slave had data 
that was not unique while the master data was unique. I backed up the table 
on the slave, deleted the data from the master table, deleted the data from 
the slave table, restarted the slave, it worked, removed both indexes on 
the slave and master... Then I copied the data back to the slave table. Now 
I get the above messages, and typing either slave start, or slave stop 
hangs endlessly.

Thanks,


Eric 


-
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: assigning a user/passwd to a database

[Peter Lovatt]

Hi

have you looked at GRANT

http://www.mysql.com/doc/en/GRANT.html

I think it is what you are looking for

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Chris Walcott [mailto:cwalcott;macromedia.com]
Sent: 14 November 2002 19:25
To: Mysql-L (E-mail)
Subject: assigning a user/passwd to a database


How do I set a username/passwd to a specific database for authentication?

I know how to create users but I can't find anything in the docs about how
to password protect a database that is publicly available.

I'm using mysql with ColdFusion and one of the things you are aupposed to
supply when binding a database to CF is a username and password

- chris

-
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

Exciting new Replication Error -- more info

[Eric]

MASTER Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)

SLAVE Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386)


On my Master I am getting this:


mysql SHOW BINLOG EVENTS IN '/usr/local/var/www200-bin.008' FROM 38717800;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6227106
Current database: *** NONE ***

ERROR 2013: Lost connection to MySQL server during query







Slave SQL thread initialized, starting replication in log 'www200-bin.008' 
at position 38717817, relay log './s142-17-103-3-relay-bin.056' position: 
9212273
021114 16:34:12  Error in Log_event::read_log_event(): 'read error', 
data_len=161,event_type=2
021114 16:34:12  Slave SQL thread: I/O error reading event(errno: 
-1  cur_log-error: 122)
021114 16:34:12  Error reading relay log event: Aborting slave SQL thread 
because of partial event read
021114 16:34:12  Could not parse log event entry, check the master for 
binlog corruption
This may also be a network problem, or just a bug in the master or slave code.
021114 16:34:12  Error running query, slave SQL thread aborted. Fix the 
problem, and restart the slave SQL thread with SLAVE START. We stopped at 
log 'www200-bin.008' position 38717817
021114 16:34:12  Slave SQL thread exiting, replication stopped in 
log  'www200-bin.008' at position 38717817
021114 16:34:17  Slave I/O thread: connected to master 
'[EMAIL PROTECTED]:3306',  replication started in log 
'www200-bin.008' at position 38748768


I don't have a clue what this could mean. I had a screw up where I made a 
unique index on the master, but the database table on the slave had data 
that was not unique while the master data was unique. I backed up the table 
on the slave, deleted the data from the master table, deleted the data from 
the slave table, restarted the slave, it worked, removed both indexes on 
the slave and master... Then I copied the data back to the slave table. Now 
I get the above messages, and typing either slave start, or slave stop 
hangs endlessly.

Thanks,


Eric 


-
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: simple query turned ugly

[Vince LaMonica]

On Thu, 14 Nov 2002, Roger Baklund wrote:

} * Vince LaMonica
[snip]
}  The user has created multiple author cols in the publications table
}  because the order of the author matters [eg: it is better for someone to
}  be an author1 than an author2 or a dreaded author5]. Some publications
}  have 1 author, some have up to five.
} 
} hm... This is not good db design... I would use a third table:
} 'paper_authors' with the columns 'paper_id', 'author_id' and 'prio', where
} 'prio' is a tinyint with the values 1-5.

You are correct, thanks. I added a paper_authors table with the above cols 
[except I called 'prio' 'priority' instead.

Applying your left join [as well as Jon Frisby's suggestion] works great 
for the non-normalized version of this small database. But now that I have 
the 'join table' [paper_authors] above, I'm not so certain how to produce 
the same results.

I'm currently attempting this by doing [only trying priority 1 and 2 
right now]:

SELECT
papers.id,
a1.last_name as auth1,
a2.last_name as auth2,
papers.year
FROM 
paper_authors, papers,
authors AS a1
left join authors AS a2 ON  (a2.id = paper_authors.author_id
AND 
paper_authors.paper_id = papers.id AND paper_authors.priority = '2')
WHERE
a1.id  = paper_authors.author_id
AND paper_authors.priority = '1'
AND paper_authors.paper_id = papers.id
ORDER BY
year ASC

Here's the 3 tables:

mysql desc authors;
+-+-+--+-+-++
| Field   | Type| Null | Key | Default | Extra  |
+-+-+--+-+-++
| id  | smallint(3) |  | PRI | NULL| auto_increment |
| last_name   | varchar(60) |  | | ||
| first_name  | varchar(60) | YES  | | NULL||
| middle_name | varchar(60) | YES  | | NULL||
+-+-+--+-+-++

mysql desc papers ;
+-+--+--+-+-++
| Field   | Type | Null | Key | Default | Extra  |
+-+--+--+-+-++
| id  | smallint(3) unsigned |  | PRI | NULL| auto_increment |
| year| varchar(4)   |  | | ||
| title   | varchar(255) | YES  | | NULL||
[snip]
[i took the author1 - author5 cols out]

mysql desc paper_authors;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| paper_id  | smallint(3) unsigned |  | | 0   |   |
| author_id | smallint(3) unsigned |  | | 0   |   |
| priority  | tinyint(1) unsigned  |  | | 0   |   |
+---+--+--+-+-+---+

Running the above query produces a the correct priority 1 author, but the 
priority 2 author rows are all NULL. Running the query with all 4 left 
joins results in the same NULL values in the auth2, auth3, etc, cols. I've 
got to be missing something basic here, right? 

Any further assistance would be most appreciated. 

/vjl/

-- 
Vince LaMonica   UC Irvine,  School  of  Social Ecology
 W3 Developer   *  116 Social Ecology I, Irvine, CA 92697
 [EMAIL PROTECTED]  http://www.seweb.uci.edu/techsupport

 Tower: Delta Zulu Romeo, turn right now and report your heading.
 Pilot: Wilco. 341, 342, 343, 344, 345...


-
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

Foreign Keys and InnoDb in MySQL

[Bruce Lee]

Hello,

I have a problem about foreign key in using MySQL.com manual. According to 
the example in MySQL.com manual, one foreign key is ok. However, I have 3 
tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more 
foreign keys, I have the following errors.

Case 1:

mysql create table customerTb (
customerId int not null,
primary key (customerId)
) type = innodb;
mysql insert into customerTb values (1), (2), (3), (4), (5);

mysql create table carTb (
carId int not null,
primary key (carId)
) type = innodb;
mysql insert into carTb values (1), (2), (3), (4), (5);

mysql create table buyTb (
customerId int not null,
carId int not null,
primary key (customerId, carId),
index i_Tb (customerId, carId),
foreign key (customerId) references customerTb (customerId),
foreign key (carId) references carTb (carId)
on delete cascade
) type = innodb;
ERROR 1005 at line 15: Can't create table '.\ibdata\buytb.frm' (errno: 150)

Case 2:

mysql create table customerTb (
customerId int not null,
primary key (customerId)
) type = innodb;
mysql insert into customerTb values (1), (2), (3), (4), (5);

mysql create table carTb (
carId int not null,
primary key (carId)
) type = innodb;
mysql insert into carTb values (1), (2), (3), (4), (5);

mysql create table buyTb (
customerId int not null,
carId int not null,
primary key (customerId, carId),
index i_customerTb (customerId),
index i_carTb (carId),
foreign key (customerId) references customerTb (customerId),
foreign key (carId) references carTb (carId)
on delete cascade
) type = innodb;
mysql insert into buyTb values (1, 1), (1, 2), (1, 3), (2, 3), (4, 3), (4, 
4), (4, 5), (5, 5), (5, 1);

mysql delete from customerTb where customerId = 1;
ERROR 1217: Cannot delete a parent row: a foreign key constraint fails

I have thought it for more than three nights, but I still have no solution 
for this. Can the manual state whether Innodb can support more then one 
foreign key or not? It makes me so confused.

Thanks a lot!

Nobita

_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail


-
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

Solutions to Solaris 8 Intel compile problems

[jpw]

Description:
a) --enable-assembler causes invalid opcode with strings.s
   strings-x86.s, line 1: Illegal mnemonic
   strings-x86.s, line 1: Syntax error
   make: Fatal error: Command failed for target `strings-x86.o'
b) Incorrect socket length declaration
   Config.h has type int, should be socklen_t
c) Can't static link  --with-mysqld-ldflags=-all-static
Although INSTALL-SOURCE does address these issues, it is difficult to wade 
through all
of it to determine the cause of the problems and solve them.  I expect many 
people will
be unable to.  Perhaps  the documentation could be clearer in this regard in 
the Solaris Intel
section, or configure could return an error for unusable options ?
Same errors using gcc 2.95.2

Fix:
The following compiles without errors:
cd mysql-3.23.53
rm config.cache
rm config.log
CFLAGS=-O3 -march=i686 CXX=gcc CXXFLAGS=-O3 -march=i686 
-felide-constructors -fno-exceptions -fno-rtti
export CFLAGS CXX CXXFLAGS
./configure --prefix=/usr/local/mysql --with-mysqld-ldflags=-all
vi config.h
   Change line 214   #define SOCKET_SIZE_TYPE int
   To#define SOCKET_SIZE_TYPE socklen_t
make clean
make
make install

Submitter-Id:  I don't have one ?
Originator:Jeff Page
Organization:  Qenesis Inc.
MySQL support: none
Synopsis:  Diffculties compiling on Solaris 8 Intel
Severity:  non-critical
Priority:  low
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.53 (Source distribution)

Environment:

System: SunOS montreal 5.8 Generic_108529-16 i86pc i386 i86pc
Architecture: i86pc

Some paths:  /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/local/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/3.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld 
--disable-nls
Thread model: posix
gcc version 3.2
Compilation info: CC='gcc'  CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs 
-Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts 
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual 
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors 
-fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer'  LDFLAGS=''
LIBC: 
-rw-r--r--   1 root bin  1590140 Oct 11 18:12 /lib/libc.a
lrwxrwxrwx   1 root root  11 Dec 31  2000 /lib/libc.so - ./libc.so.1
-rwxr-xr-x   1 root bin   944472 Oct 11 18:12 /lib/libc.so.1
-rw-r--r--   1 root bin  1590140 Oct 11 18:12 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Dec 31  2000 /usr/lib/libc.so - ./libc.so.1
-rwxr-xr-x   1 root bin   944472 Oct 11 18:12 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler 
--with-extra-charsets=complex --enable-thread-safe-client --with-innodb 
--with-berkeley-db --enable-thread-safe-client 'CFLAGS=-Wimplicit -Wreturn-type 
-Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses 
-Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 
'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts 
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual 
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors 
-fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc
Perl: This is perl, version 5.005_03 built for i86pc-solaris

-
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: turn off auto commit in MYSQL

[Peter Brawley]

 is there any configuration that turn on auto commit
 persistently ... i mean for each client connections?
 (in my.cnf [client] or something else)

The default is ON. Turning it off is how a client begins a transaction. If
you want to prevent users from using transactions, you can use MyISAM
tables.

PB

-

 
  Thank you very much
  I got one more question
  Do I need to change the table type to
  transaction-safe tables (InnoDB
  and BDB) ?
  AS I am going thru  the manuals I read that tables
  should be of InnoDB
  or BDB inorder to work for manual commit.
 
 
  once again thanks in advance,
  Devi
 
 
  -Original Message-
  From: Peter Brawley
  [mailto:peter.brawley;artfulsoftware.com]
  Sent: Wednesday, November 13, 2002 6:04 PM
  To: Devi Annisetty
  Subject: Re: turn off auto commit in MYSQL
 
 
  SET @@autocommit=0
  or
  BEGIN
 
  -
 
  Hi,
  I am newbie to MYSQL and ODBC
 
  I have to update more than 2 tables simultanously
  currently my application uses ADOBC connection
  object.
 
  How can turn off the autocommit option and set
  manaul commit.
 
  what places I need to change inorder to work manual
  commit
 
  Thanks in Advance for your time
  Devi




-
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

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

[Edwin Raj]

Hello Friends,

I have installed mysql version 3.23.52 binary file. The installation 
went well without any errors but when I type mysql in the command prompt 
I get this error. Can someone help me fix this. Am using red hat 6.2 version

Rgds
Edwin



-
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: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

[Edwin Raj]

If this could help to analyse the problem, when I try to create a 
password this is the message I get

[root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password 
'simple'
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!


Edwin Raj wrote:

Hello Friends,

I have installed mysql version 3.23.52 binary file. The installation 
went well without any errors but when I type mysql in the command 
prompt I get this error. Can someone help me fix this. Am using red 
hat 6.2 version

Rgds
Edwin





-
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: ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (111)

[Vince LaMonica]

On Fri, 15 Nov 2002, Edwin Raj wrote:

} [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password 
} 'simple'
} /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
} error: 'Can't connect to local MySQL server through socket 
} '/tmp/mysql.sock' (111)'
} Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

Looks like the error message is pretty clear - mysqld is not running. 
MySQL is a client/server application - there is a server that needs to 
run, and then the client can connect to that server. 

You need to make sure that mysqld is running. Since it appears you're on a 
linux box, you can run this command:

ps aux |grep mysql

If nothing comes up, then you need to start mysqld. It may reside in
/usr/sbin. You should probably check the MySQL manual:

http://www.mysql.com/doc/en/Post-installation.html

HTH,

/vjl/

-- 
Vince LaMonica   UC Irvine,  School  of  Social Ecology
 W3 Developer   *  116 Social Ecology I, Irvine, CA 92697
 [EMAIL PROTECTED]  http://www.seweb.uci.edu/techsupport

   No matter what happens, somebody will find a way to 
take it too seriously.



-
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 2 servers on 1 DB

[Andrey Kotrekhov]

äÏÂÒÙÊ ÄÅÎØ.

 On Thu, Nov 14, 2002 at 02:44:47PM +0200, Andrey Kotrekhov wrote:
  Hi, All! sql
 
  Can I run 2 mysqld that use the same DB?
  Not replication , 1 DB on my HDD but 2 mysqld work with this DB.
 
  For example I have external RAID and I want decrease CPU usage.
  I run 2 mysqld on different servers, but they use 1 DB.
  Is this possible?

 If you enable MySQL's extenal locking support, yes.
But how safe is this? Is this work at all?
In manual I see strong warning:

WARNING: Normally you should never have two servers that update data in
the same database! If your OS doesn't support fault-free system locking,
this may lead to unpleasant surprises!

What will be happened when I update some records throw 1-st server and
select the same records throw 2-d server?


 Jeremy
 --
 Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

 MySQL 3.23.51: up 100 days, processed 2,121,676,852 queries (244/sec. avg)


Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44


-
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