MySQL embedded?

[Mathias Bertelsen]

Hello

I have a question about MySQL and regular 'programs', as i am normally used
to programming web-apps and the like, with that kind of programming and
database interaction. I want to know if it is possible to somehow 'embed'
the MySQL database in the program you are making? (on say, Java and
windows...?) so the person installing the program doesn't have to install a
MySQL database on his system
And if so, is it possible (and easy from a developers point of view) to make
the user in the beginning on install choose between having a regular
MySQL-database or the 'embedded'?

Sorry if it's a stupid question but i am really not used to making regular
applications... :) and i didn't find an answer on mysql.com...

/Mathias


-
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 Privileges Question

[Yat-Shing Tam]

Hi Mihail,

I have done the flushing before trying to connect and it didn't work.  I
try the show command and nothing unusal from what it reported.

Regards,
Michael

- Original Message -
From: <[EMAIL PROTECTED]>
To: "Yat-Shing Tam" <[EMAIL PROTECTED]>
Cc: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 17, 2002 10:23 PM
Subject: Re: MySQL Privileges Question


> Did you try:
>
> FLUSH PRIVILEGES;
>
> Also, to see what user can do with his permissions you can try this:
>
> SHOW GRANTS FOR username;
>
>
> Mihail
>
> Quoting Yat-Shing Tam <[EMAIL PROTECTED]>:
>
> > Hi fellows,
> >
> > I have a MySQL privileges question and hope someone can provide some
> > input on it.
> >
> > I have setup a user who can access only one db, say 'DB1'.
> > About the privileges, I set the account privilege like this:
> > 1) In user table, this account has Host='%' User='user_name'
> > Password='pwd' and all other privileges are set to 'N'.
> > 2) In db table, this account has Host='%' Db='DB1' User='user_name'
and
> > all other privileges are set to 'Y' EXCEPT grant_priv.
> >
> > Through MySQL Front GUI, the user login and is allowed to access
'DB1'
> > only and other dbs are not visible to this user.  Very things look good
at
> > this point, however, when I have a piece of java code try to access
'DB1'
> > with this user account through MM.MySQL JDBC I receive  an access deny.
> >
> > Questions:
> > 1) Why it behaves like this?  I thought if I can access through GUI
> > application with this account, I should have the same access through
JDBC.
> > 2) Does this mean I have to use an account which has a global access
> > privilege(s) in order to access the db through JDBC??
> >
> > Any input would be appreciated.
> >
> > Best regards,
> > Michael
>

-
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:myODBC BIGINT conversion

[Oliver Six]

Dennis <[EMAIL PROTECTED]> wrote on 17.07.2002 20:37:50:

>
>sql query
>
>We have data stored as BIGINT in unix, and there are 32bit unsigned values 
>but nothing larger. I would assume if we convert this to integer in win98 
>it would seem that values over 31bits would be wrong. Are there workarounds 
>for this? Is this also an issue in later version of windows?
>
>DB 
>
Hi Dennis,

why don't you use SQL_BIGINT together with __int64? I think this should give 
you the correct values and you can control the conversion to a 32 bit unsigned. 

Bye Oliver
--
Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% 
attention to detail. 

Oliver Six, CEO
CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen
Phone +49 89 71 01 93 41,  Fax +49 89 71 01 93 42


-
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

Tee Shirt

[Simon Green]

Hi All
Some thing that is a bit lighter
Where can I get a MySQL Tee Shirt?
We now have a FreeBSD devil and a Linux Penguinin my department
All I would like it a Dolphin to keep up!
Simon

-
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 embedded?

[Mathias Bertelsen]

Hi

Thank you for the help. It looks fairly uncomplicated this embedded
database.
Luckily the application we are planning is also supposed to be Open Source
and available on sourceforge.net, so there shouldn't be a problem with
licensing.
The idea is, that the user, on install, gets to choose between a purely
client program connecting to a local or remote MySQL database with the
benefits that entails (multiple users on the same data and from different
places), or a client/server program with the MySQL database embedded in the
applications, for the small solutions.
Does anyone know if it complicates the code having these two options
available for the user? Do the database have the same interface and features
available (eg. transactions) in both these two options?

/Mathias


- Original Message -
From: "Jan Peuker" <[EMAIL PROTECTED]>
To: "Mathias Bertelsen" <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 9:56 AM
Subject: Re: MySQL embedded?


> Hi Mathias,
>
> it's possible, have a look at: http://www.mysql.com/doc/l/i/libmysqld.html
,
> the problem is just a) licensing and b) you can't connect from an outside
> process. It's no problem, too, to install a MySQL-Database before, that's
a
> question of your install procedure. The only problem will be, to
modularize
> the relevant parts of your application(e.g. database creation, rights
> management).
> But, at least, there is berkeleyDB(http://www.sleepycat.com/), too, if you
> just want small tables like hashes and no relations.
> regards,
>
> jan



-
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

Now it's available MYSQL API for VBA

[Gelu Gogancea]

Hi VBA Developer,

Over 45 MYSQL API (base) functions are now available for using in Microsoft
VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning how
you must use this API functions and how you can use multiple
connection/query.
Memory consumption is 2 kb.Performance guarantied (1700 fetch_row/sec.)...

You can download it from :
http://www.simtel.net/pub/dl/59731.shtml

or

http://www.gonetsoftware.com/gmysql  (thanks Eivind)

Regards,

Gelu

_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [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

list some records combo-box in my ASP's script

[Ivan Paul]

hi all,

i have no idea when i want to list
some records in one field using ASP's combo box

table name: operator
field name: desc   ===>>> field that i want to list-up using combo in my
ASP's script


table structure:

code varchar(8) not null primary key
desc varchar(40) null


have an idea?


TIA

ivan paul

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: Now it's available MYSQL API for VBA

[Gelu Gogancea]

No differences.

- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 12:23 PM
Subject: RE: Now it's available MYSQL API for VBA


> > Over 45 MYSQL API (base) functions are now available for using in
Microsoft
> > VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning
how
> > you must use this API functions and how you can use multiple
> > connection/query.
> > Memory consumption is 2 kb.Performance guarantied (1700
fetch_row/sec.)...
>
> And how does this differ from using the standard VB/VBA functions to
manipulate MySQL databases?
>


-
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: Now it's available MYSQL API for VBA

[Ed Carp]

> Over 45 MYSQL API (base) functions are now available for using in Microsoft
> VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning how
> you must use this API functions and how you can use multiple
> connection/query.
> Memory consumption is 2 kb.Performance guarantied (1700 fetch_row/sec.)...

And how does this differ from using the standard VB/VBA functions to manipulate MySQL 
databases?

-
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 Best Practices

[Håkon Eriksen]

Imro STROK <[EMAIL PROTECTED]> writes:

> But I would also like to have some "MySQL Best Practices"  documents
> regarding:
> * Performance & Tuning 
> * Backup & Recovery
> Appreciate if you guys/gals can send me some documents.

Take a look at http://www.onlamp.com/pub/a/onlamp/2002/07/11/MySQLtips.html >

-- 
 - håkon

-
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 SELECT and VALUES

[Simon Green]

> Hi All
> I am trying to copy data from one table to another using in MySQL 
> INSERT INTO  table1
> SELECT table2
> statment but I would like to add some fixed values to this and so some
> thing like.
> INSERT INTO table1
> SELECT table2
> VALUES ('A','B');
> But I can not find if this can be done or how
> Thanks
> Simon

-
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

backup

[Ilyas Keser]

Hi list...

What is the best way to backup a Mysql database? I read in the 
documentation that mysqlhotcopy is the best and quickest way to do 
this.
But I can not start mysqlhotcopy...
Error Message is:

Can't locate DBI.pm in @INC (@INC contains: 
/System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin 
/Library/Perl /Library/Perl /Network/Library/Perl/darwin 
/Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line 
8.
BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.

What is DBI.pm?

Thanks

-
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

replication privleges issue

[Martin Waite]

Hi,

SQL, MySQL.

I want my master to contain only recent data, but
my slave to hold a long-term archive.

My plan to do this is to use a merge table on the 
master to provide an alias for the underlying 
real table.   I then perform updates and inserts
on the real table, and deletes on the merge table.

Both inserts and deletes are replicated to the slave,
but on the slave the merge table is defined as 
an empty union so that the deletes effectively 
become null-ops.

My main worry here is that at some point the 
merge table on the master might get redefined
or rebuilt - and I don't want this replicated
to the slave otherwise the deletes will actually 
start taking effect there.

Now the question:  how do I set up privileges on 
the slave so that a drop or alter table performed 
on this one table on the master are disallowed 
from being replicated on the slave ?

regards,
Martin




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

[Håkon Eriksen]

Ilyas Keser <[EMAIL PROTECTED]> writes:

> Can't locate DBI.pm in @INC (@INC contains:
> /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin
> /Library/Perl /Library/Perl /Network/Library/Perl/darwin
> /Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line
> 8.
> BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.
> What is DBI.pm?

It's a perl module you need in order to contact MySQL from perl.
Obviously, if perl can't talk to the databases, it won't get any data
from it either. Consult your operating system manual or your local
perl expert to find out how to install the module.

-- 
 - håkon

-
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 SELECT and VALUES

[Arul]

Hi SImon

Try this

INSERT INTO
   table1
SELECT
   12 as fixedvalue1 , 20 as fixedvalue2 ,table2.A , table2.B
FROM
   table2

WHERE
  table2.id = 10

First the SELECT Query is executed from the table 2 which has  id = 10
The Result would be something like this

fixedvalue1fixedvalue2table2.A table2.B
12 20 'A''B'
12 20 'AA''BB'


Then these values are inserted in table 1


- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Mysql (E-mail)'" <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 3:51 PM
Subject: INSERT SELECT and VALUES


>
> > Hi All
> > I am trying to copy data from one table to another using in MySQL
> > INSERT INTO  table1
> > SELECT table2
> > statment but I would like to add some fixed values to this and so some
> > thing like.
> > INSERT INTO table1
> > SELECT table2
> > VALUES ('A','B');
> > But I can not find if this can be done or how
> > Thanks
> > Simon
>
> -
> 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

backup

[Ilyas Keser]

Hi list...

What is the best way to backup a Mysql database? I read in the 
documentation that mysqlhotcopy is the best and quickest way to do 
this.
But I can not start mysqlhotcopy...
Error Message is:

Can't locate DBI.pm in @INC (@INC contains: 
/System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin 
/Library/Perl /Library/Perl /Network/Library/Perl/darwin 
/Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line 
8.
BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.

What is DBI.pm?

Thanks

-
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@lists.mysql.com

[sean]

>Description:
My slave log files are filled with the following:
Failed reading log event, reconnecting to retry ... server_errno=1159
>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
none
>Synopsis:  
>Severity:  
serious
>Priority:  
high
>Category:  mysql
>Class: 
>Release:   mysql-3.23.51 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin  Ver 8.23 Distrib 3.23.51, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.51-Max-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 8 min 43 sec

Threads: 1  Questions: 942  Slow queries: 0  Opens: 26  Flush tables: 1  Open tables: 
20 Queries per second avg: 1.801
>Environment:

System: Linux gcn13.grand-central.net 2.4.17 #1 SMP Sat Jan 12 15:28:10 EST 2002 i686 
unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS=' -O3'  CXX='gcc'  CXXFLAGS=' -O3  
-felide-constructors -fno-exceptions -fno-rtti  '  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Nov 29  1999 /lib/libc.so.6 -> libc-2.1.1.so
-rwxr-xr-x1 root root  4016683 Apr 16  1999 /lib/libc-2.1.1.so
-rw-r--r--1 root root 19533408 Apr 16  1999 /usr/lib/libc.a
-rw-r--r--1 root root  178 Apr 16  1999 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb 
--enable-assembler --enable-local-infile --with-mysqld-user=mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man 
'--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS= -O3' 'CXXFLAGS= -O3
   -felide-constructors -fno-exceptions -fno-rtti  ' CXX=gcc
Perl: This is perl, version 5.005_03 built for i386-linux

-
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 Privileges Question

[Ralf Narozny]

As a little addition to that:

localhost needs to be given extra rights, because localhost will always 
use socket connections instead of TCP.

Yat-Shing Tam wrote:

>Hi Mihail,
>
>I have done the flushing before trying to connect and it didn't work.  I
>try the show command and nothing unusal from what it reported.
>
>Regards,
>Michael
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "Yat-Shing Tam" <[EMAIL PROTECTED]>
>Cc: "MySQL Mailing List" <[EMAIL PROTECTED]>
>Sent: Wednesday, July 17, 2002 10:23 PM
>Subject: Re: MySQL Privileges Question
>
>
>  
>
>>Did you try:
>>
>>FLUSH PRIVILEGES;
>>
>>Also, to see what user can do with his permissions you can try this:
>>
>>SHOW GRANTS FOR username;
>>
>>
>>Mihail
>>
>>Quoting Yat-Shing Tam <[EMAIL PROTECTED]>:
>>
>>
>>
>>>Hi fellows,
>>>
>>>I have a MySQL privileges question and hope someone can provide some
>>>input on it.
>>>
>>>I have setup a user who can access only one db, say 'DB1'.
>>>About the privileges, I set the account privilege like this:
>>>1) In user table, this account has Host='%' User='user_name'
>>>Password='pwd' and all other privileges are set to 'N'.
>>>2) In db table, this account has Host='%' Db='DB1' User='user_name'
>>>  
>>>
>and
>  
>
>>>all other privileges are set to 'Y' EXCEPT grant_priv.
>>>
>>>Through MySQL Front GUI, the user login and is allowed to access
>>>  
>>>
>'DB1'
>  
>
>>>only and other dbs are not visible to this user.  Very things look good
>>>  
>>>
>at
>  
>
>>>this point, however, when I have a piece of java code try to access
>>>  
>>>
>'DB1'
>  
>
>>>with this user account through MM.MySQL JDBC I receive  an access deny.
>>>
>>>Questions:
>>>1) Why it behaves like this?  I thought if I can access through GUI
>>>application with this account, I should have the same access through
>>>  
>>>
>JDBC.
>  
>
>>>2) Does this mean I have to use an account which has a global access
>>>privilege(s) in order to access the db through JDBC??
>>>
>>>Any input would be appreciated.
>>>
>>>Best regards,
>>>Michael
>>>  
>>>
>
>-
>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
>
>  
>

-- 
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de




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

[Ralf Narozny]

Hello!

Ilyas Keser wrote:

> Hi list...
>
> What is the best way to backup a Mysql database? I read in the 
> documentation that mysqlhotcopy is the best and quickest way to do this.
> But I can not start mysqlhotcopy...
> Error Message is:
>
> Can't locate DBI.pm in @INC (@INC contains: 
> /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin 
> /Library/Perl /Library/Perl /Network/Library/Perl/darwin 
> /Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line 8.
> BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.
>
> What is DBI.pm?


DataBase Interface . Perl Module (iirc)

which indicates that you need Perl DBI Module for mysqlhotcopy.

Greetings
 Ralf

sql , query

-- 
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de




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

[Cal Evans]

have you tried mysqldump?

*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
 

-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 6:15 AM
To: [EMAIL PROTECTED]
Subject: backup


Hi list...

What is the best way to backup a Mysql database? I read in the 
documentation that mysqlhotcopy is the best and quickest way to do 
this.
But I can not start mysqlhotcopy...
Error Message is:

Can't locate DBI.pm in @INC (@INC contains: 
/System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin 
/Library/Perl /Library/Perl /Network/Library/Perl/darwin 
/Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line 
8.
BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.

What is DBI.pm?

Thanks

-
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

Table types in replication

[Pete French]

If I have amast/salve pair where the slave is replicating from
the master then do the table types have to be the same ?

Specifically can I have a myisam table on the master and replicate to
a bdb table on the slave ?

The reasoning behind this is to try and find a *fast* was to convert
a MYISAM table to a BDB table having the database down for the
minimum amount of time. Idea so far is this:

on current database machine do a ''mysqldump' and then enable logging.
Load onto new database machine with table types set of BDB.
Make new db machine replicate from old until it has caught up with the new
data which was inserted into the master whilst the load was happening.
When both are in sync then take them down and point allupdating
clients to the new database machine.

Any comments ? Converting the tables "in situ" is painfully slow - a
couple of days I suspect.

-pcf.

-
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

Full Text Search

[Dasmeet Singh]

I am developing a site which shows tv schedules online... 
http://www.einfotimes.com I want to add search to it.
Basically i want to know how to full text search through all the tables 
in database and i also want the name of table in result along with 
fields...is it possible?
Dasmeet




Just for Filters "Select sql query"



--
http://www.einfotimes.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

Fw: Problems with high-use tables

[Christopher A. Libby]

- Original Message -
From: "Christopher A. Libby" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 3:32 PM
Subject: Problems with high-use tables


Hi - I've been using MySQL for a variety of functions with great success
over the last year.  However, I recently rebuilt my log database server
after a crash, and I've been having a lot of trouble with two tables getting
corrupted.

One table stores my syslog entries from Kiwi Syslod Daemon, and the other
stores the actual firewall logs extracted from the syslog entries.  Every
five minutes I run a process which reads in all the syslog entries, extracts
the firewall logs from them, then deletes the entries from the syslog table.
My problem is I keep getting corrupted data files, which brings the whole
system to a halt.

I'm running MySQL v3 (latest build) on a WinNT4 box.  I'm using Perl &
MyODBC to process the data.  Any thoughts?

-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

RE: sql-commands in a file

[Cal Evans]

yes, write them all to a file and put that file in a directory you have
access too.  Then when you want to execute them:

mysql -u user -p < filename

=C=

*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 7:11 AM
To: [EMAIL PROTECTED]
Subject: sql-commands in a file


HI all;

I have 3 databases. I want backup all this databases by giving one
command. I use the backup command to backup my databases, it seems to
be the fastest way.
Can I write sql the sql-commands below in a file and execute them by
giving only one command?

use db1
backup table tab1, tab2 tab3 to '/backup/db1';
use db2
backup table tab1, tab2 tab3 to '/backup/db2';
use db3
backup table tab1, tab2 tab3 to '/backup/db3';

Thanks
Ilyas

-
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

sql-commands in a file

[Ilyas Keser]

HI all;

I have 3 databases. I want backup all this databases by giving one 
command. I use the backup command to backup my databases, it seems to 
be the fastest way.
Can I write sql the sql-commands below in a file and execute them by 
giving only one command?

use db1
backup table tab1, tab2 tab3 to '/backup/db1';
use db2
backup table tab1, tab2 tab3 to '/backup/db2';
use db3
backup table tab1, tab2 tab3 to '/backup/db3';

Thanks
Ilyas

-
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: Rewind the auto_increment index?

[Egor Egorov]

Erick,
Thursday, July 18, 2002, 10:17:12 AM, you wrote:

>> let us say i have a table:
>> 
>>customers
>>idint(10) auto_increment
>>name  varchar(20)
>> 
>> 
>> whenever i do, 
>> 
>>insert into customers (name) values ('...');
>> 
>> it automatically generates the id, right? that is the meaning of the
>> auto_increment index key. now my question is that if i add a name and
>> then delete it, this index remains increasing. if i add a new row, and
>> then immediately delete it (not some time later, immediately) in that
>> case do i have a way of rewinding the index? 

On BDB and ISAM tables, yes. If you delete row with maximum id, the next
inserted row will have the same value in the auto_increment field.
On MyISAM and InnoDB tables, no.






-- 
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: Mysql 3.23 for AIX 4.3.3

[Victoria Reznichenko]

Morris,
Wednesday, July 17, 2002, 4:49:50 PM, you wrote:

MF> I still need to get a version of mysql working on
MF> AIX 4. I have been watching the mail list and
MF> have seen nothing about a new release. I recently
MF> looked at the web site and found that the current
MF> download binary release is now 3.23.49 and it
MF> previously was 3.23.51. Does this mean that .49
MF> is now a working version?

No, 3.23.49 is not good for AIX ..
MySQL programmers are working on a new build.






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

[Egor Egorov]

Alexander,
Wednesday, July 17, 2002, 11:32:19 PM, you wrote:

AB> When I want to run two servers with different
AB> configuration. Can I run in the same machine and two
AB> running?
  Yes, you can (it's not true for Windows):
   http://www.mysql.com/doc/M/u/Multiple_servers.html
   http://www.mysql.com/doc/m/y/mysqld_multi.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: Deleting foreign keys with Innodb tables

[Victoria Reznichenko]

Archbold,
Thursday, July 18, 2002, 12:18:09 AM, you wrote:

A> I'm having a problem dropping a foreign key constraint from an Innodb table. I am 
using MySQL 3.23.51 for Win32.  Any help would be greatly appreciated

A>  I have a simple set up like the one below:

A> CREATE TABLE mastertable
A> (
A> masterkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT
A> ) TYPE=innodb;

A> CREATE TABLE othertable
A> (
A> otherkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT
A> masterkey INT NOT NULL,
A> INDEX (masterkey),
A> FOREIGN KEY (masterkey) REFERENCES mastertable (masterkey) ON DELETE CASCADE
A> ) TYPE=innodb;

A> Which works fine and all.  However, if I go to remove a foreign key it won't let me 
- though it does not report any errors:
A> ALTER TABLE othertable DROP FOREIGN KEY masterkey;

A> I tried dropping the column entirely (which is what I'm aiming to do in the first 
place) and dropping the index, but Innodb won't let me do either of those because of 
the foreign key
A> constraints.

A> I've also tried setting the table to a MyISAM type, removing the constraints, index 
and column then setting it back to an Innodb table.  No go there either.  It wants 
that field and index in
A> the table before it will change the type back to Innodb.

A> So, how does one go about removing the foreign key constraint once it is in place?

Use DROP TABLE and then CREATE TABLE to remove foreign key
constraints.





-- 
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 SELECT and VALUES

[Egor Egorov]

Simon,
Thursday, July 18, 2002, 1:21:20 PM, you wrote:

>> I am trying to copy data from one table to another using in MySQL
>> INSERT INTO  table1
>> SELECT table2
>> statment but I would like to add some fixed values to this and so some
>> thing like.
>> INSERT INTO table1
>> SELECT table2
>> VALUES ('A','B');
>> But I can not find if this can be done or how

Not clear enough for me what do you want to do ..

What about:

 INSERT INTO table1(field1,field2)
 SELECT table2.field1, table2.field2
 FROM table2
 WHERE table2.field1='A'
 AND table2.filed2='B';

For more details:
http://www.mysql.com/doc/I/N/INSERT_SELECT.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: safe_mysqld - my.cnf weird foo

[Victoria Reznichenko]

Shon,
Tuesday, July 16, 2002, 10:45:19 PM, you wrote:

SS> i configure/make/make install mysql-3.23.51 on sparc solaris using
SS> gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc.
SS> i ran the mysql_install_db script, i performed all the chown/chgrp
SS> operations, i copied mysql.server to /etc/rc3.d/S99mysql. i copied
SS> my-huge.cnf to /usr/local/etc/my.cnf and edited this to add some
SS> different options. when i start mysql, the my.cnf file was not
SS> loading. i could tell because some of the options i specified were
SS> not being run. i copied my.cnf to /etc/my.cnf and tried again.
SS> everything worked. why? i changed the sysconfdir during
SS> configuration.

option --sysconfdir is supported by configure, not by MySQL.
You can't specify another location for my.cnf than
  /etc/my.cnf
  DATADIR/my.cnf
  ~/.my.cnf



-- 
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: how to fast rename column name.

[Victoria Reznichenko]

qingfong,
Thursday, July 18, 2002, 4:49:16 AM, you wrote:

q> mysql:
q>  how to rename column name  exception that use alter table tablename column 
newcolumn expression. I want get fast to rename the column name, but use front idea is 
very slowly when my table has
q> 1000 record. help me!
  
You can't use any other statement except ALTER TABLE to rename a
column. If you use MyISAM tables, you can increase value of
myisam_sort_buffer_size variable:
  http://www.mysql.com/doc/A/L/ALTER_TABLE.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

mysql_query() hangs if remote database becomes unavailable

[equ]

>Description:

With the current series of MySQL RDBMS (tested with 3.23.49 on Debian
Linux 3.0 running a 2.4.19-pre10 kernel) connecting to a remote
database can be problematic since MySQL doesn't handle very well
situations where the remote database has become unavailable.

To be more precise, issuing a mysql_query() when the remote database
has become unavailable (due to routing problems, physical cabling,
firewall filtering, etc) will cause the execution to remain in
mysql_query() for a undetermined amount of time. Strace'ing shows the
process trying to read() from the MySQL socket (here fd = 3) which
will hang, see below.

20:33:21 write(1, "entered oer_debug()\n", 20) = 20
20:33:21 write(1, "reconnect()\n", 12)  = 12
20:33:21 fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
20:33:21 read(3, 0x8090d68, 8192)   = -1 EAGAIN (Resource temporarily unavailable)
20:33:21 fcntl64(3, F_SETFL, O_RDWR)= 0
20:33:21 write(3, "H\0\0\0\3INSERT INTO oer_output VALU"..., 76) = 76
20:33:21 read(3,

What happens in that code is that always when a debug message is
written to stdout it is also written to the database. After "entered
oer_debug()" and "reconnect()" would follow the writing of
"reconnect()" to the database. The writing seems to have succeeded (?)
but the read() following it will block, see below.

20:33:21 read(3, 0x8090d68, 4)  = -1 ETIMEDOUT (Connection timed out)
20:50:55 shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is 
not connected)
20:50:55 close(3)   = 0
20:50:55 write(1, "leaving oer_debug()\n", 20) = 20

I was actually patient enough to wait for it to timeout. Seems that
read() will timeout in about 17,5 minutes which is awfully close to
the TCP timeout of 15 minutes. If you are wondering, mysql_query()
will return -1 and not 2006 or 2013 as one would expect.

What will happen next is that the next call to mysql_query() will make
MySQL try to connect to the remote database which again will timeout
in a undetermined amount of time.

Now, before you suggest I should be using mysql_options() to set the
connect timeout, I am. It doesn't seem to help in this context. I had
the timeout set to 10 seconds and it took 17,5 minutes for read() to
timeout and 3 minutes for connect() to timeout.

What I would like to see in MySQL is the ability to control how MySQL
reacts to a database connection becoming unavailable or at least to be
able to detect it. What I would also like to see is a timeout option
for queries (set a timeout for how long the query is allowed to take).

Thank you in advance for your past/present/future efforts.

>How-To-Repeat:

Startup your MySQL program, let it connect to the remote database and
filter the traffic with a firewall. The next mysql_query() will hang.

>Fix:

>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  mysql_query() hangs if remote database becomes unavailable
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.49 (Source distribution)

>Environment:

System: Linux irc1 2.4.19-pre10 #1 Sat Jun 8 03:00:02 EEST 2002 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Jun  8 02:24 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x1 root root  1153784 Apr 28 12:57 /lib/libc-2.2.5.so
-rw-r--r--1 root root  2390922 Apr 28 12:58 /usr/lib/libc.a
-rw-r--r--1 root root  178 Apr 28 12:58 /usr/lib/libc.so
-rw-r--r--1 root root   726660 Mar 24 06:56 /usr/lib/libc-client.so.2001
Configure command: ./configure  --prefix=/usr --exec-prefix=/usr 
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql 
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info 
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler 
--with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile 
--with-raid --enable-thread-safe-client --without-readline 
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql 
--without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all


-
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

Sorting order in MySQL

[Daniel Kiss]

Hi all,

I (like almost everyone else) use different character set than latin1.
I have noticed that the Hungarian sorting does not work properly.
I have checked he .conf files, and if I see it well, the way of comparing 
character fields is very simple. Just comparing he characters at the same 
position from left to right, just like in English.
I don't speak too many languages, so I don't know this problem is in other 
cases, but in the Hungarian languages sometimes you have to do more than 
this. Sometimes you have to check two or more characters next to each other 
at the same time.
So, instead of too long explaination:

Is there any way in MySQL (for example write an UDF for comparing texts for 
sorting) to change the sorting order?

Thanks,
Daniel


-
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

maximum row

[Mustafa Yelmer]

dou you know that mysql can handle maximum row of records?
thanks



-
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

Convert to largefile support

[rick]

Hi all,
If I want to convert an existing Mysql install from non-largefile to support to 
largefile support (I rebuilt the software and enabled this), do I need to rebuild my 
databases/tables/indexes after I upgrade the software?  Or should I be able to just 
upgrade the software and use my existing data structures?

Thanks,
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

my.cnf - pulled out all my hair

[Shon Stephens]

can anyone tell me how to make mysql read my.cnf from /usr/local/etc instead
of /etc? i tried configuring with --sysconfdir=/usr/local/etc at compile
time. that is not working.

thanks,
shon

-
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

shell script to backup

[Ilyas Keser]

Hi all...

I am a new Linux user. Does any one have a shell script to backup all 
Mysql databases?

Thanks
ilyas...

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

[Relihan, Daniel]

Hi,

mySQL wasnt allowing anyone to write to it, so I deleted some stuff and
mySQL started working again. However, even though I had freed up more than
enough space, the problem repeated itself. When I tried to drop an old
database, mysql hung and I cant even get into mysql anymore. Any ideas on
what to do? Thankfully, I backed up the database that I need, so if I fresh
install is needed, then it wont be a problem. Thank you for your help. I
really appreciate it.

- Dan R.

-
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: Deleting foreign keys with Innodb tables

[Philip Molter]

On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko wrote:
: Archbold,
: Thursday, July 18, 2002, 12:18:09 AM, you wrote:
: 
: A> I'm having a problem dropping a foreign key constraint from an Innodb table. I am 
:using MySQL 3.23.51 for Win32.  Any help would be greatly appreciated
: 
: A>  I have a simple set up like the one below:
: 
: A> CREATE TABLE mastertable
: A> (
: A> masterkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT
: A> ) TYPE=innodb;
: 
: A> CREATE TABLE othertable
: A> (
: A> otherkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT
: A> masterkey INT NOT NULL,
: A> INDEX (masterkey),
: A> FOREIGN KEY (masterkey) REFERENCES mastertable (masterkey) ON DELETE CASCADE
: A> ) TYPE=innodb;
: 
: Use DROP TABLE and then CREATE TABLE to remove foreign key
: constraints.

Maybe Heikki can expand on this, because this is really an unacceptable 
way to remove a foreign key.  What do you do with a table that has  
tens or hundreds of millions of rows of data?  Do you copy out the  
data, recreate the table, then copy it back in?  Do you realize 
what type of performance/time/service hit that would place on a 
database, just to remove a foreign key? 

Are there any plans to introduce this seemingly basic functionality?

Philip


sql, query

Please, please, the filter needs to be updated to allow more than
just posts with sql or query in them.  I replied to a post on coming
from this list and it was rejected by the query.  That's simply
asinine.  I can't believe it couldn't even pick out.  Please update
the filter with words/phrases such as "innodb", "index", "foreign
key", or "table" so we don't have to keep resending replies to the
list.

Either that, or turn the list into subscriber only.  I realize that
it may discourage some people from asking for help, but it's
definitely more discouraging to have your posts rejected because
you didn't use one of *two* keywords.

* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [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: backup

[Massimo Petrini]

Also in may NT machine appear the same error. Which is the problem ?
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 1:58 PM
Subject: backup


> Hi list...
>
> What is the best way to backup a Mysql database? I read in the
> documentation that mysqlhotcopy is the best and quickest way to do
> this.
> But I can not start mysqlhotcopy...
> Error Message is:
>
> Can't locate DBI.pm in @INC (@INC contains:
> /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin
> /Library/Perl /Library/Perl /Network/Library/Perl/darwin
> /Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line
> 8.
> BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.
>
> What is DBI.pm?
>
> Thanks
>
> -
> 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

Exporting & Replication

[Dan Wareham]

Hello Everyone!!

I've just joined this list and have already started to enjoy the
various threads that are running. I also wanted to get some feedback
on something that I'm trying to do.

I have currently developed a survey system that uses a mysql database
that consists of 15 tables. The database is kept and administered on
the server in the office and then dumped out and copied across to a
notebook server which we then take out to run our application and
which then get updated with user input. When we return back to the
office the database is dumped out and replaces the one on the office
server.

The first issue is that we now have the need to run two notebook
servers, which mean we can't just dump the data out and copy it
across. The second issue is that the company data we are holding is
getting way too big to carry around on the laptops.

What I want to do is to keep the office based database as the admin,
allowing us to add companies and users etc... I then, for each survey
workshop, want to be able to output 11 tables exactly how they appear
on the office database with the other 4 tables being empty structures
that I can insert smaller amounts of company and user data into.

Having read the manual I think it comes to doing it one of two ways:

1) Use replication to keep the 11 tables up to date and then use
"create table" to build the other 4 tables.

2) Use "create table" to build the workshop databases from the main
database.

Any advice on the best solution would be greatly appreciated.
Thanks in advance

Regards
D@n
==
Design evokes emotion, gives identity,
communicates an idea and compels a response

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.comm

-
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: safe_mysqld - my.cnf weird foo

[Shon Stephens]

thanks victoria. now that is cleared up for me.

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 8:41 AM
To: [EMAIL PROTECTED]
Subject: Re: safe_mysqld - my.cnf weird foo


Shon,
Tuesday, July 16, 2002, 10:45:19 PM, you wrote:

SS> i configure/make/make install mysql-3.23.51 on sparc solaris using
SS> gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc.
SS> i ran the mysql_install_db script, i performed all the chown/chgrp
SS> operations, i copied mysql.server to /etc/rc3.d/S99mysql. i copied
SS> my-huge.cnf to /usr/local/etc/my.cnf and edited this to add some
SS> different options. when i start mysql, the my.cnf file was not
SS> loading. i could tell because some of the options i specified were
SS> not being run. i copied my.cnf to /etc/my.cnf and tried again.
SS> everything worked. why? i changed the sysconfdir during
SS> configuration.

option --sysconfdir is supported by configure, not by MySQL.
You can't specify another location for my.cnf than
  /etc/my.cnf
  DATADIR/my.cnf
  ~/.my.cnf



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

-
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

Sorting order in MySQL

[Nikolaos Georgiafentis]

Hi all,

 >I (like almost everyone else) use different character set than latin1.
 >I have noticed that the Hungarian sorting does not work properly.
 >I have checked he .conf files, and if I see it well, the way of comparing 
character fields is very simple. Just comparing he> >characters at the same 
position from left to right, just like in English.
 >I don't speak too many languages, so I don't know this problem is in 
other cases, but in the Hungarian languages sometimes >you have to do more 
than this. Sometimes you have to check two or more characters next to each 
other at the same time.
 >So, instead of too long explaination:

 >Is there any way in MySQL (for example write an UDF for comparing texts 
for sorting) to change the sorting order?
The same problem exists also for greek charset (i.e greek.conf)
Thanks,
 Daniel

Georgiafentis Nikolaos
Project Manager
[EMAIL PROTECTED] 
iTEL LTD
409 Vouliagmenis Ave.
Ilioupoli, 16346
Tel: +30 10 9790050
Fax: +30 10 9790051


-
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 a row from another table

[Marek Kilimajer]

Hi,


is it possible to simply update a row from one table with a row from 
another table using reference key.
Something like this example query (which is doesn't work)

UPDATE orders_products SET orders_products.status=orders.orders_status 
WHERE orders.orders_id=orders_products.orders_id

Marek





-
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: Table types in replication

[Ralf Narozny]

Hello!

Pete French wrote:

>If I have amast/salve pair where the slave is replicating from
>the master then do the table types have to be the same ?
>
>Specifically can I have a myisam table on the master and replicate to
>a bdb table on the slave ?
>
>The reasoning behind this is to try and find a *fast* was to convert
>a MYISAM table to a BDB table having the database down for the
>minimum amount of time. Idea so far is this:
>  
>

How about this:

CREATE TABLE new_table () 
TYPE=BDB;
INSERT INTO new_table SELECT * FROM old_table;
CREATE INDEX ... ON new_table;...
ALTER TABLE new_table ADD PRIMARY KEY (...);...
RENAME old_table TO old_table_bak;
RENAME new_table TO old_table;

That should cause a downtime of less than a second...

last but not least you need insert all rows that have been created 
between the INSERT and the last RENAME.

>on current database machine do a ''mysqldump' and then enable logging.
>Load onto new database machine with table types set of BDB.
>Make new db machine replicate from old until it has caught up with the new
>data which was inserted into the master whilst the load was happening.
>When both are in sync then take them down and point allupdating
>clients to the new database machine.
>
>Any comments ? Converting the tables "in situ" is painfully slow - a
>couple of days I suspect.
>  
>

Greetings
 Ralf

>  
>

-- 
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de




-
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: shell script to backup

[Cal Evans]

mysqldump -opt > everything.sql


*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
 

-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: shell script to backup


Hi all...

I am a new Linux user. Does any one have a shell script to backup all 
Mysql databases?

Thanks
ilyas...

-
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: shell script to backup

[Duncan Hill]

On Thu, 18 Jul 2002, Ilyas Keser wrote:

> Hi all...
> 
> I am a new Linux user. Does any one have a shell script to backup all 
> Mysql databases?

Read The fine Manual - it gives several ways.


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

[Stefano Incontri]

You could use something like :

mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=yourpasswd > /some/where/backup.sql

It generates a SQL commands file able to completely rebuild the DB, e.g.
after a mysql_install_db command.

Ciao,
Stefano

> -Original Message-
> From: Relihan, Daniel [mailto:[EMAIL PROTECTED]] 
> Sent: 18 July 2002 15:48
> To: '[EMAIL PROTECTED]'
> Subject: MYSQL freezing
> 
> 
> Hi,
> 
> mySQL wasnt allowing anyone to write to it, so I deleted some 
> stuff and
> mySQL started working again. However, even though I had freed 
> up more than
> enough space, the problem repeated itself. When I tried to drop an old
> database, mysql hung and I cant even get into mysql anymore. 
> Any ideas on
> what to do? Thankfully, I backed up the database that I need, 
> so if I fresh
> install is needed, then it wont be a problem. Thank you for 
> your help. I
> really appreciate it.
> 
> - Dan R.
> 
> -
> 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: Fw: Problems with high-use tables

[William R. Mussatto]

Just a quick question.  Why are you not running DBD::Mysql directly?  It 
should eliminate the ODBC layer and help with speed.

On Thu, 18 Jul 2002, Christopher A. Libby wrote:

> Date: Thu, 18 Jul 2002 08:22:33 -0400
> From: Christopher A. Libby <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Fw: Problems with high-use tables
> 
> 
> - Original Message -
> From: "Christopher A. Libby" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 16, 2002 3:32 PM
> Subject: Problems with high-use tables
> 
> 
> Hi - I've been using MySQL for a variety of functions with great success
> over the last year.  However, I recently rebuilt my log database server
> after a crash, and I've been having a lot of trouble with two tables getting
> corrupted.
> 
> One table stores my syslog entries from Kiwi Syslod Daemon, and the other
> stores the actual firewall logs extracted from the syslog entries.  Every
> five minutes I run a process which reads in all the syslog entries, extracts
> the firewall logs from them, then deletes the entries from the syslog table.
> My problem is I keep getting corrupted data files, which brings the whole
> system to a halt.
> 
> I'm running MySQL v3 (latest build) on a WinNT4 box.  I'm using Perl &
> MyODBC to process the data.  Any thoughts?
> 
> -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
> 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
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: shell script to backup

[Stefano Incontri]

You could use something like :

mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=yourpasswd > /some/where/backup.sql

It generates a SQL commands file able to completely rebuild the DB, e.g.
useful after a mysql_install_db command.

Ciao,
Stefano

> -Original Message-
> From: Ilyas Keser [mailto:[EMAIL PROTECTED]] 
> Sent: 18 July 2002 15:44
> To: [EMAIL PROTECTED]
> Subject: shell script to backup
> 
> 
> Hi all...
> 
> I am a new Linux user. Does any one have a shell script to backup all 
> Mysql databases?
> 
> Thanks
> ilyas...
> 
> -
> 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: backup

[Archbold, David W.]

DBI is the Perl module used to communicate with the database. The error message is 
informing you that you do not have the DBI module installed on your system.

This isn't a mysql-specific problem, so you should probably consult with an actual 
Perl help group.  At the risk of going off-topic though, you can try the following to 
install the module...

NT (with activestate perl):   C:\> ppm install DBI
Linux:  perl -MCPAN -e 'install DBI'



-Original Message-
From: Massimo Petrini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 9:06 AM
To: [EMAIL PROTECTED]; Ilyas Keser
Subject: Re: backup


Also in may NT machine appear the same error. Which is the problem ?
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 1:58 PM
Subject: backup


> Hi list...
>
> What is the best way to backup a Mysql database? I read in the
> documentation that mysqlhotcopy is the best and quickest way to do
> this.
> But I can not start mysqlhotcopy...
> Error Message is:
>
> Can't locate DBI.pm in @INC (@INC contains:
> /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin
> /Library/Perl /Library/Perl /Network/Library/Perl/darwin
> /Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line
> 8.
> BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.
>
> What is DBI.pm?
>
> Thanks
>
> -
> 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

Re: Table types in replication

[Pete French]

> CREATE TABLE new_table () 
> TYPE=BDB;
> INSERT INTO new_table SELECT * FROM old_table;
> CREATE INDEX ... ON new_table;...
> ALTER TABLE new_table ADD PRIMARY KEY (...);...
> RENAME old_table TO old_table_bak;
> RENAME new_table TO old_table;
>
> That should cause a downtime of less than a second...

Interesting suggestion... I have about a million rows in that table,
but I'll try it...

> last but not least you need insert all rows that have been created 
> between the INSERT and the last RENAME.

Well, if its less than a second I can afford to have the database down for
that long - its the "several days" that is problematical.

*quick test*
About 3 minutes to do thecopy -not bad at all!

I've been doing some experimentswith BDB tables though and am having
real problems- of the "locking up the mysql server" type! I have
a small benchmark I use to check the speed of my main table, which
locks the tbale, does two updates n a single rowof that table and
unlocks it again. I run many of these in parallel (up to 100) to get a ffeel
for the load.

Running these tests on the BDB version of the table I have found
that after aout 30 connections I get Can't lock file (errno: 12)
at which point the server locks up. It will not shutdown properly,
and just hangs - eventually needing to be killed by hand.

Maybe BDB tables are not for me after all...

-pcf.

-
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: Problem Installing on RH 7.3

[Richard Fox]

The mysqld.log file says:

020717 13:05:05  mysqld started
020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05  mysqld ended

But I do see the host.frm file:

-rw-rw1 root root 8958 Jul 17 13:04
/var/lib/mysql/mysql/host.frm

How did you fix this problem?

I do have the /var/lib/mysql/mysql.sock file...

Thanks
Rich

> I'm near enough in the same position as you are. Check the file
> /var/log/mysqld.log to see what the problem is. I had a problem accessing
> the file './mysql/host.frm', but I think that I've fixed this now.
>
> What happens when you try the 'mysql' command? I get the response
> "can't connect to local MySQL server through socket
> '/var/usr/mysql/mysql.sock'"
> And indeed there is no such file.
> Do you have this file?
>
> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 10:41 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL: Problem Installing on RH 7.3
>
>
>
> The MySQL daemon does not run. I installed the binary RPM's from the RH
cd,
> MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
> execute correctly. The I run safe_mysqld &, and I get:
>
> [root@thor rfox]# /usr/bin/safe_mysqld &
> [1] 2212
> [root@thor rfox]# Starting mysqld daemon with databases from
/var/lib/mysql
> 020717 15:21:28  mysqld ended
>
> That's it! I tried both the rpm and compiling it myself from source with
> BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
>
> I just need a little hint, please! How do I troubleshoot this?
>
> Thanks,
>
> Rich
>
> sql
>
>
> -
> 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: backup

[Stefano Incontri]

Try useing something like :

mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=yourpasswd > /some/where/backup.sql

It generates a SQL commands file able to completely rebuild the DB, e.g.
useful after a mysql_install_db command.

Ciao,
Stefano

> -Original Message-
> From: Massimo Petrini [mailto:[EMAIL PROTECTED]] 
> Sent: 18 July 2002 16:06
> To: [EMAIL PROTECTED]; Ilyas Keser
> Subject: Re: backup
> 
> 
> Also in may NT machine appear the same error. Which is the problem ?
> - Original Message -
> From: "Ilyas Keser" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, July 18, 2002 1:58 PM
> Subject: backup
> 
> 
> > Hi list...
> >
> > What is the best way to backup a Mysql database? I read in the
> > documentation that mysqlhotcopy is the best and quickest way to do
> > this.
> > But I can not start mysqlhotcopy...
> > Error Message is:
> >
> > Can't locate DBI.pm in @INC (@INC contains:
> > /System/Library/Perl/darwin /System/Library/Perl 
> /Library/Perl/darwin
> > /Library/Perl /Library/Perl /Network/Library/Perl/darwin
> > /Network/Library/Perl /Network/Library/Perl .) at 
> ./mysqlhotcopy line
> > 8.
> > BEGIN failed--compilation aborted at ./mysqlhotcopy line 8.
> >
> > What is DBI.pm?
> >
> > Thanks
> >
> > 
> -
> > 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

Re: backup

[z]

On Thu, 18 Jul 2002 16:05:34 +0200, Massimo Petrini wrote:
>Also in may NT machine appear the same error. Which is the problem ?

DBI is a perl module for interfacing with databases

see
http://search.cpan.org/search?module=DBI

-z

sql mysql query
-- 
z, [EMAIL PROTECTED] on 07/18/2002


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

[Anil Garg]

hi,

I cant use some characters in my full text search (like * , "" , etc.)
I found out that it was due to the old version of the mysql i am using.
Now the problem is i want to switch from the older version(3.23.49) to 4.0.2
so that my full text search can be more efficient.
Can some one tell me what needs to be done for the upgarde?and
What backups do i need to take?

thanx and regards
anil


-
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

Replication in v4.0.2 not doing UPDATE

[MySQL admin account]

>Description:
I am using MySQL v4.0.2 and I have set up a master database and 2 slave
databases, all on separate Solaris machines. The replication works fine
when I INSERT or DELETE but does not perform my UPDATE statements. I have
used 'mysqlbinlog' on the relay log on one of the slaves and the UPDATE
statements are being sent to the slaves but they are not being executed.
No errors have been generated to the error log and no errors are shown when
a SHOW SLAVE STATUS is run. The slaves use replicate-do-table directives in
the config file but the tables that I am trying to update are listed and
I can INSERT into and DELETE from these tables that I am trying to update.
The UPDATE succeeds on the master. All of my tables are INNODB type.
>How-To-Repeat:
When I run an UPDATE statement on my master database on replicated tables
it is not replicated to the slaves (even though the statement is replicated
to the relay log on the slave servers).
>Fix:
Unknown

>Submitter-Id:  miguelryan
>Originator:MySQL admin account
>Organization:  freelance consultant
>MySQL support: none
>Synopsis:  Replication in v4.0.2 not doing UPDATE
>Severity:  critical
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-4.0.2-alpha (Source distribution)

>Environment:

System: SunOS ops-dev5 5.6 Generic_105181-28 sun4u sparc SUNW,UltraSPARC-IIi-cEngine
Architecture: sun4

Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  
LDFLAGS=''
LIBC: 
-rw-r--r--   1 bin  bin  1623504 Aug 24  2001 /lib/libc.a
lrwxrwxrwx   1 root root  11 Feb  9  2000 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 bin  bin  1024888 Aug 24  2001 /lib/libc.so.1
-rw-r--r--   1 bin  bin  1623504 Aug 24  2001 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Feb  9  2000 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 bin  bin  1024888 Aug 24  2001 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex 
--with-server-suffix= --enable-thread-safe-client --enable-local-infile 
--enable-assembler --disable-shared --with-innodb CC=gcc 'CFLAGS=-O3 
-fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors 
-fno-exceptions -fno-rtti' CXX=gcc
Perl: This is perl, version 5.005_03 built for sun4-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

mysql upgrade

[Anil Garg]

hi,

I cant use some characters in my full text search (like * , "" , etc.)
I found out that it was due to the old version of the mysql i am using.
Now the problem is i want to switch from the older version(3.23.49) to 4.0.2
so that my full text search can be more efficient.
Can some one tell me what needs to be done for the upgarde?and
What backups do i need to take?

thanx and regards,
anil.
mysql, 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

Replication w/ InnoDB

[James Kelty]

Ok, ok, now that I know that I 'can' replicate InnoDB tables, it's time I
got it to ACTUALLY replicate InnoDB tables, eh?

This is my /etc/my.cnf file from the master server:

[mysqld]
log-bin=/storage/mysql/replication.log
server-id=1
default-table-type=innodb


innodb_data_home_dir=/storage/innodb
set-variable = innodb_mirrored_log_groups=1
#
#
innodb_data_file_path=indata1:2000M;indata2:
data5:2000M;indata6:2000M
#
#
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_si
innodb_log_group_home_dir = /storage/innodbl
#
#
innodb_log_arch_dir = /storage/innodblogs
innodb_log_archive = 0
set-variable = innodb_log_files_in_group=3
#
#
set-variable = innodb_log_file_size=100M
set-variable = innodb_log_buffer_size=16M
#
#
#
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

[mysql.server]
user=mysql
basedir=/usr/local/mysql

[safe_mysqld]
err-log=/storage/mysql/mysql_error_log
pid-file=/storage/mysql/mysqld.pid


And Here is my /etc/my.cnf file from the SLAVE:

[mysqld]
server-id=2
master-host=192.168.10.49
master-user=repl
master-password=replicate
master-connect-retry=5
master-info-file=master.info
replicate-do-db=everbase
log-slave-updates
#skip-slave-start

default-table-type=innodb

innodb_flush_log_at_trx_commit=0
innodb_data_home_dir=/database/MySQL/innodb
set-variable = innodb_mirrored_log_groups=1
#
#
innodb_data_file_path=indata1:2000M:autoextend:max
#
#
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_size=80M
innodb_log_group_home_dir = /database/MySQL/innodb
#
#
innodb_log_arch_dir = /database/MySQL/innodblogs
innodb_log_archive = 0
set-variable = innodb_log_files_in_group=3
#
#
set-variable = innodb_log_file_size=100M
set-variable = innodb_log_buffer_size=16M
#
#
#
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50


I have select, and file permissions for the 'repl' user,
and when I try the sql query LOAD TABLE Users FROM MASTER on the slave,
all I get is the replicated table is created, but NO data comes accross,
and I get the 1189 Net Read Error on the slave. BUT! When I change the type
of
table from InnoDB to MyISAM on the MASTER SERVER, the above LOAD TABLE works
REALLY well.


Not sure why this is happening. Plus, NONE of the changes I make to the
table after altering it
to the MyISAM type, replicate? What am I missing. I would really like the
replication to work well
with InnoDB types instead of MyISAM.

Please, can someone point me in the right direction?

Thanks!

-James


-
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: Fw: Problems with high-use tables

[Christopher A. Libby]

When the scripts where originally written, I didn't have a clue about the
DBD::MySQL module.  I've also got scripts running in VBScript via ODBC, so I
wanted to stick to a standard I/O method.

-Chris


- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: "Christopher A. Libby" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 11:30 AM
Subject: Re: Fw: Problems with high-use tables


Just a quick question.  Why are you not running DBD::Mysql directly?  It
should eliminate the ODBC layer and help with speed.

On Thu, 18 Jul 2002, Christopher A. Libby wrote:

> Date: Thu, 18 Jul 2002 08:22:33 -0400
> From: Christopher A. Libby <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Fw: Problems with high-use tables
>
>
> - Original Message -
> From: "Christopher A. Libby" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 16, 2002 3:32 PM
> Subject: Problems with high-use tables
>
>
> Hi - I've been using MySQL for a variety of functions with great success
> over the last year.  However, I recently rebuilt my log database server
> after a crash, and I've been having a lot of trouble with two tables
getting
> corrupted.
>
> One table stores my syslog entries from Kiwi Syslod Daemon, and the other
> stores the actual firewall logs extracted from the syslog entries.  Every
> five minutes I run a process which reads in all the syslog entries,
extracts
> the firewall logs from them, then deletes the entries from the syslog
table.
> My problem is I keep getting corrupted data files, which brings the whole
> system to a halt.
>
> I'm running MySQL v3 (latest build) on a WinNT4 box.  I'm using Perl &
> MyODBC to process the data.  Any thoughts?
>
> -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
>

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
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: Problem Installing on RH 7.3

[Jan Kudrman]

I am not sure, but are you sure that mysqld is running as a root? Or as a
mysql (user) and mysql (group).

Try to check rights of the mysqld user.

Jan


- Original Message -
From: "Richard Fox" <[EMAIL PROTECTED]>
To: "Noamn" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 5:44 PM
Subject: Re: MySQL: Problem Installing on RH 7.3


The mysqld.log file says:

020717 13:05:05  mysqld started
020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05  mysqld ended

But I do see the host.frm file:

-rw-rw1 root root 8958 Jul 17 13:04
/var/lib/mysql/mysql/host.frm

How did you fix this problem?

I do have the /var/lib/mysql/mysql.sock file...

Thanks
Rich

> I'm near enough in the same position as you are. Check the file
> /var/log/mysqld.log to see what the problem is. I had a problem accessing
> the file './mysql/host.frm', but I think that I've fixed this now.
>
> What happens when you try the 'mysql' command? I get the response
> "can't connect to local MySQL server through socket
> '/var/usr/mysql/mysql.sock'"
> And indeed there is no such file.
> Do you have this file?
>
> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 10:41 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL: Problem Installing on RH 7.3
>
>
>
> The MySQL daemon does not run. I installed the binary RPM's from the RH
cd,
> MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
> execute correctly. The I run safe_mysqld &, and I get:
>
> [root@thor rfox]# /usr/bin/safe_mysqld &
> [1] 2212
> [root@thor rfox]# Starting mysqld daemon with databases from
/var/lib/mysql
> 020717 15:21:28  mysqld ended
>
> That's it! I tried both the rpm and compiling it myself from source with
> BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
>
> I just need a little hint, please! How do I troubleshoot this?
>
> Thanks,
>
> Rich
>
> sql
>
>
> -
> 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

Re: Deleting foreign keys with Innodb tables

[Heikki Tuuri]

Philip,

- Original Message -
From: "Philip Molter" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 6:23 PM
Subject: Re: Deleting foreign keys with Innodb tables


> On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko wrote:
> : Archbold,
> : Thursday, July 18, 2002, 12:18:09 AM, you wrote:
> :
> : A> I'm having a problem dropping a foreign key constraint from an Innodb
table. I am using MySQL 3.23.51 for Win32.  Any help would be greatly
appreciated
> :
> : A>  I have a simple set up like the one below:
> :
> : A> CREATE TABLE mastertable
> : A> (
> : A> masterkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT
> : A> ) TYPE=innodb;
> :
> : A> CREATE TABLE othertable
> : A> (
> : A> otherkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT
> : A> masterkey INT NOT NULL,
> : A> INDEX (masterkey),
> : A> FOREIGN KEY (masterkey) REFERENCES mastertable (masterkey) ON DELETE
CASCADE
> : A> ) TYPE=innodb;
> :
> : Use DROP TABLE and then CREATE TABLE to remove foreign key
> : constraints.
>
> Maybe Heikki can expand on this, because this is really an unacceptable
> way to remove a foreign key.  What do you do with a table that has
> tens or hundreds of millions of rows of data?  Do you copy out the
> data, recreate the table, then copy it back in?  Do you realize
> what type of performance/time/service hit that would place on a
> database, just to remove a foreign key?

ALTER TABLE ... DROP CONSTRAINT FOREIGN KEY ... REFERENCES...

is easy to implement but no timetable is set yet. I will next look into a
similar problem: dropping or adding an index quickly. Currently MySQL
recreates the whole table when you drop or add an index.

> Are there any plans to introduce this seemingly basic functionality?
>
> Philip
>
>
> sql, query
>
> Please, please, the filter needs to be updated to allow more than
> just posts with sql or query in them.  I replied to a post on coming
> from this list and it was rejected by the query.  That's simply
> asinine.  I can't believe it couldn't even pick out.  Please update
> the filter with words/phrases such as "innodb", "index", "foreign
> key", or "table" so we don't have to keep resending replies to the
> list.

We sometimes receive Klez.H viruses in emails titled 'A foreign key
constraint fails'. The Klez.H worm apparently is the first true artificial
intelligence program. Nigerian money laundering letters, which are a daily
nuisance, often contain the word 'transaction'.

> Either that, or turn the list into subscriber only.  I realize that

Sorry, but I am not a subscriber :). I read from the news group
mailing.database.mysql.

> it may discourage some people from asking for help, but it's
> definitely more discouraging to have your posts rejected because
> you didn't use one of *two* keywords.
>
> * Philip Molter
> * Texas.net Internet
> * http://www.texas.net/
> * [EMAIL PROTECTED]

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://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: MySQL: Problem Installing on RH 7.3

[Mark Schoonover]

At first blush it looks like it's a rights problem. Need to have the
/var/lib/mysql owned by mysql.mysql... If you're starting mysql as the user
mysql...

HTH

.mark

> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 8:44 AM
> To: Noamn; [EMAIL PROTECTED]
> Subject: Re: MySQL: Problem Installing on RH 7.3
> 
> 
> The mysqld.log file says:
> 
> 020717 13:05:05  mysqld started
> 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 020717 13:05:05  mysqld ended
> 
> But I do see the host.frm file:
> 
> -rw-rw1 root root 8958 Jul 17 13:04
> /var/lib/mysql/mysql/host.frm
> 
> How did you fix this problem?
> 
> I do have the /var/lib/mysql/mysql.sock file...
> 
> Thanks
> Rich
> 
> > I'm near enough in the same position as you are. Check the file
> > /var/log/mysqld.log to see what the problem is. I had a 
> problem accessing
> > the file './mysql/host.frm', but I think that I've fixed this now.
> >
> > What happens when you try the 'mysql' command? I get the response
> > "can't connect to local MySQL server through socket
> > '/var/usr/mysql/mysql.sock'"
> > And indeed there is no such file.
> > Do you have this file?
> >
> > -Original Message-
> > From: Richard Fox [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 17, 2002 10:41 PM
> > To: [EMAIL PROTECTED]
> > Subject: MySQL: Problem Installing on RH 7.3
> >
> >
> >
> > The MySQL daemon does not run. I installed the binary RPM's 
> from the RH
> cd,
> > MySQL 3.23.49. I run mysql_install_db, outputs some text 
> and appears to
> > execute correctly. The I run safe_mysqld &, and I get:
> >
> > [root@thor rfox]# /usr/bin/safe_mysqld &
> > [1] 2212
> > [root@thor rfox]# Starting mysqld daemon with databases from
> /var/lib/mysql
> > 020717 15:21:28  mysqld ended
> >
> > That's it! I tried both the rpm and compiling it myself 
> from source with
> > BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
> >
> > I just need a little hint, please! How do I troubleshoot this?
> >
> > Thanks,
> >
> > Rich
> >
> > sql
> >
> >
> > 
> -
> > 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

Re: MySQL: Problem Installing on RH 7.3

[Ryan Fox]

First, nice username :)

Anyhow, use the /etc/init.d/mysqld script as root to start/stop mysql,
not the safe_mysqld binary.  The init.d script really calls the
safe_mysqld binary, but ti also makes a couple sanity checks like
ensuring that the initial database files exist and are owned by the
proper user.
 
Example:
# /etc/init.d/mysqld start

This should get you past the problem you are currently having, which is
that mysqld can't find it's database files.  This is mostly due to
redhat's mysql rpm installing the database files in a different location
than mysql's distibution does.

Hope this helps,
Ryan Fox
[EMAIL PROTECTED]


On Thu, 2002-07-18 at 11:44, Richard Fox wrote:
> The mysqld.log file says:
> 
> 020717 13:05:05  mysqld started
> 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 020717 13:05:05  mysqld ended
> 
> But I do see the host.frm file:
> 
> -rw-rw1 root root 8958 Jul 17 13:04
> /var/lib/mysql/mysql/host.frm
> 
> How did you fix this problem?
> 
> I do have the /var/lib/mysql/mysql.sock file...
> 
> Thanks
> Rich
> 
> > I'm near enough in the same position as you are. Check the file
> > /var/log/mysqld.log to see what the problem is. I had a problem accessing
> > the file './mysql/host.frm', but I think that I've fixed this now.
> >
> > What happens when you try the 'mysql' command? I get the response
> > "can't connect to local MySQL server through socket
> > '/var/usr/mysql/mysql.sock'"
> > And indeed there is no such file.
> > Do you have this file?
> >
> > -Original Message-
> > From: Richard Fox [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 17, 2002 10:41 PM
> > To: [EMAIL PROTECTED]
> > Subject: MySQL: Problem Installing on RH 7.3
> >
> >
> >
> > The MySQL daemon does not run. I installed the binary RPM's from the RH
> cd,
> > MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
> > execute correctly. The I run safe_mysqld &, and I get:
> >
> > [root@thor rfox]# /usr/bin/safe_mysqld &
> > [1] 2212
> > [root@thor rfox]# Starting mysqld daemon with databases from
> /var/lib/mysql
> > 020717 15:21:28  mysqld ended
> >
> > That's it! I tried both the rpm and compiling it myself from source with
> > BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
> >
> > I just need a little hint, please! How do I troubleshoot this?
> >
> > Thanks,
> >
> > Rich
> >
> > sql
> >
> >
> > -
> > 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

Re: MySQL: Problem Installing on RH 7.3

[Gerald Clark]

You can see them because you are root, and you own them.
Mysql can't see them because it is mysql.
chown   -R  mysql  /var/lib/mysql

Richard Fox wrote:

>The mysqld.log file says:
>
>020717 13:05:05  mysqld started
>020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
>'./mysql/host.frm' (errno: 13)
>020717 13:05:05  mysqld ended
>
>But I do see the host.frm file:
>
>-rw-rw1 root root 8958 Jul 17 13:04
>/var/lib/mysql/mysql/host.frm
>
>How did you fix this problem?
>
>I do have the /var/lib/mysql/mysql.sock file...
>
>Thanks
>Rich
>
>>I'm near enough in the same position as you are. Check the file
>>/var/log/mysqld.log to see what the problem is. I had a problem accessing
>>the file './mysql/host.frm', but I think that I've fixed this now.
>>
>>What happens when you try the 'mysql' command? I get the response
>>"can't connect to local MySQL server through socket
>>'/var/usr/mysql/mysql.sock'"
>>And indeed there is no such file.
>>Do you have this file?
>>
>>-Original Message-
>>From: Richard Fox [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, July 17, 2002 10:41 PM
>>To: [EMAIL PROTECTED]
>>Subject: MySQL: Problem Installing on RH 7.3
>>
>>
>>
>>The MySQL daemon does not run. I installed the binary RPM's from the RH
>>
>cd,
>
>>MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
>>execute correctly. The I run safe_mysqld &, and I get:
>>
>>[root@thor rfox]# /usr/bin/safe_mysqld &
>>[1] 2212
>>[root@thor rfox]# Starting mysqld daemon with databases from
>>
>/var/lib/mysql
>
>>020717 15:21:28  mysqld ended
>>
>>That's it! I tried both the rpm and compiling it myself from source with
>>BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
>>
>>I just need a little hint, please! How do I troubleshoot this?
>>
>>Thanks,
>>
>>Rich
>>
>>sql
>>
>>
>>-
>>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

count query across two tables

[Stanley, Jason]

hello all,

i'm new to the list (and to mysql, for that matter) and am looking for some help with 
what should be a fairly simple query.

what i'm doing is writing a very simple bulletin board with jsp using two tables in 
mysql. the first table contains the title and body of the topic and the second 
contains the replies, which are cross-indexed by the topic id. simple enough, but here 
they are...

+-++--+---+
| TopicID | title  | username | body  |
+-++--+---+
|   1 | new topic  | kilgore  | body text |
|   2 | big topic at hand  | kilgore  | more  |
|   3 | you'll never guess who i saw today | kilgore  | david |
|   4 | silliest topic ever| bob  | etc...|
|   5 | this is another topic  | kilgore  | ...   |  
|   6 | look! my first topic!  | jeff | ...   |
|   7 | yet another test topic | kilgore  | ...   |
|   8 | NO MORE| kilgore  | ...   |
|   9 | oh hello   | kilgore  | ...   |
|  10 | never mind the testing | kilgore  | ...   |
|  11 | eh?| kilgore  | ...   |
|  12 | TITLE  | kilgore  | ...   |
+-++--+---+

+-+-+-+-+
| ReplyID | TopicID | body| user|
+-+-+-+-+
|   4 |   4 | anyone? | bob |
|  11 |   5 | what| kilgore |
|  10 |   2 | who?| kilgore |
|   8 |   4 | another reply   | kilgore |
|   9 |   3 | oh my   | kilgore |
|  12 |   5 | what| kilgore |
|  13 |   5 | again   | bob |
|  14 |   3 | yessir  | bob |
|  15 |   6 | oi  | jeff|
|  16 |   6 | oi  | jeff|
|  17 |   6 | oi  | jeff|
|  18 |   6 | oi  | jeff|
|  19 |   6 | thing   | kilgore |
|  20 |   6 | thing   | kilgore |
|  21 |   6 | thing   | kilgore |
|  22 |   4 | BLING   | tommy   |
|  23 |  10 | hello   | kilgore |
|  24 |  12 | reply   | kilgore |
+-+-+-+-+

so here's my problem: on the page which displays the topic titles, i wish to display 
all of the topics along with the number of replies specific to that topic. here is my 
query:

SELECT *, COUNT(TalkReplies.TopicID) as Comments
FROM TalkTopics, TalkReplies
WHERE TalkTopics.TopicID = TalkReplies.TopicID
GROUP BY TalkTopics.TopicID DESC

this gets me almost there BUT it excludes any topics from the list which have no 
replies (so i only get a list of 7 topics here instead of 12). this has been plaguing 
me for days and i can't seem to get my head around how i should rephrase the query. 
any insight would be *greatly* appreciated.

thanks,
-j

-
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

slave stop command doesn't work if slave thread is blocked

[Marc Prewitt]

>Description:
If a 'slave stop' command is while a slave is blocked waiting
for a table, the slave thread must be manually killed in order for the 
slave stop command to complete.

>How-To-Repeat:

mysql> show slave status\G
*** 1. row ***
Master_Host: fosters
Master_User: mysql-repl
Master_Port: 3306
  Connect_retry: 60
   Log_File: fosters-bin.1088
Pos: 266992616
  Slave_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
 Last_errno: 0
 Last_error:
   Skip_counter: 0
1 row in set (0.00 sec)

mysql> flush tables with read lock;
Query OK, 0 rows affected (0.03 sec)

(wait for slave thread to block)

mysql> show processlist\G
*** 1. row ***
 Id: 1
   User: system user
   Host: none
 db: wssource_prod
Command: Connect
   Time: 28
  State: Waiting for table
   Info: /* WSSource::BusObj::Commit 896@DowJonesParse::Process 356@main
*/UPDATE   dow_jones SET A_
Id = 1027

mysql> slave stop;

(switch to another command interpreter)

mysql> show processlist\G
*** 1. row ***
 Id: 1
   User: system user
   Host: none
 db: wssource_prod
Command: Connect
   Time: 172
  State: Waiting for table
   Info: /* WSSource::BusObj::Commit 896@DowJonesParse::Process 356@main
*/UPDATE   dow_jones SET A_
Id = 1027
*** 2. row ***
 Id: 2
   User: mysql
   Host: localhost
 db: NULL
Command: Query
   Time: 126
  State: waiting for slave to die
   Info: slave stop

mysql> kill 2;
Query OK, 0 rows affected (0.00 sec)

mysql> show processlist\G
*** 1. row ***
 Id: 1
   User: system user
   Host: none
 db: wssource_prod
Command: Connect
   Time: 213
  State: Waiting for table
   Info: /* WSSource::BusObj::Commit 896@DowJonesParse::Process 356@main
*/UPDATE   dow_jones SET A_
Id = 1027
*** 2. row ***
 Id: 2
   User: mysql
   Host: localhost
 db: NULL
Command: Killed
   Time: 167
  State: waiting for slave to die
   Info: slave stop

mysql> kill 1;

>Fix:


>Submitter-Id:  Marc Prewitt 
>Originator:"Marc Prewitt" <[EMAIL PROTECTED]>
>Organization:
 Wall Street Source
>MySQL support: extended login support
>Synopsis:  slave stop command doesn't work if slave thread is blocked
>Severity:  serious
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.46 (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.23 Distrib 3.23.46, for sun-solaris2.8 on 
>sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.46-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/tmp/mysql.sock
Uptime: 9 min 28 sec

Threads: 2  Questions: 5353  Slow queries: 1  Opens: 109  Flush tables: 3 
Open tables: 1 Queries per second avg: 9.424
>Environment:

System: SunOS polar 5.8 Generic_108528-15 sun4u sparc SUNW,Sun-Blade-1000
Architecture: sun4

Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
GCC: Reading specs from
/opt/gcc/3.0.4/lib/gcc-lib/sparc-sun-solaris2.8/3.0.4/specs
Configured with: ../3.0.4/configure
--with-gcc-version-trigger=/usr/local/src/gcc/3.0.4/gcc/version.c
--prefix=/opt/gcc/3.0.4 --with-system-zlib
Thread model: posix
gcc version 3.0.4
Compilation info: CC='/opt/gcc/2.95.2/bin/gcc'  CFLAGS='-O3 -mcpu=v8
-Wa,-xarch=v8plusa'  CXX='/opt/gcc/2.95.2/bin/g++'  CXXFLAGS='-O3 -mcpu=v8
-Wa,-xarch=v8plusa -felide-constructors -fno-exceptions -fno-rtti' 
LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root root  11 Aug 22  2001 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x   1 root bin  1146204 Jul 11 18:02 /lib/libc.so.1
lrwxrwxrwx   1 root root  11 Aug 22  2001 /usr/lib/libc.so ->
./libc.so.1
-rwxr-xr-x   1 root bin  1146204 Jul 11 18:02 /usr/lib/libc.so.1
Configure command: ./configure  --prefix=/opt/mysql/3.23.46
--with-berkeley-db --with-innobase --localstatedir=/export/DB/mysqldb
--with-unix-socket-path=/var/tmp/mysql.sock

-
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: Problem Installing on RH 7.3

[Philip Molter]

On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
: The mysqld.log file says:
: 
: 020717 13:05:05  mysqld started
: 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 020717 13:05:05  mysqld ended
: 
: But I do see the host.frm file:
: 
: -rw-rw1 root root 8958 Jul 17 13:04
: /var/lib/mysql/mysql/host.frm
: 
: How did you fix this problem?

Permissions are wrong.  MySQL typically runs as mysql:mysql, not
root:root.  If I remember correctly, there may have been a problem
with the setup scripts that handled this.  Check the RH bug reports.
The fix is simply to change owner/groups on the necessary
files/directories.

But Trond can give you specifics.  It still may be user error. :)

: I do have the /var/lib/mysql/mysql.sock file...

* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [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

HP-UX 11, mysql-max

[Jason Baker]

I tried the HP-UX mysql depot from the HP Software Porting Center, but 
it doesn't have innodb support.

The mysql-max capability page says that innodb is supported on HP-UX, 
though... so presumably somebody, somewhere, has done this already.

When I'm trying to compile with gcc 2.95.3 or with gcc 3.0.1, I get a 
missing library (-ldl) when building mysqld, despite configuring with 
--disable-shared and --enable-static.

So... I'm game for just about any advice at this point.  A depot with 
mysqld-max would be ideal, advice on what's going wrong on the link 
would be a close second.

Thanks in advance,
 Jason

-
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

Innodb startup hangs on AIX 4.3.3 when built with IBM's VisualAgeC/C++ compiler 5.0.x

[Rick Flower]

Hi.. I recently built MySQL 3.23.51 on two different AIX 4.3 boxes using 
the VisualAge C/C++ compiler 5 only to find that that MySQL daemon is 
unable to properly start itself.. Below is the excerpt from the "err" 
file.. I waited until it was done with writing out the large InnoDB 
log/data files.  I even tried connecting GDB to the mysqld process, but it 
was unable to do so (it just hung).  I finally had to "kill -9" it (kill by 
itself didn't work).  Now, I find that if I startup with "--skip-innodb" 
set when I run the safe_mysqld script, that MySQL starts up fine..

Just for reference, here's the CC/CPP environment variables I used with 
configure :

CC=xlc_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=10240
CXX=xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=10240
CFLAGS=-I/usr/local/include
LDLFLAGS=-L/usr/local/lib
CPPFLAGS=-I/usr/local/include
CXXFLAGS=-I/usr/local/include

./configure --prefix=/opt/mysql --enable-thread-safe-client 
--enable-large-files --with-innodb

along with the changes as discussed in the below archived message from late 
last year :

http://groups.google.com/groups?hl=en&selm=9s779b%24o9a%241%40FreeBSD.csie.
NCTU.edu.tw&rnum=4

% more var/xena.err
020718 11:46:23  mysqld started
InnoDB: The first specified data file /opt/mysql/var/test/test did not 
exist:
InnoDB: a new database to be created!
020718 11:46:26  InnoDB: Setting file /opt/mysql/var/test/test size to 1000 
MB
InnoDB: Database physically writes the file full: wait...
020718 11:47:59  InnoDB: Log file /opt/mysql/logs/ib_logfile0 did not 
exist: new to be created
InnoDB: Setting log file /opt/mysql/logs/ib_logfile0 size to 16 MB
InnoDB: Database physically writes the file full: wait...
020718 11:48:01  InnoDB: Log file /opt/mysql/logs/ib_logfile1 did not 
exist: new to be created
InnoDB: Setting log file /opt/mysql/logs/ib_logfile1 size to 16 MB
InnoDB: Database physically writes the file full: wait...
020718 11:55:01  mysqld ended

I ONLY got the "mysqld ended" line AFTER I kill -9'd it.  I checked that it 
properly created all of the log files, etc.. Any ideas?

% ls -la var/test
total 1024008
drwx--2 mysqldba   512 Jul 18 11:46 .
drwx--4 mysqldba   512 Jul 18 11:55 ..
-rw-rw1 mysqldba  1048576000 Jul 18 11:47 test

% ls -la logs/
total 32776
drwxrwxr-x2 mysqldba   512 Jul 18 11:48 .
drwxrwxr-x   13 mysqldba   512 Jul 18 11:46 ..
-rw-rw1 mysqldba  16777216 Jul 18 11:48 ib_logfile0
-rw-rw1 mysqldba  16777216 Jul 18 11:48 ib_logfile1

# This is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/mf.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /opt/mysql/var) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
port= 3306
socket  = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
ansi
port= 3306
socket  = /tmp/mysql.sock

# Uncomment the following if you are using Innobase tables
innodb_data_home_dir = /opt/mysql/var/test
innodb_data_file_path = test:1000M
innodb_log_group_home_dir = /opt/mysql/logs/
innodb_log_arch_dir = /opt/mysql/logs/
innodb_log_archive=0
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=2
#  Set the log file size to about
#  15 % of the buffer pool size
set-variable = innodb_log_file_size=16M
set-variable = innodb_log_buffer_size=8M
#  Set ..flush_log_at_trx_commit to
#  0 if you can afford losing
#  a few last transactions
innodb_flush_log_at_trx_commit=1
set-variable = innodb_buffer_pool_size=32M
set-variable = innodb_additional_mem_pool_size=32M
set-variable = innodb_file_io_threads=2
set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable= max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M

[myisamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M

[mysqlhotcopy]
interactive-timeout

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

Three easy, FAST-REPLY questions re: MySQLGUI

[Andy Fields]

Folks,

On my FreeBSD UNIX/Apache virtual private server (ISP is NTT/Verio), I
have MySQL-3.23.49 installed with one empty database and password
created to get me started.

My desktop "box" is Windows XP Pro.

I've already downloaded and installed MyODBC 3.51.03 (full package/docs)
and my MS MDAC is equivalent to version 2.7 RTM (2.20.7713.4), according
to Microsoft's little self-tester utility.

So far, the ONLY problem I'm having is with my DSN Configuration with
the MyODBC 3.51.03 driver as revealed in the following popup message:

"[MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'localhost'
(10061)"

I know there are SEVERAL OTHER installation/configuration chores to
complete before I enjoy the wonders of MySQL.

Hence...my downloading MySQLGUI to tackle those chores more effectively
in combination with reading the ~!@#$% manuals over and over and over.

MY THREE QUESTIONS...finally...

1. I notice in my Windows Registry and the odbc.ini file that references
to
   myodbc3 are preceded by TWO--sometimes THREE--back slashes like the
   sample below...

Driver32=C:\WINDOWS\System32\\\myodbc3.dll

   For whatever technical reasons that multiple back slashes ARE
required,
   HOW MANY should be present before the myodbc file references?

   ___ Only 1 back slash is required.

   ___ back slashes ARE required.


To "compile" MySQLGUI to help me easily access/configure/use MySQL on a
FreeBSD Unix/Apache server from Windows XP Pro (dial-up)...

2.  WHICH of the following items  3. In WHAT order do I 
MUST I download (i.e., x_YES)? ..and theninstall/configure
them?

   1st  2nd  3rd  4th  5th  6th
7th

 x_Yes __ No  MySQLGUI 1.7.5 Source Code   ___  ___  ___  ___  ___  ___
___

 __Yes __ No  Statically Complied MySQLGUI ___  ___  ___  ___  ___  ___
___

 x_Yes __ No  Win32 static binary of 
  MySQLGUI 1.7.5-2 ___  ___  ___  ___  ___  ___
___


 
 __Yes __ No  FreeBSD 4.2 static binary
  of MySQLGUI 1.7.2___  ___  ___  ___  ___  ___
___

 __Yes __ No  MySQL Monitor Epplet, etc.   ___  ___  ___  ___  ___  ___
___
 
 x_Yes __ No  The newest FLTK  ___  ___  ___  ___  ___  ___
___ 

 x_Yes __ No  The newest FLTK VW Library   ___  ___  ___  ___  ___  ___
___

 x_Yes __ No  FLTK editor widget 0.4   
  for MySQLGUI ___  ___  ___  ___  ___  ___
___
 
 __Yes __ No  The newest MySQL C++ library ___  ___  ___  ___  ___  ___
___


Thanks for your kind assistance and reply at your earliest convenience.

Respectfully yours,

Andy Fields
[EMAIL PROTECTED]
Santa Clara, CA (in the heart of Silicon Valley)





-
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: count query across two tables

[Mark Matthews]

See http://www.mysql.com/doc/J/O/JOIN.html

What you basically want is a left join between TalkTopics and TalkReplies.
Then any rows in TalkReplies that don't have a row in TalkTopics will come
back with all nulls (but they'll still make it through the query), i.e:


SELECT *, COUNT(TalkReplies.TopicID) as Comments
FROM TalkTopics LEFT JOIN TalkReplies
ON TalkTopics.TopicID = TalkReplies.TopicID
GROUP BY TalkTopics.TopicID DESC

-Mark
- Original Message -
From: "Stanley, Jason" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 1:54 PM
Subject: count query across two tables



hello all,

i'm new to the list (and to mysql, for that matter) and am looking for some
help with what should be a fairly simple query.

what i'm doing is writing a very simple bulletin board with jsp using two
tables in mysql. the first table contains the title and body of the topic
and the second contains the replies, which are cross-indexed by the topic
id. simple enough, but here they are...

+-++--+---+
| TopicID | title  | username | body  |
+-++--+---+
|   1 | new topic  | kilgore  | body text |
|   2 | big topic at hand  | kilgore  | more  |
|   3 | you'll never guess who i saw today | kilgore  | david |
|   4 | silliest topic ever| bob  | etc...|
|   5 | this is another topic  | kilgore  | ...   |
|   6 | look! my first topic!  | jeff | ...   |
|   7 | yet another test topic | kilgore  | ...   |
|   8 | NO MORE| kilgore  | ...   |
|   9 | oh hello   | kilgore  | ...   |
|  10 | never mind the testing | kilgore  | ...   |
|  11 | eh?| kilgore  | ...   |
|  12 | TITLE  | kilgore  | ...   |
+-++--+---+

+-+-+-+-+
| ReplyID | TopicID | body| user|
+-+-+-+-+
|   4 |   4 | anyone? | bob |
|  11 |   5 | what| kilgore |
|  10 |   2 | who?| kilgore |
|   8 |   4 | another reply   | kilgore |
|   9 |   3 | oh my   | kilgore |
|  12 |   5 | what| kilgore |
|  13 |   5 | again   | bob |
|  14 |   3 | yessir  | bob |
|  15 |   6 | oi  | jeff|
|  16 |   6 | oi  | jeff|
|  17 |   6 | oi  | jeff|
|  18 |   6 | oi  | jeff|
|  19 |   6 | thing   | kilgore |
|  20 |   6 | thing   | kilgore |
|  21 |   6 | thing   | kilgore |
|  22 |   4 | BLING   | tommy   |
|  23 |  10 | hello   | kilgore |
|  24 |  12 | reply   | kilgore |
+-+-+-+-+

so here's my problem: on the page which displays the topic titles, i wish to
display all of the topics along with the number of replies specific to that
topic. here is my query:

SELECT *, COUNT(TalkReplies.TopicID) as Comments
FROM TalkTopics, TalkReplies
WHERE TalkTopics.TopicID = TalkReplies.TopicID
GROUP BY TalkTopics.TopicID DESC

this gets me almost there BUT it excludes any topics from the list which
have no replies (so i only get a list of 7 topics here instead of 12). this
has been plaguing me for days and i can't seem to get my head around how i
should rephrase the query. any insight would be *greatly* appreciated.

thanks,
-j

-
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: Innodb startup hangs on AIX 4.3.3 when built with IBM'sVisualAge C/C++ compiler 5.0.x

[Rick Flower]

[ MySQL ]

Here's some additional data now that I've rebuilt using "--enable-debug" or 
whatever the configure option is.

Here's what GDB is claiming is happening after it ran for about 2 minutes 
(after initial startup when NO files needed to be created)

(gdb) where
#0  thr_local_get (id=60) at thr0loc.c:75
#1  0x1022f98c in thr_local_get_in_ibuf_field () at thr0loc.c:145
#2  0x101c1b74 in ibuf_inside () at ibuf0ibuf.c:223
#3  0x101bc59c in fil_io (type=537082596, sync=271108496, 
space_id=804396760, block_offset=804396764, byte_offset=804396784, 
len=804396776, buf=0x2ff21ed4,
message=0xdeadbeef) at fil0fil.c:1105
#4  0x1020609c in trx_sys_doublewrite_restore_corrupt_pages () at 
trx0sys.c:281
#5  0x10189180 in innobase_start_or_create_for_mysql () at srv0start.c:1093
#6  0x10181e4c in innobase_init () at ha_innobase.cc:463
#7  0x1001350c in ha_init () at handler.cc:161
#8  0x10051120 in main (argc=21, argv=0x20052a70) at mysqld.cc:1899
#9  0x1204 in __start ()
(gdb)


It appears to be running in a loop as can be seen below.. I found a comment 
indicating something about it possibly running out of file handles, and 
have included a LSOF output for this process as well :

% lsof -p22014
COMMAND   PID  USER   FD   TYPE DEVICE SIZE/OFF   NODE NAME
mysqld  22014 mysql  cwd   VDIR   43,4  512 262153 /test2 
(/dev/test2lv)
mysqld  22014 mysql0u  VCHR   38,7   0t2353 168294 /dev/pts/7
mysqld  22014 mysql1w  VREG   43,4  792 262156 /test2 
(/dev/test2lv)
mysqld  22014 mysql2w  VREG   43,4  792 262156 /test2 
(/dev/test2lv)
mysqld  22014 mysql3u  IPv4 0x7028e2dc  0t0TCP *:3306 (LISTEN)
mysqld  22014 mysql4u  unix   10,7  0t0 70 /tmp/mysql.sock


75  in thr0loc.c
(gdb)
77  in thr0loc.c
(gdb)
79  in thr0loc.c
(gdb)
72  in thr0loc.c
(gdb)
81  in thr0loc.c
(gdb)
74  in thr0loc.c
(gdb)
75  in thr0loc.c
(gdb)
77  in thr0loc.c
(gdb)
79  in thr0loc.c
(gdb)
72  in thr0loc.c
(gdb)
81  in thr0loc.c
(gdb)
74  in thr0loc.c
(gdb)
75  in thr0loc.c
(gdb)
77  in thr0loc.c
(gdb)
79  in thr0loc.c
(gdb)
72  in thr0loc.c
(gdb)
81  in thr0loc.c
(gdb)
74  in thr0loc.c
(gdb)
75  in thr0loc.c

-
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

Local VB6 using MySQL DB on Web server

[Jorge Garza]

Hi

I have a web DB proyect and I would like to make a VB6 client where I can
connect to a local X database and a Web MySQL on a UNIX server.

So far, locally everything works great with VB6 and MySQL, the grids,
textbox, ADO control, etc.(DNS-Less and with DNS).
But when I connect to the DB on the web(Troughchj), which uses the same
MySQL structure, I get errors like "CANNOT INITIALIZE DATA BINDINGS" from
the grid control and I supose is going to be the same with some other
controls.

Any way, I understand that there must be some options changed on the ADO
object(control..?), like the cursorlocation, type, etc. this are the things
that I haven't get clear, I been reading little things about this from there
and there(like a puzzle)... and didn't work until I remembered read (from
MySQL site I guess) that it cannot use the SELECT * statement.. so I tried
specifyng the fields and it worked(DataGrid)...

So, What would be the rules I need to look for in order to get VB to work
with web MySQL DBs..?
Is it mandatory NOT to use the ' * ' in the SQL query..?

By the way, has anyone used DBSync from Sandshot software..? I'm trying to
use it as a way of avoiding the need of developing my own VB replicator, but
I have some wired eorros with remote MySQL DBs.

Thank you very much

Jorge Garza
(Sorry about my english :)

My system features(just in case)
Win ME
MyODBC 3.5
MySQL server
VB 6
Also have...
PWS 4 with PHP server
MyCC
MM Ultradev



-
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: Innodb startup hangs on AIX 4.3.3 when built with IBM's VisualAge C/C++ compiler 5.0.x

[Heikki Tuuri]

Rick,

these code excerpts may explain the problem:

/***
Returns the local storage struct for a thread. */
static
thr_local_t*
thr_local_get(
/*==*/
/* out: local storage */
os_thread_id_t  id) /* in: thread id of the thread */
{
thr_local_t*local;

try_again:
ut_ad(thr_local_hash);
ut_ad(mutex_own(&thr_local_mutex));

/* Look for the local struct in the hash table */

local = NULL;

HASH_SEARCH(hash, thr_local_hash, os_thread_conv_id_to_ulint(id),
local, local->id == id);
if (local == NULL) {
mutex_exit(&thr_local_mutex);

thr_local_create();

mutex_enter(&thr_local_mutex);

goto try_again;
}

ut_ad(local->magic_n == THR_LOCAL_MAGIC_N);

return(local);
}

/***
Creates a local storage struct for the calling new thread. */

void
thr_local_create(void)
/*==*/
{
thr_local_t*local;

if (thr_local_hash == NULL) {
thr_local_init();
}

local = mem_alloc(sizeof(thr_local_t));

local->id = os_thread_get_curr_id();
local->handle = os_thread_get_curr();
local->magic_n = THR_LOCAL_MAGIC_N;

local->in_ibuf = FALSE;

mutex_enter(&thr_local_mutex);

HASH_INSERT(thr_local_t, hash, thr_local_hash,
os_thread_conv_id_to_ulint(os_thread_get_curr_id()),
local);

mutex_exit(&thr_local_mutex);
}

/*
Returns the thread identifier of current thread. */

os_thread_id_t
os_thread_get_curr_id(void)
/*===*/
{
#ifdef __WIN__
return(GetCurrentThreadId());
#else
pthread_tpthr;

pthr = pthread_self();

/* TODO: in the future we have to change os_thread_id
   to pthread_t; the following cast may work in a wrong way on some
   systems if pthread_t is a struct; this is just a quick fix
   for HP-UX to eliminate a compiler warning */

return(*(os_thread_id_t*)((void*) (&pthr)));
#endif
}

If pthread_t is a struct where the first field does NOT determine the thread
uniquely, then our hash table will be confused. The above definition code
assumes pthread_t is either a pointer, or a struct where the first field
determines the thread uniquely.

Fix: os_thread_id_t is now an unsigned long int. Change it to a struct.
Compare these structs with the comparison functions provided in the pthreads
standard Posix functions, I think there are appropriate functions in it to
determine if two variables of type pthread_t represent the same thread.
Check also that the unsigned long int representation is not used anywhere to
determine the identity of pthread_t.

For example, in the code:

HASH_SEARCH(hash, thr_local_hash, os_thread_conv_id_to_ulint(id),
local, local->id == id);

the comparison local->id == id should be replaced with someting like
pthreads_are_identical(local->id, id).

This has to be changed in the InnoDB code some time. I cannot promise a date
yet. Thank you for bringing this up!

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


- Original Message -
From: "Rick Flower" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Friday, July 19, 2002 12:58 AM
Subject: Re: Innodb startup hangs on AIX 4.3.3 when built with IBM's
VisualAge C/C++ compiler 5.0.x


> [ MySQL ]
>
> Here's some additional data now that I've rebuilt using "--enable-debug"
or
> whatever the configure option is.
>
> Here's what GDB is claiming is happening after it ran for about 2 minutes
> (after initial startup when NO files needed to be created)
>
> (gdb) where
> #0  thr_local_get (id=60) at thr0loc.c:75
> #1  0x1022f98c in thr_local_get_in_ibuf_field () at thr0loc.c:145
> #2  0x101c1b74 in ibuf_inside () at ibuf0ibuf.c:223
> #3  0x101bc59c in fil_io (type=537082596, sync=271108496,
> space_id=804396760, block_offset=804396764, byte_offset=804396784,
> len=804396776, buf=0x2ff21ed4,
> message=0xdeadbeef) at fil0fil.c:1105
> #4  0x1020609c in trx_sys_doublewrite_restore_corrupt_pages () at
> trx0sys.c:281
> #5  0x10189180 in innobase_start_or_create_for_mysql () at
srv0start.c:1093
> #6  0x10181e4c in innobase_init () at ha_innobase.cc:463
> #7  0x1001350c in ha_init () at handler.cc:161
> #8  0x10051120 in main (argc=21, argv=0x20052a70) at mysqld.cc:1899
> #9  0x1204 in __start ()
> (gdb)
>
>
> It appears to be running in 

MyOLEDB-Provider - Some fixes by me

[Christoph Weber]

Hi!

I read a message from venu to somebody called Woods, concerning fixing some
of the bugs in the OLEDB-provider for MySQL trough external people.
(http://www.geocrawler.com/archives/3/108/2002/4/0/8496671)

Are you still interested in some fixes? I would be happy to give them to you
for free.

I've spent nearly 30 hours up to now and have improved in the following
areas:

- Support for text-columns (DBFIELDTYPE_IUNKNOWN -> ISimpleStream)
- Fix of a nasty bug which caused sporadic error messages (No conversion
available) because of a uninitialized field (dwType of rgdbcolumninfo)
- Kernel-Memorycheck-error in conjunction with text-columns (pobject was
just copied and ado tried to free the pointer)
- Tables collection was not available the first time (a second access to the
tables-property worked) because of a error I can't remember at the moment
- Commands with string parameters caused errors if they contained meta
characters like \ or '
- UPDATE-Command failed if the new value matched the old one (Flag
CLIENT_FOUND_ROWS was missing when opening)
- Bumped up the maximum table name to 64 instead of 32 characters because
one of our test tables had exactly 32 characters and there was no reason for
this.
- increased the (precompiled) maximum number of memory slots to 100 MByte
because 10 MByte was way too small for our needs.

There are still some of errors, but I think it's a big progress forward.

I made most of the changes to the oledb-implementation only. The only other
thing I modified was in the myodbc-subdirectory: I extended the default
flags
with CLIENT_FOUND_ROWS because ADO would otherwise think the row update
failed because of a concurrency failure when using pessimistic locking with
recordsets.

If you are interested in the changes, please tell my how to provide them.
The easiest for me would of course be to send all files zipped together like
they were distributed originally.
I could also send only the modified files or even a diff-output between the
original OLEDB3.0.zip-contents and my version (in this case pls. provide
short instructions on how to do this).

best regards,
  christoph weber


-
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: HP-UX 11, mysql-max

[Heikki Tuuri]

Jason,

- Original Message - 
From: "Jason Baker" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 11:48 PM
Subject: HP-UX 11, mysql-max


> I tried the HP-UX mysql depot from the HP Software Porting Center, but 
> it doesn't have innodb support.
> 
> The mysql-max capability page says that innodb is supported on HP-UX, 
> though... so presumably somebody, somewhere, has done this already.
> 
> When I'm trying to compile with gcc 2.95.3 or with gcc 3.0.1, I get a 
> missing library (-ldl) when building mysqld, despite configuring with 
> --disable-shared and --enable-static.
> 
> So... I'm game for just about any advice at this point.  A depot with 
> mysqld-max would be ideal, advice on what's going wrong on the link 
> would be a close second.

please try

HP-UX downloads

Binary packages (tar.gz) 
MySQL 4.0.1-alpha HP-UX 10.20 (6.5M) Download


at http://www.mysql.com/downloads/mysql-4.0.html

Some people also compile Max-3.23 on their own HP-UX computer.

> Thanks in advance,
>  Jason

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

help with installation

[Steve Dickey]

I am a mysql newbie and in search of some pointers to get mysql 3.23.51
installed on my Redhat 7.3 system.  I have the RPM downloaded and installed
but I am  not able to find the programs listed such as mysqladmin.  The
mysqld process is running and I can run the mysql_install_db script.  

Any ideas or links to helpful information would be most appreciated.

thanks...scd

Steve Dickey, President/CEO
Corbett Systems
719-520-9962 x1007
http://www.corb.net
"Who is John Galt?"
NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named. Any use, copying
or disclosure by any other person is strictly prohibited. If you have
received this transmission in error, please notify the sender via e-mail.



-
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: Replication w/ InnoDB

[Heikki Tuuri]

James,

I am sorry, the manual page at
http://www.mysql.com/doc/I/n/InnoDB_restrictions.html is not up-to-date.

Look at http://www.innodb.com/ibman.html#InnoDB_restrictions instead:
.
* In the MySQL replication load table from master does not work yet for
InnoDB tables. A workaround is to alter the table to MyISAM in the master,
do then the load, and after that alter back to InnoDB in the master.
.

But often you should replicate everything, not just a single table. Then it
is best to shut down the master and copy all relevant files to the slave. Or
use InnoDB Hot Backup, a non-free tool.

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com


- Original Message -
From: ""James Kelty"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 9:49 PM
Subject: Replication w/ InnoDB


> Ok, ok, now that I know that I 'can' replicate InnoDB tables, it's time I
> got it to ACTUALLY replicate InnoDB tables, eh?
>
> This is my /etc/my.cnf file from the master server:
>
> [mysqld]
> log-bin=/storage/mysql/replication.log
> server-id=1
> default-table-type=innodb
>
>
> innodb_data_home_dir=/storage/innodb
> set-variable = innodb_mirrored_log_groups=1
> #
> #
> innodb_data_file_path=indata1:2000M;indata2:
> data5:2000M;indata6:2000M
> #
> #
> set-variable = innodb_buffer_pool_size=128M
> set-variable = innodb_additional_mem_pool_si
> innodb_log_group_home_dir = /storage/innodbl
> #
> #
> innodb_log_arch_dir = /storage/innodblogs
> innodb_log_archive = 0
> set-variable = innodb_log_files_in_group=3
> #
> #
> set-variable = innodb_log_file_size=100M
> set-variable = innodb_log_buffer_size=16M
> #
> #
> #
> innodb_flush_log_at_trx_commit=1
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
>
> [mysql.server]
> user=mysql
> basedir=/usr/local/mysql
>
> [safe_mysqld]
> err-log=/storage/mysql/mysql_error_log
> pid-file=/storage/mysql/mysqld.pid
>
>
> And Here is my /etc/my.cnf file from the SLAVE:
>
> [mysqld]
> server-id=2
> master-host=192.168.10.49
> master-user=repl
> master-password=replicate
> master-connect-retry=5
> master-info-file=master.info
> replicate-do-db=everbase
> log-slave-updates
> #skip-slave-start
>
> default-table-type=innodb
>
> innodb_flush_log_at_trx_commit=0
> innodb_data_home_dir=/database/MySQL/innodb
> set-variable = innodb_mirrored_log_groups=1
> #
> #
> innodb_data_file_path=indata1:2000M:autoextend:max
> #
> #
> set-variable = innodb_buffer_pool_size=128M
> set-variable = innodb_additional_mem_pool_size=80M
> innodb_log_group_home_dir = /database/MySQL/innodb
> #
> #
> innodb_log_arch_dir = /database/MySQL/innodblogs
> innodb_log_archive = 0
> set-variable = innodb_log_files_in_group=3
> #
> #
> set-variable = innodb_log_file_size=100M
> set-variable = innodb_log_buffer_size=16M
> #
> #
> #
> innodb_flush_log_at_trx_commit=1
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
>
>
> I have select, and file permissions for the 'repl' user,
> and when I try the sql query LOAD TABLE Users FROM MASTER on the slave,
> all I get is the replicated table is created, but NO data comes accross,
> and I get the 1189 Net Read Error on the slave. BUT! When I change the
type
> of
> table from InnoDB to MyISAM on the MASTER SERVER, the above LOAD TABLE
works
> REALLY well.
>
>
> Not sure why this is happening. Plus, NONE of the changes I make to the
> table after altering it
> to the MyISAM type, replicate? What am I missing. I would really like the
> replication to work well
> with InnoDB types instead of MyISAM.
>
> Please, can someone point me in the right direction?
>
> Thanks!
>
> -James
>
>
> -
> 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: Three easy, FAST-REPLY questions re: MySQLGUI

[Dan Nelson]

In the last episode (Jul 18), Andy Fields said:
> Folks,
> 
> On my FreeBSD UNIX/Apache virtual private server (ISP is NTT/Verio), I
> have MySQL-3.23.49 installed with one empty database and password
> created to get me started.
> 
> My desktop "box" is Windows XP Pro.
> 
> I've already downloaded and installed MyODBC 3.51.03 (full package/docs)
> and my MS MDAC is equivalent to version 2.7 RTM (2.20.7713.4), according
> to Microsoft's little self-tester utility.
> 
> So far, the ONLY problem I'm having is with my DSN Configuration with
> the MyODBC 3.51.03 driver as revealed in the following popup message:
> 
> "[MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'localhost' (10061)"

Sounds like you forgot to fill in the hostname of the FreeBSD box in
your DSN configuration, and the XP machine is trying to connect to a
server on itself.
 
> 
> 1. I notice in my Windows Registry and the odbc.ini file that
>references to myodbc3 are preceded by TWO--sometimes THREE--back
>slashes like the sample below...
> 
> Driver32=C:\WINDOWS\System32\\\myodbc3.dll
> 
>For whatever technical reasons that multiple back slashes ARE
>required, HOW MANY should be present before the myodbc file
>references?

At least one :)  Multiple slashes or backslashes in a path (barring the
\\server\ notation for win32 UNC paths) are always silently compressed
to a single one.

> To "compile" MySQLGUI to help me easily access/configure/use MySQL on
> a FreeBSD Unix/Apache server from Windows XP Pro (dial-up)...
> 
> 2.  WHICH of the following items  3. In WHAT order do I 
> MUST I download (i.e., x_YES)? ..and theninstall/configure
> them?

Gah.  The wordwrapping on this "form" is so mangled I cannot bring
myself to even quote it (The "7" column is wrapped, just like "them" in
the paragraph I quoted).  Download the win32 static binary.

-- 
Dan Nelson
[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: Replication in v4.0.2 not doing UPDATE

[Heikki Tuuri]

Hi!

Please provide more details. Does the problem happen also if you replicate
all tables, not just use the replicate-do-table directive?

What is the table definition like (print SHOW CREATE TABLE in the master as
well as slave)? Does it have foreign key constraints? Give an example of an
UPDATE statement which does not succeed. If you execute the UPDATE manually
on the slave, does it succeed then?

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

- Original Message -
From: "MySQL admin account" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 9:20 PM
Subject: Replication in v4.0.2 not doing UPDATE


> >Description:
> I am using MySQL v4.0.2 and I have set up a master database and 2
slave
> databases, all on separate Solaris machines. The replication works
fine
> when I INSERT or DELETE but does not perform my UPDATE statements.
I have
> used 'mysqlbinlog' on the relay log on one of the slaves and the
UPDATE
> statements are being sent to the slaves but they are not being
executed.
> No errors have been generated to the error log and no errors are
shown when
> a SHOW SLAVE STATUS is run. The slaves use replicate-do-table
directives in
> the config file but the tables that I am trying to update are
listed and
> I can INSERT into and DELETE from these tables that I am trying to
update.
> The UPDATE succeeds on the master. All of my tables are INNODB
type.
> >How-To-Repeat:
> When I run an UPDATE statement on my master database on replicated
tables
> it is not replicated to the slaves (even though the statement is
replicated
> to the relay log on the slave servers).
> >Fix:
> Unknown
>
> >Submitter-Id: miguelryan
> >Originator: MySQL admin account
> >Organization:  freelance consultant
> >MySQL support: none
> >Synopsis: Replication in v4.0.2 not doing UPDATE
> >Severity: critical
> >Priority: high
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-4.0.2-alpha (Source distribution)
>
> >Environment:
>
> System: SunOS ops-dev5 5.6 Generic_105181-28 sun4u sparc
SUNW,UltraSPARC-IIi-cEngine
> Architecture: sun4
>
> Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/usr/ucb/cc
> GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs
> gcc version 2.95.3 20010315 (release)
> Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'
CXX='gcc'

CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -
fno-rtti'  LDFLAGS=''
> LIBC:
> -rw-r--r--   1 bin  bin  1623504 Aug 24  2001 /lib/libc.a
> lrwxrwxrwx   1 root root  11 Feb  9  2000 /lib/libc.so ->
./libc.so.1
> -rwxr-xr-x   1 bin  bin  1024888 Aug 24  2001 /lib/libc.so.1
> -rw-r--r--   1 bin  bin  1623504 Aug 24  2001 /usr/lib/libc.a
> lrwxrwxrwx   1 root root  11 Feb  9  2000 /usr/lib/libc.so ->
./libc.so.1
> -rwxr-xr-x   1 bin  bin  1024888 Aug 24  2001 /usr/lib/libc.so.1
> Configure command:
./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --with-s
erver-suffix= --enable-thread-safe-client --enable-local-infile --enable-ass
embler --disable-shared --with-innodb CC=gcc
'CFLAGS=-O3 -fno-omit-frame-pointer'
'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -
fno-rtti' CXX=gcc
> Perl: This is perl, version 5.005_03 built for sun4-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
>



-
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/enhancement request

[Chuck Simmons]

sql query

fyi...  Section 6.4.1 of the manual says:

"

SELECT [STRAIGHT_JOIN]
   [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
   [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY]
   [DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
[FROM table_references
  [WHERE where_definition]
  [GROUP BY {unsigned_integer | col_name | formula} [ASC | DESC], ...]
  [HAVING where_definition]
  [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
  [LIMIT [offset,] rows]
  [PROCEDURE procedure_name]
  [FOR UPDATE | LOCK IN SHARE MODE]]

"

In addition to being able to specify an update lock or a shared mode 
lock, one should be able to specify no lock.  This is the moral 
equivalent of the Sybase "noholdlock" option.  This is useful if you 
normally want to run in a high isolation environment but are, say, 
running a transaction where you don't need repeatable reads for some 
select in that transaction.


-
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

Host IP is not allowed to connect this MySQL server

[Matt]

Hello, I am trying to connect to a remote MySQL server of mine and I get
this error " Host IP is not allowed to connect this MySQL server " If
someone could give me the shortcut to this file so I can edit it to
allow me in- It would be greatly appreciated.
 
Thank You
 
Matt


-
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

mysqlimport usage

[James Ching]

Hi,

Does anyone know where to view mysqlimport logs?  After running with
"--replace" and I can see a number of rows recorded as deleted and some as
warnings.  I can't locate any history anywhere - not in the current
directory, not in mysql installation location, not in in syslog...

Thanks much

James


-
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

Very basic bug: Respecting NOT NULL?

[Bradley Plies]

OS: Win2K
MySQL:  3.23.51
What:   CREATE TABLE
Problem:Column specification not honoring NOT NULL specifier.


CREATE TABLE PFPBaseRequest
(
# Uniquely identify this record
id  INTEGER NOT NULL AUTO_INCREMENT,
trx_typeCHAR(1) NOT NULL,
tender  CHAR(1) NOT NULL,
req_dateDATETIME NOT NULL,
amt DECIMAL(16,2) NOT NULL,
PRIMARY KEY (id)
);


mysql> describe pfpbaserequest;
+--+---+--+-+-++

| Field| Type  | Null | Key | Default | 
Extra  |

+--+---+--+-+-++

| id   | int(11)   |  | PRI | NULL| 
auto_increment |

| trx_type | 
char(1)   |  | | ||

| tender   | 
char(1)   |  | | ||

| req_date | datetime  |  | | -00-00 00:00:00 
||

| amt  | decimal(16,2) |  | | 
0.00||

+--+---+--+-+-++

5 rows in set (0.00 sec)

mysql> insert into pfpbaserequest (tender) values('X');
Query OK, 1 row affected (0.00 sec)

mysql> select * from pfpbaserequest;
++--++-+--+
| id | trx_type | tender | req_date| amt  |
++--++-+--+
|  1 |  | X  | -00-00 00:00:00 | 0.00 |
++--++-+--+
1 row in set (0.00 sec)


-
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

Query

[abhilas]

Hi,
  I am retrieving the values of some positions of a table in MySQL 
dynamically.The position has null(automatically database insert that null 
value),1,2 values.I have to retrieve that values to a java prog and to 
check whether the retrieved value is 1,2 or null.This I am doing like 
this. 
  I reterieves the value using rs1.getString(usrnameDB).

if(rs1.getString(usrnameDB).equals("1"))
else if(rs1.getString(usrnameDB).equals("null"))
   The II line won't work because here the null parameter(entered 
automatically in the database)is something different from that is there in 
a JAva prog.
  I just want to know how can I check that a retrieved value in this 
manner is 1,2 or null.
 Abhilash


-
This message was sent using Endymion MailMan.
http://www.endymion.com/products/mailman/



-
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

optimization

[jesilva]

>MySQL version 3.23.43 for SCO 5.06 binary INTEL.
>The point is that it doesn't make the rigth selection of the index
>When it performs
>explain select nfactura, nauclfe from auxiliar where nfactura like '30%'
>order by nfactura;
>The result we have is:
>table type possible_keys key key_len ref rows Extra
>auxiliar ALL nfactura_idx NULL NULL NULL 1028572 where used; Using filesort
>The name of the table is "auxiliar" and the field "nfactura" is "unique
>key" not null.
>The rigth answer should be "key nfactura" but it isn't as you can see.
>The same query works ok with other versions of MySQL 3.23.45 for FreeBsd

-
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: Host IP is not allowed to connect this MySQL server

[Bhavin Vyas]

http://www.mysql.com/doc/G/R/GRANT.html
- Original Message -
From: "Matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 4:42 PM
Subject: Host IP is not allowed to connect this MySQL server


> Hello, I am trying to connect to a remote MySQL server of mine and I get
> this error " Host IP is not allowed to connect this MySQL server " If
> someone could give me the shortcut to this file so I can edit it to
> allow me in- It would be greatly appreciated.
>
> Thank You
>
> Matt
>
>
> -
> 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

proces to blockade

[jesilva]

Hi we have a problem,
I have table of 1,000,000 rows and i do query all, and after i can't do any more, 
because this process to blockade all mysql i can't do query of any table.

What can i do ?


Thanks and Regards 

-
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: Host IP is not allowed to connect this MySQL server

[Matthew Scarrow]

It's not a file it's in the database.

telnet to the server and login to mysql using the mysql client util like
this

mysql -u root -p

then hit enter and enter the password.

now do these commands to create a remote super user
mysql> GRANT ALL PRIVILEGES ON *.* TO
monty@youripaddresshere_or_%_for_all_or_example_192.%
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

that's it. For further fine tunning on privilages please visit www.mysql.com
and go to there documentation section. There you will find all you need to
know about creating users.



Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax:   519-442-0429


-Original Message-
From: Matt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 7:42 PM
To: [EMAIL PROTECTED]
Subject: Host IP is not allowed to connect this MySQL server


Hello, I am trying to connect to a remote MySQL server of mine and I get
this error " Host IP is not allowed to connect this MySQL server " If
someone could give me the shortcut to this file so I can edit it to
allow me in- It would be greatly appreciated.

Thank You

Matt


-
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: Host IP is not allowed to connect this MySQL server

[Nitesh Divecha]

Thanks Dude,

I gotta same probz... but I got it now :)

Regards
Nitesh

> 
> From: Bhavin Vyas <[EMAIL PROTECTED]>
> Date: 2002/07/18 Thu PM 08:15:26 GMT+03:00
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: Host IP is not allowed to connect this MySQL server
> 
> http://www.mysql.com/doc/G/R/GRANT.html
> - Original Message -
> From: "Matt" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, July 18, 2002 4:42 PM
> Subject: Host IP is not allowed to connect this MySQL server
> 
> 
> > Hello, I am trying to connect to a remote MySQL server of mine and I get
> > this error " Host IP is not allowed to connect this MySQL server " If
> > someone could give me the shortcut to this file so I can edit it to
> > allow me in- It would be greatly appreciated.
> >
> > Thank You
> >
> > Matt
> >
> >
> > -
> > 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

Bash to remote MySql Server

[Terence]

Hi List,

Wondering if anyone knows whether it's possible from bash, to connect to a
remote mysql database? And if so, where I can find some help.
All I require is to connect to another mysql database and get a list of
users. (I am trying to avoid running another mysql db for just one table)
If not, what do I need to look into? perl?

Thanks
Terence


-
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

Merge records from multiple tables???

[Ollie Acheson]

Hi,

I am a newcomer to mysql (and pretty much to sql in general). I have a
question that is probably pretty simple to answer, but it is escaping
me at present.

I want to select records from two separate tables and put the results
into a result table. Seems pretty simple, but I don't want to join the
records from the two tables into combined records in the result table
but rather keep them as separate records in the result table.

Perhaps an example would clarify what I want to do.

Suppose I have two tables of data, such as a current invoice file and
an invoice history file. Suppose I need to do a report that would
include all records from both files. For the life of me, I don't see
how to accomplish this. For the old-timers out there, this was called
a merge in an earlier era of data processing.

Thanks for any pointers.

Ollie

-- 
|---|
| Ollie Acheson |
| Morristown, NJ|
|---|


-
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

Query cache size

[Haapanen, Tom]

I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that
4.02 performance rocks!  :-)

I was planning to wait for the beta builds, but the thing that triggered my
decision was the discovery of the query cache.  Our database server (1.4 GHz
Athlon on FreeBSD) typically runs between 20% and 40% load, and complex
pages (like our front page!) with many queries were getting the page
processing time (including the web server, a 533 MHz Alpha on NetBSD) up to
4-5 seconds.

With my initial 4.02 configuration, my front page processing times are
between 0.5 and 1.5 seconds -- and the database server load is hovering
around 10-20%.  Excellent!

The query cache, though ... the documentation doesn't make many suggestions
about sizing it.  I started with this:


-
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

Query cache size

[Haapanen, Tom]

[Sorry about the early send on the previous one ...]

I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that
4.02 performance rocks!  :-)

I was planning to wait for the beta builds, but the thing that triggered my
decision was the discovery of the query cache.  Our database server (1.4 GHz
Athlon on FreeBSD) typically runs between 20% and 40% load, and complex
pages (like our front page!) with many queries were getting the page
processing time (including the web server, a 533 MHz Alpha on NetBSD) up to
4-5 seconds.

With my initial 4.02 configuration, my front page processing times are
between 0.5 and 1.5 seconds -- and the database server load is hovering
around 10-20%.  Excellent!

The query cache, though ... the documentation doesn't make many suggestions
about sizing it.  I started with this:

set-variable= query_cache_limit=2M
set-variable= query_cache_size=64M
set-variable= query_cache_startup_type=1

Is this reasonable?  This is what my status shows (after 30 minutes or so):

| Qcache_queries_in_cache  | 789  |
| Qcache_inserts   | 1512 |
| Qcache_hits  | 2847 |
| Qcache_not_cached| 0|
| Qcache_free_memory   | 65710008 |

Is that Qcache_free_memory figure really right?  And, more importantly,
should I allocate more memory for this?  This seems like my biggest win, and
I do have 1 GB available.

Tom Haapanen
[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: Merge records from multiple tables???

[Bhavin Vyas]

create table abc as (select * from xyz1);
insert into abc values (select * from xyz2);

The above 2 commands should do it.
You might need to change them a bit, if so
www.mysql.com/doc should be very helpful.

Regards,
Bhavin.
- Original Message -
From: "Ollie Acheson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 6:24 PM
Subject: Merge records from multiple tables???


> Hi,
>
> I am a newcomer to mysql (and pretty much to sql in general). I have a
> question that is probably pretty simple to answer, but it is escaping
> me at present.
>
> I want to select records from two separate tables and put the results
> into a result table. Seems pretty simple, but I don't want to join the
> records from the two tables into combined records in the result table
> but rather keep them as separate records in the result table.
>
> Perhaps an example would clarify what I want to do.
>
> Suppose I have two tables of data, such as a current invoice file and
> an invoice history file. Suppose I need to do a report that would
> include all records from both files. For the life of me, I don't see
> how to accomplish this. For the old-timers out there, this was called
> a merge in an earlier era of data processing.
>
> Thanks for any pointers.
>
> Ollie
>
> --
> |---|
> | Ollie Acheson |
> | Morristown, NJ|
> |---|
>
>
> -
> 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: Bash to remote MySql Server

[Colin Faber]

Yes,

use the ``mysql'' client.



Terence wrote:
> 
> Hi List,
> 
> Wondering if anyone knows whether it's possible from bash, to connect to a
> remote mysql database? And if so, where I can find some help.
> All I require is to connect to another mysql database and get a list of
> users. (I am trying to avoid running another mysql db for just one table)
> If not, what do I need to look into? perl?
> 
> Thanks
> Terence
> 
> -
> 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

-- 
Colin Faber
(303) 736-5160
fpsn.net, Inc.

-
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

Win and Linux ? Ver 3 and Ver 4 compatibility ?

[Jimmy Fernandez]

Hi ALL,
I just wanted to clarify something:
1. Can I upgrade the MySQL version from one older version to a newer 
version? For example if I have data base in ver 3.0 can I import over to 
newly downloaded ver 4.0 ? Will it still work ?
Can I then delete off ver 3..0 and run the old database from ver 4.0 ?

2. If I made the database in Windows version of MySQL can I bring the 
database over to a Unix or Linux machine ?
What are the changes I have to make if any ?

THANKS in advance.

Cheers
Jimmy



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Innodb and unbuffered raw io on linux?

[Christian Jaeger]

Hello Heikki and all,

I've already asked about this a year ago, but didn't finish my 
investigations then.

What's the status with innodb and *unbuffered raw* io on linux?

The manual describes the use of the "newraw" and "raw" options, and I 
know these work on disk devices (like /dev/sda8), but this isn't raw 
io, it's still cached by the kernel and so takes up RAM additional to 
the cache from innodb (as well as a bit CPU to copy over the data 
between kernel and user space). If you want to do direct IO, the use 
of the 'raw' tool to set up a 'raw character device' mapped to the 
disk block device is needed:

cd /dev
mkdir raw
umask 077
mknod rawctl u 162 0
umask 007
mknod raw/raw1 u 162 1
mknod raw/raw2 u 162 2
chgrp mysql raw/raw1
 # ^- I'm not sure whether the access rights of the mapped device
 # take precedence over those of the original block device, though
raw raw/raw1 sda8

I've tried Mysql with this config:
#innodb_data_file_path=/dev/sda8:1906Mraw  <- did work, but buffered
innodb_data_file_path=/dev/raw/raw1:1906Mraw

020719 00:59:24  mysqld started
InnoDB: Operating system error number 22 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: Look from section 13.2 at http://www.innodb.com/ibman.html
InnoDB: what the error number means or use the perror program of MySQL.
InnoDB: Cannot continue operation.
020719 00:59:25  mysqld ended

perror 22
Error code  22:  Invalid argument

This error code is typical for when buffers are not aligned to sector 
sized memory boundaries, which is necessary for unbuffered io to work 
on linux.
I've written an experimental program that shows this and put it here:
http://pflanze.mine.nu/~chris/mysql/o_direct.c

So I guess Innodb is not ready for unbuffered io. I'm also guessing 
that it's probably not that easy to achieve good performance with 
unbuffered io, since you would probably have to do readahead and so 
on yourself.

I'm also unsure about the current status of rawio in linux (2.4). 
Reading on http://oss.sgi.com/projects/rawio/ (under the FAQ), they 
say that they have a "better" implementation than the one from 
Stephen Tweedie/Redhat. But the code in kernel 2.4 seems to be only 
the one from Stephen Tweedie.
This is what the source code of the 'dd' tool (as found in 
Debian/testing) shows, btw:
 /* ...
  The page alignment is necessary on any linux system that supports
  either the SGI raw I/O patch or Stephen Tweedies raw I/O patch.
  It is necessary when accessing raw (i.e. character special) disk
  devices on Unixware or other SVR4-derived system.  */


Hope this helps a bit.
What do you think about it?
I could put a bit of time aside for testing (or maybe more, but who 
would pay me?...:)

Cheers,
Christian.
-- 
Christian Jaeger  Programmer & System Engineer  +41 1 430 45 26
ETHLife CMS Project - www.ethlife.ethz.ch/newcms - www.ethlife.ethz.ch

-
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