Re: MySQL database in a File system

2002-02-13 Thread Andreas Schoelver
12.02.02 05:56:48, "D Bamud" <[EMAIL PROTECTED]> wrote: >I need to create a database in MySQL that I need to bundle with my program >for distribution. The user will have its own copy of MySQL running. User [...] >file system database bundle will be done before running the program. How to >create

Re: MySQL Client/Server problem - AGAIN, sorry!!!

2002-02-06 Thread Andreas Schoelver
06.02.02 11:42:26, Marcelo Muzilli <[EMAIL PROTECTED]> wrote: >Hi all, > I want to connect a MySQL client from Windows NT to SUN Solaris 2.6. > How can I do this? I need some services running in the Server (in my case, SUN >Solaris). What means the message: > > "Host is not a

Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie

2002-02-04 Thread Andreas Schoelver
04.02.02 15:11:30, Rich Fortnum <[EMAIL PROTECTED]> wrote: >Hi there. I have a need to reach into a remote database and write to their >tables from my tables. Or have them reach into my tables and read from >mine. Either way, data will travel over the net. I need that data secure >and I don't

Re: Remove source install from configure make make install

2002-02-04 Thread Andreas Schoelver
03.02.02 18:33:50, Samy Elashmawy <[EMAIL PROTECTED]> wrote: >Folks, I have installed multiple copies of MySql , >MyODBC , unixODBC and need to clean up the system. I >have removed the rpm versions , but now need to remove >the source versions. How is this done under linux , >especialy for Mysql

RE: AUTO_INCREMENT columns randomly restart counting from 1

2002-02-04 Thread Andreas Schoelver
Hi Michael 01.02.02 16:27:24, "Fochtman, Michael" <[EMAIL PROTECTED]> wrote: >BMJI, > >But isn't 'last_insert_id()' only meant to be called after inserting a >record?? If you've never inserted a record (using the current connection), >it seems like calling 'last_insert_id()' would be a meaningl

RE: AUTO_INCREMENT columns randomly restart counting from 1

2002-02-04 Thread Andreas Schoelver
Hi Bruce 01.02.02 15:41:49, Bruce Stewart <[EMAIL PROTECTED]> wrote: >Hi Andreas, > >> >I think AUTO_INCREMENT is on a per-connection basis. So if >> you're doing >> >this across different database connections, it will reset to 0. >[snip] >> do a 'select * from where test=1' and you will >>

RE: AUTO_INCREMENT columns randomly restart counting from 1

2002-02-01 Thread Andreas Schoelver
30.01.02 17:48:06, Richard Bolen <[EMAIL PROTECTED]> wrote: > >I think AUTO_INCREMENT is on a per-connection basis. So if you're doing >this across different database connections, it will reset to 0. no, that's not the case. just try it. crate a table with column id as auto_increment int and a

AUTO_INCREMENT columns randomly restart counting from 1

2002-01-30 Thread Andreas Schoelver
esets to 1, which breaks the whole application. this appears long before any overflow might happen. has anyone else ever noticed this? any idea what might be wrong ? the version of the server is 3.23.42 . best regards Andreas

Re: mysql trouble

2002-01-30 Thread Andreas Schoelver
30.01.02 16:57:00, valentin <[EMAIL PROTECTED]> wrote: >Hello, >We are students in a french university and we have a trouble while >running mysql on our server. >After typing the command mysql, we have this message: > >ERROR 2002: Can't connect to local MySQL server through socket >'/tmp/mysql.so

RE: Faliue: Write huge binary data to blob Field of mysql use jdbc

2001-09-20 Thread Andreas . Schoelver
Hi ? ? > -Original Message- > From: ? ? [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 19, 2001 12:12 PM > To: [EMAIL PROTECTED] > Subject: Faliue: Write huge binary data to blob Field of > mysql use jdbc > > > Hi all: > > We are making a project about "document manage " ,I

RE: BDB table : different results on adjacent queries

2001-09-20 Thread Andreas . Schoelver
Hi Dana > -Original Message- > From: Dana Powers [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 19, 2001 7:19 PM > To: [EMAIL PROTECTED] > Cc: mysql mailing list (E-Mail) > Subject: Re: BDB table : different results on adjacent queries > > > What is the query you are running +

BDB table : different results on adjacent queries

2001-09-19 Thread Andreas . Schoelver
hi all we encountered the following: - altered table type to 'BDB' - did 2 identical queries - got different result sets ! after restart of MySQL the very next query gave the correct results, the next did NOT. any ideas? Thanx in advance Andreas Schoelver -- Andreas Schoelver (