Re: SELECT MAX makes MYSQL Crush
hello, i got a really long text to put in mysql n when i use longtext field, it isnt enuff Can u help me pls ?? thx in advance feroze - 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: Newbie Question about working with datetime column
I'm fairly certain now() runs off system time...so you can adjust your system time on the server to reflect your time zone... if thats not possibly, or not wanted, in place of now, you can use.. DATE_SUB(NOW(), INTERVAL 2 HOUR) cheers! On January 7, 2002 11:53 pm, Kevin Campbell wrote: Im using the NOW() function to store the date and time in my database table that a person fills out my form. But I noticed that its 2002-01-07 11:51pm but the time shows up as 2002-01-08 01:51:18. It appears to be two hours off. How can I adjust the time to match my time zone? Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.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
Tru64 UNIX V5.1A Build Instructions (gcc) ?
Hi All. Has anybody from the MySQL source distribution successfully build a working MySQL ? I have done it using Compaq's C and C++ compiler - But I would like to have build instructions when using GNU C. Regards and thanks, Karsten Elgaard Sørensen Compaq Computer ApS Denmark - 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: SELECT MAX makes MYSQL Crush (??)
Rezal writes: hello, i got a really long text to put in mysql n when i use longtext field, it isnt enuff Can u help me pls ?? thx in advance I'll do my best to decipher your message... you have something that's bigger than the maximum size of a LONGTEXT and you want to put in in the database? That doesn't make much sense. Why would you want to store more than 4 gigabytes per table row? And what sort of data is that anyway? Since you'll probably not have very many objects of that size, why not use the file system? //C - giving his screen a funny look -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Lost connection, C API
Heikki Tuuri wrote: Hi! Are you running mysqld under the safe_mysqld script, which automatically restarts mysqld after a crash? Yes, mysqld started with safe_mysqld script If yes, look at the 'hostname'.err file and send its contents to me. Nothing happens in the hostname.err (I started mysqld this morning at 11:45) 020107 11:45:08 mysqld started 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 11:45:10 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections With ps ..., I confirm that mysqld processes have NOT restarted (running since 11:45) Or, if you run mysqld from the command prompt, capture what mysqld prints to the command prompt window. If mysqld does not crash, then the problem is probably some client/server issue. Regards, Heikki Has we got a network error yesterday, I have run another test this night with the following modifications : max_connect_errors=65535 skip-host-cache connection to 'localhost' (the client and the serveur run on the same machine) I have got errors like : MySQL server has gone away (12 occurences) Commands out of sync; You can't run this command now (85 occurences) Lost connection to MySQL server during query (only one occurence) The transaction overload is about : 200848 Insert 486205 Update 334945 Select for 8 hours Before restarting the 2nd test I restart mysqld (yesterday at 22:28) so here is the hotname.err --- 020107 11:45:08 mysqld started 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 11:45:10 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections 020107 22:27:45 /opt/mysql/libexec/mysqld: Normal shutdown 020107 22:27:45 InnoDB: Starting shutdown... 020107 22:27:58 InnoDB: Shutdown completed 020107 22:27:58 /opt/mysql/libexec/mysqld: Shutdown Complete 020107 22:27:58 mysqld ended 020107 22:28:25 mysqld started 020107 22:28:26 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 22:28:26 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 22:28:27 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections Status information: Current dir: /opt/mysql/var/ Current locks: lock: 83f3ed0: lock: 8396308: lock: 8395a28: lock: 838cfa0: lock: 8390c00: lock: 838cf00: lock: 838ce60: lock: 838c588: lock: 837e8b8: lock: 837ee28: lock: 837ed90: lock: 83746e0: key_cache status: blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 5704 read_next:1706 read_rnd47 read_first:394 write:1447 delete 0 update:465 Table status: Opened tables: 26 Open tables: 20 Open files: 2 Open streams: 0 -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/CC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: INSERT value from another table
* matt I was wondering how I would insert a value which is present in another table, specifically, this is a member_id field from a main members table which acts as a foreign key in this table (Although I know this not truly possible in MySQL). I think this attempted, although non functional, insert statement describes what it is I'm trying to do: INSERT INTO skills (member_id, name, schooling, certifications, description) VALUES (members.max(member_id),'$skill_name','$schooling','$certifications','$s kill_description'); Would I be best to select this before hand with PHP and somehow store the result in a variable and then insert it? Thanks very much for the help. If all wanted values was available in the member table, you wouldn't need to use a script, but I suspect in this case this is not the case: INSERT INTO skills (member_id, name, schooling, certifications, description) SELECT member_id, '$skill_name','$schooling','$certifications','$skill_description' FROM member ORDER BY member_id DESC LIMIT 1; -- Roger - 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: Lost connection, C API
Bernard Chambon wrote: 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 Bernard: How come you're not giving your OS more file descriptors? ulimit problem, perhaps. Van database,sql,query,table -- = Linux rocks!!! http://www.dedserius.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: Newbie Question about working with datetime column
Brian Snopek writes: I'm fairly certain now() runs off system time...so you can adjust your system time on the server to reflect your time zone... The computer should know what timezone it's in. You can unset TZ before running safe_mysqld to get MySQL to run on UTC, but that is a kludge, really. The root of all problems is that MySQL uses local time instead of UTC, and that causes all sorts of annoying problems, especially when daylight savings time is toggled, or when doing replication, or when dealing with people from other timezones, or... you get my point. Until the MySQL team gains respect for timezone issues, we'll be stuck with a MySQL that can't distinguish UTC from local time, and we'll be forced to do all timezone calculations on the application side. The approach I'll be taking is to run MySQL with TZ set to local time, and allow local time t obe used where it's not critical, but compensate for TZ differences in the handling of sessions, job control, and everywhere else where time differences are involved. if thats not possibly, or not wanted, in place of now, you can use.. DATE_SUB(NOW(), INTERVAL 2 HOUR) Except that you'd have to extract the correct offset from your current local timezone. And of course you must know what TZ the server has. The number of hours might not be an integer, btw, but I'm pretty sure the number of seconds will. //C - earlier than usual -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Mysql connection problem
Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: mysql not found. How can I find mysql server? Cindy Simon Green [EMAIL PROTECTED] 01/07 10:05 AM No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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
adding users (reference from O'reilly book)
I was reading about adding/managing users. I understand hat the user table holds user information. the example I will give is taken from the oreilly book. insert into user (host, user, password, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'bob', password('mypass'), 'Y', 'Y', 'Y', 'Y') ; questions 1.) is the % a wildcard, and if so does this mean the user bob can connect from any host ? 2.) the password function encrypts the password. If the password function is missed out before the ('mypass') bit will it enter the password un-encrypted ? or will it just not work ? thanks, Matt. - 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: adding users (reference from O'reilly book)
1.) the % IS a wildcard and the user bob CAN connect from any host. 2.) the string 'mypass' will be inserted into the table. but the user bob can not logon because he doesnot know the unencrypted password of 'mypass'. -- Zu Zhihui [EMAIL PROTECTED] - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: MySql List [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 5:38 PM Subject: adding users (reference from O'reilly book) I was reading about adding/managing users. I understand hat the user table holds user information. the example I will give is taken from the oreilly book. insert into user (host, user, password, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'bob', password('mypass'), 'Y', 'Y', 'Y', 'Y') ; questions 1.) is the % a wildcard, and if so does this mean the user bob can connect from any host ? 2.) the password function encrypts the password. If the password function is missed out before the ('mypass') bit will it enter the password un-encrypted ? or will it just not work ? thanks, Matt. - 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: adding users (reference from O'reilly book)
Hi If you have a new copy of MySQL use GRANT. If you have an old copy update it. If you can not do this then Yes % is a wild card. Yes bob can use any host at user table is global. Yes you can use clear text passwords. Hope this helps. Simon PS I like using desc tablename PPS Get the new O'reilly book the old one is not so good! -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 09:38 To: MySql List Subject: adding users (reference from O'reilly book) I was reading about adding/managing users. I understand hat the user table holds user information. the example I will give is taken from the oreilly book. insert into user (host, user, password, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'bob', password('mypass'), 'Y', 'Y', 'Y', 'Y') ; questions 1.) is the % a wildcard, and if so does this mean the user bob can connect from any host ? 2.) the password function encrypts the password. If the password function is missed out before the ('mypass') bit will it enter the password un-encrypted ? or will it just not work ? thanks, Matt. - 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
[Bug in replications] set character set don't work
Description: Using set character set cp1251_koi8 before updates insert right data on master server (cp1251 from client recode to koi8 on server), but replication on slave server wrong (data dosn't recode from cp1251 to koi8). How-To-Repeat: Setup replication with master and slave servers Do with Master server: set character set cp1251_koi8; insert into test (test) values ('[text at cp1251 codepage]'); select test from test; You will see text, recoded from cp1251 to koi8 Do with Slave server: select test from test; You will see text, *dosn't* recoded Fix: Binary log on master (I see it with mysqlbinlog) is right: query set character set cp1251_koi8 is present. So, problem with *slave* only. Submitter-Id: submitter ID Originator:Pavel Andreew Organization: Ekaterinburg Telegraph MySQL support: none Synopsis: set character set cp1251_koi8 don't work on slave server Severity: serious Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.47 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.47-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 4 hours 14 min 6 sec Threads: 2 Questions: 178 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.012 Environment: System: Linux collage 2.4.17 #1 Tue Dec 25 12:39:34 YEKT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 äÅË 6 10:31 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1171196 äÅË 3 23:07 /lib/libc-2.2.4.so -rw-r--r--1 root root 2669312 äÅË 3 23:07 /usr/lib/libc.a -rw-r--r--1 root root 178 äÅË 3 23:07 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all - 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
text file insert
Hi, I prefer to used load data infile command to insert text file (CSV format) to MySQL. I wonder that Could load data use with pure text file (no delimiter)? if not how to insert text file in to MySQL faster than read every line? SF - 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: adding users (reference from O'reilly book)
thanks for your help on this, I would like to use the grant sql command as I am using the latest version 3 of mysql, however I am find problems finding good usage guide for grants. I will update the oreilly mysql book. I need to do this with my bind and apache book too. Matt. -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 09:50 To: '[EMAIL PROTECTED]'; MySql List Subject: RE: adding users (reference from O'reilly book) Hi If you have a new copy of MySQL use GRANT. If you have an old copy update it. If you can not do this then Yes % is a wild card. Yes bob can use any host at user table is global. Yes you can use clear text passwords. Hope this helps. Simon PS I like using desc tablename PPS Get the new O'reilly book the old one is not so good! -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 09:38 To: MySql List Subject: adding users (reference from O'reilly book) I was reading about adding/managing users. I understand hat the user table holds user information. the example I will give is taken from the oreilly book. insert into user (host, user, password, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'bob', password('mypass'), 'Y', 'Y', 'Y', 'Y') ; questions 1.) is the % a wildcard, and if so does this mean the user bob can connect from any host ? 2.) the password function encrypts the password. If the password function is missed out before the ('mypass') bit will it enter the password un-encrypted ? or will it just not work ? thanks, Matt. - 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
Importing of text fails on incompatible date fields.
I have a flat text file that is about 820mb I need to import into a database that has the dates in the format MM-DD-. MySQL requires dates with the year first and when I try importing test chunks of the data all I get is zero's in the date field because of the dates being in the wrong format. There are about 30 million records so editing the file is not feasible. Will someone help me with a solution either with a perl script or some other method that you might know of. I am willing to research this further if someone will point me in the right direction. Thank You Jeremy Johnstone AltDNS.net inc. *** PLEASE REPLY TO MY EMAIL ADDRESS DIRECTLY *** *** [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: Lost connection, C API
Hi! Then it looks like a problem in the communication or in your client test program. The following error Commands out of sync; You can't run this command now (85 occurences) means that you have issued C API commands to a single MySQL connection in a wrong order. If your application has several client threads, are you sure you create one connection to each thread, and issue the C API commands in the right order? Sometimes people try to use a single connection for several client threads, and get the error above. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Bernard Chambon [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, January 08, 2002 11:16 AM Subject: Re: Lost connection, C API Heikki Tuuri wrote: Hi! Are you running mysqld under the safe_mysqld script, which automatically restarts mysqld after a crash? Yes, mysqld started with safe_mysqld script If yes, look at the 'hostname'.err file and send its contents to me. Nothing happens in the hostname.err (I started mysqld this morning at 11:45) 020107 11:45:08 mysqld started 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 11:45:10 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections With ps ..., I confirm that mysqld processes have NOT restarted (running since 11:45) Or, if you run mysqld from the command prompt, capture what mysqld prints to the command prompt window. If mysqld does not crash, then the problem is probably some client/server issue. Regards, Heikki Has we got a network error yesterday, I have run another test this night with the following modifications : max_connect_errors=65535 skip-host-cache connection to 'localhost' (the client and the serveur run on the same machine) I have got errors like : MySQL server has gone away (12 occurences) Commands out of sync; You can't run this command now (85 occurences) Lost connection to MySQL server during query (only one occurence) The transaction overload is about : 200848 Insert 486205 Update 334945 Select for 8 hours Before restarting the 2nd test I restart mysqld (yesterday at 22:28) so here is the hotname.err --- 020107 11:45:08 mysqld started 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 11:45:08 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 11:45:10 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections 020107 22:27:45 /opt/mysql/libexec/mysqld: Normal shutdown 020107 22:27:45 InnoDB: Starting shutdown... 020107 22:27:58 InnoDB: Shutdown completed 020107 22:27:58 /opt/mysql/libexec/mysqld: Shutdown Complete 020107 22:27:58 mysqld ended 020107 22:28:25 mysqld started 020107 22:28:26 Warning: setrlimit couldn't increase number of open files to more than 1024 020107 22:28:26 Warning: Changed limits: max_connections: 512 table_cache: 251 020107 22:28:27 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections Status information: Current dir: /opt/mysql/var/ Current locks: lock: 83f3ed0: lock: 8396308: lock: 8395a28: lock: 838cfa0: lock: 8390c00: lock: 838cf00: lock: 838ce60: lock: 838c588: lock: 837e8b8: lock: 837ee28: lock: 837ed90: lock: 83746e0: key_cache status: blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 5704 read_next:1706 read_rnd47 read_first:394 write:1447 delete 0 update:465 Table status: Opened tables: 26 Open tables: 20 Open files: 2 Open streams: 0 -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/CC - 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
OleDB
Hello Im using OleDB from my ASP pages and I have a problem with queries with count(*) and group by statement. I had the same problem with ODBC but i Solved it by setting the Change BigInt to Int and the Return all rows option. Now I changed to OleDB for better speed but I don't know how to set these options. So far my Database is pretty small with just 20 tables but it will grow fast and i want to use the best connection from start. Anybody have any ideas? Regards Mattias Persson - 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
Corrupt table
Hi! I have a most peculiar problem with a corrupt table. My situation: I have a mysql server running with several databases, one of them a log database that only have one table with several attributes. I have lots of inserts into this table which grows continuously, now the table size is about 400 MB. Every other day I'm running a batch file to remove older log messages and to optimize the table (with OPTIMIZE TABLE command). My problem: When the log database has grown over 250MB and I run the optimize table command from the batchfile, I get a corrupt table. I can run the recover option that only restores the indeces and the table is up and working again. When checking the table I get the following result: Checking MyISAM file: LogEvents Data records: 784569 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Key in wrong position at page 9251840 - check records and index references myisamchk: error: Record at: 226899000 Can't find key for index: 1 MyISAM-table 'LogEvents' is corrupted Fix it using switch -r or -o I have turned on the binary log and whenever it fails it has not happend anything out of the ordinary or at a special insert (i'm only doing inserts). I don't get any corrupt table problems on a log database with smaller amount of data ( 100MB) and not every time I do it on a larger database amount either but it has happend several times.. This problem arise when running optimize table, but another time I was making a huge free text search via the mysqladmin console. This was done while the log database was up and running and inserting a lot of messages, then I got the same problem that the database table got corrupt. It is very easy to repair, but I would gladly find out what the problem is instead so I can try fixing it. Anyone got a clue? I have only three indeces besides the primary key, one on two fields and the rest on single fields. THANKS! /Monika - 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
Business opportunity
Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center! A FREE membership in the DHS Club means saving money on everything you buy at The ClubShop Mall Affiliate Stores because you receive REBATES on ALL your purchases! FREE Members also save up to 1/2 the retail price on all purchases at the DHS Club Outlet Center! Have you ever thought about owning your own business? As a VIP, you are able to have your own affordable internet business! Fill out the form below and you will find all about the Internet's most innovative and exciting consumer and business opportunities - The DHS Club! To Find out more go to http://www.geocities.com/robertbill28344/ This is a one time mailing however if you wish to be removed from my list please reply to [EMAIL PROTECTED] with remove in the subject line. Thank You, Robert Bill VIP RB165603 - 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
Equivalent for 'prompt'.
Hi, Is there any MySQL equivalent command for the Oracle 'prompt' command (which writes out some text). Thanks in advance, -- Sebastien Guillemin - 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 exits with core dump segmentation fault
Bill Kurland writes: Thanks for the reply. gcc and g++ are both version 2.95.3 I've tried installing three different binaries, one from the mysql site and two different versions from the Bull site. All failed with different problems on this machine so I tired them all on a different model machine, but running the same version of AIX. They failed with the same problems. So, I figured I'd try building it for the specific machine Bill Kurland Shakespeare Co. 138 Watts Street New York, NY 10013 212.965.9683 x814 212.965.9884 fax [EMAIL PROTECTED] Please follow my other advices: First CXX should be gcc with 2.95.*. Second, your CPU type might be wrong. You could leave up to GCC to discover a proper CPU type that you have. Other possible cause is misconfiguration of AIX. Either due to TCP/IP, running of file descriptors, sockets etc ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unknown compiler errors (gcc 3.0.1 / 3.1)
Johan Wahlström writes: Hello Everyone! This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2 installation. (yes i have upgraded to 3.1 from the default 2.96 version). I get the same result with 3.0.1 also from Redhat. any ideas ? regards, Johan Just change CXXLD to g++ ... If you take a look at the latest 4.0.* BK repository, you will find out how we managed even to circumvent the usage of g++ in linking of mysqld. But this is not applicable to 3.23. branch. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unknown compiler errors (gcc 3.0.1 / 3.1)
Johan Wahlström writes: Hello Everyone! This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2 installation. (yes i have upgraded to 3.1 from the default 2.96 version). I get the same result with 3.0.1 also from Redhat. any ideas ? regards, Johan Just change CXXLD to g++ ... If you take a look at the latest 4.0.* BK repository, you will find out how we managed even to circumvent the usage of g++ in linking of mysqld. But this is not applicable to 3.23. branch. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: OleDB
Hi, I think that adding .;Extended Properties=OPTION=16400 to your ADO connection string should do the trick. Cheers, Bruce -Original Message- From: Mattias Persson [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 13:29 To: [EMAIL PROTECTED] Subject: OleDB Hello Im using OleDB from my ASP pages and I have a problem with queries with count(*) and group by statement. I had the same problem with ODBC but i Solved it by setting the Change BigInt to Int and the Return all rows option. Now I changed to OleDB for better speed but I don't know how to set these options. So far my Database is pretty small with just 20 tables but it will grow fast and i want to use the best connection from start. Anybody have any ideas? Regards Mattias Persson - 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
timestamp column
Hi, My table has 3 columns: id, name, timestamp. When I use the MySQL command line client, (a) insert into table values(1,'xxx') fails for insufficient number of values. (b) insert into table values(1,'xxx',null) succeeds. 1. The MySQL manual states that The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. So why doesn't option (a) above work? 2. When using statement (b) from MS Access application, access claims Cannot update 'TimeStamp'; Field is not updateable. Turns out that I'm unable to use any of the statements (a) or (b) from within an access application. So what is it that I don't understand ??? Thanks, Osnat. - 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
Wishing you Happy new year
HTML HEAD TITLE/TITLE style type=text/css !-- .ms {font-family:arial; font-size:10pt} .rj {font-family:arial; font-size:8pt} //-- /style /HEAD BODY form action = http://www.essencomp.com/unsubscribe.asp; method=post table border=0 cellpadding=0 cellspacing=0 width=50% align=center trTd align=rightimg src=http://www.essencomp.com/images/image1.jpg; border=0/td td width=15%nbsp;/td /tR tr Td table width=90% cellpadding=0 cellspacing=0 border=0 align=right trtd table width=100% cellpadding=0 cellspacing=0 border=0 trTd width=99%font face=Times New Roman size=6Santa brings your businessbrthe best present of all...nbsp;nbsp;a bright future /font/td td align=rightimg src=http://www.essencomp.com/images/horiaie.jpg; border=0/td /tr /table /td /tR /table /td tdnbsp;/td /tR trTd align=right table width=100% cellpadding=0 cellspacing=0 border=0 trtd width=1% valign=bottomimg src=http://www.essencomp.com/images/horia_6ie.jpg; border=0/td td align=rightimg src=http://www.essencomp.com/images/santa.gif; border=0/td /tr /table tdnbsp;/td /tR tr Td table border=0 cellpadding=0 cellspacing=0 width=100% trtd width=5%img src=http://www.essencomp.com/images/horia1ie.jpg; border=0/td td table border=0 cellpadding=0 cellspacing=0 width=85% align=right tr tdp align=justify class=msThe success of your business depends on how you deal with the current situations and adapt to changes, as they occur around you. Changing times wait for no one. To survive and thrive in the modern market, your business needs that extra edge. One that the latest technology provides, by keeping you in step with the future. /p p align=justify class=ms Using the internet as an additional business resource, is this very step forward. With the iEssen/i Cyber Outlet software, a ready to use e-business solution, you can create your own online store in less than an hour.* /p p align=justify class=ms Purchase the licensed software right away and see the difference. At just pennies a day for a year only, the software pays for itself. You pay no more. Just selling less than one extra burger, icecream, or an item of similar value every day, will recover your cost within a year. Even as you earn much more, with each passing day. /p p align=justify class=ms The time is ripe. Grab the present now. For it will shape your future. brAs Santa is always right! Merry Christmas!! brbrtable border=0 cellpadding=0 cellspacing=0trTd class=rj*Domain registration valid internet merchant account needed./td/tr/table /p
replication :Slave thread: error connecting to master..urgent
Hi! aravindgorthy == aravindgorthy iso-8859-1 writes: aravindgorthy Hai aravindgorthy While setting up the replication environment i am aravindgorthy getting the following error in the master ..what might aravindgorthy be the problem aravindgorthy 020108 13:20:00 Slave thread: error connecting to aravindgorthy master: Can't connect to MySQL server on '' (10049) aravindgorthy (0), retry in 60 sec aravindgorthy I followed all the steps correctly given in the aravindgorthy manual. aravindgorthy The master status and slave status are not showing aravindgorthy null and my slave is in a running stage. aravindgorthy Thanks in advance. aravindgorthy Aravind aravindgorthy = aravindgorthy Aravind Gorthy, aravindgorthy VisualSoft Technologies. To be able to help you with this, we would need know your my.cnf files for both the master and the slave and the contents of the master.info file on the slave. Any other information that you can give about your setup would also be helpful! Regards, Monty PS: If you can't get this to work, a fast route to get this to work would be to take up MySQL support from https://order.mysql.com and let the MySQL developers help you set up your system. - 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: mysqlgui - my.cnf or my.ini
jds writes: hi! i'm running 3.23.47 w/ mysql gui1.7.5-2 on win2k to config innodb, i edited the my.ini (with some help from heikki...thanks!) and learned on win my.cnf and my.ini cannot co-exist. now i'm ready to install mysqlgui to set up my admin, users, etc... my question is: can i add the included mysqlgui parameters to my.ini in WINNT? will this work? it only mentions adding to c:\my.cnf (which i don't have, since it cant use both) thanks in advance, jds Hi! Yes, you can. But , you do not need to. The only real reason why you would create [client_fltk] options header is to : * have help file on F1 key * to share the same history file with mysql monitor program * to change a location of options file for mysqlgui In any case, just fill up all entries in Options dialogue and Save them. That is all you have to do with mysqlgui ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: timestamp column
* Osnat Rabi My table has 3 columns: id, name, timestamp. When I use the MySQL command line client, (a) insert into table values(1,'xxx') fails for insufficient number of values. I don't know if this will help you, but this is valid: insert into table set id=1, name='xxx'; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql Gui connecting to remote server problem
Matthew Darcy writes: Hi, my laptop is running windows 2000 and is called jaguar. I have mysql running on a linux server called jordan. when I fire up mysqlui and tell it to connec to jordan as root I get prompted for a password. I enter the password (that I have tested and is correct) and it say at the bottom of the gui Host 'jaguar.no-dns.co.uk' is not allowed to connect to this MySQL server how can I fix this. Thanks, Matt. The above is MySQL access problem. You have not granted user rights to login from jaguar.no-dns.co.uk host. Either grant access to [EMAIL PROTECTED] or to user@%, which means any host. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About spam
[EMAIL PROTECTED] writes: HTML I'm getting seriously sick of the amount of spam on this list. I don't know what MySQL employee is responsible for managing this list, but assuming that there is such a person, could he/she _please_ do something about the problem? When every other list owner can figure out how to restrict posting to subscribers only, how hard can it be? As far as I have seen, it's quite rare with serious posts from non-subscribers, whereas the spam and empty bug reports arrive at a rate that's on the order of mails per day. //C - annoyed -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Installing Static MySQLGUI on Solaris 7
EDA Peach writes: Hi Gerald, Sorry ... the OS is Solaris 7, running on a Sun Ultra Sparc 5. I downloaded the Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 (mysqlgui-solaris-2.7-sparc-static-1.6.gz). I gunzipped the file and attempted to execute it and got this error message: ld.so.1: mysqlgui-solaris-2.7-sparc-static-1.6: fatal: libstdc++.so.2.10.0: open failed: No such file or directory Killed Please advise. Thanks. Regards, Eda Hi! To make it run, you need to install libstdc++ from gcc 2.95.2 package and mysqlgui will run -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Location of databases
We run MySql on our Freebsd server, and on our Win2K server. We have several clients, and would like to store the databases in the clients' root directory. Is this possible? Thanks! - 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 Book
I prefer 'MySQL' by Michael Kofler (Apres ISBN 1893115577) D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. - 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 -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz Heise GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 - 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
Com_select larger than questions bug?
From show status (in mysql 4.0.1) | Com_select | 192446| | Questions| 121881| Why are there more selects than the total number of questions? Is that correct? There are of course Insert, deletes and other Com_ variables as well. I can provide the whole list! Thanks, Ken - Ken Menzel ICQ# 9325188 www.icarz.com [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: Location of databases
There are two things you can do when running MySQL for other people. One: Use GRANT and let every one know about but not see each others databases. Two: Run more than one copy of MySQL on your sever...this also means that they can be set up for each persons needs Hope this helps... Simon -Original Message- From: Michael D. Stackhouse [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 15:05 To: mysql list Subject: Location of databases We run MySql on our Freebsd server, and on our Win2K server. We have several clients, and would like to store the databases in the clients' root directory. Is this possible? Thanks! - 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: SELECT MAX makes MYSQL Crush
Rezal wrote: hello, i got a really long text to put in mysql n when i use longtext field, it isnt enuff Can u help me pls ?? thx in advance feroze Sheesh! Over 4 GB in a single row? That doesn't make much sense. Why not store the text in a file on the filesystem instead? And just a point that struck me; if one has got large objects in a database and want to use it (for instance, for some web application), one's better off storing just a link to the file instead of storing the whole nine yards in the database. Cheers, Markus -- Markus Lervik UNIX-administrator with a kungfoo grip Vaasa City Library - Regional Library - 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
Assertion failure in thread 54 in file trx0undo.c line 1316
Bonjour, Any idea ? I will try to make the server crash one more time and tell you if I find the query. Regards, Alex. 020108 9:43:58 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections InnoDB: Error: undo-id is 2860816 InnoDB: Assertion failure in thread 54 in file trx0undo.c line 1316 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=67104768 record_buffer=1044480 sort_buffer=2097144 max_used_connections=53 max_connections=100 threads_connected=47 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 372331 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 020108 16:31:20 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 34 1254013465 InnoDB: Doing recovery: scanned up to log sequence number 34 1254078976 InnoDB: Doing recovery: scanned up to log sequence number 34 1254144512 InnoDB: Doing recovery: scanned up to log sequence number 34 1254210048 InnoDB: Doing recovery: scanned up to log sequence number 34 1254275584 InnoDB: Doing recovery: scanned up to log sequence number 34 1254341120 InnoDB: Doing recovery: scanned up to log sequence number 34 1254406656 InnoDB: Doing recovery: scanned up to log sequence number 34 1254472192 InnoDB: Doing recovery: scanned up to log sequence number 34 1254537728 InnoDB: Doing recovery: scanned up to log sequence number 34 1254603264 InnoDB: Doing recovery: scanned up to log sequence number 34 1254668800 InnoDB: After this prints a line for every 10th scan sweep: InnoDB: Doing recovery: scanned up to log sequence number 34 1255324160 InnoDB: Doing recovery: scanned up to log sequence number 34 1255979520 InnoDB: Doing recovery: scanned up to log sequence number 34 1256634880 InnoDB: Doing recovery: scanned up to log sequence number 34 1257290240 InnoDB: Doing recovery: scanned up to log sequence number 34 1257945600 InnoDB: Doing recovery: scanned up to log sequence number 34 1258600960 InnoDB: Doing recovery: scanned up to log sequence number 34 1259256320 InnoDB: Doing recovery: scanned up to log sequence number 34 1259911680 InnoDB: Doing recovery: scanned up to log sequence number 34 1260567040 InnoDB: Doing recovery: scanned up to log sequence number 34 1261222400 InnoDB: Doing recovery: scanned up to log sequence number 34 1261877760 InnoDB: Doing recovery: scanned up to log sequence number 34 1262533120 InnoDB: Doing recovery: scanned up to log sequence number 34 1263188480 InnoDB: Doing recovery: scanned up to log sequence number 34 1263843840 InnoDB: Doing recovery: scanned up to log sequence number 34 1264499200 InnoDB: Doing recovery: scanned up to log sequence number 34 1265154560 InnoDB: Doing recovery: scanned up to log sequence number 34 1265809920 InnoDB: Doing recovery: scanned up to log sequence number 34 1266465280 InnoDB: Doing recovery: scanned up to log sequence number 34 1267120640 InnoDB: Doing recovery: scanned up to log sequence number 34 1267776000 InnoDB: Doing recovery: scanned up to log sequence number 34 1268431360 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents:0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 020108 16:32:54 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections - 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: Location of databases
Thanks - but my real question is where is this data stored on my system? Do I have control to locate the databases for each client in different locations? Mike Simon Green wrote: There are two things you can do when running MySQL for other people. One: Use GRANT and let every one know about but not see each others databases. Two: Run more than one copy of MySQL on your sever...this also means that they can be set up for each persons needs Hope this helps... Simon -Original Message- From: Michael D. Stackhouse [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 15:05 To: mysql list Subject: Location of databases We run MySql on our Freebsd server, and on our Win2K server. We have several clients, and would like to store the databases in the clients' root directory. Is this possible? Thanks! - 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: About spam
Reported to SpamCop.net At 15:54 2002-01-08, Carl Troein [EMAIL PROTECTED] [RegSoft/mysql] wrote: [EMAIL PROTECTED] writes: HTML I'm getting seriously sick of the amount of spam on this list. I don't know what MySQL employee is responsible for managing this list, but assuming that there is such a person, could he/she _please_ do something about the problem? When every other list owner can figure out how to restrict posting to subscribers only, how hard can it be? As far as I have seen, it's quite rare with serious posts from non-subscribers, whereas the spam and empty bug reports arrive at a rate that's on the order of mails per day. //C - annoyed -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need to do to prevent this, including uninstalling WinMySQLAdmin, which I have not figured out how to do? When I remove my.ini from C:\Windows and reinstall C:\my.cnf, then the my.cnf gets renamed to my_cnf.bak and a minimal C:\Windows\my.ini is created when I reboot. Is there a flag for the [WinMySQLAdmin] section in the my.ini file that I can declare which will instruct WinMySQLAdmin not to auto start when the computer is rebooted? Thanks, Dan Jordan - 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: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Just take the shortcut out of the startup menu -Original Message- From: Dan Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:04 AM To: [EMAIL PROTECTED] Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need to do to prevent this, including uninstalling WinMySQLAdmin, which I have not figured out how to do? When I remove my.ini from C:\Windows and reinstall C:\my.cnf, then the my.cnf gets renamed to my_cnf.bak and a minimal C:\Windows\my.ini is created when I reboot. Is there a flag for the [WinMySQLAdmin] section in the my.ini file that I can declare which will instruct WinMySQLAdmin not to auto start when the computer is rebooted? Thanks, Dan Jordan - 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
Time and dates with Access.
I'm having difficulty handling data and time with access. I'm using the ODBC driver from the MySQL site to link the tables, and I can view and manipulate the data. the problem comes when I save a time, it is displayed incorrectly in access. Is this a known problem? If so, how do I work around 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
General Query time question
Hello all. I have a database which is around 10million rows. The structure is as follows: id int(11) NOT NULL- Auto Increment address char(90) NOT NULL status char(2) NOT NULL country char(2) state char(2) areacode char(3) ...about 40 char(1) fields. I have an unique index on address, and a non-unique index on address. I also have a non-unique index on status. My questions is this. The following query takes about 7 minutes to run: SELECT count(*) as count from userdata; This is on a PIII 700, with 512MB Ram, running Linux. Is that amount of time normal on a 10million record DB? Or, are the 40 char(1) fields just slowing it down? Thanks for any help, Darren - 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: Assertion failure in thread 54 in file trx0undo.c line 1316
Alex, looks like a memory overwrite. A trx undo log object contains a random field. Did you do anything special with the database when this happened? Regards, Heikki Innobase Oy . Bonjour, Any idea ? I will try to make the server crash one more time and tell you if I find the query. Regards, Alex. 020108 9:43:58 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections InnoDB: Error: undo-id is 2860816 InnoDB: Assertion failure in thread 54 in file trx0undo.c line 1316 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=67104768 record_buffer=1044480 sort_buffer=2097144 max_used_connections=53 max_connections=100 threads_connected=47 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 372331 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 020108 16:31:20 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 34 1254013465 InnoDB: Doing recovery: scanned up to log sequence number 34 1254078976 InnoDB: Doing recovery: scanned up to log sequence number 34 1254144512 - 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
Different instances of mysqladmin
Can I have different instances of winmysqladmin start instanciating different mysql's? i want to run one for the stable version, and one for mysql 4.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: General Query time question
Correction on the query: SELECT count(*) as count FROM userdata WHERE status = 'A'; Sorry. -Original Message- From: Greer, Darren (MED) Sent: Tuesday, January 08, 2002 10:20 AM To: '[EMAIL PROTECTED]' Subject: General Query time question Hello all. I have a database which is around 10million rows. The structure is as follows: id int(11) NOT NULL- Auto Increment address char(90) NOT NULL status char(2) NOT NULL country char(2) state char(2) areacode char(3) ...about 40 char(1) fields. I have an unique index on address, and a non-unique index on address. I also have a non-unique index on status. My questions is this. The following query takes about 7 minutes to run: SELECT count(*) as count from userdata; This is on a PIII 700, with 512MB Ram, running Linux. Is that amount of time normal on a 10million record DB? Or, are the 40 char(1) fields just slowing it down? Thanks for any help, Darren - 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: General Query time question
Greer, Darren (MED) writes: Correction on the query: SELECT count(*) as count FR OM userdata WHERE status = 'A'; Ah. That does make a difference. MySQL is of course forced to go through all of your data, counting the number of rows with status 'A'. I don't believe an index would do you much good, since it'd add so much to the size of the index file and slow down updates and inserts. Is there any way you could just store that number in another table, maybe? You'd have to update it every time you insert or update the big table, but if that's only done in a few places it should be doable. If that won't work, but it's not important with perfect accuracy, you could run that evil SELECT once a day or however often you like, and cache the result. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: About spam
Personnaly I found no particular spam on this list, in the beginning of the year I found article dated to the 01/01/2003 and not the 01/01/2002, this message was refused cause it doens t contain words like sql I thinks that my mail client wich doesn work well (hum outlook). a+. - 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: General Query time question
You are correct, they are simple Y/N fields. I am not familiar with the process you mentioned, but will do some digging. If you have any information you could give me that doesn't require too much of your time, I would appreciate it. Thanks, Darren -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:37 AM To: Greer, Darren (MED) Cc: '[EMAIL PROTECTED]' Subject: Re: General Query time question I'm just guessing here, but I suppose most of the char(1) fields are y/n fields. If that's the case you should consider using a single BIGINT and flag those bits instead. That would considerably reduce the size of the table on one hand and I guess it should improve things speed-wise as well. Obviously, my whole theory stands on a supposition, so I might be wrong in suggesting this. Bogdan Greer, Darren (MED) wrote: id int(11) NOT NULL- Auto Increment address char(90) NOT NULL status char(2) NOT NULL country char(2) state char(2) areacode char(3) ...about 40 char(1) fields. - 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
General mySQL setup question
Hi, Would like to know if there is a preferred way of setting up the data directory for mySQL. The default for a database would be in C:\mysql\data. Is this the preferred way or should this be set up in another directory outside of the mysql directory? Does moving the data directory affect performance, security, etc? Most likely there is no difference but would like to see if there is a preferred way of setting this up. Thanks! -los _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 problems on 4-way server
Hi, We are running MySQL version 3.23.43 on one of our servers and have some stability problems the occur about every 1-2 days. When it happens everythings keeps working but the load goes up to about 80. After stopping and restarting MySQL everything goes back to normal (load average about 0.5). There are usually only a few connection open at the same time (about 20) and we have no slow or heavy duty queries. Is there anyone who had a similar problem? We're not sure what could possibly cause this. Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet connection Software: Base RedHat 7.2 installation Unpatched kernel 2.4.17 The database-files are placed on a dedicated raid-5 disk. Note: Displaying the processlist does not reveal any unusual or special queries when the problem occurs. They just run slower because of the high load. Regards, Dennis - 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: General Query time question
I didn't think/read far enough. One more attempt is due. Correction on the query: SELECT count(*) as count FR OM userdata WHERE status = 'A'; I didn't see that it was on that column you had an index, so forget I said 'of course'. Have you used EXPLAIN to figure out if the index is actually used in the query? If you haven't already, consider running an ANALYZE TABLE just so MySQL can get some idea of the distribution for the indexed columns. It might help the optimizer make a better decision if it's not already doing what's best. If the status column only has a few different values, an index will not be used because the overhead of using the index will be greater than the benefit. If this is the case, you'll be better off without the index, and you could consider one of the two options I rambled about in my previous mail. //C - sorry 'bout that. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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 authentication using PAM
On Mon, Jan 07, 2002 at 10:43:57PM -0600, Jeff Williams wrote: We have been using LDAP for our user database for some years. We are now getting into MySQL, and I would like to be able to grant or deny access within MySQL based on LDAP user information, rather than having to maintain a separate database of users within MySQL. I understand that there is presently no support for doing this directly to LDAP; but I wondered if there is a way of having MySQL authenticate against PAM. I would certainly appreciate any information anyone can give me on this. There currently is no PAM support in MySQL. Part of the problem is that MySQL would still need some mechanism for figuring out which hosts are allowed to connect. Last I checked, PAM only deals with usernames and passwords, buy MySQL uses the combination of user/pass/host when granting access. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 5 days, processed 122,691,712 queries (246/sec. avg) - 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: Importing of text fails on incompatible date fields.
#!/your/path/to/perl open(OLD, yourbigfile.txt); open(FIXED, newfile); while ($line = OLD) { $line =~ s/(\d{2})-(\d{2})-(\d{4})/$3-$1-$2/g; print FIXED $line; } Michael On Tue, 8 Jan 2002, Jeremy Johnstone wrote: I have a flat text file that is about 820mb I need to import into a database that has the dates in the format MM-DD-. MySQL requires dates with the year first and when I try importing test chunks of the data all I get is zero's in the date field because of the dates being in the wrong format. There are about 30 million records so editing the file is not feasible. Will someone help me with a solution either with a perl script or some other method that you might know of. I am willing to research this further if someone will point me in the right direction. Thank You Jeremy Johnstone AltDNS.net inc. *** PLEASE REPLY TO MY EMAIL ADDRESS DIRECTLY *** *** [EMAIL PROTECTED] Michael Stassen University Information Technology Services Indiana University Bloomington [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
Debian and MySQL
Hi all, I'm doing some experimenting with debian, has anybody created any .deb packages for MySQL? TIA, John - 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: variable descriptions missing in the documentation
Jean-Luc Fontaine writes: I would need those to finish the on-line help in my mystatus and myvars moodss modules for the 4.0.1 server. Please let me know if this is not the right place to post this. [skip] I also take this opportunity to wish a very successful new year to the MySQL team. Best regards, -- Jean-Luc Fontaine Jean-Lux, You will get description of most of those in the manual from our BK repository. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
count(distinct
SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip) FROM pole_voti' at line 1 Why ? Where is the error ? Ilic. - 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: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
is WinMySQLAdmin in your Windows START folder? -Original Message- From: Dan Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:04 AM To: [EMAIL PROTECTED] Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need to do to prevent this, including uninstalling WinMySQLAdmin, which I have not figured out how to do? When I remove my.ini from C:\Windows and reinstall C:\my.cnf, then the my.cnf gets renamed to my_cnf.bak and a minimal C:\Windows\my.ini is created when I reboot. Is there a flag for the [WinMySQLAdmin] section in the my.ini file that I can declare which will instruct WinMySQLAdmin not to auto start when the computer is rebooted? Thanks, Dan Jordan - 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: Tru64 UNIX V5.1A Build Instructions (gcc) ?
Elgaard Sorensen, Karsten writes: Hi All. Has anybody from the MySQL source distribution successfully build a working MySQL ? I have done it using Compaq's C and C++ compiler - But I would like to have build instructions when using GNU C. Regards and thanks, Karsten Elgaard Sørensen Compaq Computer ApS Denmark Hi! You will find all instructions needed in our manual. Section on Tru64 ... There are also binaries available on our site. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Kylix frustrated me...!!!
Dear Friends, I am trying to develop an application with Kylix ver.1, MySQL ver.11.15 distrib 3.23.41 for suse linux (i686). I am using MySQLConnection object to connect my MySQL database server (and with so : libmysqlclient.so.10.0.0). But I found some ridiculous problem : 1. Have setup/determine the value of the parameter in Parameter String of MySQLConnection object and Ive setup LoadParamsOnConnect and LoadPrompt to true. If I am trying to login to my MySQL using MySQLConnection object from the server machine where my MySQL located/exists, than I can do login properly. But If I try to login from another machine (client) than I found error message that saying my username or password is wrong. But its impossible because Ive also tried to connect from the same client machine and using KMySQL and I can login with this KMySQL properly. What is the mistake ? I could not login with MySQLConnection object of Kylix from a client machine because it said the username or the password that I am using to login was wrong. 2. And after If I have logged in with MySQLConnection object of Kylix into my MySQL server, SQLDataSet ran very peculiar (not properly). I have determine the value of DataSource parameter into DataSource1, SQLConnection parameter into SQLConnection1, but If I activate the SQLDataSet object (turn active parameter value into true) than my Kylix hang (hangup). I can not do anything anymore to my Kylix because after I activate the SQMDataSet, lookslike my Kylix is too busy to do something and it can not give me any reaction if I do any action even only one click of my mouse it can not give a reaction. Its just simply hangup. What is the mistake ? Please Help me !!! I dont what to do anymore .. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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: [SLE] Kylix frustrated me...!!!
Hello Prabu, Is it really nessesary to use proprietary Kylix environment (is it using Pascal as a core language?) to write your application? I'm not a specialist in Kylix but why don't you look into possibility of using open source programming languages and editors? For example, using just a plain vi editor you can write just any kind of code in Perl, C/C++, Java e.t.c. If you addicted to graphical environments you can use free Quanta+ editor and others. Just a suggestion, please don't take me wrong. Alex --- Dear Friends, I am trying to develop an application with Kylix ver.1, MySQL ver.11.15 distrib 3.23.41 for suse linux (i686). I am using MySQLConnection object to connect my MySQL database server (and with so : libmysqlclient.so.10.0.0). But I found some ridiculous problem : 1. Have setup/determine the value of the parameter in Parameter String of MySQLConnection object and Ive setup LoadParamsOnConnect and LoadPrompt to true. If I am trying to login to my MySQL using MySQLConnection object from the server machine where my MySQL located/exists, than I can do login properly. But If I try to login from another machine (client) than I found error message that saying my username or password is wrong. But its impossible because Ive also tried to connect from the same client machine and using KMySQL and I can login with this KMySQL properly. What is the mistake ? I could not login with MySQLConnection object of Kylix from a client machine because it said the username or the password that I am using to login was wrong. 2. And after If I have logged in with MySQLConnection object of Kylix into my MySQL server, SQLDataSet ran very peculiar (not properly). I have determine the value of DataSource parameter into DataSource1, SQLConnection parameter into SQLConnection1, but If I activate the SQLDataSet object (turn active parameter value into true) than my Kylix hang (hangup). I can not do anything anymore to my Kylix because after I activate the SQMDataSet, lookslike my Kylix is too busy to do something and it can not give me any reaction if I do any action even only one click of my mouse it can not give a reaction. Its just simply hangup. What is the mistake ? Please Help me !!! I dont what to do anymore .. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- To unsubscribe send e-mail to [EMAIL PROTECTED] For additional commands send e-mail to [EMAIL PROTECTED] Also check the FAQ at http://www.suse.com/support/faq and the archives at http://lists.suse.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: MySQLgui fails
Roel Van den Bergh writes: After a long day of trying and reading all sorts of manuals and faqs and newsgroups I still can't create tables with the mySQLgui (1.7.5.2 windows) running in win 2000 pro standalone feature I can read the test database (empty of course)and the users dbase in neither of them I'm able of creating new tables What am I doing wrong? tnx for helping this NB - - - Roel Van den Bergh - Interieurarchitect email: [EMAIL PROTECTED] http://www.planetinterior.com Hi! You can run CREATE / ALTER table from mysqlgui without any problems. Doing it through GUI interface was not done due to a lack of time. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing Static MySQLGUI on Solaris 7
Hi, gcc and the libstdc++ are already loaded. libstdc++ is in /usr/local/lib should it be somewhere else? Please advise. Thanks. Regards, Mike --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: EDA Peach writes: Hi Gerald, Sorry ... the OS is Solaris 7, running on a Sun Ultra Sparc 5. I downloaded the Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 (mysqlgui-solaris-2.7-sparc-static-1.6.gz). I gunzipped the file and attempted to execute it and got this error message: ld.so.1: mysqlgui-solaris-2.7-sparc-static-1.6: fatal: libstdc++.so.2.10.0: open failed: No such file or directory Killed Please advise. Thanks. Regards, Eda Hi! To make it run, you need to install libstdc++ from gcc 2.95.2 package and mysqlgui will run -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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: General Query time question
If I move the status to another table, and then wanted to get a count of everyone who is of status 'A', how would that be any quicker? Would I join the tables? -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:34 AM To: [EMAIL PROTECTED] Subject: Re: General Query time question I didn't think/read far enough. One more attempt is due. Correction on the query: SELECT count(*) as count FR OM userdata WHERE status = 'A'; I didn't see that it was on that column you had an index, so forget I said 'of course'. Have you used EXPLAIN to figure out if the index is actually used in the query? If you haven't already, consider running an ANALYZE TABLE just so MySQL can get some idea of the distribution for the indexed columns. It might help the optimizer make a better decision if it's not already doing what's best. If the status column only has a few different values, an index will not be used because the overhead of using the index will be greater than the benefit. If this is the case, you'll be better off without the index, and you could consider one of the two options I rambled about in my previous mail. //C - sorry 'bout that. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Com_select larger than questions bug?
Ken Menzel writes: From show status (in mysql 4.0.1) | Com_select | 192446| | Questions| 121881| Why are there more selects than the total number of questions? Is that correct? There are of course Insert, deletes and other Com_ variables as well. I can provide the whole list! Thanks, Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] Hi! This is a bug that we shall soon sort out ... You are evidently using our BK tree ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Debian and MySQL
%% John Cichy [EMAIL PROTECTED] writes: jc I'm doing some experimenting with debian, has anybody created any .deb jc packages for MySQL? Go to http://www.debian.org, on the left menu bar pick Debian Packages, then in the search box enter mysql (make sure the distribution is set correctly for whatever Debian distro you have installed). MySQL is free software, so it's eligible to be (and in fact is) included in Debian proper. You don't need any 3rd party .debs for it. HTH! -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - 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: Com_select larger than questions bug?
Hi Back! Hi! This is a bug that we shall soon sort out ... OK Great, just wanted to make sure you knew about it, or that find out what I did not understand. (So which is the correct number?) You are evidently using our BK tree ... Well, not on that one, that is 4.0.1-alpha from ftp.mysql.com, I am using the BK tree on my personal test test system, but it has been working so well that when 4.0.1 came out we installed it on our internal company test systems, which runs our web demo site, our demo databases and our internal company intranet. It has been working very well. Then only issue I have had I think is a FreeSD threads issue (not new, same old thing). I am preparing an e-mail to ask for advice on how to proceed. It does not happen often but would be good to change. Thanks Sinisa! Ken P.S. (I'll am watching internals list for multitable update). P.P.S got 10 inches (25 cm) of snow yesterday. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: count(distinct
I don't have MySQL on the computer I am on to test this but you might try rewriting it this way: select count(distinct(ip)) from pole_voit Original Message Follows From: Ilic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: count(distinct Date: Tue, 8 Jan 2002 18:47:43 +0100 SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip) FROM pole_voti' at line 1 Why ? Where is the error ? Ilic. - 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 _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote: On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: : : So, could you give me some advice that if it is feasible ? Or show : me your successful cases of using mySQL which is supporting very : large DB or tables with details ? : : How about a table with 260 million rows? We've got one that is very, : very quick for indexed selects. How quick is it for inserts? And what table type? Sorry for the insanely late reply. I had to vanish for a while. It is a MyISAM table and we can run a few hundred inserts/second on it--(probably a lot more, but I can't easily test that right now. Hope that helps. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 5 days, processed 123,265,106 queries (246/sec. avg) - 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: Stability problems on 4-way server
Dennis Jacobfeuerborn writes: Hi, We are running MySQL version 3.23.43 on one of our servers and have some stability problems the occur about every 1-2 days. When it happens everythings keeps working but the load goes up to about 80. After stopping and restarting MySQL everything goes back to normal (load average about 0.5). There are usually only a few connection open at the same time (about 20) and we have no slow or heavy duty queries. Is there anyone who had a similar problem? We're not sure what could possibly cause this. Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet connection Software: Base RedHat 7.2 installation Unpatched kernel 2.4.17 The database-files are placed on a dedicated raid-5 disk. Note: Displaying the processlist does not reveal any unusual or special queries when the problem occurs. They just run slower because of the high load. Regards, Dennis Please install and use latest 3.23 binary RPM from our site. If you are not using our binary, then it is probably a cause of instability. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing Static MySQLGUI on Solaris 7
EDA Peach writes: Hi, gcc and the libstdc++ are already loaded. libstdc++ is in /usr/local/lib should it be somewhere else? Please advise. Thanks. Regards, Mike It could be anywhere you like as long as that directory is in LD_LIBRARY_PATH. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thanks for the help with MyODBC
Through the responses, links, and a little concern (and a really smart and helpful web Host, he did most of the hard stuff), I got MyODBC working like a charm. Made up a file DSN and can use it in Visual C++, Visual Basic, and Access. Also thanks to whomever put MyODBC out there... database,sql,query,table - 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: count(distinct
The syntax is: SELECT DISTINCT http://www.mysql.com/doc/S/E/SELECT.html Xi2 -Original Message- From: Ilic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: count(distinct SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip) FROM pole_voti' at line 1 Why ? Where is the error ? Ilic. - 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: RE: RE: Mysql connection problem
Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy Simon Green [EMAIL PROTECTED] 01/08 1:26 AM Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: mysql not found. How can I find mysql server? Cindy Simon Green [EMAIL PROTECTED] 01/07 10:05 AM No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
At 09:04 08/01/2002 -0700, Dan Jordan wrote: Hi! Go to start Menu and remove the Icon of WinMySQLAdmin. Regards, Miguel Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need to do to prevent this, including uninstalling WinMySQLAdmin, which I have not figured out how to do? When I remove my.ini from C:\Windows and reinstall C:\my.cnf, then the my.cnf gets renamed to my_cnf.bak and a minimal C:\Windows\my.ini is created when I reboot. Is there a flag for the [WinMySQLAdmin] section in the my.ini file that I can declare which will instruct WinMySQLAdmin not to auto start when the computer is rebooted? Thanks, Dan Jordan - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Syncronization between two databases
On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: Hi! I need to syncronize two indentical MySQL databases. The A database is on a server permanently connected to the Internet trough an ADSL connection, while the B database is on a server equipped with an ISDN connection. How can I keep the two databases identical? Have you looked at MySQL's built-in replication? PS: Sorry for my bad english, but I'm Italian. Don't be. It's pretty good. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 5 days, processed 123,728,201 queries (245/sec. avg) - 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: RE: Mysql connection problem
from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Mysql connection problem Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy Simon Green [EMAIL PROTECTED] 01/08 1:26 AM Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: mysql not found. How can I find mysql server? Cindy Simon Green [EMAIL PROTECTED] 01/07 10:05 AM No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql connection problem
The server is not telling you that mysql is not found. The shell is telling you that mysql is not found because the the current directory is not included in the PATH searched by the shell. try ./mysql or /usr/local/bin/mysql. Cindy Yu wrote: Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy Simon Green [EMAIL PROTECTED] 01/08 1:26 AM Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: mysql not found. How can I find mysql server? Cindy Simon Green [EMAIL PROTECTED] 01/07 10:05 AM No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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: Stability problems on 4-way server
Dennis Jacobfeuerborn [EMAIL PROTECTED] writes: We are running MySQL version 3.23.43 on one of our servers and have some stability Where did you get that? The MySQL site? Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet connection Software: Base RedHat 7.2 installation Unpatched kernel 2.4.17 2.4.17 has problems with heavy database usage. Does this happen on the supported kernels as well? (I'm guessing yes, this doesn't seem to have anything to do with the kernel... you might want to check if anything suspicious show up in dmesg, though) -- Trond Eivind Glomsrød Red Hat, Inc. - 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: Importing of text fails on incompatible date fields.
Jeremy, Apart from this perl of wisdom, how about defining two columns: one a 'temporary' text field and the other the 'real date column - as proposed, and importing the date-data into MySQL in the temporary-text field (and leaving the other/real one empty). Then copy the data out of the temporary column, use MySQL's functions to extract and re-concatenate the components into the MySQL sequence, and update the record's real/date column. Once all this is done (and checked - a step which might be harder in the Perl-driven solution) the temporary/construction date-data column can be dropped. Regards, =dn #!/your/path/to/perl open(OLD, yourbigfile.txt); open(FIXED, newfile); while ($line = OLD) { $line =~ s/(\d{2})-(\d{2})-(\d{4})/$3-$1-$2/g; print FIXED $line; } Michael On Tue, 8 Jan 2002, Jeremy Johnstone wrote: I have a flat text file that is about 820mb I need to import into a database that has the dates in the format MM-DD-. MySQL requires dates with the year first and when I try importing test chunks of the data all I get is zero's in the date field because of the dates being in the wrong format. There are about 30 million records so editing the file is not feasible. Will someone help me with a solution either with a perl script or some other method that you might know of. I am willing to research this further if someone will point me in the right direction. Thank You Jeremy Johnstone AltDNS.net inc. *** PLEASE REPLY TO MY EMAIL ADDRESS DIRECTLY *** *** [EMAIL PROTECTED] Michael Stassen University Information Technology Services Indiana University Bloomington [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
MySQL + InnoDB + fereign keys
Hi. I am using MySQL 3.23.44-MAX. with InnoDB I have create two tables (one of them parent, other child). All seems Ok. But when I am trying to insert new record into the table I am getting key violation. It happened when I am trying insert null value into field that have foreign key. (column could be null) I am tried to find any mention over the net, but I haven't found any mentions about this. Sincerely yours, Ivan Latysh. [EMAIL PROTECTED] http://ivan.yourmail.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: Different instances of mysqladmin
At 09:31 08/01/2002 -0700, John Meyer wrote: Hi! Can I have different instances of winmysqladmin start instanciating different mysql's? i want to run one for the stable version, and one for mysql 4.0 Unlucky no. By the way the Windows Server currently doesn't have support for to run several instances. To introduce this is part of my immediately TODO in the 4.0 tree, however I can say for you, that the second instance for 4.0 should be made separately without the support of WinMySQLAdmin. Regards, Miguel - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
complicated select
Hi, I have a table that contains something like follows: id prop_name status action_date prop_type address 1 name1 ok 2001-12-12 1 addy1forname1 2 name2 ok 2001-12-13 1 addy1forname2 3 name1 ok 2001-12-13 1 addy2(new)forname1 4 name3 ok 2001-12-14 2 addy1forname3 5 name2 ok 2001-12-13 1 addy2(new)forname2 If I am looking for all prop_names of type=1 I must get the following list only: name1 with id=3 and name2 with id=5. the other name1's and name2's and name3 should not be included as they are either older or not of type 1. Also, another twist. The name1 and name2 should only be listed if their action_date is not older than 52 weeks (1 year). A bit more background to clarify. The table holds data for properties which gets updated from time to time. I have a search function on a website using php that allows the user to search for all type 1's and I only want the latest entry for each prop_name to appear on the list and only if the data is not older than a year. My existing code works fine, but it doesn't work when a new entry is made to the table ( it shows both or all of the previous entries as well). I am looking for an sql string solution here that will only return the rows I'm looking for as I have already written all the code to run through these rows and create hyperlinks etc, so I would ideally not want to change that if possible. So, basically my problem is that my current sql string returns incorrect rows along with correct ones and I would like to remove the incorrect ones by using a different sql string rather than write more if's and then's to try to sort out which rows are garbage and which should be echoed. Thanks alot. Please yell if I can make the problem more clear. - 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: RE: RE: Mysql connection problem
Hi Gary, Finally I can access the server. You are my hero. I am new to mysql. It takes me a month to try it. Thank you very very much! Cindy [EMAIL PROTECTED] 01/08 11:14 AM from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Mysql connection problem Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy Simon Green [EMAIL PROTECTED] 01/08 1:26 AM Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: mysql not found. How can I find mysql server? Cindy Simon Green [EMAIL PROTECTED] 01/07 10:05 AM No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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
Not in Another Table
Is there a way I can filter OUT records referenced in another table? With Subselects it would be this, but I'm using 3.23: select a.* from a where a.id not in (select id from b) You get the idea. - 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
Macintosh mySQL clients
Hi everyone, I yould like to write a database server using MySQL. Before I begin, I would like to know: 1. Is this possible to write, in C, a Macintosh client to this MySQL server application? 2. Even if we already use Linux and Windows NT servers, is this a good alternative to write the MySQL database server on a Mac OS X machine? Best Regards, Serge Thibault Tamec Inc. - 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: Location of databases
On Tue, Jan 08, 2002 at 10:04:40AM -0500, Michael D. Stackhouse wrote: We run MySql on our Freebsd server, and on our Win2K server. We have several clients, and would like to store the databases in the clients' root directory. Is this possible? Under UNIX, all of the separate databases exist as a unique subdirectory under a directory; see references to DATADIR in the documentation. Any one database's tables exists as separate files within the respective database directory. You can physically relocate a database directory to wherever you want, as long as you maintain a symlink to it from the DATADIR. Bear in mind that the MySQL engine will be running as a specific UID, and that UID will need read/write permission for the database's new home... Thanks! -- 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
Re: Macintosh mySQL clients
Serge Thibault writes: Hi everyone, I yould like to write a database server using MySQL. Before I begin, I would like to know: 1. Is this possible to write, in C, a Macintosh client to this MySQL server application? 2. Even if we already use Linux and Windows NT servers, is this a good alternative to write the MySQL database server on a Mac OS X machine? Best Regards, Serge Thibault Tamec Inc. There are already MySQL binaries for OS X. You can download them from our site. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection, C API
Hello, No there's no thread in my application, the program use fork but of course a new connection is create after each fork() Today before running another test I do the following - drop then create the tables - increase the limit for opened file from 1024 to 4096 I run a test for 2 hours and I got : - Lost connection to MySQL (708) - Can't connect to MySQL server (49) //error while trying new connection 49 errors in 6 seconds in from 14:07:16 to 14:07:22 (due to a burst of fork() ) - 'ip_adress' is not allowed to connect to this MySQL Server (4) //error while trying new connection - Commands out of sync (6) But apart of these errors I have made many successful insert (4457) , update (11594), select (25017) that why I am confused and I don't know what to change ! Best regards Heikki Tuuri wrote: Hi! Then it looks like a problem in the communication or in your client test program. The following error Commands out of sync; You can't run this command now (85 occurences) means that you have issued C API commands to a single MySQL connection in a wrong order. If your application has several client threads, are you sure you create one connection to each thread, and issue the C API commands in the right order? Sometimes people try to use a single connection for several client threads, and get the error above. Best regards, Heikki Tuuri Innobase Oy -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: Empty table returned when qureying for show databases; right after installation. It shows a table with 10 rows, with empty fields in each, and writes in the total, 11 databases. When using a newly created database, doesn't show created tables (on show tables), what can be the problem ? How-To-Repeat: Just compile...maybe the configuration will help. Synopsis: Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.47 (Source distribution) Server: lt-mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.47-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 6 min 36 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.013 Environment: System: Linux home.pashkovsky.com 2.2.19 #7 Tue Oct 16 00:24:21 IST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -march=i586 -mcpu=i586 -felide-constructors -fno-exceptions -fomit-frame-pointer -fno-rtti' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 16 14:45 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rwxr-xr-x1 root root 5724399 Oct 3 20:55 /lib/libc-2.2.4.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure Perl: This is perl, version 5.005_03 built for i386-linux - 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: General mySQL setup question
At 16:50 08/01/2002 +, Los Morales wrote: Hi! Hi, Would like to know if there is a preferred way of setting up the data directory for mySQL. The default for a database would be in C:\mysql\data. Is this the preferred way or should this be set up in another directory outside of the mysql directory? Does moving the data directory affect performance, security, etc? Most likely there is no difference but would like to see if there is a preferred way of setting this up. Thanks! Take a look in the Manual how to set another location than the default c:\mysql. In advance you will to use my.ini file with the variable datadir and basedir pointing for the new paths. Regards, Miguel -los _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not in Another Table
select a.* from a left join b on a.id = b.id where b.id is null; Ken Kinder wrote: Is there a way I can filter OUT records referenced in another table? With Subselects it would be this, but I'm using 3.23: select a.* from a where a.id not in (select id from b) You get the idea. - 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: count(distinct
Ilic writes: SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? What's your MySQL version? Check the docs to see what version is required for count(distinct). I think it was added in 3.23.early, so it might be time to upgrade. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: General Query time question
Greer, Darren (MED) writes: If I move the status to another table, and then wanted to get a count of everyone who is of status 'A', how would that be any quicker? Would I join the tables? Communication error - reattempting. I meant that if you want to get the count of the number of 'A's often, you could store that number (the count of the number of 'A's) in another table. There'd be no change to your existing table, but there'd be no need to look in it just to get the count. I really have no idea what types of queries you perform or how often, so I'm not really in a position to suggest anything. I just wanted to raise your awareness of the possibility of such a solution. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. 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
Table crashing
Hi, I've got a table with a 5 milion records and with 10 records adding every day. My problem is that when I try to delete old records from this tables at some point I receive the following error ERROR 1034: Incorrect key file for table: 'logs'. Try to repair it. and the query execution stops. I know my table is OK - I used myisamchk before trying to delete records and there were no problems Any ideas? Dobromir Velev - 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: synopsis of the problem (one line)
make sure mysql owns the database directory and all its files. [EMAIL PROTECTED] wrote: Description: Empty table returned when qureying for show databases; right after installation. It shows a table with 10 rows, with empty fields in each, and writes in the total, 11 databases. When using a newly created database, doesn't show created tables (on show tables), what can be the problem ? How-To-Repeat: Just compile...maybe the configuration will help. Synopsis: Severity: critical Priority: high Category: mysql Class:sw-bug Release: mysql-3.23.47 (Source distribution) Server: lt-mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.47-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket/tmp/mysql.sock Uptime:6 min 36 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.013 Environment: System: Linux home.pashkovsky.com 2.2.19 #7 Tue Oct 16 00:24:21 IST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -march=i586 -mcpu=i586 -felide-constructors -fno-exceptions -fomit-frame-pointer -fno-rtti' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 16 14:45 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rwxr-xr-x1 root root 5724399 Oct 3 20:55 /lib/libc-2.2.4.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure Perl: This is perl, version 5.005_03 built for i386-linux - 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: Syncronization between two databases
Jeremy Zawodny wrote: On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: Hi! Have you looked at MySQL's built-in replication? Yes. But it seems to be created for a permanent connection between two databases... or can I make a replica using a dial-up connection (such as ISDN)? Don't be. It's pretty good. :-) Thanx :-) Marco - 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, creating table
what is wrong with this statement? mysql create table message (messageId AUTO_INCREMENT, timePosted VARCHAR(25), - userEmail VARCHAR(30), messagePosted MEDIUMBLOB); ERROR 1064: You have an error in your SQL syntax near 'AUTO_INCREMENT, timePoste d VARCHAR(25), userEmail VARCHAR(30), messagePosted MED' at line 1 - 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