RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

[shane]

Hi, the driver which i am using is type IV. do i still need to install
myodbc?

thks

-Original Message-
From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 2:04 PM
To: shane
Cc: [EMAIL PROTECTED]
Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for
user... (Using password: No) message


Hi Shane

To connect to MySQL using JDBC Driver, it depends up on the type of JDBC
driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER)
then you need MyODBC installed on the system and configured properly as
explained in the earlier mail in the mysql list.

Here is the link, which tells different types of JDBC drivers in the world.
http://java.sun.com/products/jdbc/driverdesc.html < or >
http://www.jguru.com/faq/view.jsp?EID=691

Let us know, what type of JDBC driver are you using to connect to MySQL ?

Thank you
Venu Anuganti

- Original Message -
From: "shane" <[EMAIL PROTECTED]>
To: "Venu Anuganti" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 10:39 PM
Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
(Using password: No) message


> i am using the mmmysql jdbc driver, and i was wondering whether i need to
> install myodbc.
> i'm running mysql server on a linux machine and the binary version of the
> download from
> www.mysql.com does not include the odbc driver and the libraries required
> for myodbc.
> I'm running on a i686 but the rpm version they have is for i386 system
>
> thks
> shane
>
> -Original Message-
> From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 12:55 PM
> To: Luc Lalancette; [EMAIL PROTECTED]
> Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for
> user... (Using password: No) message
>
>
> Hi Luc
>
> Here is the common syntax, that is used as the connection string through
> JDBC-ODBC Driver.
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> String url = "jdbc:odbc:TestDSN";
> Coonection con = DriverManager.getConnection(url,"username","password");
>
> Before connecting, make sure you intslled the ODBC Driver and configured
the
> DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error
> below, it looks you have the valid DSN, but you didn't supply the UID and
> PWD in the connection string.
>
> Thank you
> Venu Anuganti
>
> - Original Message -
> From: "Luc Lalancette" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, July 18, 2001 3:02 PM
> Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
> (Using password: No) message
>
>
> I am starting using mysql and I made a java SimpleQuery servlet that is
> suppose to retreive one row from the database. However, when I try to
> connect I get that message from the Subject. I know I'm suppose to pass
the
> password but can't seem to find a way of doing it. I was wondering if the
> problem was with those two lines or if it was in the tdx mysql driver
> default configuration in the ODBC.
>
> Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;");
>
> I would appreciate if someone could help me to get my connection going.
> Thank you very much
> Luc Lalancette
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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 or MS SQL?

[Bernhard Doebler]

Hi,

the question is what operating system you are going to use. If your DB gets to large 
you will have problems not with tha database but with the filesystem.

Best Regards
Bernhard

- Original Message - 
From: "Alexander Chernienko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 7:51 PM
Subject: MySQL or MS SQL?


> I'm currently writing proposals for a customer who want to hire our little
> programming team for creating corporate information system, wich includes
> huge database with number of records between 1-10 millions (incl. blobs -
> pictures). Expected database size is tens of Gb.
> 
> There is idea of using MS SQL Server for some reasons, on other hand we have
> big experience with MySQL (but with smaller databases).
> So I'm very interested to hear  advise, especially from people who had
> experience with both SQL servers - which SQL Server is preferable in such
> situation.


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

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: Transaction for MySQL

[Michael Tam]

Hi everyone,

Would someone help me out with these questions?

I know these may be something obvious/ in the manual .. etc but I would
like to have someone showing me if I am on the right track and maybe share
some of these in greater detail.  Greatly appreciated.


Regards,
Michael

- Original Message -
From: "Michael Tam" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 2:06 PM
Subject: Transaction for MySQL


Hi all,

I am new using MySQL.  I found out that the default table type used in
the binary isn't support transaction and would like to make MySQL uses
another table type which supports transaction.  The following are my
questions regarding the issue:

1) which one should I use InnoDB or BDB?  what kind of advantages given by
each type?

2) currently, I am using the default type - MyISAM, where I am running
MySqld-nt.  If I would like to switch to another
table type.  Do I just uninstall the service of MySqld-nt from win2000
and install MySqld-Max service??
In addition to the daemond, I need to comment out the MyISAM config

3) what would happen to my existing MyISAM type tables which already exists
in MySQL if I do the switch over? and
   would I able to use/create MyISAM type table uder MySqld-Max??

Thank you and greatly appreciated for any suggestion/help.

Regards,
Michael


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

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

RE: mysql.org

[Martin Jeremic]

First, I support mySQL and Open Source community. Maybe you can fight them
with their own weapon. They have made some extra applications based on
mySQL, and they sell it. You can create same applications as Open Source.


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

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

Re: Can't initialize InnoDB as 'innodb_data_file_path' Problem

[Sunento Wu]

Thanks Ken !


- Original Message - 
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "Sunento Wu" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 1:45 PM
Subject: Re: Can't initialize InnoDB as
'innodb_data_file_path' Problem


> Better read the manual:
> http://www.innodb.com/ibman.html#InnoDB_start
> 
> Enjoy,
> Ken
> - Original Message -
> From: "Sunento Wu" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, July 18, 2001 10:34 PM
> Subject: Can't initialize InnoDB as
'innodb_data_file_path' Problem
> 
> 
> > Hi,
> >
> > I am still new in mysql.
> > I just install mysql to my win 98.
> > When I try to run the server, mysqld, I got this
error
> >:
> > ===
> > C:\mysql\bin>mysqld
> > Can't initialize InnoDB as 'innodb_data_file_path'
is
> > not set
> >
> > ===
> >
> > Have some one experienced with this error before ?
> > I have read the Installation Guide for WIN 98, but
can
> > not find any solution for this problem.
> >
> > Thanks,
> >
> > anen
> >
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> > http://personal.mail.yahoo.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
> >
> 

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

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

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

Fw: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

[Venu Anuganti]

--
For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Venu Anuganti <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Redwood city, California  USA
   <___/   www.mysql.com
- Original Message -
From: "Luc Lalancette" <[EMAIL PROTECTED]>
To: "Venu Anuganti" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 10:04 PM
Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
(Using password: No) message


> Thanks again... It seems that I owe you one it worked.
> Luc
> - Original Message -
> From: "Venu Anuganti" <[EMAIL PROTECTED]>
> To: "Luc Lalancette" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, July 18, 2001 10:54 PM
> Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for
user...
> (Using password: No) message
>
>
> > Hi Luc
> >
> > Here is the common syntax, that is used as the connection string through
> > JDBC-ODBC Driver.
> >
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > String url = "jdbc:odbc:TestDSN";
> > Coonection con = DriverManager.getConnection(url,"username","password");
> >
> > Before connecting, make sure you intslled the ODBC Driver and configured
> the
> > DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error
> > below, it looks you have the valid DSN, but you didn't supply the UID
and
> > PWD in the connection string.
> >
> > Thank you
> > Venu Anuganti
> >
> > - Original Message -
> > From: "Luc Lalancette" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 18, 2001 3:02 PM
> > Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
> > (Using password: No) message
> >
> >
> > I am starting using mysql and I made a java SimpleQuery servlet that is
> > suppose to retreive one row from the database. However, when I try to
> > connect I get that message from the Subject. I know I'm suppose to pass
> the
> > password but can't seem to find a way of doing it. I was wondering if
the
> > problem was with those two lines or if it was in the tdx mysql driver
> > default configuration in the ODBC.
> >
> > Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;");
> >
> > I would appreciate if someone could help me to get my connection going.
> > Thank you very much
> > Luc Lalancette
> >
> >


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

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

Errors on log files

[2E]

Hi All,
Not sure if the last email got through to the list! But On our log 
files we are get alot of Error number zero's does anyone have any 
idea what this means? We are running a system that Uses MySQL 
3.23.39 and PHP 4.0.5. Any input would be appreciated thanks in 
advance.

Drew

Andrew Toussaint  
Richardson-Shaw Pty Ltd 
[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: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

[Venu Anuganti]

Hi Shane

To connect to MySQL using JDBC Driver, it depends up on the type of JDBC
driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER)
then you need MyODBC installed on the system and configured properly as
explained in the earlier mail in the mysql list.

Here is the link, which tells different types of JDBC drivers in the world.
http://java.sun.com/products/jdbc/driverdesc.html < or >
http://www.jguru.com/faq/view.jsp?EID=691

Let us know, what type of JDBC driver are you using to connect to MySQL ?

Thank you
Venu Anuganti

- Original Message -
From: "shane" <[EMAIL PROTECTED]>
To: "Venu Anuganti" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 10:39 PM
Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
(Using password: No) message


> i am using the mmmysql jdbc driver, and i was wondering whether i need to
> install myodbc.
> i'm running mysql server on a linux machine and the binary version of the
> download from
> www.mysql.com does not include the odbc driver and the libraries required
> for myodbc.
> I'm running on a i686 but the rpm version they have is for i386 system
>
> thks
> shane
>
> -Original Message-
> From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 12:55 PM
> To: Luc Lalancette; [EMAIL PROTECTED]
> Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for
> user... (Using password: No) message
>
>
> Hi Luc
>
> Here is the common syntax, that is used as the connection string through
> JDBC-ODBC Driver.
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> String url = "jdbc:odbc:TestDSN";
> Coonection con = DriverManager.getConnection(url,"username","password");
>
> Before connecting, make sure you intslled the ODBC Driver and configured
the
> DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error
> below, it looks you have the valid DSN, but you didn't supply the UID and
> PWD in the connection string.
>
> Thank you
> Venu Anuganti
>
> - Original Message -
> From: "Luc Lalancette" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, July 18, 2001 3:02 PM
> Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
> (Using password: No) message
>
>
> I am starting using mysql and I made a java SimpleQuery servlet that is
> suppose to retreive one row from the database. However, when I try to
> connect I get that message from the Subject. I know I'm suppose to pass
the
> password but can't seem to find a way of doing it. I was wondering if the
> problem was with those two lines or if it was in the tdx mysql driver
> default configuration in the ODBC.
>
> Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;");
>
> I would appreciate if someone could help me to get my connection going.
> Thank you very much
> Luc Lalancette
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Can't initialize InnoDB as 'innodb_data_file_path' Problem

[Ken Sommers]

Better read the manual:
http://www.innodb.com/ibman.html#InnoDB_start

Enjoy,
Ken
- Original Message -
From: "Sunento Wu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 10:34 PM
Subject: Can't initialize InnoDB as 'innodb_data_file_path' Problem


> Hi,
>
> I am still new in mysql.
> I just install mysql to my win 98.
> When I try to run the server, mysqld, I got this error
> :
> ===
> C:\mysql\bin>mysqld
> Can't initialize InnoDB as 'innodb_data_file_path' is
> not set
>
> ===
>
> Have some one experienced with this error before ?
> I have read the Installation Guide for WIN 98, but can
> not find any solution for this problem.
>
> Thanks,
>
> anen
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

Re: Solaris +SMP + mysql problem

[Alexander Belyaev]

Hello,

I have thread_concurrency=4 already in my.cnf, but mysqld don't want to use
more than 50% of CPU resources.
(Solaris8 x86 MU3 on Dual PIII Xeon with 1GB RAM)
Alexander

> On Wednesday 18 July 2001 07:41, Alexander Belyaev wrote:
> > Hello,
> > I have a similar results on my Solaris8 x86 + MU3,  Mysql 3.23.39.
> >
> > (Dual PIII Xeon  with 1Gb Ram)
> >
> > Alexander
> >
> > > Hello, i have got a A BIG PROBLEM, help me please!!!
> > >
> > > I've got installed Apache + MySQL in a Sun Enterp. 250 whith two
> > processors
> > > and my problem is the next:
> > >
> > > When I run MySQL only works one processor with mysqld
> > >
>
> Add
>
> set-variable= thread_concurrency=4
>
> to my.cnf and see if that fixes the problem.





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

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 + ssl.

[luwim+]

can mysql support ssl connection?




luwim+

(axishift.ath.cx) PGPID : 0xDABA60C7





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

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: Info needed!

[Venu Anuganti]

Hi Asha

Yes, you are correct. Please refer to the following link for more details:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
W

Thank you
Venu Anuganti
--
For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Venu Anuganti <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Redwood city, California  USA
   <___/   www.mysql.com
- Original Message -
From: "Asha Ramaiah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 10:32 PM
Subject: Info needed!


I need to run a query from a java program to :
1) get the list of tables in a particular db]
2) get the desc of each table in the list I get
Can I use the show tables; and desc tablename as a query to get the desired
RESULTSET in java(sql package) ??

Plz do respond at hte earliest!
Thanks and regds
Ash




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

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

Can't initialize InnoDB as 'innodb_data_file_path' Problem

[Sunento Wu]

Hi,

I am still new in mysql.
I just install mysql to my win 98.
When I try to run the server, mysqld, I got this error
:
===
C:\mysql\bin>mysqld
Can't initialize InnoDB as 'innodb_data_file_path' is
not set

===

Have some one experienced with this error before ? 
I have read the Installation Guide for WIN 98, but can
not find any solution for this problem.

Thanks,

anen

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.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

Info needed!

[Asha Ramaiah]

I need to run a query from a java program to :
1) get the list of tables in a particular db]
2) get the desc of each table in the list I get
Can I use the show tables; and desc tablename as a query to get the desired RESULTSET 
in java(sql package) ??

Plz do respond at hte earliest!
Thanks and regds
Ash

Re: Multiple statements via ODBC

[Venu Anuganti]

Hi Jon

MySQL/MyODBC doesn't support nested SELECT statements.  Please check the
following links, whether that helps you.

http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Missing_functions
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:79974:200107:dkdliiiacininpiok
lgg

Thank you
Venu Anuganti

- Original Message -
From: "Jon Jenkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 7:33 PM
Subject: Multiple statements via ODBC


> I'm having problems getting multiple statements that need to be executed
as
> one thread (for user variables) through via the ODBC interface (Syntax
Error
> near ";SELECT" on line 1) . This works directly from mysql but not through
> other tools (they don't seem to accept the `;' to end one statement as per
> the documentation).
>
> Can someone assist ?
>
> Jon Jenkins
>
> Simplistic example:
> SELECT @var:=0;
> SELECT * FROM inv
> WHERE invno = @var
> OR (@var = 0 AND stat <2);
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

[Venu Anuganti]

Hi Luc

Here is the common syntax, that is used as the connection string through
JDBC-ODBC Driver.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:TestDSN";
Coonection con = DriverManager.getConnection(url,"username","password");

Before connecting, make sure you intslled the ODBC Driver and configured the
DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error
below, it looks you have the valid DSN, but you didn't supply the UID and
PWD in the connection string.

Thank you
Venu Anuganti

- Original Message -
From: "Luc Lalancette" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 3:02 PM
Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
(Using password: No) message


I am starting using mysql and I made a java SimpleQuery servlet that is
suppose to retreive one row from the database. However, when I try to
connect I get that message from the Subject. I know I'm suppose to pass the
password but can't seem to find a way of doing it. I was wondering if the
problem was with those two lines or if it was in the tdx mysql driver
default configuration in the ODBC.

Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;");

I would appreciate if someone could help me to get my connection going.
Thank you very much
Luc Lalancette



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

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

Error 127

[Walter Lee Davis]

I have determined that error 127 is 'index has crashed', but I have no idea
if this is recoverable. I have a table with just under 7000 rows, and I am
getting this error when I try to count the records and set up the variables
to page through the records n at a time. Is there any practical limit to the
number of rows in a table?

I have tried repeatedly to remove the index and reindex the database, but I
just keep getting the error 127 no matter what I do.

Any thoughts?

Walter


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

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: Multiple INSERTS syntax ...

[Allen Grace]

- Original Message -
From: "Philippe L. Houze" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 8:09 AM
Subject: MySQL: Multiple INSERTS syntax ...


> When running: INSERT INTO customers3 (firstname) select TRIM(trailing
> char(10) FROM firstname) FROM customers where id>1219; everything works
> according to plan but when running: INSERT INTO customers3
> (lastname,firstname) SELECT trim(trailing char(10) FROM firstname FROM
> customers where id>1219, trim(trailing char(10) FROM lastname FROM
customers
> where id>1219; I am getting an 1064 error

Your bracketing is a bit wonky, and you can only have one FROM matching each
SELECT.

Something like:
INSERT INTO customers3  (lastname, firstname)
SELECT trim(trailing char(10) FROM firstname), trim(trailing char(10) FROM
lastname)
FROM customers WHERE id > 1219;


--
Allen Grace

Dark Blue Sea Pty Ltd
ph +61 7 3007 
fax +61 7 3007 0001

***The opinions expressed in this email are my own and are not
representative of DBS Pty Ltd.***


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

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

stability of freebsd 4.3, gcc 2.95.3

[Allen Grace]

Hi there

I posed a question a couple of days ago about segfaults occurring in
mysql_free_result(), but have received no response, possibly because my
question was too vague. I'd like to try again, and express the problem
differently.

Has anyone had unfavourable experiences with FreeBSD 4.3-STABLE, gcc 2.95.3,
and libmysqlclient_r.so.10 (from MySQL 3.23.39), and POSIX threads?

My code runs smoothly with 4.2-RELEASE and gcc 2.95.2, but with the later
versions of OS and compiler segfaults intermittently in
_thread_leave_cancellation_point() called from mysql_free_result(). If I set
MYSQL_DEBUG, I'm able to crash it every time with a specific sequence of
operations. (This sequence works if MYSQL_DEBUG is not set, but randomly
segfaults in the same procedure later on.)

If I can provide more information about the situation I'd be happy to.

allen

--
Allen Grace

Dark Blue Sea Pty Ltd
ph +61 7 3007 
fax +61 7 3007 0001

***The opinions expressed in this email are my own and are not
representative of DBS Pty Ltd.***


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

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: jdbc connectivity

[shane]

i have the same problem too. because the java program worked with mysql
server residing on a win2000 os, i came to the conclusion that my problem
was not with the java program but with the mysql server setup on linux. Do
we need myodbc + jdbc? i ask this question because i only installed jdbc.

regards
shane

-Original Message-
From: Kalpesh Modha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 5:00 PM
To: 'raghavan'; [EMAIL PROTECTED]
Subject: RE: jdbc connectivity


Hello.

I have the same problem let me know if you find a solution.  Mine is on
redhat 7.1

Thanks
Kal

-Original Message-
From:   raghavan [SMTP:[EMAIL PROTECTED]]
Sent:   18 July 2001 06:47
To: [EMAIL PROTECTED]
Subject:jdbc connectivity

Hi,
I am trying to connect mysql database to java program, I am using
org.gjt.mm JDBC driver.
I have username and password in USER table and host is that "%" , connect
from anywhere.Driver is loading but
its saying "access denied,@uable" something like this

could anyone help me.
regards
raghavan


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

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: unsuported function

[Colin Faber]

Try a PHP mailing list, This is off topic.




axel yson wrote:
> 
> Fatal error: Call to unsupported or undefined function mysql() in 
>/usr/local/share/apache/htdocs/test.php3 on line 13

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

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: unsuported function

[Steve Werby]

"axel yson" <[EMAIL PROTECTED]> wrote:
> Fatal error: Call to unsupported or undefined function
> mysql() in /usr/local/share/apache/htdocs/test.php3
> on line 13

This is a PHP error, not a MySQL error.  PHP does not have an internal
function mysql() so unless you defined a function called mysql() that is the
reason for your error.  If on the other hand you didn't paste that error and
accidentally typed mysql() instead of whatever really appeared in the error
message, perhaps something like mysql_connect() then the problem is you
don't have PHP compiled with MySQL support.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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

Multiple statements via ODBC

[Jon Jenkins]

I'm having problems getting multiple statements that need to be executed as
one thread (for user variables) through via the ODBC interface (Syntax Error
near ";SELECT" on line 1) . This works directly from mysql but not through
other tools (they don't seem to accept the `;' to end one statement as per
the documentation).

Can someone assist ?

Jon Jenkins

Simplistic example:
SELECT @var:=0;
SELECT * FROM inv
WHERE invno = @var
OR (@var = 0 AND stat <2);



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

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

Re: SQL question (set operator)

[Steve Werby]

"Marie-Christine Fauvet" <[EMAIL PROTECTED]> wrote:
> I'd like to program in the SQL language supported by MySQL the following
> query:
> 
> select R.A, R.B from R
> minus 
> select S.A, S.B from S
> 
> It doesn't work (syntax error, set operators are not supported).
> So, I've tried:
> 
> select R.A, R.B from R
> where not exists 
> (select * from S
> where S.A = R.A and S.B = R.B)
> 
> I've tried as well:
> 
> select R.A, R.B from R
> where (R.A, R.B) not in
> (select S.A, S.B from S)
> 
> Both of the above queries don't work.

MySQL doesn't yet support subselects.  I believe they're planned for v4.1.

> Does somebody have any idea about that? I want to avoid programming the
> minus operator in an host language ;-)

I think you may have to handle this in the application instead of the db.

-- 
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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

unsuported function

[axel yson]

Fatal error: Call to unsupported or undefined function mysql() in 
/usr/local/share/apache/htdocs/test.php3 on line 13

MySQL Timing out

[Chris Anderson]

I have an include file that includes my mysql connect information. Its sole purpose is 
to login to mysql. Strangely on my Win9x development system with apache, sometimes, 
almost randomly, the connection will time out. Then if I press refresh it works 
prefectly. I am only connecting once per page and am closing my connections when done. 
Does this sound like a MySQL or Apache onfiguration problem? Or is there something I'm 
missing. Thanks 

SQL question (set operator)

[Marie-Christine Fauvet]

Hi,


I'd like to program in the SQL language supported by MySQL the following
query:

select R.A, R.B from R
minus 
select S.A, S.B from S

It doesn't work (syntax error, set operators are not supported).
So, I've tried:

select R.A, R.B from R
where not exists 
(select * from S
where S.A = R.A and S.B = R.B)

I've tried as well:

select R.A, R.B from R
where (R.A, R.B) not in
(select S.A, S.B from S)

Both of the above queries don't work.

Does somebody have any idea about that? I want to avoid programming the
minus operator in an host language ;-)

Regards,
MC
-- 
Marie-Christine Fauvet  University of Grenoble
Visiting Fellow at the University of New South Wales
UNSW - School of Computer Science & Engineering
Sydney NSW 2052 Australia
Tel: 61 (2) 9385 7201   Fax: 61 (2) 9385 5533
[EMAIL PROTECTED]http://www.cse.unsw.edu.au/~mcfauvet

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

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: [TCX][MyODBC] Access denied for user... (Using password: No) message

[tj marlin]

the method signature for getConnection is:

public static synchronized Connection getConnection(String url,
   String user, String password) throws SQLException

try PURE JSP Java Server Pages by James Goodwill from Sams. a nice book. 
has some coding errors.

At 04:02 PM 7/18/01 -0600, you wrote:
>I am starting using mysql and I made a java SimpleQuery servlet that is 
>suppose to retreive one row from the database. However, when I try to 
>connect I get that message from the Subject. I know I'm suppose to pass 
>the password but can't seem to find a way of doing it. I was wondering if 
>the problem was with those two lines or if it was in the tdx mysql driver 
>default configuration in the ODBC.
>
>Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;");
>
>I would appreciate if someone could help me to get my connection going.
>Thank you very much
>Luc Lalancette


--
tom marlin
[EMAIL PROTECTED]
fax / voice mail: 714 507 3802 ext 4881
Never be afraid to try something new. Remember that
   - amateurs built the ark.
   - professionals built the Titanic.

Re: MySQL question

[Rolf Hopkins]

Have a look at what the error logs say.  If that doesn't help, post the
command used and error messages/logs (if relevant) to the list.

- Original Message -
From: "MIKE TURNER" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 2:05
Subject: MySQL question


>
> I have just installed MySql and when I tried to set the root password and
it
> gives me an error(I don't recall the exact text) but I looked and the
daemon
> isn't running. I tried starting it but still nothing? Did I miss a step?
> Sorry if this ends up to be a stupid mistake. Hope you can help me.
>
> Mike
>
>
>
>
>
> ___
> Send a cool gift with your E-Card
> http://www.bluemountain.com/giftcenter/
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Problem compiling with GCC 3.0

[Devendra Narayan]

due to some problem with the mailer, some
unknown multibyte characters got included
in my previous message. Here's the
configuration line again :

CC=gcc CFLAGS="-O1" CXX=gcc CXXFLAGS="-O1 -felide-constructors -fno-exceptions 
-fno-rtti" ./configure --prefix=/usr/local/mysql --with-low-memory --with-charset=sjis 
--with-extra-charset=complex

very sorry for this :-(

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

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

Problem compiling with GCC 3.0

[Devendra Narayan]

Would appreciate any help / tips regarding the following problem :

Trying to compile mysql-3.23.39 with GCC 3.0 ( on Solaris 8 ) and the following
configuration options :
CC=gcc CFLAGS="-O1" CXX=gcc CXXFLAGS="-O1 -felide-constructors -fno-exceptions 
-fno-rtti" \
./configure --prefix=/usr/local/mysql --with-low-memory --with-charset=sjis 
--with-extra-charset=complex

results in this error message :
---
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti 
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H 
-I/work/src/mysql-3.23.39/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o 
mini_client.o net_serv.o mini_client_errors.o violite.o password.o ../isam/libnisam.a 
../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a 
../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a 
../strings/libmystrings.a ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a 
../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a 
../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lz -lcrypt 
-lgen -lsocket -lnsl -lm -lpthread -lthread
Undefined   first referenced
 symbol in file
__cxa_pure_virtual  mysqlbinlog.o
ld: fatal: Symbol referencing errors. No output written to mysqlbinlog
collect2: ld returned 1 exit status


Is it a problem with GCC 3.0 ( or some stupid miss on my part ) ?

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

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: Network connection

[Werner Stuerenburg]

How about using Ora_Logon to connect to an oracle db? It is the
prescibed procedure. mysql_pconnect ist used to connect to mysql
dbs.

> $db = mysql_pconnect ("anothermachine:oracleport", "user", "passwd") or
> die ..

> I need to connect to an oracle DB - can I?  Or do I have to run a ?cgi?
> style
> script / program to get there?




-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



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

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

Re: Buffering SELECT results without using temporary tables; "Locked tables while 'Sending data'" revisited

[Werner Stuerenburg]

> (begins: http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/Mar.2000/1029.html )

By chance, this points me to an archive of this list. I already
looked for a hint at the trailer and on the website, but, as I
didn't find any, assumed that there wasn't any. Wouldn't it be
helpful to add links at both places, maybe with a suggestion to
look there, too, before asking?

-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



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

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

Solution (but only a temporary one) Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

[Carsten Gehling]

After the latest post, curiosity got the better of me (which is always good
in a debug situation).

I tried to change all 6 fields that compose the FULLTEXT index, so that they
accept NULL values. The result? The error is gone.

Is this a valid solution however? I've never been a great fan of the NULL
value in RDBMS' - I regard it as a necessary evil to be used sparsely. So it
would be great if I did not have to convert my text fields (text & varchar)
into accepting NULL.

- Carsten

- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Carsten Gehling" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 6:26 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields


> Hi!
>
> On Jul 16, Carsten Gehling wrote:
> > Description:
> > A specific table (see "How-To-Repeat) with a FULLTEXT index causes
errors in
> > the MYI file when inserting new rows.
> >
> > 1) Create the following table:
> > CREATE TABLE `visitkort` (
> [skip]
> > ) TYPE=MyISAM;
> >
> > 2) Insert a row with the following statement:
> >
> > 3) Run myisamchk with the option --extend-check and you get the
following
> > myisamchk: warning: 1 clients is using or hasn't closed the table
properly
>
> > The error does not occur, if you drop the FULLTEXT index
>
> Ok, I was able to repeat this, still I do not think it's a bug.
> Message given by myisamchk is perfectly legal - you should not expect
> MySQL to close the table immidiately when the client closes the
connection.
> MySQL can keep the table open to speedup access to it from, e.g.,
> next connection. MySQL will close the table on "FLUSH TABLE",
> or when the pool of opened tables is exceeded.
>
> if you will add "2.5) flush table" the error message will dissapear.
> if you will shutdown MySQL instead, you'll get no error, either.
> if you will issue "CHECK TABLE visitkort EXTENDED" instead of using
> external program myisamchk, again there will be no error message.
>
> So, looks like everything is ok.
>
> In you first message (without test case) you've also added
>
> > The result of this is, that if anyone is trying to update the same
record
> > afterwards, the index is corrupted.
>
> I wasn't able to reproduce that. If you have a test case for this, please,
> let me know.
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
> /_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
><___/
>



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

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: FreeBSD issues

[Michael Caplan]

Ken,

Thank you for your very helpful notes.  We took your advice and
updated to FreeBSD 4.3 and the last version of MYSQL.  We are still
experiencing problems with MYSQL, though.  We installed it fresh, with
no freeBSD tweaks.  I was not able to locate the email you referred to
regarding FreeBSD installs.  If you have any pointers on tweaking a
freeBSD install, it would be very helpful.

Regards,

Michael Caplan


-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 3:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: FreeBSD issues


Hi Michael,
   As another FreeBSD user that has posted many times on FreeBSD
topics realted to MySQL it only took me a few minutes to find
resolutions,  the problem is that some of the thread topics are
related and the answers were posted in a different thread from the
ones that orginally started a question.  I think the search engine
could be improved!

Freebsd 4.2 does have a number of bugs related to threads and the
compiler for threaded programs .  (Search 'freebsd compiler threads)
first topic on second page) I would recommend an upgrade to 4.3 and an
upgrade to a more recent MySQL is also highly recommended (3.23.39 or
.40 when it comes outs).

Upgrade your ports collection and install from ports or find my
previous posts or e-mail me direclty and I will send you some
compilation instructions as the manual seems to be outdated in
relation to compiling freebsd.

Best of luck, hope this helps
Ken
- Original Message -
From: "Michael Caplan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 5:54 PM
Subject: FreeBSD issues


> Hello,
>
> I am working with MySQL (Ver 9.38 Distrib 3.22.32, for -freebsd4.1.1
> (i386)) on FreeBSD 4.2-STABLE running (I believe) on a dual 233
Intel
> box.  We have been having some problems as of recently where system
> swap becomes flooded and the system is brought to a halt.  We
believe
> we have isolated the problem to MySQLd.
>
> In searching through the mysql discussion list, I noticed several
> people raising similar issues on FreeBSD systems.  I did not however
> come across any solutions.  Perhaps I missed something.  What are
the
> current install recommendations for the above mentioned system, and
> has the above mentioned problem been resolved?
>
> Regards,
>
> Michael Caplan
>
>
> 
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

query.preview() stored in an edit box

[Örjan Björk]

Hi, I recently downloaded mysql++ and the tutorial that came with it. Unfortunately 
they used "cout" in the examples...
they used the following code
cout>>query.preview();
and that worked great but...

How do I get the result back as a string which I can store in a CString or char 
variable??

Thanks in advance!

/Kalle B

using mysql to build a delphi program

[Ricardo Striquer Soares]

well well, as seen i brought the delphi and mysql power to built an
application wich i am installing myself in the client nowadays although
i'd like to make a more friendly installation pack in wich the client
does not need to install the mysql and afther that install the program,
i am using the installshield.
can anyone tell me wich files do i need to have in windows systems to
run mysql for me to put it in the program's project ? 
and off course, does anyone knows if mysql.com agree with this kind of
installation ?

thanks advanced.

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

[Carsten Gehling]

Finally I was able to produce a complete step-by-step to corrupt the index
;-)

Do the following in the mySQL console (with e.g. a fresh and empty table):


mysql> insert into visitkort (kategori_id) values (108);
Query OK, 1 row affected (0.01 sec)

mysql> select last_insert_id();
+--+
| last_insert_id() |
+--+
|1 |
+--+
1 row in set (0.00 sec)

mysql> update visitkort set navn = 'test5' where id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update visitkort set tekst1 = 'bla bla' where id = 1;
ERROR 1034: Incorrect key file for table: 'visitkort'. Try to repair it


After this, myisamchk reports the following:

D:\mysql\data\test>myisamchk --extend-check visitkort
Checking MyISAM file: visitkort
Data records:   1   Deleted blocks:   0
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 1 clients is using or hasn't closed the table properly
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check records and index references
MyISAM-table 'visitkort' is usable but should be fixed


I guess this isn't the expected behavior of mySQL ;-)

It should be noted, that the above behavior does not occur if I drop the
FULLTEXT index. Without this index, the errors are gone and table works
fine. I've also tried to remove all other indexes except the FULLTEXT and
the primary key, and the error is still there. So it is definitely a problem
within the FULLTEXT index.

- Carsten


- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Carsten Gehling" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 6:26 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields


> Hi!
>
> On Jul 16, Carsten Gehling wrote:
> > Description:
> > A specific table (see "How-To-Repeat) with a FULLTEXT index causes
errors in
> > the MYI file when inserting new rows.
> >
> > 1) Create the following table:
> > CREATE TABLE `visitkort` (
> [skip]
> > ) TYPE=MyISAM;
> >
> > 2) Insert a row with the following statement:
> >
> > 3) Run myisamchk with the option --extend-check and you get the
following
> > myisamchk: warning: 1 clients is using or hasn't closed the table
properly
>
> > The error does not occur, if you drop the FULLTEXT index
>
> Ok, I was able to repeat this, still I do not think it's a bug.
> Message given by myisamchk is perfectly legal - you should not expect
> MySQL to close the table immidiately when the client closes the
connection.
> MySQL can keep the table open to speedup access to it from, e.g.,
> next connection. MySQL will close the table on "FLUSH TABLE",
> or when the pool of opened tables is exceeded.
>
> if you will add "2.5) flush table" the error message will dissapear.
> if you will shutdown MySQL instead, you'll get no error, either.
> if you will issue "CHECK TABLE visitkort EXTENDED" instead of using
> external program myisamchk, again there will be no error message.
>
> So, looks like everything is ok.
>
> In you first message (without test case) you've also added
>
> > The result of this is, that if anyone is trying to update the same
record
> > afterwards, the index is corrupted.
>
> I wasn't able to reproduce that. If you have a test case for this, please,
> let me know.
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
> /_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
><___/
>



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

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

select field(3)

[Kay Bowen]

Hello all,

I haven't been using MySQL very long.  I'm more in the 'playing with it'
stage, trying to learn all the in's and out's.  So, here is my current
dilemma:

I want to be able to reference (select) a field/column by it's position
in the table rather than by the field's name.  Is there a way to do
this?  To me, the logical syntax would be something like - "select
field(3) from event1".  But I've tried that with no success.  I know the
'down and dirty' way of doing it.  But I'm lazy and would prefer the
shortcut.  The program I am looking to develop would require MANY
queries that 'describe table_name' to get the field names associated
with the positions in the table.

If this can't be done, then so be it.  It would just save me a very
large headache if it's out there and available.

Thanks in advance for your help,

Kay Bowen

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

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 loves FreeBSD (but not NetBSD) ...

[Haapanen, Tom]

Ken,

I have absolutely no complaints at all about the support I got on this
mailing list from the MySQL team -- they were very helpful, and provided
many good suggestions.  Unfortunately none of them worked, but such is life.

I am happy that MySQL is stable on FreeBSD -- I was ready to go all the way
to Red Hat, but I'm glad I was able to get FreeBSD running with the binary
MySQL package with very little pain.  And FreeBSD is close enough to NetBSD
that administration really isn't a big issue.  (Linux would have been far
more painful for us, as we don't run any Linux boxes right now.)

Oh, and I'm quite aware of the difficulty of debugging threading, from my
"other life."  It's painful at best of times (with NT and MSVC), and
excruciatingly difficult when you have to work with debuggers that have
minimal threading support -- which, alas, includes most free UNIXes.
(Incidentally, we are in the process of OEM licensing MySQL for that company
as well, so I do hope that provides some support for the project as well.)

Anyway, kudos to MySQL team for creating a great product, and for making it
work on as many platforms as it does ...

Tom Haapanen
[EMAIL PROTECTED] (nights)
[EMAIL PROTECTED] (days)


-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 July, 2001 10:51
To: Haapanen, Tom; 
Subject: Re: MySQL loves FreeBSD (but not NetBSD) ...


Hi Tom,
   As another user of MySQL on FreeBSD,  I can tell you from my own
experience that the MySQL Team is dedicated to having MySQL run on as
many platforms as possible.  I say this as an almost direct quote from
e-mail Monty sent me.  Things were not always smooth with FreeBSD
threads, it is only through quite a bit of work by some dedicated
people that this has smoothed out.  There are still issues that
remain, but they are not with MySQL.  They MySQL Team has gone out of
thier way to help debug OS threads problems.  I imagine more emphasis
will be placed on reliable pthreads libraries when the new threads
based apache web server moves out of alpha test phase and onto
production systems.

It is not easy to debug these these type of things,  the main issue is
getting some who understands threads debugging on the OS involved to
look at the code and/or writing a test program that duplicates the
problem.  Neither of these is a trivial task,  and of course the MySQL
team needs to feed  thier families, and continue to move the product
forward.  I and my company support MySQL AB (to make it clear) in both
words and financialy (I have a login support contract).   They are a
dedicated hard working group, and I am sure they are as interested as
you in the problems on NetBSD, however I think it is amazing that they
run on as many platforms as they do now without problems!  But there
is a limited amount of resources to go around, and as there are more
Linux (mysql) users than FreeBSD,  problems tend to get noticed and
fixed there first.  I think it might be similer with NetBSD and
OpenBSD,  there just less users, therefor less testing and since MySQL
is very USER supported there exists less support.  I am not saying
anything bad about OpenBSD or NetBSD,  just that it seems there are
less users on this list.  The more users looking at an issue,  the
more likely someone will find the answer/problem.

So in a nutshell what I am saying is you don't have to give up if you
really feel you want to run on NetBSD.  Go rally the people together
to find the problem.  If you can support financialy do it.  If you
support bu collecting the right people, do that.  But if the users
don't get involved at some level the problems may not go away,  or a
different user group may solve the problem for a different reason (IE
Apache).  But the users have to get involved, it's part of what open
source is all about!

Best of luck to you what ever your decison!

Ken

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

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: FreeBSD issues

[Institute For Social Ecology]

Ken,

Thank you for your very helpful notes.  We took your advice and
updated to FreeBSD 4.3 and the last version of MYSQL.  We are still
experiencing problems with MYSQL, though.  We installed it fresh, with
no freeBSD tweaks.  I was not able to locate the email you referred to
regarding FreeBSD installs.  If you have any pointers on tweaking a
freeBSD install, it would be very helpful.

Regards,

Michael Caplan


-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 3:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: FreeBSD issues


Hi Michael,
   As another FreeBSD user that has posted many times on FreeBSD
topics realted to MySQL it only took me a few minutes to find
resolutions,  the problem is that some of the thread topics are
related and the answers were posted in a different thread from the
ones that orginally started a question.  I think the search engine
could be improved!

Freebsd 4.2 does have a number of bugs related to threads and the
compiler for threaded programs .  (Search 'freebsd compiler threads)
first topic on second page) I would recommend an upgrade to 4.3 and an
upgrade to a more recent MySQL is also highly recommended (3.23.39 or
.40 when it comes outs).

Upgrade your ports collection and install from ports or find my
previous posts or e-mail me direclty and I will send you some
compilation instructions as the manual seems to be outdated in
relation to compiling freebsd.

Best of luck, hope this helps
Ken
- Original Message -
From: "Michael Caplan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 5:54 PM
Subject: FreeBSD issues


> Hello,
>
> I am working with MySQL (Ver 9.38 Distrib 3.22.32, for -freebsd4.1.1
> (i386)) on FreeBSD 4.2-STABLE running (I believe) on a dual 233
Intel
> box.  We have been having some problems as of recently where system
> swap becomes flooded and the system is brought to a halt.  We
believe
> we have isolated the problem to MySQLd.
>
> In searching through the mysql discussion list, I noticed several
> people raising similar issues on FreeBSD systems.  I did not however
> come across any solutions.  Perhaps I missed something.  What are
the
> current install recommendations for the above mentioned system, and
> has the above mentioned problem been resolved?
>
> Regards,
>
> Michael Caplan
>
>
> 
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

how to give database connection to oracle and mysql

[uma]

My application is to give database connection to oracle which is in sun solaris 
machine and to mysql which is in windowsNT machine.  How to write a java program to 
establish connection.  please help me.

Buffering SELECT results without using temporary tables; "Locked tables while 'Sending data'" revisited

[Martin Ling]

We are currently working with a table containing ~650MB of data in
700,000 rows. In attempting to select from this, we would typically find
long holdups with process states listed as creating temporary tables.

By using SQL_SMALL_RESULT we were able to greatly reduce the time taken
for select operations; all seemed merry, but we then began accumulating
apparently hung processes in a 'Sending data' state. Looking for
solutions to this, I came across the 'Locked tables while "Sending
data"' thread of March last year -

(begins: http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/Mar.2000/1029.html )

- which eventually led to the creation of the SQL_BUFFER_RESULT option.

However, using both SQL_SMALL_RESULT and SQL_BUFFER_RESULT brings us
back to holdups creating temporary tables (it seems the reasoning in the
aforementioned thread was that results are buffered when using temp
tables, and this is a nicer way of forcing that than various hacks).

Which is all very well, if you're not handling quite so much data.

What we really need is for the query results to be buffered for sending
to the client *without* forcing a temporary table.

But, hang on - from
http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/Mar.2000/1445.html , it
shouldn't be using one anyway if SQL_SMALL_RESULT is set.

Perhaps we should be looking instead at just killing off select
processes after a certain timeout; unless I've missed it there's no
option for this, so I was considering writing a daemon client to poll
the processlist and kill off the geriatrics. They then sit there in
state 'Killed' rather than 'Sending data' though. May be harmless either
way, of course.

Anyway, this is as far as I've got for now with investigating - advice
at this point would be greatly appreciated.

Thanks in advance,


Martin

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

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

RE: MySQL or MS SQL?

[Quentin Bennett]

Hi,

Agreed

Just because software is developed on a 'Free' platform, doesn't mean that
the customer expects the application to be free, or even cheap.

Our experience is that if you give something away, then people expect the
support/upgrades/customisations to be free to. If you charge, even a nominal
amount, it puts in to the mind of the customer that nothing comes for free.

Regards

Quentin

-Original Message-
From: Michael Bacarella [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 19 July 2001 7:47 a.m.
To: Chris Cameron
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL or MS SQL?


On Wed, Jul 18, 2001 at 12:38:29PM -0600, Chris Cameron wrote:

I think people who use proprietary software systems are just
accustomed to being gouged by ridiculous software costs.

Not to mention that it also costs us more to accomodate them.

Basically, distorting the argument a little, you could be saying
"Our proprietary software customers make us more money because
their platforms require far more support, and we make them
pay dearly for it".

If that works for you, great. Personally, you couldn't pay me
enough to maintain proprietary systems. :)

I'm sorry to say that your experiences do not coincide with
mine. We've seen cheapskates of all flavors and colors.

Also, just what are your clients doing dictating the software
platform you should be using? You're the technical consultant,
you should be choosing the platform!

In my experience, customers don't ask for applications developed
on free software. They just ask for applications. The fact that
they're developed using free software matters not one bit to them.

-MB

> I'm sure if done right, MySQL could do whatever you want satisfactorily.
> Same with MS SQL (ignoring cost).
> 
> However, something few people seem to know, but I've realized from
> experience is that when you offer people services based off free
> software, you get a different kind of customer. And not the good kind.
> 
> Where I work (http://www.advantcomp.com (free plug!)) we offer both
> Windows and UNIX (usually OpenBSD) solutions. When people come to us
> looking for something to be done in free unix (Linux, OpenBSD, PHP,
> MySQL, etc), they expect to pay crappy prices. And frankly they're
> crappy clients. They don't know what they want, they're only available
> to talk after hours, etc. While there are a few people who are looking
> for serious applications done in free software, they are few and far
> between.
> 
> On the other side of the coin is people looking for "enterprise
> solutions". These are people expecting to pay a lot, so they give you a
> lot. These people usually look for MS SQL/ColdFusion sort of deal. The
> Windows side of our company gets -WAY- more money than the free-UNIX
> side.
> 
> So if you're looking to make money, and have some capital to burn to
> start, I'd say use non-free software. That can be UNIX still, but not
> free-unix. Sybase, DB2 or Oracle for a database, and JSP seem to be the
> only "enterprise" solutions around for UNIX. But judging by your
> question you don't seem to be stuck with UNIX for a platform.
> 
> If you're going NT I'd be careful with Microsoft software. IIS and MS

-- 
Michael Bacarella <[EMAIL PROTECTED]>
Technical Staff / System Development,
New York Connect.Net, Ltd.

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

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

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: Multiple INSERTS syntax ...

[Philippe L. Houze]

Hi,

I found syntax for INSERT command in both Paul DuBois excellent book and
online manual but for single insert. And it works... which for a newbie like
me is thrilling. But, I am stuck for multiple inserts.

I am trying to remove from a database trailing characters (ascii 10) that
have shown up on a database after obviously a coding error in the saving of
the database. Each of the record in each field has contracted the disease...

When running: INSERT INTO customers3 (firstname) select TRIM(trailing
char(10) FROM firstname) FROM customers where id>1219; everything works
according to plan but when running: INSERT INTO customers3
(lastname,firstname) SELECT trim(trailing char(10) FROM firstname FROM
customers where id>1219, trim(trailing char(10) FROM lastname FROM customers
where id>1219; I am getting an 1064 error

I tried a SELECT trim(trailing char(10) FROM (lastname,firstname) FROM
customers where id>1219; I am also getting an 1064 error.

Any help or pointing into a direction would be greatly appreciated.
Philippe


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

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

java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

[Luc Lalancette]

I am starting using mysql and I made a java SimpleQuery servlet that is suppose to 
retreive one row from the database. However, when I try to connect I get that message 
from the Subject. I know I'm suppose to pass the password but can't seem to find a way 
of doing it. I was wondering if the problem was with those two lines or if it was in 
the tdx mysql driver default configuration in the ODBC.
 
Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;");

I would appreciate if someone could help me to get my connection going.
Thank you very much
Luc Lalancette

Problem with keys in MyISAM tables

[Marek Wojcik]

The MySQL documentation says that one can have 32 keys/table
for MyISAM table and that this can be extended to 64 keys/table
without recompiling myisamcheck.

I could not find any info on how to extend this limit.
Could anyone help me about it?

--
Marek Wójcik
[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: using InnoDB ==> transactions (rollback) don't work

[Heikki Tuuri]

George,

the default in MySQL is

set autocommit = 1;

To be able to do rollbacks you have to execute

set autocommit = 0;

Then you can do

insert into ...;

rollback;

I assume you specified in CREATE TABLE ... (...) TYPE=INNODB?

Regards,

Heikki


Copied message:
.
Hello everybody !

I'm doing some evaluating on MySQL using InnoDB tables (I need
transactions).

However, I failed admirably in trying to do a "rollback".
I read in the InnoDB manual that several statements (like ALTER,
CREATE, ...) cause an implicit COMMIT,
but it seems like it is doing the same when I do a simple operationlike:
INSERT INTO USR (LOGNAME, PASSWORD, NAME, LASTNAME, EMAIL, CREATED,
CHANGED, STATUS, COUNTRYCODE, PHONETYPEID, LANGUAGECODE)
VALUES ('suop', 'x', 'SuOp', 'SuperOperator',
'[EMAIL PROTECTED]', sysdate(), sysdate(), 'A', 'DE', '1','en');
I am not able to do a rollback on this operation.

Has someone a clue why ? 

Obviously I'm missing an important part in
the installation / configuration, but I don't have any idea (as the
saying goes: I don't see the tree because of the forest).
Any comments ? 

Thanks - and be kind to each other ;)


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

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

Network connection

[Chuck Lidderdale]

Haven't been able to find this in the docs.

$db = mysql_pconnect ("anothermachine:oracleport", "user", "passwd") or
die ..

I need to connect to an oracle DB - can I?  Or do I have to run a ?cgi?
style
script / program to get there?

Tks
Chuck L.



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

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

[Heikki Tuuri]

Hi!

I tested what happens if you already have a data file
but in my.cnf you have not specified the file size.

Then InnoDB just exits because there is a syntax error
in innodb_data_file_path

You should delete all your data and log files, write your my.cnf
or my.ini so that you specify also the data file size:

innodb_data_file_path=ibdata1:37M

and try starting MySQL server again.

Hope it succeeds this time,

Heikki

-Original Message-
From: Pete Kuczynski <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, July 18, 2001 10:48 PM
Subject: Re: innodb on nt4


I did,
see below from my prev email, that part works fine:
innodb_data_home_dir=c:/mysql
innodb_data_file_path=ibdata1

like I said, the system created a 10mb file called ibdata1 in c:\mysql

But to recap, when I try to add the specifications for logs, it wort
start, that's the next line:

innodb_log_group_home_dir = c:\iblogs

Pete




Heikki Tuuri wrote:
>
> Hi!
>
> You have to specify also the data file size in innodb_data_file_path. The
> following example is
> from the manual at www.innodb.com:
>
> Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB
> hard disk. Below is an example of possible configuration parameters in
> `my.cnf' for InnoDB:
>
> [mysqld]
> # You can write your other MySQL server options here
> # ...
> #
> innodb_data_home_dir = c:\ibdata
> innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
> set-variable = innodb_mirrored_log_groups=1
> innodb_log_group_home_dir = c:\iblogs
> set-variable = innodb_log_files_in_group=3
> set-variable = innodb_log_file_size=30M
> set-variable = innodb_log_buffer_size=8M
> innodb_flush_log_at_trx_commit=1
> innodb_log_arch_dir = c:\iblogs
> innodb_log_archive=0
> set-variable = innodb_buffer_pool_size=80M
> set-variable = innodb_additional_mem_pool_size=10M
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
>
> I think it is easiest that you copy and paste the above to your my.cnf
> and adjust directories, file sizes, and pool sizes to your needs. Files
must
> be
> < 4 GB currently.
>
> Hope it now succeeds!
>
> Heikki
>
> -Original Message-
> From: Pete Kuczynski <[EMAIL PROTECTED]>
> To: Heikki Tuuri <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Wednesday, July 18, 2001 10:14 PM
> Subject: Re: innodb on nt4
>
> Ok, got the following line working in my.ini, it created a 10mb ibdata
> file:
> innodb_data_home_dir=c:/mysql
> innodb_data_file_path=ibdata1
> set-variable=innodb_mirrored_log_groups=1
>
> but, when I add innodb_log_group_home_dir=c:/iblogs
>
> mysyl won't start. I created a iblogs directory.
>
> Any ideas?
>
> Pete
>
> Heikki Tuuri wrote:
> >
> > Pete,
> >
> > no, below you have a path:
> >
> > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> >
> > ibdata is a directory name, not a file name. InnoDB will add the
> > extra backslash after it. But InnoDB does not create directories.
> > You must manually create the directories you use.
> >
> > Regards,
> >
> > Heikki
> > http://www.innodb.com
> >
> > Copied message:
> > .
> > Hi,
> >
> > have a question about the inno_data_home_dir line on mysql-max3.23
> > do I create a file called "ibdata" cause it's not in any directory by
> > default by default.
> >
> > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> >
> > Pete
> >
> > Crercio Osmaildo da Silva wrote:
> > >
> > > Hi,
> > >
> > > For windows systems, you can install mysql-max-3.23.39, that has
support
> > for
> > > both BDB and InnoDB. For InnoDB you need to change my.cnf and include
> > these
> > > lines:> > # For Innodb Databases
> > > # change D:\WebApp\mysql\innodb and the other parameters to fit your>
#
> > needs
> > > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> > > innodb_data_file_path = ibdata1:20M;ibdata2:20M
> > > set-variable = innodb_mirrored_log_groups=1
> > > innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs
> > > set-variable = innodb_log_files_in_group=3
> > > set-variable = innodb_log_file_size=30M
> > > set-variable = innodb_log_buffer_size=8M>
> innodb_flush_log_at_trx_commit=1
> > > innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs>
> innodb_log_archive=0
> > > set-variable = innodb_buffer_pool_size=80M
> > > set-variable = innodb_additional_mem_pool_size=10M
> > > set-variable = innodb_file_io_threads=4
> > > set-variable = innodb_lock_wait_timeout=50>
> > > Then you use mysql\bin\mysqld-max-nt --install to install it as a
> service.
> > > You can run SHOW VARIABLES to see the which table types are
available.>
> > > That's it.>
> > > If you need more help, just email-me. I'd be glad to help you out.> >
> > []'s>
> > > Crercio O. Silva> > -Original Message-
> > > From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> > > Sent: terça-feira, 17 de julho de 2001 11:20> To:
[EMAIL PROTECTED]
> > > Subject: innodb on nt4>
> > > Ok, tried to updat

Re: MySQL or MS SQL?

[Rich Duzenbury]

I like MySQL, and I'm fairly new at it, but if I were to need to store and 
retrieve tens of Gb's, I would want an IBM AS/400.  Base configurations are 
quite reliable, and you can easily add RAID and other types of redundant 
support, up to and including redundant machines.  I work with numerous 
hospitals and it is their preferred platform for storing their 
financials  (AR/AP/GL/Payroll) as well as their medical records.

I will stress that this is my opinion, and I realize that it may not be a 
popular one on this forum -- You are, of course, entitled to yours.

At 09:51 PM 7/18/01 +0400, Alexander Chernienko wrote:
>Hi all,
>
>I'm currently writing proposals for a customer who want to hire our little
>programming team for creating corporate information system, wich includes
>huge database with number of records between 1-10 millions (incl. blobs -
>pictures). Expected database size is tens of Gb.


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

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

Transaction for MySQL

[Michael Tam]

Hi all,

I am new using MySQL.  I found out that the default table type used in the binary 
isn't support transaction and would like to make MySQL uses another table type which 
supports transaction.  The following are my questions regarding the issue:

1) which one should I use InnoDB or BDB?  what kind of advantages given by each type?

2) currently, I am using the default type - MyISAM, where I am running MySqld-nt.  If 
I would like to switch to another
table type.  Do I just uninstall the service of MySqld-nt from win2000 and install 
MySqld-Max service?? 
In addition to the daemond, I need to comment out the MyISAM config

3) what would happen to my existing MyISAM type tables which already exists in MySQL 
if I do the switch over? and
   would I able to use/create MyISAM type table uder MySqld-Max??

Thank you and greatly appreciated for any suggestion/help.

Regards,
Michael

Re: MySQL loves FreeBSD (but not NetBSD) ...

[Brian Reichert]

On Tue, Jul 17, 2001 at 10:05:24PM -0400, Haapanen, Tom wrote:
> ... or should that be "FreeBSD loves MySQL"?
> 
> I finally caved in after a year of increasing (and unexplained) MySQL
> crashes, despite numerous updates to more recent versions of NetBSD and
> MySQL, and dozens of experiments with different configuration options.
> MySQL would die (and restart automatically) every 5-15 minutes on the
> database server acting as the back end for our web site, motorsport.com.
> (This on NetBSD/i386, as when we started, MySQL was distinctly unhappy with
> NetBSD/Alpha)

FWIW - I had nasty problems with stable builds under FreeBSD, until
I noticed the build process was trying to make use of '-O6' when
compiling C++ code using GCC 2.95.2 ; not a good combination.

When I switched to using

  env CC=gcc CFLAGS="-O2" CXX=gcc \
 CXXFLAGS="-O2 -felide-constructors -fno-exceptions -fno-rtti" \
  ./configure ...

To configure, the binary was much more stable.  (This is as of
mysql-3.23.35.)  Maybe that was a similar issue under NetBSD...

-- 
Brian 'you Bastard' Reichert<[EMAIL PROTECTED]>
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

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

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

replication issue with FreeBSD 4.2-RELEASE

[Brian Reichert]

I'm exploring mysql replication under FreeBSD 4.2-RELEASE.

Two machines, named 'master' and 'slave', each running FreeBSD
4.2-RELEASE and MySQL 3.23.36-debug.

I've followed the instructions at

  

All very straight forward.

When I spin everything up, I see these errors on the slave server:

  /usr/local/libexec/mysqld: ready for connections

  010718 19:28:17  Slave: connected to master '[EMAIL PROTECTED]:3306',
  replication started in log 'FIRST' at position 4

  010718 19:29:22  Error reading packet from server: Lost connection
  to MySQL server during query (read_errno 35,server_errno=2013)

  010718 19:29:22  Slave: Failed reading log event, reconnecting
  to retry, log 'master-bin.001' position 803

  010718 19:29:22  Slave: reconnected to master
  '[EMAIL PROTECTED]:3306',replication resumed in log 'master-bin.001'
  at position 803

And the last two errors just keep repeating.  I can otherwise
connect just fine:

  slave% mysql -u repl -prepl -h master.xxx.xxx
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 58 to server version: 3.23.36-debug-log
  
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer
  
  mysql> quit
  Bye

I presume 'read_errno 35' refers to:

   35 EAGAIN Resource temporarily unavailable. This is a
   temporary condition and later calls to the same routine may
   complete normally.

Does anyone have any insight?  Funky hardware?  The list has mentioned 
4.2-RELEASE having threading problems, fixed in 4.3.  Might this be the
case?  I don't want to have to upgrade the OS, out-of-hand.

Upgrade the version of MySQL on the master a/o slave?  I see some
changes WRT replication:

  F.2.1 Changes in release 3.23.40
   
 Added slave_wait_timeout for replication. 

  F.2.3 Changes in release 3.23.38

 Better error message when slave max_allowed_packet is too low
 to read a very long log event from the master.

  F.2.4 Changes in release 3.23.37

 Fixed bug that erroneously logged a drop of internal temporary
 table on thread termination to the binary log - bug affected
 replication.

Would any of these apply to the errors I'm seeing?

-- 
Brian 'you Bastard' Reichert<[EMAIL PROTECTED]>
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

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

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

Inserts Broken after database move

[Karim A Nassar]

I am using 3.22.32. The directrory where the databases lived was nearly
full. Following the instructions in the manual, I stopped mysqld, I tar'd
up the db's, moved them to the new location, created symlinks in the
original location, restarted mysql (using safe_mysql). I now have the
problem that inserts claim to work but I cannot access the data. For
example:

INSERT INTO main.houses (clientid, state, city, county) VALUES
('', 'Florida', 'Ft. Lauderdale', 'Broward County');

SELECT * from main.houses WHERE clientid=;

Returns nothing.

The only thing I can think of is that safe_mysqld needs a param that I am
not passing it, but it has the databases, and the executables and the
correct user. (I can connect to all db's, but cannot insert)

Any help out there?

Thanks in advance,
-- Karim Nassar




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

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

Replication Offset off by 22 bug fixed

[Sasha Pachev]

Hello, everyone:

Good news - I was able to repeat and fix the bug that several people have 
reported but were not able to repeat. No wonder - even after I noticed the 
problem in the source, it took some creative work to be able to write a test 
case for it. ( We try to write a test case for every bug we find, even if we 
find it just by visual inspection). 

The symptom of the bug was that you would get a message in the slave error 
log about the lost connection due to a low setting of max_allowed_packet when 
max_allowed_packet setting was not the problem at all. 

The fix is to upgrade to 3.23.40, which should be out within 24 hours ( this 
is why I have not bothered to make a patch, if somebody really cannot wait, 
let me know).

To work around, if you hit this problem before 3.23.40 becomes available, do:

SLAVE STOP;
SHOW SLAVE STATUS;
remember the offset
subtract 22 from it and obtain the value of new_pos
CHANGE MASTER TO MASTER_LOG_POS=new_pos   
SLAVE START;

Let's hope this is the last replication bug in 3.23 :-)

-- 
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

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

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: PLEASE help me!! MySQL Linux Problem

[Mike Baranski]

Read the man page for gcc and note the command line switch to point the 
linker at specific libraries, then use those switches on the command line.  
This is a linker error, rather than a compiler error:

Example:
g++ myGreatProgram.cpp -L/usr/mysql/lib -lmysqlclient



On Wednesday 18 July 2001 15:28, David Ayliffe wrote:
> I am having A LOT of trouble compiling the code Simple1.cc which comes
> with the C++ API for Linux
> I have extracted the API to a directory in /root/ and MySQL is installed
> and works in /usr/local/mysql
>
> PLEASE someone please help me compile just this simple program.  What am
> I missing?
>
> When I compile it I include the path to the header files to mysql and of
> the mysql API.
>
> I am running Suse Linux 7.1 professional with Kernel 2.4
> This is what I get when I try and compile it:
>
>
> pc-xxx-31-190-xxx-du:~/mysql++-1.7.9/examples # g++ simple1.cc
> -I/root/mysql++-1.7.9/sqlplusint/ -I/usr/local/mysql/include
> /tmp/ccvKKWW7.o: In function `main':
> /tmp/ccvKKWW7.o(.text+0x30): undefined reference to
> `MysqlConnection::MysqlConnection(char const *, char const *, char const
> *, char const *, bool)'
> /tmp/ccvKKWW7.o(.text+0x55b): undefined reference to `operator<<(ostream
> &, mysql_ColData const &)'
> /tmp/ccvKKWW7.o(.text+0x6a2): undefined reference to
> `MysqlConnection::~MysqlConnection(void)'
> /tmp/ccvKKWW7.o(.text+0x80d): undefined reference to
> `MysqlConnection::~MysqlConnection(void)'
> /tmp/ccvKKWW7.o(.rodata+0x1ac): undefined reference to `mysql_date
> type_info node'
> /tmp/ccvKKWW7.o(.rodata+0x1e4): undefined reference to `mysql_time
> type_info node'
> /tmp/ccvKKWW7.o: In function `MysqlDate type_info function':
> /tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlDate+0x18): undefined
> reference to `mysql_date type_info function'
> /tmp/ccvKKWW7.o: In function `MysqlTime type_info function':
> /tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlTime+0x18): undefined
> reference to `mysql_time type_info function'
> /tmp/ccvKKWW7.o: In function `MysqlRes::~MysqlRes(void)':
> /tmp/ccvKKWW7.o(.gnu.linkonce.t._._8MysqlRes+0x1b): undefined reference
> to `MysqlResUse::~MysqlResUse(void)'
> /tmp/ccvKKWW7.o: In function `MysqlQuery::preview(void)':
> /tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.preview(void)+0x1b):
> undefined reference to `SQLQuery::str(SQLQueryParms const &) const'
> /tmp/ccvKKWW7.o: In function `MysqlRes::num_rows(void) const':
> /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.num_rows(void) const+0x14):
> undefined reference to `mysql_num_rows'
> /tmp/ccvKKWW7.o: In function `MysqlQuery::store(SQLQueryParms &,
> query_reset)':
> /tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.store(SQLQueryParms &,
> query_reset) +0x40): undefined reference to `SQLQuery::str(SQLQueryParms
> const &, query_reset)'
> /tmp/ccvKKWW7.o: In function
> `MysqlFieldNames::MysqlFieldNames(MysqlResUse const *)':
> /tmp/ccvKKWW7.o(.MysqlFieldNames::gnu.linkonce.t.(MysqlResUse const
> *)+0x4d): undefined reference to `MysqlFieldNames::init(MysqlResUse
> const
> *)'
> /tmp/ccvKKWW7.o: In function `MysqlResUse::num_fields(void) const':
> /tmp/ccvKKWW7.o(.MysqlResUse::gnu.linkonce.t.num_fields(void)
> const+0x12): undefined reference to `mysql_num_fields'
> /tmp/ccvKKWW7.o: In function `MysqlRes::fetch_row(void) const':
> /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xd8):
> undefined reference to `mysql_fetch_row'
> /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xec):
> undefined reference to `mysql_fetch_lengths'
> /tmp/ccvKKWW7.o: In function `MysqlRes::data_seek(unsigned int) const':
> /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.data_seek(unsigned int)
> const+0x1c): undefined reference to `mysql_data_seek'
> /tmp/ccvKKWW7.o: In function `MysqlConnection::store(basic_string string_char_traits, __default_alloc_template > const &)':
> /tmp/ccvKKWW7.o(.MysqlConnection::gnu.linkonce.t.store(basic_string ,
> string_char_traits, __default_alloc_template > const
> &)+0x1d): undefined reference to
> `MysqlConnection::store(basic_string,
> __default_alloc_template > const &, bool)'
> /tmp/ccvKKWW7.o: In function `FieldTypes::FieldTypes(MysqlResUse const
> *)':
> /tmp/ccvKKWW7.o(.FieldTypes::gnu.linkonce.t.(MysqlResUse const *)+0x4d):
> undefined reference to `FieldTypes::init(MysqlResUse const *)'
> collect2: ld returned 1 exit status
>
>
>
>
> Please please someone help.   This is REALLY starting to get on my
> nerves now!!
>
> Thanks lots
> David Ayliffe ([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://w

Re: innodb on nt4

[Pete Kuczynski]

I did,
see below from my prev email, that part works fine:
innodb_data_home_dir=c:/mysql
innodb_data_file_path=ibdata1

like I said, the system created a 10mb file called ibdata1 in c:\mysql

But to recap, when I try to add the specifications for logs, it wort
start, that's the next line:

innodb_log_group_home_dir = c:\iblogs

Pete




Heikki Tuuri wrote:
> 
> Hi!
> 
> You have to specify also the data file size in innodb_data_file_path. The
> following example is
> from the manual at www.innodb.com:
> 
> Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB
> hard disk. Below is an example of possible configuration parameters in
> `my.cnf' for InnoDB:
> 
> [mysqld]
> # You can write your other MySQL server options here
> # ...
> #
> innodb_data_home_dir = c:\ibdata
> innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
> set-variable = innodb_mirrored_log_groups=1
> innodb_log_group_home_dir = c:\iblogs
> set-variable = innodb_log_files_in_group=3
> set-variable = innodb_log_file_size=30M
> set-variable = innodb_log_buffer_size=8M
> innodb_flush_log_at_trx_commit=1
> innodb_log_arch_dir = c:\iblogs
> innodb_log_archive=0
> set-variable = innodb_buffer_pool_size=80M
> set-variable = innodb_additional_mem_pool_size=10M
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
> 
> I think it is easiest that you copy and paste the above to your my.cnf
> and adjust directories, file sizes, and pool sizes to your needs. Files must
> be
> < 4 GB currently.
> 
> Hope it now succeeds!
> 
> Heikki
> 
> -Original Message-
> From: Pete Kuczynski <[EMAIL PROTECTED]>
> To: Heikki Tuuri <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Wednesday, July 18, 2001 10:14 PM
> Subject: Re: innodb on nt4
> 
> Ok, got the following line working in my.ini, it created a 10mb ibdata
> file:
> innodb_data_home_dir=c:/mysql
> innodb_data_file_path=ibdata1
> set-variable=innodb_mirrored_log_groups=1
> 
> but, when I add innodb_log_group_home_dir=c:/iblogs
> 
> mysyl won't start. I created a iblogs directory.
> 
> Any ideas?
> 
> Pete
> 
> Heikki Tuuri wrote:
> >
> > Pete,
> >
> > no, below you have a path:
> >
> > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> >
> > ibdata is a directory name, not a file name. InnoDB will add the
> > extra backslash after it. But InnoDB does not create directories.
> > You must manually create the directories you use.
> >
> > Regards,
> >
> > Heikki
> > http://www.innodb.com
> >
> > Copied message:
> > .
> > Hi,
> >
> > have a question about the inno_data_home_dir line on mysql-max3.23
> > do I create a file called "ibdata" cause it's not in any directory by
> > default by default.
> >
> > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> >
> > Pete
> >
> > Crercio Osmaildo da Silva wrote:
> > >
> > > Hi,
> > >
> > > For windows systems, you can install mysql-max-3.23.39, that has support
> > for
> > > both BDB and InnoDB. For InnoDB you need to change my.cnf and include
> > these
> > > lines:> > # For Innodb Databases
> > > # change D:\WebApp\mysql\innodb and the other parameters to fit your> #
> > needs
> > > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> > > innodb_data_file_path = ibdata1:20M;ibdata2:20M
> > > set-variable = innodb_mirrored_log_groups=1
> > > innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs
> > > set-variable = innodb_log_files_in_group=3
> > > set-variable = innodb_log_file_size=30M
> > > set-variable = innodb_log_buffer_size=8M>
> innodb_flush_log_at_trx_commit=1
> > > innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs>
> innodb_log_archive=0
> > > set-variable = innodb_buffer_pool_size=80M
> > > set-variable = innodb_additional_mem_pool_size=10M
> > > set-variable = innodb_file_io_threads=4
> > > set-variable = innodb_lock_wait_timeout=50>
> > > Then you use mysql\bin\mysqld-max-nt --install to install it as a
> service.
> > > You can run SHOW VARIABLES to see the which table types are available.>
> > > That's it.>
> > > If you need more help, just email-me. I'd be glad to help you out.> >
> > []'s>
> > > Crercio O. Silva> > -Original Message-
> > > From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> > > Sent: terça-feira, 17 de julho de 2001 11:20> To: [EMAIL PROTECTED]
> > > Subject: innodb on nt4>
> > > Ok, tried to update existing table(s) to InnoDB [from MYISAM] using
> > > "alter table da_table type=InnoDB;, but show variables still shows
> > > table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it
> > > installs with MYISAM only, not InnoDB options.>
> > > I cannot find any documentation on instaling mysql on NT with InnoDB
> > > "compiled" in. Is there such a thing? Where?
> > > Bottom line, how do I get InnoDB "compiled" in with a standard mysql
> > > database installation. All I want out of this is transaction support.>
> > > Best Rgards!> > Pete> > ___
> > > Pete Kuczynski> 

Re: MySQL or MS SQL?

[Michael Bacarella]

On Wed, Jul 18, 2001 at 12:38:29PM -0600, Chris Cameron wrote:

I think people who use proprietary software systems are just
accustomed to being gouged by ridiculous software costs.

Not to mention that it also costs us more to accomodate them.

Basically, distorting the argument a little, you could be saying
"Our proprietary software customers make us more money because
their platforms require far more support, and we make them
pay dearly for it".

If that works for you, great. Personally, you couldn't pay me
enough to maintain proprietary systems. :)

I'm sorry to say that your experiences do not coincide with
mine. We've seen cheapskates of all flavors and colors.

Also, just what are your clients doing dictating the software
platform you should be using? You're the technical consultant,
you should be choosing the platform!

In my experience, customers don't ask for applications developed
on free software. They just ask for applications. The fact that
they're developed using free software matters not one bit to them.

-MB

> I'm sure if done right, MySQL could do whatever you want satisfactorily.
> Same with MS SQL (ignoring cost).
> 
> However, something few people seem to know, but I've realized from
> experience is that when you offer people services based off free
> software, you get a different kind of customer. And not the good kind.
> 
> Where I work (http://www.advantcomp.com (free plug!)) we offer both
> Windows and UNIX (usually OpenBSD) solutions. When people come to us
> looking for something to be done in free unix (Linux, OpenBSD, PHP,
> MySQL, etc), they expect to pay crappy prices. And frankly they're
> crappy clients. They don't know what they want, they're only available
> to talk after hours, etc. While there are a few people who are looking
> for serious applications done in free software, they are few and far
> between.
> 
> On the other side of the coin is people looking for "enterprise
> solutions". These are people expecting to pay a lot, so they give you a
> lot. These people usually look for MS SQL/ColdFusion sort of deal. The
> Windows side of our company gets -WAY- more money than the free-UNIX
> side.
> 
> So if you're looking to make money, and have some capital to burn to
> start, I'd say use non-free software. That can be UNIX still, but not
> free-unix. Sybase, DB2 or Oracle for a database, and JSP seem to be the
> only "enterprise" solutions around for UNIX. But judging by your
> question you don't seem to be stuck with UNIX for a platform.
> 
> If you're going NT I'd be careful with Microsoft software. IIS and MS

-- 
Michael Bacarella <[EMAIL PROTECTED]>
Technical Staff / System Development,
New York Connect.Net, Ltd.

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

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

PLEASE help me!! MySQL Linux Problem

[David Ayliffe]

I am having A LOT of trouble compiling the code Simple1.cc which comes
with the C++ API for Linux
I have extracted the API to a directory in /root/ and MySQL is installed
and works in /usr/local/mysql

PLEASE someone please help me compile just this simple program.  What am
I missing?  

When I compile it I include the path to the header files to mysql and of
the mysql API.

I am running Suse Linux 7.1 professional with Kernel 2.4
This is what I get when I try and compile it:


pc-xxx-31-190-xxx-du:~/mysql++-1.7.9/examples # g++ simple1.cc
-I/root/mysql++-1.7.9/sqlplusint/ -I/usr/local/mysql/include
/tmp/ccvKKWW7.o: In function `main':
/tmp/ccvKKWW7.o(.text+0x30): undefined reference to
`MysqlConnection::MysqlConnection(char const *, char const *, char const
*, char const *, bool)'
/tmp/ccvKKWW7.o(.text+0x55b): undefined reference to `operator<<(ostream
&, mysql_ColData const &)'
/tmp/ccvKKWW7.o(.text+0x6a2): undefined reference to
`MysqlConnection::~MysqlConnection(void)'
/tmp/ccvKKWW7.o(.text+0x80d): undefined reference to
`MysqlConnection::~MysqlConnection(void)'
/tmp/ccvKKWW7.o(.rodata+0x1ac): undefined reference to `mysql_date
type_info node'
/tmp/ccvKKWW7.o(.rodata+0x1e4): undefined reference to `mysql_time
type_info node'
/tmp/ccvKKWW7.o: In function `MysqlDate type_info function':
/tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlDate+0x18): undefined
reference to `mysql_date type_info function'
/tmp/ccvKKWW7.o: In function `MysqlTime type_info function':
/tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlTime+0x18): undefined
reference to `mysql_time type_info function'
/tmp/ccvKKWW7.o: In function `MysqlRes::~MysqlRes(void)':
/tmp/ccvKKWW7.o(.gnu.linkonce.t._._8MysqlRes+0x1b): undefined reference
to `MysqlResUse::~MysqlResUse(void)'
/tmp/ccvKKWW7.o: In function `MysqlQuery::preview(void)':
/tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.preview(void)+0x1b):
undefined reference to `SQLQuery::str(SQLQueryParms const &) const'
/tmp/ccvKKWW7.o: In function `MysqlRes::num_rows(void) const':
/tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.num_rows(void) const+0x14):
undefined reference to `mysql_num_rows'
/tmp/ccvKKWW7.o: In function `MysqlQuery::store(SQLQueryParms &,
query_reset)':
/tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.store(SQLQueryParms &,
query_reset) +0x40): undefined reference to `SQLQuery::str(SQLQueryParms
const &, query_reset)'
/tmp/ccvKKWW7.o: In function
`MysqlFieldNames::MysqlFieldNames(MysqlResUse const *)':
/tmp/ccvKKWW7.o(.MysqlFieldNames::gnu.linkonce.t.(MysqlResUse const
*)+0x4d): undefined reference to `MysqlFieldNames::init(MysqlResUse
const
*)'
/tmp/ccvKKWW7.o: In function `MysqlResUse::num_fields(void) const':
/tmp/ccvKKWW7.o(.MysqlResUse::gnu.linkonce.t.num_fields(void)
const+0x12): undefined reference to `mysql_num_fields'
/tmp/ccvKKWW7.o: In function `MysqlRes::fetch_row(void) const':
/tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xd8):
undefined reference to `mysql_fetch_row'
/tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xec):
undefined reference to `mysql_fetch_lengths'
/tmp/ccvKKWW7.o: In function `MysqlRes::data_seek(unsigned int) const':
/tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.data_seek(unsigned int)
const+0x1c): undefined reference to `mysql_data_seek'
/tmp/ccvKKWW7.o: In function `MysqlConnection::store(basic_string, __default_alloc_template > const &)':
/tmp/ccvKKWW7.o(.MysqlConnection::gnu.linkonce.t.store(basic_string, __default_alloc_template > const
&)+0x1d): undefined reference to
`MysqlConnection::store(basic_string,
__default_alloc_template > const &, bool)'
/tmp/ccvKKWW7.o: In function `FieldTypes::FieldTypes(MysqlResUse const
*)':
/tmp/ccvKKWW7.o(.FieldTypes::gnu.linkonce.t.(MysqlResUse const *)+0x4d):
undefined reference to `FieldTypes::init(MysqlResUse const *)'
collect2: ld returned 1 exit status




Please please someone help.   This is REALLY starting to get on my
nerves now!!

Thanks lots
David Ayliffe ([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: innodb on nt4

[Heikki Tuuri]

Hi!

You have to specify also the data file size in innodb_data_file_path. The
following example is
from the manual at www.innodb.com:

Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB
hard disk. Below is an example of possible configuration parameters in
`my.cnf' for InnoDB:

[mysqld]
# You can write your other MySQL server options here
# ...
#
innodb_data_home_dir = c:\ibdata
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:\iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

I think it is easiest that you copy and paste the above to your my.cnf
and adjust directories, file sizes, and pool sizes to your needs. Files must
be
< 4 GB currently.

Hope it now succeeds!

Heikki

-Original Message-
From: Pete Kuczynski <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, July 18, 2001 10:14 PM
Subject: Re: innodb on nt4


Ok, got the following line working in my.ini, it created a 10mb ibdata
file:
innodb_data_home_dir=c:/mysql
innodb_data_file_path=ibdata1
set-variable=innodb_mirrored_log_groups=1

but, when I add innodb_log_group_home_dir=c:/iblogs

mysyl won't start. I created a iblogs directory.

Any ideas?

Pete

Heikki Tuuri wrote:
>
> Pete,
>
> no, below you have a path:
>
> innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
>
> ibdata is a directory name, not a file name. InnoDB will add the
> extra backslash after it. But InnoDB does not create directories.
> You must manually create the directories you use.
>
> Regards,
>
> Heikki
> http://www.innodb.com
>
> Copied message:
> .
> Hi,
>
> have a question about the inno_data_home_dir line on mysql-max3.23
> do I create a file called "ibdata" cause it's not in any directory by
> default by default.
>
> innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
>
> Pete
>
> Crercio Osmaildo da Silva wrote:
> >
> > Hi,
> >
> > For windows systems, you can install mysql-max-3.23.39, that has support
> for
> > both BDB and InnoDB. For InnoDB you need to change my.cnf and include
> these
> > lines:> > # For Innodb Databases
> > # change D:\WebApp\mysql\innodb and the other parameters to fit your> #
> needs
> > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> > innodb_data_file_path = ibdata1:20M;ibdata2:20M
> > set-variable = innodb_mirrored_log_groups=1
> > innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs
> > set-variable = innodb_log_files_in_group=3
> > set-variable = innodb_log_file_size=30M
> > set-variable = innodb_log_buffer_size=8M>
innodb_flush_log_at_trx_commit=1
> > innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs>
innodb_log_archive=0
> > set-variable = innodb_buffer_pool_size=80M
> > set-variable = innodb_additional_mem_pool_size=10M
> > set-variable = innodb_file_io_threads=4
> > set-variable = innodb_lock_wait_timeout=50>
> > Then you use mysql\bin\mysqld-max-nt --install to install it as a
service.
> > You can run SHOW VARIABLES to see the which table types are available.>
> > That's it.>
> > If you need more help, just email-me. I'd be glad to help you out.> >
> []'s>
> > Crercio O. Silva> > -Original Message-
> > From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> > Sent: terça-feira, 17 de julho de 2001 11:20> To: [EMAIL PROTECTED]
> > Subject: innodb on nt4>
> > Ok, tried to update existing table(s) to InnoDB [from MYISAM] using
> > "alter table da_table type=InnoDB;, but show variables still shows
> > table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it
> > installs with MYISAM only, not InnoDB options.>
> > I cannot find any documentation on instaling mysql on NT with InnoDB
> > "compiled" in. Is there such a thing? Where?
> > Bottom line, how do I get InnoDB "compiled" in with a standard mysql
> > database installation. All I want out of this is transaction support.>
> > Best Rgards!> > Pete> > ___
> > Pete Kuczynski> Sr. Field Engineer> DHL Airways Inc.
> > Infrastructure Technology & Services> (773)-462-9758
> > 24/7 Helpdesk 1-800-434-5767>
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)>
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php--
> ___Pete KuczynskiSr. Field Engineer
> DHL Airways Inc.Inf

Re: innodb on nt4

[Pete Kuczynski]

Ok, got the following line working in my.ini, it created a 10mb ibdata
file:
innodb_data_home_dir=c:/mysql
innodb_data_file_path=ibdata1
set-variable=innodb_mirrored_log_groups=1

but, when I add innodb_log_group_home_dir=c:/iblogs  

mysyl won't start. I created a iblogs directory.

Any ideas?

Pete

Heikki Tuuri wrote:
> 
> Pete,
> 
> no, below you have a path:
> 
> innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> 
> ibdata is a directory name, not a file name. InnoDB will add the
> extra backslash after it. But InnoDB does not create directories.
> You must manually create the directories you use.
> 
> Regards,
> 
> Heikki
> http://www.innodb.com
> 
> Copied message:
> .
> Hi,
> 
> have a question about the inno_data_home_dir line on mysql-max3.23
> do I create a file called "ibdata" cause it's not in any directory by
> default by default.
> 
> innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> 
> Pete
> 
> Crercio Osmaildo da Silva wrote:
> >
> > Hi,
> >
> > For windows systems, you can install mysql-max-3.23.39, that has support
> for
> > both BDB and InnoDB. For InnoDB you need to change my.cnf and include
> these
> > lines:> > # For Innodb Databases
> > # change D:\WebApp\mysql\innodb and the other parameters to fit your> #
> needs
> > innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
> > innodb_data_file_path = ibdata1:20M;ibdata2:20M
> > set-variable = innodb_mirrored_log_groups=1
> > innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs
> > set-variable = innodb_log_files_in_group=3
> > set-variable = innodb_log_file_size=30M
> > set-variable = innodb_log_buffer_size=8M> innodb_flush_log_at_trx_commit=1
> > innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs> innodb_log_archive=0
> > set-variable = innodb_buffer_pool_size=80M
> > set-variable = innodb_additional_mem_pool_size=10M
> > set-variable = innodb_file_io_threads=4
> > set-variable = innodb_lock_wait_timeout=50>
> > Then you use mysql\bin\mysqld-max-nt --install to install it as a service.
> > You can run SHOW VARIABLES to see the which table types are available.>
> > That's it.>
> > If you need more help, just email-me. I'd be glad to help you out.> >
> []'s>
> > Crercio O. Silva> > -Original Message-
> > From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> > Sent: terça-feira, 17 de julho de 2001 11:20> To: [EMAIL PROTECTED]
> > Subject: innodb on nt4>
> > Ok, tried to update existing table(s) to InnoDB [from MYISAM] using
> > "alter table da_table type=InnoDB;, but show variables still shows
> > table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it
> > installs with MYISAM only, not InnoDB options.>
> > I cannot find any documentation on instaling mysql on NT with InnoDB
> > "compiled" in. Is there such a thing? Where?
> > Bottom line, how do I get InnoDB "compiled" in with a standard mysql
> > database installation. All I want out of this is transaction support.>
> > Best Rgards!> > Pete> > ___
> > Pete Kuczynski> Sr. Field Engineer> DHL Airways Inc.
> > Infrastructure Technology & Services> (773)-462-9758
> > 24/7 Helpdesk 1-800-434-5767>
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)>
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php--
> ___Pete KuczynskiSr. Field Engineer
> DHL Airways Inc.Infrastructure Technology & Services(773)-462-9758
> 24/7 Helpdesk 1-800-434-5767
> -
> Before posting, please check:   http://www.mysql.com/manual.php   (the
> manual)
>http://lists.mysql.com/   (the list archive)
> To request this thread, e-mail <[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

-- 
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767


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

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

Restoring mysql database from backup and logging

[Philip Daggett]

When restoring a backup, the binlog will record all of the backup's 
commands (create tables and insert into's). Would it therefore be a good 
idea to flush the logs before a restore and then flush the logs immediately 
after so that the "restoration log" can be deleted (or ignored)?


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

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 or MS SQL?

[Chris Cameron]

I'm sure if done right, MySQL could do whatever you want satisfactorily.
Same with MS SQL (ignoring cost).

However, something few people seem to know, but I've realized from
experience is that when you offer people services based off free
software, you get a different kind of customer. And not the good kind.

Where I work (http://www.advantcomp.com (free plug!)) we offer both
Windows and UNIX (usually OpenBSD) solutions. When people come to us
looking for something to be done in free unix (Linux, OpenBSD, PHP,
MySQL, etc), they expect to pay crappy prices. And frankly they're
crappy clients. They don't know what they want, they're only available
to talk after hours, etc. While there are a few people who are looking
for serious applications done in free software, they are few and far
between.

On the other side of the coin is people looking for "enterprise
solutions". These are people expecting to pay a lot, so they give you a
lot. These people usually look for MS SQL/ColdFusion sort of deal. The
Windows side of our company gets -WAY- more money than the free-UNIX
side.

So if you're looking to make money, and have some capital to burn to
start, I'd say use non-free software. That can be UNIX still, but not
free-unix. Sybase, DB2 or Oracle for a database, and JSP seem to be the
only "enterprise" solutions around for UNIX. But judging by your
question you don't seem to be stuck with UNIX for a platform.

If you're going NT I'd be careful with Microsoft software. IIS and MS
SQL scares the crap out of me when it comes to security.

Anywho, probably way beyond what you wanted to know,
Chris

-Original Message-
From: Alexander Chernienko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:51 AM
To: [EMAIL PROTECTED]
Subject: MySQL or MS SQL?


Hi all,

I'm currently writing proposals for a customer who want to hire our
little
programming team for creating corporate information system, wich
includes
huge database with number of records between 1-10 millions (incl.
blobs -
pictures). Expected database size is tens of Gb.

There is idea of using MS SQL Server for some reasons, on other hand we
have
big experience with MySQL (but with smaller databases).
So I'm very interested to hear  advise, especially from people who had
experience with both SQL servers - which SQL Server is preferable in
such
situation.

In other words - huge database, blobs etc, MS SQL vs. MySQL,  your
opinion?

Many thanks in advance,
Alexander




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

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

Configuration error

[Informatica UNAN-Leon]

Help me:

I am install mysql-3.23.39 on BSDI4.1 
I have error on configuration:
How solution this problem

Atte,
Cesar real
Universidad Autonoma de Nicaragua Leon
---

configure:3950: checking for opendir in -ldir
configure:3969: gcc -o conftest -O3 -mpentiumconftest.c -ldir   1>&5
ld: cannot open -ldir: No such file or directory
configure: failed program was:
#line 3958 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply.  */
char opendir();

int main() {
opendir()
; return 0; }



configure:4188: checking for floatingpoint.h
configure:4198: gcc -E  conftest.c >/dev/null 2>conftest.out
configure:4194: floatingpoint.h: No such file or directory
configure: failed program was:
#line 4193 "configure"
#include "confdefs.h"
#include 





configure:4658: checking for p2open
configure:4686: gcc -o conftest -O3 -mpentiumconftest.c -lm  1>&5
/var/tmp/ccfPd79i.o: In function `main':
/var/tmp/ccfPd79i.o(.text+0x4): undefined reference to `p2open'
configure: failed program was:
#line 4663 "configure"
#include "confdefs.h"
/* System header to define __stub macros and hopefully few prototypes,
which can conflict with char p2open(); below.  */
#include 
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply.  */
char p2open();

int main() {

/* The GNU C library defines this for functions which it implements
to always fail with ENOSYS.  Some functions are actually named
something starting with __ and the normal name is an alias.  */
#if defined (__stub_p2open) || defined (__stub___p2open)
choke me
#else
p2open();
#endif

; return 0; }
configure:4704: checking for p2open in -lgen
configure:4723: gcc -o conftest -O3 -mpentiumconftest.c -lgen  -lm  1>&5
ld: cannot open -lgen: No such file or directory
configure: failed program was:
#line 4712 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply.  */
char p2open();

int main() {
p2open()
; return 0; }

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

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

RE: how to elect slave as master?

[Ricardo Kleemann]

Thank you.

But then how can mysql replication be used for high availability? If I
always rely on 1 master only, what happens if the master goes down?

I've tried two-way master-slave and I understand there are problems. :-(


On Wed, 18 Jul 2001, Warren van der Merwe wrote:

> Hi Ricardo
> 
> >From my opinion, and yet again the pro's may dispute it, I understand what
> you actually want is a two way slave situation, in that way, when one goes
> down the second is there to take over, and when server1 comes back up if
> will update itself's from server2 and carry on. The rest of (front end web,
> or app or whatever) is upto you, you will need to configure your app to use
> server1 when available or server2.
> 
> two way replication is set up by setting server2 as a slave to server1, and
> vice versa.
> 
> THe scenario you describe will not work, because when server1 comes back up
> it will not have the changes that has occured since Server2 took over.
> 
> Beware though, two way replication causes serious issues with
> auto-numbering, and it is best to handle this yourself, in my opinion.
> 
> Regards
> Warren
> 
> 
> ~
> Warren van der Merwe
> Software Director
> PRT Trading (Pty) Ltd t/a RedTie
> Durban, South Africa
> Cell (+27-83) 262-9163
> Office (+27-31) 767-0249
> 
> 
> > -Original Message-
> > From: Ricardo Kleemann [mailto:[EMAIL PROTECTED]]
> > Sent: 18 July 2001 19:37
> > To: [EMAIL PROTECTED]
> > Subject: how to elect slave as master?
> >
> >
> >
> > Hi everyone,
> >
> > I'm wondering how I should configure my.cnf if I have a master-slave
> > scenario where I would like to declare the slave master if
> > the master goes
> > down.
> >
> > What I mean is, let's say I have 2 database servers:
> >
> > server1 = master
> > server2 = slave
> >
> > so normally my.cnf for server2 would have server1 configured as
> > master-host, and server1 would not have any master database
> > server configured.
> >
> > So assuming server1 goes down, I'd have to declare server2 as
> > master, and
> > have it no longer use the "master-host".
> >
> > My confusion is mostly with server1. When it comes back up, how is it
> > supposed to work? Is it supposed to suddenly become a slave?
> > Or does it
> > again come up as master and then server2 relinquishes its
> > master status?
> >
> > How can all of this be done automatically? It seems a little
> > confusing to
> > me to have to have all this automatic switching...
> >
> > HELP! :-)
> >
> > Ricardo
> >
> >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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: how to elect slave as master?

[Warren van der Merwe]

Hi Ricardo

>From my opinion, and yet again the pro's may dispute it, I understand what
you actually want is a two way slave situation, in that way, when one goes
down the second is there to take over, and when server1 comes back up if
will update itself's from server2 and carry on. The rest of (front end web,
or app or whatever) is upto you, you will need to configure your app to use
server1 when available or server2.

two way replication is set up by setting server2 as a slave to server1, and
vice versa.

THe scenario you describe will not work, because when server1 comes back up
it will not have the changes that has occured since Server2 took over.

Beware though, two way replication causes serious issues with
auto-numbering, and it is best to handle this yourself, in my opinion.

Regards
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249


> -Original Message-
> From: Ricardo Kleemann [mailto:[EMAIL PROTECTED]]
> Sent: 18 July 2001 19:37
> To: [EMAIL PROTECTED]
> Subject: how to elect slave as master?
>
>
>
> Hi everyone,
>
> I'm wondering how I should configure my.cnf if I have a master-slave
> scenario where I would like to declare the slave master if
> the master goes
> down.
>
> What I mean is, let's say I have 2 database servers:
>
> server1 = master
> server2 = slave
>
> so normally my.cnf for server2 would have server1 configured as
> master-host, and server1 would not have any master database
> server configured.
>
> So assuming server1 goes down, I'd have to declare server2 as
> master, and
> have it no longer use the "master-host".
>
> My confusion is mostly with server1. When it comes back up, how is it
> supposed to work? Is it supposed to suddenly become a slave?
> Or does it
> again come up as master and then server2 relinquishes its
> master status?
>
> How can all of this be done automatically? It seems a little
> confusing to
> me to have to have all this automatic switching...
>
> HELP! :-)
>
> Ricardo
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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.org

[Michael Collins]

It seems to me that the bottom line is that any outcome that results 
in there being a fork in the development of MySQL (with the result 
being two completely different types of MySQL), or in NuSphere 
retaining control of the mysql.org domain should be vehemently 
rejected by the MySQL community. No matter what agreement may or may 
not have been created, since MySQL AB has made it clear that this is 
not what they want or intended. So to me it is obvious that any 
agreement that may have been made is either being misinterpreted by 
NuSphere or was not entered in good faith.

NuSphere, if what you want is an improved MySQL and if you have 
anything to contribute to the betterment of MySQL, hand over the 
code. If you want a "non-profit" Web site first turn over MySQL.org 
to MySQL AB and either register NuSphere.org for your non-profit site 
or help MySQL AB to get it started. If you want to make money on 
MySQL, follow the guidelines of GPL to the letter and to the approval 
of MySQL or pay the per-copy license.

I guess the solution seems so simple for an outsider.
-- 
Michael
__
||| Michael Collins   |||
||| Kuwago Web Services   |||  mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA  |||  http://www.lassodev.com

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

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

MySQL question

[MIKE TURNER]

I have just installed MySql and when I tried to set the root password and it
gives me an error(I don't recall the exact text) but I looked and the daemon
isn't running. I tried starting it but still nothing? Did I miss a step?
Sorry if this ends up to be a stupid mistake. Hope you can help me.

Mike





___
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/



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

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

Mysqlhotcopy regexp problem

[Chris Lott]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Using the mysqhotcopy that came with the most recent MySQL (3.23.39) on a
RedHat 7.1 box with perl 5.6.0, I am getting the following errors when
trying to back up all databases:

mysqlhotcopy --password="foo" --allowold --regexp=".*" /usr/backups/ \

_ListTables is deprecated, use $dbh->tables() at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/mysql.pm line 262.
Use of uninitialized value in transliteration (tr///) at
/usr/bin/mysqlhotcopy line 230.
Use of uninitialized value in regexp compilation at /usr/bin/mysqlhotcopy
line 231.

If I specify just one database, I still get the "deprecated" warning, but
the hotcopy works...


-BEGIN PGP SIGNATURE-
Version: PGP 7.0.3- signed for information authentication and security
Comment: Key ID: 0x51046CFD

iQA/AwUBO1XOy9aLYehRBGz9EQLiHwCZAW94JqVel00uX5FywPA9j/NOw58An1Ek
LmUQkQGZAEfdFQpS4SnsJ+NR
=DbwQ
-END PGP SIGNATURE-

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

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

Re: How does this work in MySQL?

[Mike Baranski]

On Wednesday 18 July 2001 13:32, you wrote:
> I recently got into a discussion with a colleague that was interesing.  He
> is a database warehouse guy, so I assume he knows more than I do on this
> subject, but he was unable to explain things to me very well :)
>
> The question is how does mysql organize data between the physical table,
> the select statement and auto_increment?
In the physical table, lots of times, if you delete a record, it will not be 
either the first or last (physically), in fact, the chances are very small.  
Rather than re-order the whole file each time you delete a record, you just 
mark that space as open, a "hole" if you will. Next time you insert a record 
small enough to fit into that "hole" you just stick it there, rather than at 
the end.  Then, you can regularly "de-fragment" the files, by closing all the 
"holes" and compacting all of the records.  Therefore, if you insert a record 
into a "hole" the physical order is different than the order of the order by 
columns.  The ANSI specs don't say anything about physical storage.


> As an example, if I insert one new row per second into a table with
> auto_increment not null set, I had thought that when I make a select all
> (not ordered) that the resulting data set would be in SOME kind of order.
>
> In this paradigm, my colleague says that there are no guarantees that the
> records will be retrieved in any kind of order, and may in fact be random.
> How does this work?
The aboove example explaines this, if you have records out of order, and 
select without ordering, it's silly to sort b/c that's extra work.  
Therefore, the select will just get the data in the order that htey're on the 
disk (linear scan) and they will be out of order, as explained above.
>
> He also states that auto_increment does not guarantee consistent
> increments. All it does is guarantee increasing increments.  So in fact
> what he says is that if I insert 5 new records into an empty table with id
> as
> auto_increment, the corresponding ids may be 1,5,7,23,24... or
> 10,19,21,30,43, etc...
>

See the ANSI Specs, they define this...

> I had thought that auto_increment incremented by 1, assuming the paradigm
> described above, and no deletes from the table.
>
> His reasoning for both of these examples is that the data may be written to
> any physical location, and therefore retrieved in any order.  I am a bit
> suspicious of this, as I had thought that the new data in a table was
> appended to the table (again using the paradigm above as the case).
>
> Any thoughts on this stuff?
>
> Thanks,
> Bryan
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Faults

[Gerald Clark]

Werner Stuerenburg wrote:

>> The main aspect I'm interested in is avoiding data loss. So I want that any
>> change to database must immediatly (or at least on regular intervals) be
>> made persistent. Is there any configurable parameter to do this?
> 
> 
> 
> You may want to read about transaction services.

You may also want to consider backup powersupplies.
-- 
Gerald L. Clark
[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: InnoDB logging meachanism (newbie ;)

[Heikki Tuuri]

George,

the binlog is exactly you must have switched on and you must
keep the binlog files. The binlog contains the SQL statements you
run into your database, and by re-running it against your database
backup you can recover from your backup to the present state.

You need the binlogs in disaster recovery: broken disk, fire, etc.
In 'normal' crashes (seg fault, OS crash, power outage) normally the
regular InnoDB log files are enough and it will automatically
recover to a consistent state. Then you do not need to recover
from a backup with the binlogs.

Regards,

Heikki
http://www.innodb.com

Copied message:

The InnoDB manual reads:
"...To be able to recover your InnoDB database (...), you have
to run your MySQL database with the general logging and log
archiving of MySQL switched on. Here by the general logging we
mean the logging mechanism of the MySQL server which is 
independent of InnoDB logs."

I admit, I am a litte disturbed. To shed a little light:
which are the logging mechanisms I have to enable and howcan I do this ?
I have binary logging enabled in my.cnf [at least I hope so
using the entry "binlog"] - is that all I have to do ?Thanks for your help.

George


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

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 or MS SQL?

[Alexander Chernienko]

Hi all,

I'm currently writing proposals for a customer who want to hire our little
programming team for creating corporate information system, wich includes
huge database with number of records between 1-10 millions (incl. blobs -
pictures). Expected database size is tens of Gb.

There is idea of using MS SQL Server for some reasons, on other hand we have
big experience with MySQL (but with smaller databases).
So I'm very interested to hear  advise, especially from people who had
experience with both SQL servers - which SQL Server is preferable in such
situation.

In other words - huge database, blobs etc, MS SQL vs. MySQL,  your opinion?

Many thanks in advance,
Alexander




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

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: Database Replication

[Gerald Clark]

Make sure it is world readable.

Jeremy Zawodny wrote:

> On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote:
> 
>> We are looking to replicate a couple of databases on to a second
>> server.  Having looked through the manual it says we need to add
>> various commands to my.cnf.
>> 
>> It turns out that we do not have a my.cnf (so apprently MySQL just
>> defaults), so can we just create this file with the replication
>> commands in it ?
> 
> 
> Yes, you can.  Just make sure that they all appear in a "[mysqld]"
> section.
> 
> Jeremy


-- 
Gerald L. Clark
[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: How does this work in MySQL?

[Dan Nelson]

In the last episode (Jul 18), Bryan Coon said:
> In this paradigm, my colleague says that there are no guarantees that
> the records will be retrieved in any kind of order, and may in fact
> be random. How does this work?
> 
> He also states that auto_increment does not guarantee consistent
> increments. All it does is guarantee increasing increments.  So in
> fact what he says is that if I insert 5 new records into an empty
> table with id as auto_increment, the corresponding ids may be
> 1,5,7,23,24... or 10,19,21,30,43, etc...
> 
> I had thought that auto_increment incremented by 1, assuming the
> paradigm described above, and no deletes from the table.
> 
> His reasoning for both of these examples is that the data may be
> written to any physical location, and therefore retrieved in any
> order.  I am a bit suspicious of this, as I had thought that the new
> data in a table was appended to the table (again using the paradigm
> above as the case).

You're talking about specific case (empty table, one user), but his
statements are true even if the table has gaps in it or there are
multiple people inserting records to the table.  If there are gaps in
the table due to previously-deleted records, then INSERTed data may be
placed into the middle of the table.  If there are multiple users
inserting records, a single user's view of the auto_increment field
will look like there are "jumps".

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

Replication & Load InFile

[Warren van der Merwe]

Hi

If you use the load infile to insert images into a blob field, and then the
path does not exist when the replication takes place, will there be an
error, or is it clever enough to get the blob data from the db?

THanks


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249

database, mysql


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

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

how to elect slave as master?

[Ricardo Kleemann]

Hi everyone,

I'm wondering how I should configure my.cnf if I have a master-slave
scenario where I would like to declare the slave master if the master goes
down.

What I mean is, let's say I have 2 database servers:

server1 = master
server2 = slave

so normally my.cnf for server2 would have server1 configured as
master-host, and server1 would not have any master database
server configured.

So assuming server1 goes down, I'd have to declare server2 as master, and
have it no longer use the "master-host". 

My confusion is mostly with server1. When it comes back up, how is it
supposed to work? Is it supposed to suddenly become a slave? Or does it
again come up as master and then server2 relinquishes its master status?

How can all of this be done automatically? It seems a little confusing to
me to have to have all this automatic switching...

HELP! :-)

Ricardo





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

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

How does this work in MySQL?

[Bryan Coon]

I recently got into a discussion with a colleague that was interesing.  He
is a database warehouse guy, so I assume he knows more than I do on this
subject, but he was unable to explain things to me very well :)

The question is how does mysql organize data between the physical table, the
select statement and auto_increment?

As an example, if I insert one new row per second into a table with
auto_increment not null set, I had thought that when I make a select all
(not ordered) that the resulting data set would be in SOME kind of order.

In this paradigm, my colleague says that there are no guarantees that the
records will be retrieved in any kind of order, and may in fact be random.
How does this work?

He also states that auto_increment does not guarantee consistent increments.
All it does is guarantee increasing increments.  So in fact what he says is
that if I insert 5 new records into an empty table with id as
auto_increment, the corresponding ids may be 1,5,7,23,24... or
10,19,21,30,43, etc...

I had thought that auto_increment incremented by 1, assuming the paradigm
described above, and no deletes from the table.

His reasoning for both of these examples is that the data may be written to
any physical location, and therefore retrieved in any order.  I am a bit
suspicious of this, as I had thought that the new data in a table was
appended to the table (again using the paradigm above as the case).

Any thoughts on this stuff?

Thanks,
Bryan

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

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 get COUNT(*) on # rows AND return LIMITed results in 1 query ?

[Dan Nelson]

In the last episode (Jul 18), S A said:
> Is there some way to take the following 2 queries & make them into
> one ?

Nope.  Do them separately (or do the count(*) once and cache it for the
rest of the session).

> I want to be able to in one query get the # of overall rows and do a
> LIMITed result set to get the first NN rows.
> 
> Is it possible to to do this in one query ? Presumable MySQL has to
> figure out what the overall # is to return the limited result set so
> it'd be more efficient to do this all at once.

No, mysql doesn't have to calculate the entire resultset; all it needs
to do it get the first record.  If you had 1 million records with
group_id=1, it could take a long time to calculate the count(*).
 
> SELECT COUNT(*) FROM posts WHERE group_id=1;

i.e. find first group_id index entry with the value of '1', scan
forward in the index until value != 1, return count.
 
> SELECT post_subject FROM posts WHERE group_id=1 LIMIT 10,10;

i.e. find first group_id index entry with the value of '1', skip 10
entries, then for the next 10 entries (assuming there are still records
with value of '1'), fetch the appropriate data record and return
'post_subject' to the user.

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

How to find the port Mysql listens to?

[Yan Ge]

Hi, Guys!
 
I have difficulties to talk to MySql via Java Servlet and Resin.
 
Platform:
We use Solaries, and Resin as Servlet container. The server I use and the
server with MySql database is connected via LAN.
 
What I have done:
 
1. I have put resin's mysql jdbc driver in resin/lib, and set up CLASSPATH
as Env variable and in resin.conf. My test code shows that the driver is
found.
 
2. I defined both jadbcDriver and dbURL
 
String jdbcDriver="com.caucho.jdbc.mysql.Driver"; 
String dbURL="jdbc:mysql://hostservername:3306/dbname"; 
 
3. Run code:
 
   Class.forName(jdbcDriver).newInstance();
   out.println("Got mysql driver in STAGING, ...\n\n");
   dbConn=DriverManager.getConnection(dbURL, username, password); 
   out.println("And connect MySql in T1!");
 
Outcome:
 
Code 
catch (Exception e) {
   out.println("Error: " + e);
  }
generated error message:
 
Error: java.sql.SQLException: Communication link failure: Bad handshake 
 
My Questions:
 
1. Since I use 3306 as port number, could it be wrong? If it may, how could
I find the port which Mysql listens to?
2. If it is not a port problem, what might be the cause of the failure?
 
I appreciate much any of your helps!
 
Yan

Re: Converting ACCESS or EXCEL Data to MySQL

[John Meyer]

At 08:47 AM 7/18/01 -0700, Dennis Salguero wrote:
>Notice that I haven't really mentioned MySQL at all. As much as I like
>MySQL, if you already have a SQL Server that can connect to the Internet, I
>don't understand the need to use MySQL in this scenario ??? Obviously, if
>this is a web page that will see a lot of traffic, or the SQL Server
>database is no good or too big, then of course you can still use MySQL in
>the same manner mentioned above. Just remember, that you will have to use a
>new ODBC driver, MyODBC.
>
>Good Luck,

Or, if you use PHP, an alternative to ASP, you can just use the built in 
functions to access MySQL.



John Meyer
[EMAIL PROTECTED]
Programmer


If we didn't have Microsoft, we'd have to blame ourselves for all of our 
programs crashing


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

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: [PHP] Email Software

[Dave Carter]

LOL!!!

-Original Message-
From: Dan Harrington [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:47 AM
To: Wee Chua; PHP (E-mail); MySQL (E-mail)
Subject: RE: [PHP] Email Software


try http://www.spamcop.net, they are experts in it.


> -Original Message-
> From: Wee Chua [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 6:50 AM
> To: PHP (E-mail); MySQL (E-mail)
> Subject: [PHP] Email Software
>
>
>
> Hi all,
> I need a little help from you guys. Can anyone tell what is the best
> software for sending million emails at a time or something
> like that? Where can I buy email addresses from? Thank
> you!
>
> Sincerely
> Calvin Chua
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [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

performances

[safae]

Bonjour,
Je voudrais avoir une idée sur les performances de MYSQL, du genre capacité maximale , 
temps de réponse. 
Et puis comment faire pour modifier les parametres surtout le TIMEOUT. 
Merci

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

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

RE: Re[2]: AW: password-recovery for root-user?

[Ravi Raman]

the link got split over 2 lines when it was copied/pasted...
manual_Privilege_system.html
instead of
manual_Privilege_system.h

-ravi.

-Original Message-
From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:25 AM
To: Ravi Raman
Cc: [EMAIL PROTECTED]; Rischbode, Horst;
[EMAIL PROTECTED]
Subject: Re[2]: AW: password-recovery for root-user?


>
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h

FYI: The link you requested was not found.

Sie schrieben am Mittwoch, 18. Juli 2001, 16:17:24:


>>mysqld --skip-grant-tables

> section 6.3 on this page:
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
> tml

> -ravi.



> -Original Message-
> From: Andy Tanner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 10:03 AM
> To: Werner Stuerenburg; Rischbode, Horst
> Cc: [EMAIL PROTECTED]
> Subject: RE: AW: password-recovery for root-user?



>  Similarly - how about

>  - take a copy of you original mysql database tables
>  - overwrite the mysql database tables with the original installation
tables
>  - login as root (the password will be blank)
>  - import your orignial tables back into the mysql database

>  good luck
>  Andy

> -Original Message-
> From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
> Sent: 18 July 2001 13:26
> To: Rischbode, Horst
> Cc: [EMAIL PROTECTED]
> Subject: Re: AW: password-recovery for root-user?


> You can reinstall the complete system from scratch, if you are
> superuser to that system. Would be the easiest way to do it, I
> guess.

>> I'm trying to get the root-password to be deleted or set to a
>> new value without knowing the old password. (Forgotten...)

> table

> --
> Herzlich
> Werner Stuerenburg

> _
> ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
> Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
> http://pferdezeitung.de



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

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


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

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




--
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



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

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



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

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 get COUNT(*) on # rows AND return LIMITed results in 1 query ?

[S A]

Is there some way to take the following 2 queries & make them into one ?

I want to be able to in one query get the # of overall rows and do a LIMITed result 
set to get the first NN rows.

Is it possible to to do this in one query ? Presumable MySQL has to figure out what 
the overall # is to return the limited result set so it'd be more efficient to do this 
all at once.

thanks,

- Sam.

SELECT COUNT(*) FROM posts WHERE group_id=1;

SELECT post_subject FROM posts WHERE group_id=1 LIMIT 10,10;

 



-
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year!
http://personal.mail.yahoo.com/

Re: Converting ACCESS or EXCEL Data to MySQL

[Dennis Salguero]

- Original Message -
From: "Oliver Hohlfeld" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 8:13 AM
Subject: Converting ACCESS or EXCEL Data to MySQL


> I'm currently working on a bigger Project.

Uh oh, wasn't that the plot to "The Spanish Prisoner" ?? ;-)

> I'm currently thinking about the easiest way to get data from
> this database and put it online. I could start to develop on
> a little software tool which publicates the data but isn't there
> a easier way ?

How do you want to put this data on the web? Do you want it to be dynamic or
just a static HTML page? It sounds like you're working in a Microsoft shop,
so for dynamic pages, have you considered ASP? The advantage to using ASP,
in your scenario, is that you would only write the ASP code once, the web
page and the HTML for it would be dynamically generated. For creating HTML
pages, you can use everything from the wizards within the Office products to
a custom program in VB (or another language of choice).

> I'm rather new to MySQL and general SQL Technologies, so maybe
> I overlocked something. Yes, I already looked in the user manual
> at www.mysql.com and I read something about ODBC Support, but does
> that also work if the Database Server is lockated somewhere in the
> Internet ?

ODBC really works with anything, that's the whole point of using it. If you
want to connect  your current SQL Server to a web page, you would create an
ODBC connection on the web server (with the SQL Sever IP address & user
info). From there, within your ASP code, you could reference the ODBC
connection, which will pass the information back & forth between the web
page and the database.

Notice that I haven't really mentioned MySQL at all. As much as I like
MySQL, if you already have a SQL Server that can connect to the Internet, I
don't understand the need to use MySQL in this scenario ??? Obviously, if
this is a web page that will see a lot of traffic, or the SQL Server
database is no good or too big, then of course you can still use MySQL in
the same manner mentioned above. Just remember, that you will have to use a
new ODBC driver, MyODBC.

Good Luck,

Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.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

ERWIN, stored procedure, release date MySql questions

[Steve Dufrane]

I am not a subscriber to this message board, please copy replies to
[EMAIL PROTECTED]

Greetings, 

A few questions - 

*regarding trying to determine how to use stored procedures with Mysql, 1
approach I have heard is to put all your sql in a text file -how does this
compare to just embedding the SQL in your program/business logic ? 

*when is the release data of 4.0, and what is the release date and version
for support for mysql stored procedures ?  mysql.com is non specific about
either. 

* Regarding ERWIN I see you can dump the model into the good old DBF files,
but then what are the steps for mysql to use them next ? 

* Also, on ERWIN, it today automatically creates for example ms sqlserver
stored procedures for cascade delete and copy logic within the data model.
question is can it generate *generic* sql that could be used for another
vendor db, say mysql ? 

Thanks, 

Steve 






___
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/



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

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[2]: AW: password-recovery for root-user?

[Werner Stuerenburg]

> http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h

FYI: The link you requested was not found.

Sie schrieben am Mittwoch, 18. Juli 2001, 16:17:24:


>>mysqld --skip-grant-tables

> section 6.3 on this page:
> http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
> tml

> -ravi.



> -Original Message-
> From: Andy Tanner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 10:03 AM
> To: Werner Stuerenburg; Rischbode, Horst
> Cc: [EMAIL PROTECTED]
> Subject: RE: AW: password-recovery for root-user?



>  Similarly - how about

>  - take a copy of you original mysql database tables
>  - overwrite the mysql database tables with the original installation tables
>  - login as root (the password will be blank)
>  - import your orignial tables back into the mysql database

>  good luck
>  Andy

> -Original Message-
> From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
> Sent: 18 July 2001 13:26
> To: Rischbode, Horst
> Cc: [EMAIL PROTECTED]
> Subject: Re: AW: password-recovery for root-user?


> You can reinstall the complete system from scratch, if you are
> superuser to that system. Would be the easiest way to do it, I
> guess.

>> I'm trying to get the root-password to be deleted or set to a
>> new value without knowing the old password. (Forgotten...)

> table

> --
> Herzlich
> Werner Stuerenburg

> _
> ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
> Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
> http://pferdezeitung.de



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

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


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

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




-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



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

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

BLOB storing

[Damiano Sandei]

I'm trying to save BLOB values in a table from a little java application,
but i found only null values in the table.
I've configured the max_allowed_packet parameter, I've controlled the path
of the file I want to save, but nothing.
Anyone can help me?
Thank you

Damiano




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

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: Small Problem with a function

[Werner Stuerenburg]

mysql support should be built into php. I experienced this twice
under Winxx. The first time I found a remedy which I don't
remember. The second time I upgraded to the newest version of
php.

> Fatal error: Call to unsupported or undefined function mysql_pconnect()
> in ./db_mysql.php on line 38




-- 
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



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

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

RE: Small Problem with a function

[Sander Pilon]

You must compile PHP with the mysql module enabled. See the PHP manual
for more information.
(Or search the excellent php mailinglist archives at
http://www.php.net/support.php)

> -Original Message-
> From: Rick Makla [mailto:[EMAIL PROTECTED]] 
> Sent: 18 July 2001 17:02
> To: [EMAIL PROTECTED]
> Subject: Small Problem with a function
> 
> 
> What can I do to fix this error or can you referance me to a 
> point where I can look at to try to fix the problem.
> 
> Fatal error: Call to unsupported or undefined function 
> mysql_pconnect() in ./db_mysql.php on line 38
> 
> Rick Makla 
> Digital Media
> P: 803.758.4057
> F: 803.779.9455
> [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: Small Problem with a function

[Mike Baranski]

Did you build PHP with mysql support, and are you requring the mysql/php 
module in your program, something is not set up correctly.

On Wednesday 18 July 2001 11:01, Rick Makla wrote:
> What can I do to fix this error or can you referance me to a point where
> I can look at to try to fix the problem.
>
> Fatal error: Call to unsupported or undefined function mysql_pconnect()
> in ./db_mysql.php on line 38
>
> Rick Makla
> Digital Media
> P: 803.758.4057
> F: 803.779.9455
> [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

Converting ACCESS or EXCEL Data to MySQL

[Oliver Hohlfeld]

Hi there,

I'm currently working on a bigger Project. There is a company who
want to publicate their article database daily on the internet.
The database is located in a Microsoft SQL Server and they use
Access as frontend. So, exporting the Data to Excel is no problem.

I'm currently thinking about the easiest way to get data from
this database and put it online. I could start to develop on
a little software tool which publicates the data but isn't there
a easier way ?
I'm rather new to MySQL and general SQL Technologies, so maybe
I overlocked something. Yes, I already looked in the user manual
at www.mysql.com and I read something about ODBC Support, but does
that also work if the Database Server is lockated somewhere in the
Internet ?

Many thanks in advance,
Oliver Hohlfeld


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

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

Small Problem with a function

[Rick Makla]

What can I do to fix this error or can you referance me to a point where
I can look at to try to fix the problem.

Fatal error: Call to unsupported or undefined function mysql_pconnect()
in ./db_mysql.php on line 38

Rick Makla 
Digital Media
P: 803.758.4057
F: 803.779.9455
[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: Modifing A Table

[Jason Burfield]

alter table TABLENAME add COLUMN_NAME etc, etc...

ie:
alter table members add firstname varchar(50) not null;

If you want to put it after a specific column you can do the following:

alter table members add firstname varchar(50) not null after lastname;

  --  Jason


On 7/18/01 10:32 AM, Paul Castiglione was heard saying:

> Hello
> 
> Is there a way to add addition feilds to a table after it been created.
> 
> Thank in Advance
> Paul 
> 


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

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 loves FreeBSD (but not NetBSD) ...

[Ken Menzel]

Hi Tom,
   As another user of MySQL on FreeBSD,  I can tell you from my own
experience that the MySQL Team is dedicated to having MySQL run on as
many platforms as possible.  I say this as an almost direct quote from
e-mail Monty sent me.  Things were not always smooth with FreeBSD
threads, it is only through quite a bit of work by some dedicated
people that this has smoothed out.  There are still issues that
remain, but they are not with MySQL.  They MySQL Team has gone out of
thier way to help debug OS threads problems.  I imagine more emphasis
will be placed on reliable pthreads libraries when the new threads
based apache web server moves out of alpha test phase and onto
production systems.

It is not easy to debug these these type of things,  the main issue is
getting some who understands threads debugging on the OS involved to
look at the code and/or writing a test program that duplicates the
problem.  Neither of these is a trivial task,  and of course the MySQL
team needs to feed  thier families, and continue to move the product
forward.  I and my company support MySQL AB (to make it clear) in both
words and financialy (I have a login support contract).   They are a
dedicated hard working group, and I am sure they are as interested as
you in the problems on NetBSD, however I think it is amazing that they
run on as many platforms as they do now without problems!  But there
is a limited amount of resources to go around, and as there are more
Linux (mysql) users than FreeBSD,  problems tend to get noticed and
fixed there first.  I think it might be similer with NetBSD and
OpenBSD,  there just less users, therefor less testing and since MySQL
is very USER supported there exists less support.  I am not saying
anything bad about OpenBSD or NetBSD,  just that it seems there are
less users on this list.  The more users looking at an issue,  the
more likely someone will find the answer/problem.

So in a nutshell what I am saying is you don't have to give up if you
really feel you want to run on NetBSD.  Go rally the people together
to find the problem.  If you can support financialy do it.  If you
support bu collecting the right people, do that.  But if the users
don't get involved at some level the problems may not go away,  or a
different user group may solve the problem for a different reason (IE
Apache).  But the users have to get involved, it's part of what open
source is all about!

Best of luck to you what ever your decison!

Ken
- Original Message -
From: "Haapanen, Tom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 10:05 PM
Subject: MySQL loves FreeBSD (but not NetBSD) ...


> ... or should that be "FreeBSD loves MySQL"?
>
> I finally caved in after a year of increasing (and unexplained)
MySQL
> crashes, despite numerous updates to more recent versions of NetBSD
and
> MySQL, and dozens of experiments with different configuration
options.
> MySQL would die (and restart automatically) every 5-15 minutes on
the
> database server acting as the back end for our web site,
motorsport.com.
> (This on NetBSD/i386, as when we started, MySQL was distinctly
unhappy with
> NetBSD/Alpha)
>
> So I picked up a clean disk, installed FreeBSD 4.3 over the
Internet, booted
> to multiuser, and did "pkg_add -r mysql-server" to installe the
prebuilt
> MySQL binaries.  Stopped the server, ftp'd the databases over -- and
it
> worked!  Wonderfully, in fact ... in 48 hours now, not a single
crash, and
> the CPU utilization has been quite reasonable, too.
>
> In the end, I suspect that MySQL couldn't deal with the threading
libraries
> available on NetBSD, although I have no proof of this.  No other
application
> has given us this much trouble, but nothing else we use uses such
heavy
> threading, either.  (We still continue to use NetBSD/Alpha for all
our other
> servers.)
>
> If anyone on the list is running MySQL on NetBSD in a reasonably
busy
> production environment, I would still like to hear about it, though.
>
> Tom Haapanen
> [EMAIL PROTECTED]
>
> 
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>


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

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: Modifing A Table

[j.urban]

mysql> alter table mytable add newcolumn varchar(16);

Have a look at the ALTER TABLE syntax in the manual...

http://www.mysql.com/doc/A/L/ALTER_TABLE.html


On Wed, 18 Jul 2001, Paul Castiglione wrote:

> Hello
> 
> Is there a way to add addition feilds to a table after it been created.
> 
>  Thank in Advance
> Paul 
> 


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

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

Modifing A Table

[Paul Castiglione]

Hello

Is there a way to add addition feilds to a table after it been created.

 Thank in Advance
Paul 

RE: AW: password-recovery for root-user?

[Ravi Raman]

>mysqld --skip-grant-tables

section 6.3 on this page:
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
tml

-ravi.



-Original Message-
From: Andy Tanner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 10:03 AM
To: Werner Stuerenburg; Rischbode, Horst
Cc: [EMAIL PROTECTED]
Subject: RE: AW: password-recovery for root-user?



 Similarly - how about

 - take a copy of you original mysql database tables
 - overwrite the mysql database tables with the original installation tables
 - login as root (the password will be blank)
 - import your orignial tables back into the mysql database

 good luck
 Andy

-Original Message-
From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
Sent: 18 July 2001 13:26
To: Rischbode, Horst
Cc: [EMAIL PROTECTED]
Subject: Re: AW: password-recovery for root-user?


You can reinstall the complete system from scratch, if you are
superuser to that system. Would be the easiest way to do it, I
guess.

> I'm trying to get the root-password to be deleted or set to a
> new value without knowing the old password. (Forgotten...)

table

--
Herzlich
Werner Stuerenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



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

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


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

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