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 such

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 my_IP is not

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 tablename where test=1' and you will see

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

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

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.sock'

AUTO_INCREMENT columns randomly restart counting from 1

2002-01-30 Thread Andreas Schoelver
, 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 Schoelver

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

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 use

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 (AS) mailto