date:20020115



Hi!

I've got two mysql databases that have exactly the same structure (same
tables using BDB, columns, etc.) and different data.

When I try to do a select on a table from database A, I get the right
results, but when I try the same select on the same table from database B, I
get the results from the database A.

The only way I seem to be able to access the data on database B is to remove
the other database from MySQL.
From my tests it seems that MySQL only uses the table name to access the
data (not using also the database name).

Anyone has an idea, of why this happens.

Nuno A. S. Gonçalves
[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: MySQL can't tell the difference between two databases???

2002-01-15 Thread Duncan Hill


On Tue, 15 Jan 2002, Nuno Gonçalves wrote:

 The only way I seem to be able to access the data on database B is to
 remove the other database from MySQL. From my tests it seems that MySQL
 only uses the table name to access the data (not using also the database
 name).

The sql queries you are using on your database would help.  We are not 
mind-readers (well, I'm not!).


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

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: Multi-table delete/update



Thank you for your report.

We shall take a look at it.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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 can't tell the difference between two databases???



It's something like this:

mysql use db1
mysql select * from products;
++-+-+--+--+
| Id | Ref | Version | Type | Name |
++-+-+--+--+
|  1 | XXX |   1 |1 | XXX  |
++-+-+--+--+
1 row in set (0.27 sec)

mysql use db2
mysql select * from products;
++-+-+--+--+
| Id | Ref | Version | Type | Name |
++-+-+--+--+
|  1 | XXX |   1 |1 | XXX  |
++-+-+--+--+
1 row in set (0.16 sec)

I'm sure the table products on database db2 is empty, because of the results
I get when I remove db1 from the system.
The same select returns empty.

Hope that helps. Thanks.

Nuno A. S. Gonçalves
[EMAIL PROTECTED]


- Original Message -
From: Duncan Hill [EMAIL PROTECTED]
To: Nuno Gonçalves [EMAIL PROTECTED]
Cc: Mailing list MySql [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 12:13 PM
Subject: Re: MySQL can't tell the difference between two databases???


 On Tue, 15 Jan 2002, Nuno Gonçalves wrote:

  The only way I seem to be able to access the data on database B is to
  remove the other database from MySQL. From my tests it seems that MySQL
  only uses the table name to access the data (not using also the database
  name).

 The sql queries you are using on your database would help.  We are not
 mind-readers (well, I'm not!).





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

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: Official State of Mysql-Max


Ross,

Ross Davis wrote in message ...
On the front screen of the mysql site the mysql-Max 3.23.47 is listed as
stable.

However on the download page it is said to be considered a beta yet?

the download page is lagging behind. The MySQL manual describes it as gamma,
which is also the official classification by Innobase Oy.

The reason that I am asking this question, is that the Borland Delphi
Developers will not release a new version that supports the record locking
until this program is OFFICIALLY listed as stable.

If it is not yet listed as stable, then is there an ETA?

We will declare MySQL-Max stable during this month if no serious new bug
reports appear. The last bug classified as serious in InnoDB was the insert
buffer bug which was fixed on November 17th, 2001. The MySQL part in
MySQL-Max has been officially stable for a year now. You can follow the
official status of MySQL/InnoDB from the InnoDB website
http://www.innodb.com. It contains also a bug list.

Thanks in advance.

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 can't tell the difference between two databases???

2002-01-15 Thread Javier Armendáriz


What happens if you try select * from db1.products and select * from
db2.products;???

Doing that does the same?



 -Mensaje original-
 De: Nuno Gonçalves [mailto:[EMAIL PROTECTED]]
 Enviado el: martes, 15 de enero de 2002 13:24
 Para: Mailing list MySql
 Asunto: Re: MySQL can't tell the difference between two databases???



 It's something like this:

 mysql use db1
 mysql select * from products;
 ++-+-+--+--+
 | Id | Ref | Version | Type | Name |
 ++-+-+--+--+
 |  1 | XXX |   1 |1 | XXX  |
 ++-+-+--+--+
 1 row in set (0.27 sec)

 mysql use db2
 mysql select * from products;
 ++-+-+--+--+
 | Id | Ref | Version | Type | Name |
 ++-+-+--+--+
 |  1 | XXX |   1 |1 | XXX  |
 ++-+-+--+--+
 1 row in set (0.16 sec)

 I'm sure the table products on database db2 is empty, because of
 the results
 I get when I remove db1 from the system.
 The same select returns empty.

 Hope that helps. Thanks.

 Nuno A. S. Gonçalves
 [EMAIL PROTECTED]


 - Original Message -
 From: Duncan Hill [EMAIL PROTECTED]
 To: Nuno Gonçalves [EMAIL PROTECTED]
 Cc: Mailing list MySql [EMAIL PROTECTED]
 Sent: Tuesday, January 15, 2002 12:13 PM
 Subject: Re: MySQL can't tell the difference between two databases???


  On Tue, 15 Jan 2002, Nuno Gonçalves wrote:
 
   The only way I seem to be able to access the data on database B is to
   remove the other database from MySQL. From my tests it seems
 that MySQL
   only uses the table name to access the data (not using also
 the database
   name).
 
  The sql queries you are using on your database would help.  We are not
  mind-readers (well, I'm not!).
 
 



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

 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: Altering InnoDB tables


John,

did you configure innodb_buffer_pool_size and InnoDB log files big? Look at
the online manual on the recommended sizes.

If the table is very big, then UNIQUE secondary keys will cause a lot of
disk i/o, because a disk read is required to check the constraint for each
row, and the insert buffer cannot be used.

Hmm... a fix would be to disable UNIQUE checking during the conversion. I
could add an option where you can switch the UNIQUE checking off in my.cnf.
That option would be used during big conversion procedures, if you already
know that the data satisifies the constraint.

Ok, I will introduce the my.cnf option

innodb_no_unique_checks

in 3.23.4x. Thank you for bringing this up :).

About Robert Ricci's question: SHOW TABLE STATUS FROM ... reports FOREIGN
KEY constraints in the table comment section.

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



John Kemp wrote in message ...
I am also in the process of altering tables from MyISAM to INNODB. I
have one big problem - a very large table ( 5 million rows) with 5
indices/indexes on it, including a couple that are UNIQUE but with NULL
values allowed. Creating the last of these indices is taking an absurd
amount of time on my test system, which makes it impossible for me to
recommend this change for production as our systems would be down for
many days.

Here are the steps I took (note that after each failure, I recreated the
original data structure)

1) I tried altering the table directly to be Innodb. I stopped this
after 4 days, when all it said in the process list was 'copying to tmp
table' - after 4 days!
2) Then I tried mysqldumping the table structure, and changing MyISAM -
INNODB, dropped the table, and ran the mysqldump output back into the
database. The INSERTS ran horribly slowly - something like 50,000
inserts in 4 hours. This extrapolates to a query that would run for
several weeks on 5 million rows, so I stopped it again.
3) Then I tried dropping all the indices, altering the table to INNODB
and re-creating the indicies. This worked pretty quickly until the final
index creation, which is still running after more than 4 days.

What am I doing wrong? This seems like an unacceptable length of time to
convert a valid MyISAM table to Innodb, yet I REALLY need the row-level
locking ASAP!

Any help would be appreciated.

Table structure is shown below, as is the current mysqladmin processlist.

Thanks,

John



CREATE TABLE Subscriber (
   SubscriberID int(11) NOT NULL auto_increment,
   Email varchar(255) NOT NULL default '',
   Zipcode varchar(5) default NULL,
   InitialContactDate date NOT NULL default '-00-00',
   FirstName varchar(20) default NULL,
   LastName varchar(20) default NULL,
   OrigDate date NOT NULL default '-00-00',
   AlertWhenAvailable char(1) default NULL,
   Gender char(1) default NULL,
   DOB date default NULL,
   Password varchar(25) default NULL,
   SubscriberTypeID mediumint(9) default NULL,
   Attempts tinyint(4) NOT NULL default '0',
   Username varchar(255) default NULL,
   Address varchar(255) default NULL,
   City varchar(100) default NULL,
   State char(2) default NULL,
   Married char(1) default NULL,
   Age varchar(5) default NULL,
   Income varchar(20) default NULL,
   optin int(11) default NULL,
   Country char(2) default 'US',
   SourcePartnerID int(11) default '0',
   Occupation char(2) default NULL,
   PRIMARY KEY  (SubscriberID),
   UNIQUE KEY AK1Subscriber (Email),
   UNIQUE KEY XAK2Subscriber (Username),
   KEY xie2Subscriber (optin,Gender,DOB),
   KEY xie3Subscriber (Zipcode)
) TYPE=MyISAM;

__

++---+---++-++-
--+---+
| Id | User  | Host  | db | Command | Time   | State
  | Info
  |
++---+---++-++-
--+---+
| 87 | jkemp | localhost | streetmail | Query   | 250195 | copy to tmp
table | alter table Subscriber add unique index XAK2Subscriber (Username) |
| 95 | jkemp | localhost || Query   | 0  |
  | show processlist
  |
++---+---++-++-
--+---+

__
Robert P Ricci wrote:

 I've recently converted from using MyISAM to InnoDB tables, and am
 pleased with InnoDB so far. However, the inability to use 'ALTER TABLE'
 with InnoDB tables is very problematic, as our software is still under
 heavy development and our database schema changes frequently. I'm
 working on a way to automate the drop/create/repopulate

Re: innoDB confusion


Aaron,

please look at http://www.innodb.com/features.html,
http://www.innodb.com/division.html, and http://www.innodb.com/ibman.html

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


Rutledge, Aaron wrote in message ...
Hello,  I am new to this list and MySQL.  I am very excited about this
open source community.  I can definitely see MySQL becoming to database
servers, what Apache has become to web servers.
I am currently developing a mission critical manufacturing web
application in Java and I am leaning towards using MySQL as the back-end
DB.  Since MySQL has gotten excellent reviews as far as stability,
speed, and ease of use--and my application does not require foreign key
restraints or lots of bells and whistles --I decided it was worth a
shot.  My only concern from the onset was that it wasn't transactionally
safe.  I can't have the DB lose data if the server goes down.  I have
learned that InnoDB provides this functionality on top of MySQL, but the
interrelation between the two is very unclear to me.  I haven't found a
good FAQ for explaining what InnoDB does and how it does it with MySQL.
I've only found information in the 'do this, this and this to make this
work' style.  I am never sure if I am working with InnoDB or MySQL or
both.  I don't feel like I can really commit to this DB until I get a
good grasp of the complexity of this relationship.
So far I have set up the InnoDB data files and directories and have
MySQL up and running.  I set my my.ini file with
'default-table-type=innodb' and my innodb information.  Everything seems
great--I can create tables, do all my select statements, etc..
Everything seems easy as pie, but I can't shake the concern that I am
not understanding InnoDB.  So what I am wondering--am I creating
transactionally safe tables in the innodb format every time I create a
new table?  Do I no longer have to worry about innodb?  WHat about these
ibdata1 and ibdata2 files I created?  I am assuming these hold
transactional information.  SHould I be worried about whats in there?
Will these fill up with data and outgrow their pre-defined size?  I just
feel like I am missing something.  If anyone can point me to a good
low-level FAQ or book that might explain to me about what exactly going
on with this I would be grateful.  I have been to the Innodb.com site.
Great tutorial, but It leaves me with lots of questions--especially in
regards to coordination with MySQL.
Best Regards to all, Aaron





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

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-gui won't connect


Hi!

All you have to do is follow instructions from the README document.

Enter Options dialogue, fill up all entries carefully and click on
Save.

In SQL init command  set a location of the socket file, if both
client and server are running on the same Unix machine.

In any case, just follow instructions in README and you will be up and
going in the matter of minutes.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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

I have one question...

2002-01-15 Thread


I want to store long binary data in mysql 
I set max_allowed_packet size to 50M, but I can`t stor data 
mysql error code is ' 020114 17:34:30  Aborted connection 2 to db:
'lake' user: 'lake' host: `alia' (Got an error reading communication
packets)'

and jdbc error code is ' java.sql.SQLException: Communication link
failure: java.io.IOException'

I have read  'The protocol limits for max_allowed_packet is 16M in
MySQL 3.23 and 4G in MySQL 4.0'

What is protocol limits? 

How can I stor long binary data(50M) in mysql ? (longblob type field)

Please help me


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

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

synopsis of the problem (one line)

2002-01-15 Thread root


Description:

How-To-Repeat:

Fix:


Submitter-Id:  submitter ID
Originator:root
Organization:
 
MySQL support: [none | licence | email support | extended email support ]
Synopsis:  
Severity:  
Priority:  
Category:  mysql
Class: 
Release:   mysql-3.23.41 (Source distribution)

Environment:

System: Linux vice.squad.vice 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 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/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE 
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  CXX='c++'  CXXFLAGS='-O2 -march=i386 
-mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Dez 29 19:40 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x2 root root  1282588 Set  4 20:49 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 Set  4 20:34 /usr/lib/libc.a
-rw-r--r--1 root root  178 Set  4 20:34 /usr/lib/libc.so
lrwxrwxrwx1 root root   10 Dez 29 20:18 /usr/lib/libc-client.a - 
c-client.a
Configure command: ./configure  i386-redhat-linux --prefix=/usr --exec-prefix=/usr 
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share 
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec 
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man 
--infodir=/usr/share/info --without-debug --without-readline --enable-shared 
--with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql 
--with-extra-charsets=all --disable-assember --with-berkeley-db 
--enable-large-files=yes --enable-largefile=yes --with-thread-safe-client 
--enable-assembler










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

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 can't tell the difference between two databases???

- Original Message -
From: Javier Armendáriz [EMAIL PROTECTED]
To: Mailing list MySql [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 12:49 PM
Subject: RE: MySQL can't tell the difference between two databases???

 What happens if you try select * from db1.products and select * from
 db2.products;???

 Doing that does the same?

   Yes, it's exactly the same results.

  -Mensaje original-
  De: Nuno Gonçalves [mailto:[EMAIL PROTECTED]]
  Enviado el: martes, 15 de enero de 2002 13:24
  Para: Mailing list MySql
  Asunto: Re: MySQL can't tell the difference between two databases???

  It's something like this:

  mysql use db1
  mysql select * from products;
  ++-+-+--+--+
  | Id | Ref | Version | Type | Name |
  ++-+-+--+--+
  |  1 | XXX |   1 |1 | XXX  |
  ++-+-+--+--+
  1 row in set (0.27 sec)

  mysql use db2
  mysql select * from products;
  ++-+-+--+--+
  | Id | Ref | Version | Type | Name |
  ++-+-+--+--+
  |  1 | XXX |   1 |1 | XXX  |
  ++-+-+--+--+
  1 row in set (0.16 sec)

  I'm sure the table products on database db2 is empty, because of
  the results
  I get when I remove db1 from the system.
  The same select returns empty.

  Hope that helps. Thanks.

  Nuno A. S. Gonçalves
  [EMAIL PROTECTED]

  - Original Message -
  From: Duncan Hill [EMAIL PROTECTED]
  To: Nuno Gonçalves [EMAIL PROTECTED]
  Cc: Mailing list MySql [EMAIL PROTECTED]
  Sent: Tuesday, January 15, 2002 12:13 PM
  Subject: Re: MySQL can't tell the difference between two databases???

   On Tue, 15 Jan 2002, Nuno Gonçalves wrote:

The only way I seem to be able to access the data on database B is
to
remove the other database from MySQL. From my tests it seems
  that MySQL
only uses the table name to access the data (not using also
  the database
name).

   The sql queries you are using on your database would help.  We are not
   mind-readers (well, I'm not!).

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

  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: pb with integrity constraint

2002-01-15 Thread Steve Edberg


See doc sections:

http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html
and
http://www.mysql.com/doc/C/R/CREATE_TABLE.html

 From the CREATE TABLE docs:

The FOREIGN KEY, CHECK, and REFERENCES clauses don't 
actually do anything. The syntax for them is provided only for 
compatibility, to make it easier to port code from other SQL servers 
and to run applications that create tables with references. See 
section 1.7.4 MySQL Differences Compared to ANSI SQL92.

And, judging by the .fr domain, you might be interested in French 
translations of the docs:

http://dev.nexen.net/docs/mysql/chargement.html


-steve


At 11:46 AM +0100 1/15/02, TOMASSONI Dominique wrote:
Hi the list,

I try to create tables with integrity constraint but it seems no running.

I've got the next script :

create table USERS
(
 USER_CODE   INT(8) not null,
 USER_NAME   VARCHAR(30)not null,  
 primary key (USER_CODE)
)
;
create table ENV
(
 USER_CODE   INT(8) not null,
 CODE_ENVVARCHAR(6) not null,
 primary key (USER_CODE, CODE_ENV),
 constraint FK_USER foreign key (USER_CODE) references USERS(USER_CODE)
)
;

The tables creation are ok, but when I insert values in the table ENV
without any data in USERS it works but normally it wouldn't.

Something bad in may script ?



-- 
++
| Steve Edberg  [EMAIL PROTECTED] |
| University of California, Davis  (530)754-9127 |
| Programming/Database/SysAdmin   http://pgfsun.ucdavis.edu/ |
++
| Restriction of free thought and free speech is the most dangerous of  |
| all subversions. It is the one un-American act that could most easily  |
| defeat us.|
| - Supreme Court Justice (1939-1975) William O. Douglas |
++

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

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: Official State of Mysql-Max


Ross Davis writes:
 On the front screen of the mysql site the mysql-Max 3.23.47 is listed as 
 stable. 
 
 However on the download page it is said to be considered a beta yet? 
 
 The reason that I am asking this question, is that the Borland Delphi 
 Developers will not release a new version that supports the record locking 
 until this program is OFFICIALLY listed as stable. 
 
 If it is not yet listed as stable, then is there an ETA? 
 
 Thanks in advance.
 

We shall soon change our WWW page.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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: java.sql.SQLException: Lost connection to server during query the error is here

2002-01-15 Thread TAKAHASHI, Tomohiro

  Hi,

  What Application Server do you use?

  I think JDBC connection has been disconnected from MySQL
because that connection has not used for a long time.
  This error depends on Application Server. 

shashidhara n wrote:
 
 hello
 
 we are running web application using apache as web server and mysql as
 databse. after running server for 6- 8 hr it will give the following
 error
 
 java.sql.SQLException: Lost connection to server during query the error is
 here
 
 if we  restart apache server it will works
 
 i want to know why this problem occuring, any problem in mysql server
 or apache server
 please mail  to

-- 
TAKAHASHI, Tomohiro

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

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: Unable to save result set - but why?

2002-01-15 Thread Gerald Clark


It sounds like two problems to me.

1. Check/repair your tables;

2. Check your return codes in your PHP script, and take appropiate action.

Randall Stone Tayler wrote:

From a SSH I run a query and get the following:

ERROR 1030: Got error 134 from table handler

From a browser, when I run the same query I get:

Warning: MySQL: Unable to save result set in [my php file here] on line 7

Warning: Supplied argument is not a valid MySQL result resource in [my php
file here] on line 8

If I add LIMIT 12 to the query, it can handle it, but anything above 12 and
it chokes.

Other queries run fine; the result set on this query has no more than 246
results, which seems pretty low to choke the system.

The server's running mysql Ver 11.15 Distrib 3.23.43, for pc-linux-gnu
(i686)

Randy Tayler
www.RandymThoughts.com
www.Singlesaints.com
If I had something funny to say, I'd put it here.


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

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





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

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

Re: Insert failed

2002-01-15 Thread Gerald Clark


Looks like someone entered a  negative number for EventId, or it just 
reached its maximum value.
Check its maximum and minimum values.

Change it to an unsigned int.

Xavier NOPRE wrote:

Hi,

I try to insert a new record in a table. The key is an automatic ID.
The insert is refused due to duplicate key, but the key does not
exist. Why ? Is it a bug ?


Any idea ? Some help ?
Thanks

Xavier


Details:

The colums of the table:
++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra
| ++--+--+-+-++
| EventType  | varchar(64)  | YES  | | NULL|  
|
| EventOrigin| varchar(64)  | YES  | | NULL|  
|
| EventText  | varchar(250) | YES  | | NULL|  
|
| EventTimeStamp | datetime | YES  | | NULL|  
|
| EventId| int(11)  |  | PRI | NULL|
auto_increment |
++--+--+-+-++

Operations tried:

mysql select count(*) from events;
+--+
| count(*) |
 +--+
|20506 |
+--+
1 row in set (0.19 sec)
mysql insert into events set EventType='TEST',EventOrigin='me';
ERROR 1062: Duplicate entry '20507' for key 1
mysql select * from events where EventId=20507;
Empty 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





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

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 can't tell the difference between two databases???

2002-01-15 Thread Gerald Clark


Is db2 a symlink to db1?

Nuno Gonçalves wrote:

Hi!

I've got two mysql databases that have exactly the same structure (same
tables using BDB, columns, etc.) and different data.

When I try to do a select on a table from database A, I get the right
results, but when I try the same select on the same table from database B, I
get the results from the database A.

The only way I seem to be able to access the data on database B is to remove
the other database from MySQL.
From my tests it seems that MySQL only uses the table name to access the
data (not using also the database name).

Anyone has an idea, of why this happens.

Nuno A. S. Gonçalves
[EMAIL PROTECTED]





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

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





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

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

Re: MySQL can't tell the difference between two databases???

- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Nuno Gonçalves [EMAIL PROTECTED]
Cc: Mailing list MySql [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 2:35 PM
Subject: Re: MySQL can't tell the difference between two databases???

 Is db2 a symlink to db1?

db2 is a symlink, but not to db1. I'm sure of that.

I've done some more tests. It appears that if you change something on one of
the tables (adding a new column on the table products of db1), mysql decides
that both tables on the two databases are different, and it starts to give
the correct results.

I've also tested with INSERT and the same thing happens:
use db1
INSERT INTO products  ...;
use db2
INSERT INTO products  ...;
The first insert ends up in both databases, and the second only appears in
the first database.

Well, if this isn't a bug I don't know what it is.

 Nuno Gonçalves wrote:

 Hi!

 I've got two mysql databases that have exactly the same structure (same
 tables using BDB, columns, etc.) and different data.

 When I try to do a select on a table from database A, I get the right
 results, but when I try the same select on the same table from database
B, I
 get the results from the database A.

 The only way I seem to be able to access the data on database B is to
remove
 the other database from MySQL.
 From my tests it seems that MySQL only uses the table name to access the
 data (not using also the database name).

 Anyone has an idea, of why this happens.

 Nuno A. S. Gonçalves
 [EMAIL PROTECTED]

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

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

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

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

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

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 can't tell the difference between two databases???

Nuno Gonçalves writes:

 - Original Message -
 From: Gerald Clark [EMAIL PROTECTED]
 To: Nuno Gonçalves [EMAIL PROTECTED]
 Cc: Mailing list MySql [EMAIL PROTECTED]
 Sent: Tuesday, January 15, 2002 2:35 PM
 Subject: Re: MySQL can't tell the difference between two databases???

  Is db2 a symlink to db1?

 db2 is a symlink, but not to db1. I'm sure of that.

 I've done some more tests. It appears that if you change something on one of
 the tables (adding a new column on the table products of db1), mysql decides
 that both tables on the two databases are different, and it starts to give
 the correct results.

 I've also tested with INSERT and the same thing happens:
 use db1
 INSERT INTO products  ...;
 use db2
 INSERT INTO products  ...;
 The first insert ends up in both databases, and the second only appears in
 the first database.

 Well, if this isn't a bug I don't know what it is.

Hi!

I must admit that this sounds very strange.

Can you please make a test case, so that we can investigate a matter. 

Please follow instructions from the following chapter in our manual : 

How to Report Bugs or Problems
..

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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 can't tell the difference between two databases???

2002-01-15 Thread Javier Armendáriz


I really don´t undarstand

My Linux is working fine in a situation like yours. I´ve simulated your
situation


mysql use db2;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql select * from tab1;
+++
| id | name   |
+++
|  1 | javier |
+++
1 row in set (0.00 sec)


mysql use db1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql select * from tab1;
Empty set (0.00 sec)


My database and table description:

ysql use db1;
Database changed
mysql show tables;
+---+
| Tables_in_db1 |
+---+
| tab1  |
+---+
1 row in set (0.01 sec)

mysql describe tab1;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra  |
+---+-+--+-+-++
| id| int(11) |  | PRI | NULL| auto_increment |
| name  | varchar(10) | YES  | | NULL||
+---+-+--+-+-++
2 rows in set (0.00 sec)

mysql select * from tab1;
Empty set (0.01 sec)






mysql use db2
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql show tables;
+---+
| Tables_in_db2 |
+---+
| tab1  |
+---+
1 row in set (0.00 sec)

mysql describe tab1;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra  |
+---+-+--+-+-++
| id| int(11) |  | PRI | NULL| auto_increment |
| name  | varchar(10) | YES  | | NULL||
+---+-+--+-+-++
2 rows in set (0.00 sec)

mysql select * from tab1;
+++
| id | name   |
+++
|  1 | javier |
+++
1 row in set (0.01 sec)

And finally my server and sistem data:

mysql status;
--
mysql  Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)

Connection id:  6
Current database:   db1
Current user:   [EMAIL PROTECTED]
Current pager:  stdout
Using outfile:  ''
Server version: 3.23.44
Protocol version:   10
Connection: linux2 via TCP/IP
Client characterset:latin1
Server characterset:latin1
TCP port:   3306
Uptime: 7 hours 27 min 52 sec


Red Hat Linux release 7.0 (Guinness)
Kernel 2.2.16-22 on an i586


 -Mensaje original-
 De: Gerald Clark [mailto:[EMAIL PROTECTED]]
 Enviado el: martes, 15 de enero de 2002 15:35
 Para: Nuno Gonçalves
 CC: Mailing list MySql
 Asunto: Re: MySQL can't tell the difference between two databases???


 Is db2 a symlink to db1?


If it was deleting one database or table must delete de another one.



Javier Armendáriz
[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

copying databases

2002-01-15 Thread Bryan McCloskey


I am attempting to make a copy of my database, so that I will have one copy 
that my scripts in development can tinker with, while the functional version 
remains safe and unchanged. However, I am having difficulty figuring out how 
to do this. All that is important is that I create a copy of the database 
table descriptions; the data itself is not important for the test copy. (In 
fact, it would be better if I could _not_ copy the thousands of rows of 
data, so my test version would be smaller and faster.) Anyone know how to do 
this?

-bryan

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


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

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

Re: MySQL can't tell the difference between two databases???

2002-01-15 Thread System Administrator a.k.a. The Root of the Problem



Maybe it has something to do with the MySql version and OS i'm using:

I'm running 3.23.42-max-nt on a Win2000 system, using BDB tables.

Nuno A. S. Gonçalves
[EMAIL PROTECTED]


- Original Message -
From: Javier Armendáriz [EMAIL PROTECTED]
To: Mailing list MySql [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 3:28 PM
Subject: RE: MySQL can't tell the difference between two databases???


 I really don´t undarstand

 My Linux is working fine in a situation like yours. I´ve simulated your
 situation


 mysql use db2;
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A

 Database changed
 mysql select * from tab1;
 +++
 | id | name   |
 +++
 |  1 | javier |
 +++
 1 row in set (0.00 sec)


 mysql use db1;
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A

 Database changed
 mysql select * from tab1;
 Empty set (0.00 sec)


 My database and table description:

 ysql use db1;
 Database changed
 mysql show tables;
 +---+
 | Tables_in_db1 |
 +---+
 | tab1  |
 +---+
 1 row in set (0.01 sec)

 mysql describe tab1;
 +---+-+--+-+-++
 | Field | Type| Null | Key | Default | Extra  |
 +---+-+--+-+-++
 | id| int(11) |  | PRI | NULL| auto_increment |
 | name  | varchar(10) | YES  | | NULL||
 +---+-+--+-+-++
 2 rows in set (0.00 sec)

 mysql select * from tab1;
 Empty set (0.01 sec)






 mysql use db2
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A

 Database changed
 mysql show tables;
 +---+
 | Tables_in_db2 |
 +---+
 | tab1  |
 +---+
 1 row in set (0.00 sec)

 mysql describe tab1;
 +---+-+--+-+-++
 | Field | Type| Null | Key | Default | Extra  |
 +---+-+--+-+-++
 | id| int(11) |  | PRI | NULL| auto_increment |
 | name  | varchar(10) | YES  | | NULL||
 +---+-+--+-+-++
 2 rows in set (0.00 sec)

 mysql select * from tab1;
 +++
 | id | name   |
 +++
 |  1 | javier |
 +++
 1 row in set (0.01 sec)

 And finally my server and sistem data:

 mysql status;
 --
 mysql  Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)

 Connection id:  6
 Current database:   db1
 Current user:   [EMAIL PROTECTED]
 Current pager:  stdout
 Using outfile:  ''
 Server version: 3.23.44
 Protocol version:   10
 Connection: linux2 via TCP/IP
 Client characterset:latin1
 Server characterset:latin1
 TCP port:   3306
 Uptime: 7 hours 27 min 52 sec


 Red Hat Linux release 7.0 (Guinness)
 Kernel 2.2.16-22 on an i586


  -Mensaje original-
  De: Gerald Clark [mailto:[EMAIL PROTECTED]]
  Enviado el: martes, 15 de enero de 2002 15:35
  Para: Nuno Gonçalves
  CC: Mailing list MySql
  Asunto: Re: MySQL can't tell the difference between two databases???
 
 
  Is db2 a symlink to db1?
 

 If it was deleting one database or table must delete de another one.


 
 Javier Armendáriz
 [EMAIL PROTECTED]


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

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





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

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

Re: copying databases

2002-01-15 Thread Rodney Broom


Hi Bryan,

Start with this:

  % mysqldump --help


From: Bryan McCloskey [EMAIL PROTECTED]

 ...make a copy of my database

  % mysqldump --opt database_one  copy.sql


 ...data itself is not important...
 ...better if I could _not_ copy the thousands of rows...

  % mysqldump --opt -d database_one  copy.sql


To reload into database_two:

  % mysql [options] database_two  copy.sql
  # Or
  % cat copy.sql | mysql [options] database_two


If you need to create a database:

  % mysqladmin create database_two

---
Rodney Broom
Programmer: Desert.Net




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

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 - Win SQL2k DTS - MySQL

2002-01-15 Thread jfobel


Hello,

Has anyone successfully implemented using a Microsoft SQL 2000 DTS package to copy 
data from one mysql database into another mysql database? I am getting some errors 
pertaining to 'cannot insert blob fields'. -which they are not blob fields. I've tried 
this on text, char, varchar, tinytext.

I feel like the MyODBC driver is very limited in the data types that it supports.

Thanks,


Jack
[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: Altering InnoDB tables

2002-01-15 Thread John Kemp


Heikki,

I didn't config the log that big, but the buffer pool is using 1GB of 
memory, and yes, the UNIQUE index is definitely causing a lot of disk I/O!

I will be very happy to see your change, and thanks for (as usual) being 
so quick to make changes to an already very welcome addition to MySQL.

I'll add this - we're running several tables that have 5-10 million 
rows, one logging table with 56 million rows on a web-based system that 
is used by 30 people at our company, editing our newsletters (which are 
stored in the database), and almost 1 million email subscribers, who 
receive 3 database-driven emails every week, and use our similarly 
data-driven website. So MySQL is dealing with a lot of roughly 
simultaneous requests. Row-level locking has improved the performance 
massively, and made my internal and external customers happier, which 
makes my day better (fewer complaints!)

Thanks again,

John Kemp
Director, Software Development
Streetmail

Heikki Tuuri wrote:

 John,
 
 did you configure innodb_buffer_pool_size and InnoDB log files big? Look at
 the online manual on the recommended sizes.
 
 If the table is very big, then UNIQUE secondary keys will cause a lot of
 disk i/o, because a disk read is required to check the constraint for each
 row, and the insert buffer cannot be used.
 
 Hmm... a fix would be to disable UNIQUE checking during the conversion. I
 could add an option where you can switch the UNIQUE checking off in my.cnf.
 That option would be used during big conversion procedures, if you already
 know that the data satisifies the constraint.
 
 Ok, I will introduce the my.cnf option
 
 innodb_no_unique_checks
 
 in 3.23.4x. Thank you for bringing this up :).
 
 About Robert Ricci's question: SHOW TABLE STATUS FROM ... reports FOREIGN
 KEY constraints in the table comment section.
 
 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
 
 
 
 John Kemp wrote in message ...
 
I am also in the process of altering tables from MyISAM to INNODB. I
have one big problem - a very large table ( 5 million rows) with 5
indices/indexes on it, including a couple that are UNIQUE but with NULL
values allowed. Creating the last of these indices is taking an absurd
amount of time on my test system, which makes it impossible for me to
recommend this change for production as our systems would be down for
many days.

Here are the steps I took (note that after each failure, I recreated the
original data structure)

1) I tried altering the table directly to be Innodb. I stopped this
after 4 days, when all it said in the process list was 'copying to tmp
table' - after 4 days!
2) Then I tried mysqldumping the table structure, and changing MyISAM -
INNODB, dropped the table, and ran the mysqldump output back into the
database. The INSERTS ran horribly slowly - something like 50,000
inserts in 4 hours. This extrapolates to a query that would run for
several weeks on 5 million rows, so I stopped it again.
3) Then I tried dropping all the indices, altering the table to INNODB
and re-creating the indicies. This worked pretty quickly until the final
index creation, which is still running after more than 4 days.

What am I doing wrong? This seems like an unacceptable length of time to
convert a valid MyISAM table to Innodb, yet I REALLY need the row-level
locking ASAP!

Any help would be appreciated.

Table structure is shown below, as is the current mysqladmin processlist.

Thanks,

John



CREATE TABLE Subscriber (
  SubscriberID int(11) NOT NULL auto_increment,
  Email varchar(255) NOT NULL default '',
  Zipcode varchar(5) default NULL,
  InitialContactDate date NOT NULL default '-00-00',
  FirstName varchar(20) default NULL,
  LastName varchar(20) default NULL,
  OrigDate date NOT NULL default '-00-00',
  AlertWhenAvailable char(1) default NULL,
  Gender char(1) default NULL,
  DOB date default NULL,
  Password varchar(25) default NULL,
  SubscriberTypeID mediumint(9) default NULL,
  Attempts tinyint(4) NOT NULL default '0',
  Username varchar(255) default NULL,
  Address varchar(255) default NULL,
  City varchar(100) default NULL,
  State char(2) default NULL,
  Married char(1) default NULL,
  Age varchar(5) default NULL,
  Income varchar(20) default NULL,
  optin int(11) default NULL,
  Country char(2) default 'US',
  SourcePartnerID int(11) default '0',
  Occupation char(2) default NULL,
  PRIMARY KEY  (SubscriberID),
  UNIQUE KEY AK1Subscriber (Email),
  UNIQUE KEY XAK2Subscriber (Username),
  KEY xie2Subscriber (optin,Gender,DOB),
  KEY xie3Subscriber (Zipcode)
) TYPE=MyISAM;

__

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

 --+---+
 
| Id | User  | Host

[spamreply@orbz.org: Re: [Momo.Yu: Multi-function Digital Camera - PDC-31]]


Getting more problems again?

- Forwarded message from ORBZ Spam Report Reply [EMAIL PROTECTED] -

Return-Path: [EMAIL PROTECTED]
Received: from orbz.org ([EMAIL PROTECTED] [205.231.149.25])
by doctor.nl2k.ab.ca (8.12.2/8.12.2) with SMTP id g0FGCG2O011901
for [EMAIL PROTECTED]; Tue, 15 Jan 2002 09:12:16 -0700 (MST)
Received: (qmail 22686 invoked by uid 1017); 15 Jan 2002 16:12:46 -
Date: 15 Jan 2002 16:12:46 -
Message-ID: [EMAIL PROTECTED]
From: ORBZ Spam Report Reply [EMAIL PROTECTED]
Subject: Re: [Momo.Yu: Multi-function Digital Camera - PDC-31]
To: [EMAIL PROTECTED]
X-processor: spam

Results for 204.209.81.1:
br
bWarning/b:  Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line 
b35/bbr
br
bWarning/b:  Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line 
b36/bbr
br
bWarning/b:  MySQL Connection Failed: Can't connect to local MySQL server 
through socket '/tmp/mysql.sock' (2)
 in b/home/ian/orbz-apache/htdocs/functions.php/b on line b36/bbr
br
bWarning/b:  MySQL:  A link to the server could not be established in 
b/home/ian/orbz-apache/htdocs/functions.php/b on line b36/bbr
br
bWarning/b:  Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line 
b40/bbr
br
bWarning/b:  MySQL Connection Failed: Can't connect to local MySQL server 
through socket '/tmp/mysql.sock' (2)
 in b/home/ian/orbz-apache/htdocs/functions.php/b on line b40/bbr
br
bWarning/b:  MySQL:  A link to the server could not be established in 
b/home/ian/orbz-apache/htdocs/functions.php/b on line b40/bbr
br
bWarning/b:  Supplied argument is not a valid MySQL result resource in 
b/home/ian/orbz-apache/htdocs/functions.php/b on line b41/bbr
br
bWarning/b:  Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line 
b58/bbr
br
bWarning/b:  MySQL Connection Failed: Can't connect to local MySQL server 
through socket '/tmp/mysql.sock' (2)
 in b/home/ian/orbz-apache/htdocs/functions.php/b on line b58/bbr
br
bWarning/b:  MySQL:  A link to the server could not be established in 
b/home/ian/orbz-apache/htdocs/functions.php/b on line b58/bbr
This IP has been added to the queue for checking.
Results for 127.0.0.1:
This is a private IP and will not be added.

- End forwarded message -

-- 
contact:
Dave Yadallee  NetKnow  The Internet Knowledge Company
[EMAIL PROTECTED]  http://www.nl2k.ab.ca
990-3244

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

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 replication and failover

2002-01-15 Thread Steve Rapaport

Ronnie, I'm copying this to the list so it ends up in the archive for
anyone to use in future.

In answer to your question about the floating IP for the master, I'm
using heartbeat, more at http://www.samag.com/documents/s=1146/sam0109c/0109c.htm

My semi-scripts and explanations are at the bottom of this mail
as I sent them to the
last person who asked.

Best to all,
Steve Rapaport.

Ronnie Garcia wrote:

Hi Steve,
I just found your post about failover and mysql on google (
http://groups.google.com/groups?hl=frthreadm=a11dqg%242slq%241%40FreeBSD.csie.NCTU.edu.twrnum=7prev=/groups%3Fq%3Dfailover%2Bmysql%26hl%3Dfr%26scoring%3Dd%26selm%3Da11dqg%25242slq%25241%2540FreeBSD.csie.NCTU.edu.tw%26rnum%3D7)

I would be pleased to get your half-scripted solution, since i want my
slave to get the INSERT and UPDATES while my master is down.

Can you also explain me how do you handle the floating IP address for the
master ? I'm thinking about nsupdate .. ?

Thank you much,
Ronnie.

-- part of your post --

1) Use circular replication, where all machines are simulataneously master and
slave. Problem: recovery from a screwup is really hard.
2) Change roles upon failure: Use CHANGE MASTER TO on all the slaves.
Problems: tricky to set up and test. Hints in the FAQ help but are not
really tested. Configuration files may need to be changed at failure time.
3) Never change roles, slave becomes temporary master on failure, manual reset.
This is easiest to setup and test, but inelegant to reset.

For 2) and 3) you also need to have a floating IP address for your master
that can be changed upon failure to point to the current master, using
BIND or using a gratuitous ARP scheme.

Anyway, I'm currently using scheme 3, and I'll be happy to send you my

half-scripted solution which you are welcome to improve upon. I was also
using scheme 1 before, but gave up after something mis-synchronized the
replication logs and it was impossible to recover.

ere are the scripts I'm (sort of) using, and how to run them, on a 2-machine
system. Note that the order of operations could be improved to reduce
downtime, but I don't see how it could be reduced to zero yet. When I
tried it this way I had only about 30 seconds down, but that's partly because
I only copied the databases that update!

This is for use only when the master has failed, and the slave has been
making updates for some time.

[steve@db1 mysql]$ cat reset-slave.sh
#!/bin/sh
# the SLAVE half of what to do when recovering from a failover
# this runs on db1, the SLAVE.
#
# Steve Dec 27, 2001

# Note the master half is reset-slave.sh, on db2.

# stop slave replication
mysqladmin slave-stop

# stop updates and freeze data files : note this is incorrect syntax!
mysqladmin flush-tables --with-read-lock
# this won't work, you need to run something like:
# mysql -uuser -ppassword -e FLUSH TABLES WITH READ LOCK

#copy the new dynamic databases to db2 NOTE Omit any large read-only db's!
cd /var/lib/mysql
tar cvzf STEVE/reset.tgz atono mysql push
scp STEVE/reset.tgz steve@db2:/var/lib/mysql/STEVE
password

# (perhaps redundant) tell slave that bin files are meaningless
mysqladmin reset-slave

# stop the slave
mysqladmin shutdown

# remove all the bin files to reset the slave
rm db1-bin*

# reboot this system so heartbeat forces dbhost to switch over to db2.
sync
sync
/sbin/telinit 6

And now, on the other machine (db2) reset it to be the master:

[steve@db2 mysql]$ cat reset-master.sh
#!/bin/sh
# the MASTER half of what to do when recovering from a failover
#
# Steve Dec 27, 2001

# Note the slave half is reset-slave.sh, on db1.
# THE SLAVE HALF IS TO BE RUN FIRST, with master shut down.

# Shutdown the master
mysqladmin shutdown

#copy the new dynamic databases from db1
cd /var/lib/mysql
tar xvzf STEVE/reset.tgz

# remove all the bin files to reset the master
rm db2-bin*

# start the master
mysqladmin start

# (perhaps redundant) tell master that bin files are gone
mysqladmin reset-master

Reminder:
For 2) and 3) you also need to have a floating IP address for your
master that can be changed upon failure to point to the current
master, using BIND or using a gratuitous ARP scheme.

(Mine is gratuitous ARP with heartbeat detection.)

If you get scheme 2) to work, let me know, I might want to change.

Scheme 2 would probably be best for our environment, as I don't plan
on being here forever to baby it, so the more the system can do on
its own the better:) I'd definitely like to take a look at your
script to see if it gives me any ideas on how to get from 3 to 2

Agreed here.

(they seem like pretty much the same idea, just one is more complete
than the other)

I wish I could agree with you. Scheme 2 is pretty different, since
there's no data copying going on, but the configuration files must
be changed (I think) as well as telling all the systems, in the
correct order, to change masters. Also, the dying master must
remember to record its SHOW MASTER

Re: innoDB confusion

Aaron,

-Original Message-
From: Rutledge, Aaron [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Tuesday, January 15, 2002 7:13 PM
Subject: RE: innoDB confusion

Thank You Heikki,
   That information helps a lot.  A couple quick questions if you dont
mind:

In regards to the statement:

InnoDB stores the tables defined as type InnoDB to its own tablespace
and builds indexes to the tables in its own tablespace.

I am assuming the tablespaces are the ibdata files.  Does it store the

Yes the tablespace is the data files concatenated.

actual records here, or only the indexes and table definitions?  When
using innoDB tables, is anything stored in the MySQL/data directory, or
is everything in the innoDB tablespace?  The innoDB tablespace seems a

Everything is stored to the tablespace, except the tablename.frm files which
the MySQL interpreter uses to store its own table schemas.

little voodoo to me.  I am expecially concerned because they are a fixed
size and I dont understand how MySQL communicates with them.

You must make the data files big enough that your application fits there.
Note that you are then safe from the problem that someone inadvertently
fills the hard disk. That is the benefit of preallocation.

Highest regards,
Aaron

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: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Re: innoDB confusion

Aaron,

please look at http://www.innodb.com/features.html,
http://www.innodb.com/division.html, and
http://www.innodb.com/ibman.html

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

Rutledge, Aaron wrote in message ...
Hello,  I am new to this list and MySQL.  I am very excited about this
open source community.  I can definitely see MySQL becoming to database
servers, what Apache has become to web servers.
I am currently developing a mission critical manufacturing web
application in Java and I am leaning towards using MySQL as the
back-end
DB.  Since MySQL has gotten excellent reviews as far as stability,
speed, and ease of use--and my application does not require foreign key
restraints or lots of bells and whistles --I decided it was worth a
shot.  My only concern from the onset was that it wasn't
transactionally
safe.  I can't have the DB lose data if the server goes down.  I have
learned that InnoDB provides this functionality on top of MySQL, but
the
interrelation between the two is very unclear to me.  I haven't found a
good FAQ for explaining what InnoDB does and how it does it with MySQL.
I've only found information in the 'do this, this and this to make this
work' style.  I am never sure if I am working with InnoDB or MySQL or
both.  I don't feel like I can really commit to this DB until I get a
good grasp of the complexity of this relationship.
So far I have set up the InnoDB data files and directories and have
MySQL up and running.  I set my my.ini file with
'default-table-type=innodb' and my innodb information.  Everything
seems
great--I can create tables, do all my select statements, etc..
Everything seems easy as pie, but I can't shake the concern that I am
not understanding InnoDB.  So what I am wondering--am I creating
transactionally safe tables in the innodb format every time I create a
new table?  Do I no longer have to worry about innodb?  WHat about
these
ibdata1 and ibdata2 files I created?  I am assuming these hold
transactional information.  SHould I be worried about whats in there?
Will these fill up with data and outgrow their pre-defined size?  I
just
feel like I am missing something.  If anyone can point me to a good
low-level FAQ or book that might explain to me about what exactly going
on with this I would be grateful.  I have been to the Innodb.com site.
Great tutorial, but It leaves me with lots of questions--especially in
regards to coordination with MySQL.
Best Regards to all, Aaron

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

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

Tergat MySQL Studio

2002-01-15 Thread Chris Lott


Has anyone had a chance to try out the new MySQL Studio product
(http://www.mysqlstudio.com/feature.php3)? There doesn't appear to be any
kind of demo, ad while it is only $70, I figured I'd check with all of you
before trying it.

What I would really like is something akin to ER Studio and other
Embarcadero products I use for SQL Server that would work with (or also
with) MySQL! Sure makes dealing with massively complex relationships and
structures more convenient, either with InnoDB or with forthcoming MySQL 4.1
...

c
--
Chris Lott -- http://www.chrislott.org/

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

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

Foreign keys

2002-01-15 Thread Pierre Radulescu


Hi,

I am trying two create two innodb tables:

1.
CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL, PRIMARY
KEY(COD)) TYPE=INNODB;

2.
CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY
KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES FIRST(COD))
TYPE=INNODB;

The second table cannot be created (errno: 150)

Thanks in advance for help!

Pierre





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

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

2002-01-15 Thread Frankie Cooke


Hello All

I can currently connect to a Mysql database on my local machine, a windows
o/s.  However, when I try and do this on unix - get the error:

Vbscript Runtime error 'ASP 0185 : -2147467259'
Data source name not found or no default driver specified

include/dbconnectcrop.asp,line 11


Line 11 is the where I am opening the connection.  I feel that I have not
matched the driver name.  Is the driver MyODBC called something different
on Unix, other than MySQL.  Below is my conenction string.

%

' Connect to MySQL database for passwords  section documents

Dim dbconnect, anyRs, insComm

set dbconnect=Server.CreateObject(ADODB.Connection)

dbconnect.ConnectionString=Driver=MySQL;server=localhost;Database=cropwise;


dbconnect.Open

%

Thanks for any help

Frankie




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

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 confusion


One final question, and I am done.  You have helped me
tremendously--thank you.  Wow, I really didn't expect the developer of
the software to answer my questions--this is terrific.  

Is there way to verify that the tables I create are in the InnoDB
tablespace?  I am assuming that if I set 'default-table-type=innodb' in
my.ini that all tables created by the MySQL client will be created in
the innodb tablespace.  However, they also show up in the MySQL data
directory as .frm files.  How do I also know that it was created in the
InnoDB tablespace?  Aaron



-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:43 AM
To: Rutledge, Aaron
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion


Aaron,

-Original Message-
From: Rutledge, Aaron [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Tuesday, January 15, 2002 7:13 PM
Subject: RE: innoDB confusion


Thank You Heikki,
   That information helps a lot.  A couple quick questions if you dont
mind:

In regards to the statement:

InnoDB stores the tables defined as type InnoDB to its own tablespace
and builds indexes to the tables in its own tablespace.

I am assuming the tablespaces are the ibdata files.  Does it store the


Yes the tablespace is the data files concatenated.

actual records here, or only the indexes and table definitions?  When
using innoDB tables, is anything stored in the MySQL/data directory, or
is everything in the innoDB tablespace?  The innoDB tablespace seems a


Everything is stored to the tablespace, except the tablename.frm files
which
the MySQL interpreter uses to store its own table schemas.

little voodoo to me.  I am expecially concerned because they are a
fixed
size and I dont understand how MySQL communicates with them.


You must make the data files big enough that your application fits
there.
Note that you are then safe from the problem that someone inadvertently
fills the hard disk. That is the benefit of preallocation.

Highest regards,
Aaron


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: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Re: innoDB confusion


Aaron,

please look at http://www.innodb.com/features.html,
http://www.innodb.com/division.html, and
http://www.innodb.com/ibman.html

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


Rutledge, Aaron wrote in message ...
Hello,  I am new to this list and MySQL.  I am very excited about this
open source community.  I can definitely see MySQL becoming to
database
servers, what Apache has become to web servers.
I am currently developing a mission critical manufacturing web
application in Java and I am leaning towards using MySQL as the
back-end
DB.  Since MySQL has gotten excellent reviews as far as stability,
speed, and ease of use--and my application does not require foreign
key
restraints or lots of bells and whistles --I decided it was worth a
shot.  My only concern from the onset was that it wasn't
transactionally
safe.  I can't have the DB lose data if the server goes down.  I have
learned that InnoDB provides this functionality on top of MySQL, but
the
interrelation between the two is very unclear to me.  I haven't found
a
good FAQ for explaining what InnoDB does and how it does it with
MySQL.
I've only found information in the 'do this, this and this to make
this
work' style.  I am never sure if I am working with InnoDB or MySQL or
both.  I don't feel like I can really commit to this DB until I get a
good grasp of the complexity of this relationship.
So far I have set up the InnoDB data files and directories and have
MySQL up and running.  I set my my.ini file with
'default-table-type=innodb' and my innodb information.  Everything
seems
great--I can create tables, do all my select statements, etc..
Everything seems easy as pie, but I can't shake the concern that I am
not understanding InnoDB.  So what I am wondering--am I creating
transactionally safe tables in the innodb format every time I create a
new table?  Do I no longer have to worry about innodb?  WHat about
these
ibdata1 and ibdata2 files I created?  I am assuming these hold
transactional information.  SHould I be worried about whats in there?
Will these fill up with data and outgrow their pre-defined size?  I
just
feel like I am missing something.  If anyone can point me to a good
low-level FAQ or book that might explain to me about what exactly
going
on with this I would be grateful.  I have been to the Innodb.com site.
Great tutorial, but It leaves me with lots of questions--especially in
regards to coordination with MySQL.
Best Regards to all, Aaron

RE: DAYOFYEAR()

2002-01-15 Thread Curtis Gordon

It's not my perl code, that error comes from webmin when I try to run that 
query. It's okay though, I have solved the problem, I'm just saving the date 
and the time separately now and it all works great. Thank you for the help

(C:

From: Daniel Rosher [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Curtis Gordon [EMAIL PROTECTED]
Subject: RE: DAYOFYEAR()
Date: Mon, 14 Jan 2002 16:36:07 +1300

Curtis,

This is not a mysql issue ('Error - Perl execution failed')

works fine for me:

my $hashref = $dbh-selectall_hashref(END_SQL);
 select DAYOFYEAR('2002-01-14 11:08:40')
END_SQL

printing with Data::Dumper produces

$VAR1 = [
   {
 'DAYOFYEAR(\'2002-01-14 11:08:40\')' = '14'
   }
 ];

as expected.

Something is wrong with your perl code.

Regards,
Dan
  -Original Message-
  From: Curtis Gordon [mailto:[EMAIL PROTECTED]]
  Sent: Monday, 14 January 2002 4:24 p.m.
  To: [EMAIL PROTECTED]
  Subject: DAYOFYEAR()

  Hi! I'm storing a date in this format :

  2002-01-13 11:08:40
  -mm-dd hh:mm:ss

  This is great because it gives me the date and the time, which I need.
  I want to compare this date from the database to the current DAYOFYEAR()

  but when I do this
  select DAYOFYEAR('2002-01-13 11:08:40')

  I get this
  Error - Perl execution failed

  Modification of non-creatable array value attempted, subscript -1 at
  ./mysql-lib.pl line 187, line 2.

  It works great when I do select DAYOFYEAR(NOW()) though, I'm totally
  confused, is this a known bug or is there a work around that
  anybody knows
  of that you can let me in on?

  Ulitmately I want to compare todays DAYOFYEAR to the DAYOFYEAR
  from fields
  in the database to establish entries that were created today.

  I'm looking at what I have written here and I think I have
  confused myself,
  if this is not clear, please feel free to flame me.

  I'm looking forward to any light that can be shed on this problem.

  _
  Join the worlds largest e-mail service with MSN Hotmail.
  http://www.hotmail.com

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

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

_
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

access denied set mysql root user

2002-01-15 Thread Kory Wheatley


I installed the binary of mysql 3.23.39 with the following steps and it
started fine

 ln -s mysql-VERSION-OS mysql
 cd mysql
 scripts/mysql_install_db
 chown -R root  /usr/local/mysql
 chown -R mysql /usr/local/mysql/data
 chgrp -R mysql /usr/local/mysql
 chown -R root /usr/local/mysql/bin
 bin/safe_mysqld --user=mysql 

Then I tried to set a password for the MYSQL root user and I get the
following error.

./bin/mysqladmin -u root -p password 'christ1'
Enter password: ***

./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)

ALSO TRIED
# ./bin/mysqladmin -u root -h dallas.isu.edu -p password 'christ1'
Enter password: ***
./bin/mysqladmin: connect to server at 'dallas.isu.edu' failed
error: 'Host 'dallas.isu.edu' is not allowed to connect to this MySQL
server

ANY SOLUTIONS?

Kory Wheatley


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

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 confusion

2002-01-15 Thread Weaver, Walt


Do a show table status at the mysql prompt. Under type you should see
InnoDB.

--Walt Weaver
  Bozeman, Montana

-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:57 AM
To: Mysql List (E-mail)
Subject: RE: innoDB confusion


One final question, and I am done.  You have helped me
tremendously--thank you.  Wow, I really didn't expect the developer of
the software to answer my questions--this is terrific.  

Is there way to verify that the tables I create are in the InnoDB
tablespace?  I am assuming that if I set 'default-table-type=innodb' in
my.ini that all tables created by the MySQL client will be created in
the innodb tablespace.  However, they also show up in the MySQL data
directory as .frm files.  How do I also know that it was created in the
InnoDB tablespace?  Aaron



-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:43 AM
To: Rutledge, Aaron
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion


Aaron,

-Original Message-
From: Rutledge, Aaron [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Tuesday, January 15, 2002 7:13 PM
Subject: RE: innoDB confusion


Thank You Heikki,
   That information helps a lot.  A couple quick questions if you dont
mind:

In regards to the statement:

InnoDB stores the tables defined as type InnoDB to its own tablespace
and builds indexes to the tables in its own tablespace.

I am assuming the tablespaces are the ibdata files.  Does it store the


Yes the tablespace is the data files concatenated.

actual records here, or only the indexes and table definitions?  When
using innoDB tables, is anything stored in the MySQL/data directory, or
is everything in the innoDB tablespace?  The innoDB tablespace seems a


Everything is stored to the tablespace, except the tablename.frm files
which
the MySQL interpreter uses to store its own table schemas.

little voodoo to me.  I am expecially concerned because they are a
fixed
size and I dont understand how MySQL communicates with them.


You must make the data files big enough that your application fits
there.
Note that you are then safe from the problem that someone inadvertently
fills the hard disk. That is the benefit of preallocation.

Highest regards,
Aaron


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: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Re: innoDB confusion


Aaron,

please look at http://www.innodb.com/features.html,
http://www.innodb.com/division.html, and
http://www.innodb.com/ibman.html

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


Rutledge, Aaron wrote in message ...
Hello,  I am new to this list and MySQL.  I am very excited about this
open source community.  I can definitely see MySQL becoming to
database
servers, what Apache has become to web servers.
I am currently developing a mission critical manufacturing web
application in Java and I am leaning towards using MySQL as the
back-end
DB.  Since MySQL has gotten excellent reviews as far as stability,
speed, and ease of use--and my application does not require foreign
key
restraints or lots of bells and whistles --I decided it was worth a
shot.  My only concern from the onset was that it wasn't
transactionally
safe.  I can't have the DB lose data if the server goes down.  I have
learned that InnoDB provides this functionality on top of MySQL, but
the
interrelation between the two is very unclear to me.  I haven't found
a
good FAQ for explaining what InnoDB does and how it does it with
MySQL.
I've only found information in the 'do this, this and this to make
this
work' style.  I am never sure if I am working with InnoDB or MySQL or
both.  I don't feel like I can really commit to this DB until I get a
good grasp of the complexity of this relationship.
So far I have set up the InnoDB data files and directories and have
MySQL up and running.  I set my my.ini file with
'default-table-type=innodb' and my innodb information.  Everything
seems
great--I can create tables, do all my select statements, etc..
Everything seems easy as pie, but I can't shake the concern that I am
not understanding InnoDB.  So what I am wondering--am I creating
transactionally safe tables in the innodb format every time I create a
new table?  Do I no longer have to worry about innodb?  WHat about
these
ibdata1 and ibdata2 files I created?  I am assuming these hold
transactional information.  SHould I be worried about whats in there?
Will these fill up with data and outgrow their pre-defined size?  I
just
feel like I am missing something.  If anyone can point me to a good

Re: Foreign keys


Pierre,

I tested this with versions 3.23.46 and .48 on Linux and they worked ok:

mysql CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL,
PRIMARY
- KEY(COD)) TYPE=INNODB;
Query OK, 0 rows affected (0.02 sec)

mysql CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY
- KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES
FIRST(COD))
- TYPE=INNODB;
Query OK, 0 rows affected (0.04 sec)

mysql

But on Windows there was bug in database case in some earlier versions. See
http://www.innodb.com/bugfixes.html

Are you running on Windows? Check also with SHOW TABLE STATUS that the table
FIRST was really created in your test.

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


Pierre Radulescu wrote in message ...
Hi,

I am trying two create two innodb tables:

1.
CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL, PRIMARY
KEY(COD)) TYPE=INNODB;

2.
CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY
KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES FIRST(COD))
TYPE=INNODB;

The second table cannot be created (errno: 150)

Thanks in advance for help!

Pierre




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

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 confusion


Hi!

Weaver, Walt wrote in message ...
Do a show table status at the mysql prompt. Under type you should see
InnoDB.

Yes, and in really problematic situations, where you have lost your .frm
files, for example, you can use innodb_table_monitor as explained in the
InnoDB online manual.

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

--Walt Weaver
  Bozeman, Montana

-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:57 AM
To: Mysql List (E-mail)
Subject: RE: innoDB confusion


One final question, and I am done.  You have helped me
tremendously--thank you.  Wow, I really didn't expect the developer of
the software to answer my questions--this is terrific.

Is there way to verify that the tables I create are in the InnoDB
tablespace?  I am assuming that if I set 'default-table-type=innodb' in
my.ini that all tables created by the MySQL client will be created in
the innodb tablespace.  However, they also show up in the MySQL data
directory as .frm files.  How do I also know that it was created in the
InnoDB tablespace?  Aaron




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

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 problem: Show Processlist

2002-01-15 Thread Venu


Hi, 

 
 Hallo,
 
 Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC
 2.50.38.
 
 In some part of this application I like to know the processes that are
 running on MySql. I'm using SHOW PROCESSLIST expecting a recordset back
 like in SHOW STATUS. I'm getting an runtime-error -2147467259 (80004005),
 Function sequence error when I try to go to the first record (.MoveFirst).
 This works ok with SHOW STATUS.
 
 I traced the ODBC calls and enclosed the files. You can see that the SHOW
 STATUS leaves no error in the trace file. The SHOW PROCESSLIST however
 does.
 
 I hope you can give me an advice.
 
 Thanks in advance.
 Frans Streur
 -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*
  Frans Streur - 's-Hertogenbosch - The Netherlands
EMail [EMAIL PROTECTED]
 -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*
 
 Errors Tracefile: SHOW PROCESSLIST
 
 VB6 120-534   EXIT  SQLNumResultCols  with return code -1 (SQL_ERROR)
   HSTMT   031F17E0
   SWORD * 0x0012E908
 
   DIAG [S1010] [Microsoft][ODBC Driver Manager] Function 
 sequence error (0)
 

What is its previous call ? Is it SQLPrepare or SQLExecDirect ? 
Note that, if it is SQLPrepare, then please upgrade your driver 
to .39 version to have a fix for this.

Other wise, please send me the complete trace, but before that 
try with .39 version of the driver.

NOTE: The error is returned by the DM, not by the driver, so 
we need to have a trace to understand what is happening from 
the application, and my guess is something to do with app 
calling sequence.

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
   ___/  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 - Win SQL2k DTS - MySQL

2002-01-15 Thread Venu

Hi, 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 15, 2002 7:51 AM
 To: [EMAIL PROTECTED]
 Subject: MySQL - Win SQL2k DTS - MySQL

 Hello,

 Has anyone successfully implemented using a Microsoft SQL 2000 DTS 
 package to copy data from one mysql database into another mysql 
 database? I am getting some errors pertaining to 'cannot insert blob 
 fields'. -which they are not blob fields. I've tried this on text, 
 char, varchar, tinytext.

 I feel like the MyODBC driver is very limited in the data types that 
 it supports.

I will look into it. Last time when I traced this, found that the DTS 
is not doing a correct data type mapping while converting. Let me 
investigate further on this today. 

Thanks for the info.

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
   ___/  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: innoDB confusion

2002-01-15 Thread Philip Molter


On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote:
: Hi!
: 
: Weaver, Walt wrote in message ...
: Do a show table status at the mysql prompt. Under type you should see
: InnoDB.
: 
: Yes, and in really problematic situations, where you have lost your .frm
: files, for example, you can use innodb_table_monitor as explained in the
: InnoDB online manual.

This brings up an interesting point.  If you've lost your .frm
files, are you totally screwed, or does InnoDB contain enough
information to restore those .frm files?  It's not a big deal if
it doesn't.  That's why God gave us backups, after all.

I know oftentimes, when we're doing testing with very large tables,
rather than go through the hassle of cleaning stuff out, we just
drop the .frm files, which causes InnoDB to lose the tables.
Then we can recreate just fine.

* 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: My ODBC Error

2002-01-15 Thread Venu

Hi, 

 -Original Message-
 From: Frankie Cooke [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 15, 2002 9:48 AM
 To: [EMAIL PROTECTED]
 Subject: My ODBC Error

 Hello All

 I can currently connect to a Mysql database on my local machine, a windows
 o/s.  However, when I try and do this on unix - get the error:

 Vbscript Runtime error 'ASP 0185 : -2147467259'
 Data source name not found or no default driver specified

 include/dbconnectcrop.asp,line 11

 Line 11 is the where I am opening the connection.  I feel that I have not
 matched the driver name.  Is the driver MyODBC called something different
 on Unix, other than MySQL.  Below is my conenction string.

 %

 ' Connect to MySQL database for passwords  section documents

 Dim dbconnect, anyRs, insComm

 set dbconnect=Server.CreateObject(ADODB.Connection)

 dbconnect.ConnectionString=Driver=MySQL;server=localhost;Database=cropwise;

 dbconnect.Open

 %

 Thanks for any help

 Frankie

You said you are trying to connect to server running on Unix, but 
your ADO connect string has localhost. Any way, 

For more information on how to establish a remote connection using 
MyODBC, refer to the following link:

http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4326:200112:pnidmlbpjaokppdkhnhp

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
   ___/  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: innoDB confusion

Hi!
-Original Message-
From: Philip Molter [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, January 15, 2002 8:24 PM
Subject: Re: innoDB confusion

On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote:
: Hi!
:
: Weaver, Walt wrote in message ...
: Do a show table status at the mysql prompt. Under type you should
see
: InnoDB.
:
: Yes, and in really problematic situations, where you have lost your .frm
: files, for example, you can use innodb_table_monitor as explained in the
: InnoDB online manual.

This brings up an interesting point.  If you've lost your .frm
files, are you totally screwed, or does InnoDB contain enough
information to restore those .frm files?  It's not a big deal if

With some work, yes. innodb_table_monitor prints the internal schema of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear as an integer.

it doesn't.  That's why God gave us backups, after all.

I know oftentimes, when we're doing testing with very large tables,
rather than go through the hassle of cleaning stuff out, we just
drop the .frm files, which causes InnoDB to lose the tables.
Then we can recreate just fine.

Sorry, but I do not understand? If you delete the .frm file, then the large
table is preserved inside the tablespace. And if you create a table with the
same name, InnoDB will complain.

* 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

Roadmap

2002-01-15 Thread Emmanuel van der Meulen


Hello all,

Is there a roadmap for MySQL releases, and in particular when it the eta for
4.1?

Kind regards
Emmanuel


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

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 confusion


The added complexity frightens me a little.  It seems a little
black-boxish to me right now.  I am sure it is only a matter of getting
use to and working with the architecture.  The idea of a separate
table-handler in the RDBMS seems very foreign when you come from the
Oracle world.  However, I can see where this will also allow for a lot
of flexibility in design later on (anyone working on an XML data handler
for MySQL?).  Thanks for your comments.  I think I feel comfortable
enough now to proceede with using MySQL and InnoDB.  Regards, Aaron
 


-Original Message-
From: Philip Molter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 11:24 AM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion


On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote:
: Hi!
: 
: Weaver, Walt wrote in message ...
: Do a show table status at the mysql prompt. Under type you should
see
: InnoDB.
: 
: Yes, and in really problematic situations, where you have lost your
.frm
: files, for example, you can use innodb_table_monitor as explained in
the
: InnoDB online manual.

This brings up an interesting point.  If you've lost your .frm
files, are you totally screwed, or does InnoDB contain enough
information to restore those .frm files?  It's not a big deal if
it doesn't.  That's why God gave us backups, after all.

I know oftentimes, when we're doing testing with very large tables,
rather than go through the hassle of cleaning stuff out, we just
drop the .frm files, which causes InnoDB to lose the tables.
Then we can recreate just fine.

* 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


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

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 confusion



Woah...

Heikki Tuuri wrote:
With some work, yes. innodb_table_monitor prints the internal schema of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear as an integer.

Now I am confused again.  Do you only have access to column types
specified by InnoDB?  I thought that was the purpose of the .frm files.
--Aaron

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

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

Re: access denied set mysql root user

2002-01-15 Thread Diana Soares


 Then I tried to set a password for the MYSQL root user and I get the
 following error.
 
 ./bin/mysqladmin -u root -p password 'christ1'
 Enter password: ***
 
 ./bin/mysqladmin: connect to server at 'localhost' failed
 error: 'Access denied for user: 'root@localhost' (Using password: YES)

Try:
./bin/mysqladmin -u root password 'christ1'

If this works, the problem was that you were giving the new password
(Enter password: ***) when mysql was asking you the old password -
if you were changing root password for the first time, root password is
empty. 

-- 
Diana Soares


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

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 confusion


Aaron,

Rutledge, Aaron wrote in message ...

Woah...

Heikki Tuuri wrote:
With some work, yes. innodb_table_monitor prints the internal schema of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear as an integer.

Now I am confused again.  Do you only have access to column types
specified by InnoDB?  I thought that was the purpose of the .frm files.

you have all the column types of MySQL available. The above just means that
at the lower level types are mapped to more basic types. Internally DATE
columns can be compared like integer columns.

--Aaron

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

OS X Install not working

2002-01-15 Thread Rich Fortnum


Hi there.  I'm trying a binary install of MySQL for OS X.  Can anybody help
me?  The directories are messed up, so it doesn't know where to look for it.

Where should I have the master folder for MySQL?

Cheers.



@@@ Rich Fortnum / Viaduct Productions / Toronto (EST)
@@@ Web Design / Databases / Internet Video / Wireless Data
@@@ [EMAIL PROTECTED] / http://www.viaduct-productions.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: innoDB confusion