Re: MySQL database in a File system
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 database in MySQL. create the DB on your server, grab the files from the filesystem and include them into your setup, have the setup copy them to the desired place, install the client ... and simply let it use the new database. (works w/o restarting MySQL) that's the way I'm currently doing it with a setup for a windoze server/client installation. yours Andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Client/Server problem - AGAIN, sorry!!!
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 allowed to connect to this MySQL server ?? IMO this looks as if the sun can't resolve the IP number of your win box while trying to connect. I suppose you entered your win box's hostname into the user table? best regards Andreas sql,query,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
RE: AUTO_INCREMENT columns randomly restart counting from 1
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 that the 2 new values will be visible to both of the clients. As I understand it, this is correct, and by design. MSSQL functions in the [...] Correct, and it should! Don't know if I've helped you here, or only confused you more, but this functionality is by design, and I believe makes sense. the mail you replied to was my explanation to Richard Bolen's statement: # 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. My problem is somewhat different: the counter randomly resets, and that is no behaviour by design. regards Andreas mysql, sql, select - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Remove source install from configure make make install
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 , unixODBC and Myodbc ? execute 'make uninstall' from where you once called 'make install'. regards Andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
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 how I can make that secure. It's not a permissions thing, because that's straight forward...it's the communications I'm worried about. Can anybody comment on how remote security can be established between SQL databases? How about using a VPN (virtual private network) ? regards Andreas sql,select,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
RE: AUTO_INCREMENT columns randomly restart counting from 1
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 column test as int; do an 'insert into tablename values( NULL, 1)' from two different clients, do a 'select * from tablename where test=1' and you will see that the 2 new values will be visible to both of the clients. I don't yet fully understand what the manual tries to tell, but the increment works fine also after disconnecting/reconnecting a client or restarting the database. the only special thing to recognize is with function last_insert_id(). if one client creates a new autoincrement value, the other client can't see this, the result for 'select last_insert_id()' is 0! only the client performing the increment is able to determine the new value valid for _this_ client. imagine that both clients did their increments on the same table, last_insert_id() gives different answers to both of them. on the other hand: 'select max(id)' gives the absolute maximum to both of the clients. Andreas 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
Re: mysql trouble
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' (111) did you build it on your own? if so, did you use '--with-unix-socket-path=...' with configure ? is the server really running? is there any 'socket=...' line in /etc/my.cnf ? Andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AUTO_INCREMENT columns randomly restart counting from 1
Hi there We have some table used as sequences. They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them (ID). By default the tables are empty! The increment process is done by inserting a new record with a random value for the non-auto_increment column. After that the new sequence value is fetched by selecting the random value. In the next step the one and only new row will we deleted using a 'delete from seq_xx WHERE PID = random_value' statement, as described in the manual. randomly the incrementation of any of the tables fails and the counter resets 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 Schoelver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BDB table : different results on adjacent queries
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 version of mysql are you using? dpk It was a simple 'select * from table where a=value and b=value'. Version: 3.23.41, compiled with BDB and INNODB support, running on Linux (SuSE 7.0). The table we used had the following structure: a varchar(36) not null, pri b varchar(50) null c varchar(4) null d varchar(50) null e decimal (10,0) null f varchar(36) null, mul g varchar(36) null, mul h varchar(50) not null i varchar(50) null there are 3 non_unique keys defined: f+b f+d g column f is filled with all the same values (262 records) the last test was performed with the command line tool mysql. query: select count(*) from table where f='the only value in that column'; count(*) = 262 - ok. (the value in column f is a GUID which uses the full length of the field.) I repeated the query several times, with always the same positive results. Then I opened another connection (as a different user), using the same database, applied my query, and ... OOPS ... count(*) = 0 ! I turned back to the other client and again performed the same query (using the commandline buffer). Now the result of the count was 0 also there !!! Next I tried another application: mysql_navigator (1.2.4), the same query, count was 262, ok. next try: added and b = '4004' to the where clause so that the count should be 1 as there is only one record with '4004' in column 'b'. result: count was 0 ! another try on the previous select : count is 2 instead of 262 ! so what ??? replaced 'count(*)' by '*': one of the resulting records is the one with '4004' in column 'b', the other one's 'b' value is 400403. There is another record in the table beginning with 4004 in column 'b' : value '40040307', but this one wasn't selected. I hope you have an idea about this very weird behaviour. Thanx in advance Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Faliue: Write huge binary data to blob Field of mysql use jdbc
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 org.gjt.mm.mysql as jdbc to communicate with mysql. I can succeed in writing the binary data (the size about 14M) to database ,but when I write the binary data that's size exceed 20M I get a Exception. Please help me! Thanks! try setting 'set-variable=max_allowed_packet=20M' in my.cnf (take a look what's the current value with 'show variables') Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BDB table : different results on adjacent queries
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: [EMAIL PROTECTED] mailto: [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