DBD::MySQL Help!!
Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Running install for module DBD::mysql Running make for J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz Is already unwrapped into directory /root/.cpan/build/Msql-Mysql-modules-1.2216 Has already been processed within this session Running make test Won't repeat unsuccessful test during this command Running make install make test had returned bad status, won't install without force Bundle summary: The following items in bundle Bundle::DBD::mysql had installation problems: Mysql DBD::mysql Thanks, Rick
if no var/db directory where R DB files?
Hello, I have just installed mysql-3.23.37 in FreeBSD 4.2, I have already ./configure - make and - make install and notice that there is no /var/db directory, so I am wondering where the database files are? how can I find these database files? Thank you, Diego Montalvo - 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
get_meta_tags 4 proxy
I am on a lan and i would like to know how to use PHP's get_meta_tags function though my proxy. Can someone write me some sample code. Thanks database sql query _ Get Your Private, Free E-mail from MSN Hotmail at 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
Installing MySQL on Solaris as a user(not root)
I have a problem running MySQL on Solaris. I downloaded the source and compiled it following all the instructions and made mysql directory in my home directory. When I enter mysqladmin version I get: mysqladmin Ver 6.9 Distrib 3.21.33b, for sun-solaris2.8 on sparc TCX Datakonsult AB, by Monty Server version 3.23.37 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 hours 30 min 51 sec Threads: 1 Questions: 8 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.001 But when I give the command safe_mysqld I get: Starting mysqld demon with databases from /usr/local/mysql/var /usr/local/bin/safe_mysqld: /usr/local/mysql/var/grdmss57.log: cannot create It seems to me it can't create because I am not a root. What should I do? Also I can't create my password for MySQL. I get mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'm5051236@localhost' (Using password: YES)' If you have any information how to manage MySQL installed in home directory, please, help me. Maybe, I did smth wrong while installing(for example, if we install Apache in the home dir, we can choose port number etc.)? - 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: Optimization of MySQL
Hi there Is there anything similar to this that will run on a Windows platform? Regards WARREN ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Jeremy Zawodny Sent: 02 May 2001 07:30 To: Bryan Coon Cc: '[EMAIL PROTECTED]' Subject: Re: Optimization of MySQL On Tue, May 01, 2001 at 04:46:39PM -0700, Bryan Coon wrote: Our database is large, and getting larger, with several tables approaching the 1gig mark. In addition, the database will be moving to a dedicated node on a beowulf cluster. Cool... :-) For our users, we are not particulary interested in squeezing every last drop of performance out of MySQL, but I would be interested to know if there are obvious things that I should do to optimize our performace. For example, compiling my own mysql with certain flags, or perhaps startup options, etc. I searched the usenet and mysql site, and found some information but would like to hear some experienced advice before I jump in with both feet. Well, just wait a few weeks for my article in the next issue of Linux Magazine. :-) But before that happens, here are some ideas... There are two approaches to optimization, and you should use both. First is optimizing your application. This is generally just making sure your queries are fast (well indexed), you're only retrieving the data you need, you aren't indexing columns which will never benefit from indexes, you're caching data in your app which can be cached, etc. Second is server tuning. You can look at increasing the size if the key_buffer, record_buffer, and so on in your /etc/my.cnf (or similar) file. Try to get an idea how efficient things are currently. I often use mytop (http://public.yahoo.com/~jzawodn/mytop/) to gather some info about my system before, during, and after tuning. It doesn't give you everything you'll need (yet!), but it's a decent start. You'll probably want to look closely at the output of SHOW VARIABLES and SHOW STATUS and learn more about what some of them mean. And, of course, we're glad to field specific questions on this list. (This reminds me... I'm thinking of another patch to the MySQL manual which explains some more of this stuff. Just need to find the time to do it. Things are getting more, uh... interesting as the number of table handlers expand. With ISAM, MyISAM, InnoDB, BDB, Gemini, and HEAP, there is more room for both improvement and error.) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 118 days, processed 734,376,106 queries (71/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 - 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
mysqld daemon ended
dear: i having problem when start mysql using safe_mysqld command it showed mysqld daemon ended here the error_log message: 010502 14:37:20 Found old style password for user 'root'. Restart using --old-protocol mysqld ended on Wed May 2 14:37:20 MYT 2001 can someone help me on this? rachel
Import datas from FileMakerPro database
We would like to know if it is possible to import al the datas from Filemaker Pro databases in a new mysql database. We would like to use Mysql in place of Filemaker . Thanks and read you soon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with select ... in share mode
3.23.37: SELECT * FROM table1 WHERE colA=1 IN SHARE MODE does not work (ERROR 1064: You have an error in your SQL syntax near 'share mode' at line 1). On the other side SELECT * FROM table1 IN SHARE MODE does work, i.e. the syntax error only happens if I specify a WHERE clause or an ORDER clause or anything else between FROM table1 and IN SHARE MODE. table1 is a InnoDB table consisting of two integer columns colA and colB. Is the syntax error by design or is it an implementation problem? Thanks, Michael http://www.kofler.cc/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LAST_INSERT_ID returning 3 rows?
COk I was thinking that you had to tell LAST_INSERT_ID the table you wanted to get the last insert id from. What if you run a web site and you have 10 tables in a database, how can you tell what the last insert id of table 6 was? As I understand it, LAST_INSERT_ID is connection based, not table based. It gives you the last id generated by any update using that connection, regardless of the table upon which the insert was perfomed, but also independent of any updates which may be being performed by other connections. Alec mysql, database - 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
sql
sql please remove me from mailing lists - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with select ... in share mode
Hi! It is a bug in the parser that it does not accept ... IN SHARE MODE immediately after a WHERE clause. I think yacc is not very sophisticated in lookahead of symbols when it is trying to parse a statement, and may confuse IN SHARE MODE to WHERE colA IN (). We will fix the parser, but meanwhile you can use the following workaround: SELECT * FROM table1 WHERE colA=1 LIMIT 1000 IN SHARE MODE; The LIMIT clause helps yacc to find the right parsing for your statement :). Regards, Heikki 3.23.37: SELECT * FROM table1 WHERE colA=1 IN SHARE MODE does not work (ERROR 1064: You have an error in your SQL syntax near 'share mode' at line 1). On the other side SELECT * FROM table1 IN SHARE MODE does work, i.e. the syntax error only happens if I specify a WHERE clause or an ORDER clause or anything else between FROM table1 and IN SHARE MODE. table1 is a InnoDB table consisting of two integer columns colA and colB. Is the syntax error by design or is it an implementation problem? Thanks, Michael http://www.kofler.cc/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
yacc should do more lookahead in IN SHARE MODE to work
Monty, a parser bug. Regards, Heikki Hi! It is a bug in the parser that it does not accept ... IN SHARE MODE immediately after a WHERE clause. I think yacc is not very sophisticated in lookahead of symbols when it is trying to parse a statement, and may confuse IN SHARE MODE to WHERE colA IN (). We will fix the parser, but meanwhile you can use the following workaround: SELECT * FROM table1 WHERE colA=1 LIMIT 1000 IN SHARE MODE; The LIMIT clause helps yacc to find the right parsing for your statement :). Regards, Heikki 3.23.37: SELECT * FROM table1 WHERE colA=1 IN SHARE MODE does not work (ERROR 1064: You have an error in your SQL syntax near 'share mode' at line 1). On the other side SELECT * FROM table1 IN SHARE MODE does work, i.e. the syntax error only happens if I specify a WHERE clause or an ORDER clause or anything else between FROM table1 and IN SHARE MODE. table1 is a InnoDB table consisting of two integer columns colA and colB. Is the syntax error by design or is it an implementation problem? Thanks, Michael http://www.kofler.cc/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing MySQL on Solaris as a user(not root)
Since mysqladmin ran, the server is already running. Roman Shtykh wrote: I have a problem running MySQL on Solaris. I downloaded the source and compiled it following all the instructions and made mysql directory in my home directory. When I enter mysqladmin version I get: mysqladmin Ver 6.9 Distrib 3.21.33b, for sun-solaris2.8 on sparc TCX Datakonsult AB, by Monty Server version 3.23.37 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 hours 30 min 51 sec Threads: 1 Questions: 8 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.001 But when I give the command safe_mysqld I get: Starting mysqld demon with databases from /usr/local/mysql/var /usr/local/bin/safe_mysqld: /usr/local/mysql/var/grdmss57.log: cannot create It seems to me it can't create because I am not a root. What should I do? Also I can't create my password for MySQL. I get mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'm5051236@localhost' (Using password: YES)' If you have any information how to manage MySQL installed in home directory, please, help me. Maybe, I did smth wrong while installing(for example, if we install Apache in the home dir, we can choose port number etc.)? - 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 -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL can't open mysql.sock on start
Check for /etc/my.cnf or .my.cnf in mysql's var directory. One of these must have a line misdefining the socket as mysqld.sock. Chad Nantais wrote: Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory by default, and tries to start by opening socket mysql.sock. this might be a configuration error. the following fix worked. How-To-Repeat: try to start mysql by running ./safe_mysqld Fix: open /etc/my.cnf and change: socket=/tmp/mysqld.sock to this: socket=/tmp/mysql.sock Submitter-Id: submitter ID Originator:Rednaxel Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.37 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux tribewave.com 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 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/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 30 09:49 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.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 lrwxrwxrwx1 root root 19 May 1 07:37 /usr/lib/libc-client.a - /usr/lib/c-client.a Configure command: ./configure --prefix=/usr/local/mysql 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 -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max_connection
how do i change these settings like max_connection and stuff on a windows mysql server? i keep on getting this error after a while thanks
querylenght....
how long(in chars) can be a query string?? insert into Tab1 values('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'); and so on. is there a border? or can I use such chars as I like? thanks
Query speed
I am trying to run two queries which seem to me should execute at abut the same speed. My table is setup as follows: day - number of days since 1970 crcid - a number between 0 and 24 tag - a number used to identify record type total - the value stored (the rest of the record is just to identify this value) the primary key is day,crcid and tag I also have and index on crcid and on day seperately Table contains about 1,000,000 records This query takes 0.02 sec to execute: select (a.day+4)%7 as dow,avg(b.total/a.total) as average from server01_history a, server01_history b where a.day = b.day and a.crcid = 24 and a.tag = 100 and b.crcid = 24 and b.tag = 104 group by dow; note: dow is day of week which is used to group This query takes 1min 47 sec to execute: select a.crcid, avg ( b.total/a.total ) as average from server01_history a, server01_history b where a.crcid = b.crcid and a.tag = 100 and b.tag = 104 group by a.crcid; Both queries are similar they both alias the same table in order to use two separate records. Does anyone know why one query is so much faster than the other, and what can I do to speed up the second query without slowing down the first. Roger Karnouk - 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.server uses fully-qualified hostname, but mysqld doesn't
Description: My pidfile name is ldap1.pid However, I get the following error: root@ldap1# sh /usr/local/share/mysql/mysql.server stop No mysqld pid file found. Looked for /var/db/mysql/ldap1.netcarrier.net.pid. My hostname returns ldap1.netcarrier.net. So mysql.server is looking for a fully-qualified hostname, which is not the syntax used for my pidfile. How-To-Repeat: It should be repeatable just by doing the standard install on the same OS. Fix: For now, I'm going to just try to use safe_mysqld and ignore mysql.server :( Submitter-Id: submitter ID Originator:Dave Kitabjian Organization: MySQL support: none Synopsis: Severity: non-critical Priority: Category: mysql Class: sw-bug Release: mysql-3.22.27 (Source distribution) Environment: System: FreeBSD ldap1.netcarrier.net 3.5-STABLE FreeBSD 3.5-STABLE #0: Thu Jul 6 13:30:20 EDT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/LB1 i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: gcc version 2.7.2.3 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes Perl: This is perl, version 5.005_03 built for i386-freebsd - 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
tty beeps uncontrollably when hitting CR after mysqld
Description: This happens whether launching mysqld directly or safe_mysqld. Following the instructions carefully (with the backgrounder at the end), I get: /usr/local/libexec/mysqld: ready for connections but the prompt does not return. If you then hit ENTER on your keyboard, it begins to beep uncontrollably (using Win2K Telnet). Quitting ALL appli- cations doesn't even fix it, and Restart will not work. I'm forced to power down my PC or else annoy everyone else in the entire building! Perhaps the daemon isn't backgrounding properly. How-To-Repeat: Fix: Unknown. I'm hoping it doesn't present problems when I put it into my startup script. Submitter-Id: submitter ID Originator:Dave Kitabjian Organization: MySQL support: none Synopsis: Severity: unknown Priority: Category: mysql Class: sw-bug Release: mysql-3.22.27 (Source distribution) Environment: System: FreeBSD ldap1.netcarrier.net 3.5-STABLE FreeBSD 3.5-STABLE #0: Thu Jul 6 13:30:20 EDT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/LB1 i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: gcc version 2.7.2.3 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes Perl: This is perl, version 5.005_03 built for i386-freebsd - 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
Conversion from 3.22.32 to 3.23.36
Problem: I have created the databases in the new version, copied the tables into the correct directories, and changed the permissions of the entire directory structure to 777. When I run the provided script: mysql_convert_table_format, I receive an error on some of the tables that states: Unable to convert, table is Read Only. I have also used the --force opt to no avail. Some of the tables convert just fine. If anyone can point me in the right direction I would be greatful. 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
Date comparisions...
Hi all, I was recently attempting what I thought would be an easy search. I wanted to return all records with a birthdate (a DATE column) 'within' 30 days of the current date. The birthdate is stored as a -MM-DD, I have been having lots of trouble getting MySQL to return the correct records, my problems are.. 1.I need to ignore the year value as all birthdates will be previous to the current if the year is included. 2.I need to check if a birthdate is in the same month as the current month and that its day is not less than the current day. 3.Then I need to check how many days there are left in the current month, take it away from 30 and then check for birthdates in the following month within that many days. So much for being a simple problem! Anyone have any experience of doing this..? LINUX..MySQL 3.22.32 on apache thanks a bunch for any info Rolf ___ Computer games don't affect kids, I mean if pac man affected us as kids, we'd all run around in a darkened room munching pills and listening to repetitive music - 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
specifying a delimiter
Hi, Being new to MySQL, I am having a problem getting output from it to the shell that is formatted the way I need. I need a table to be written to a file with a delimiter. something like : #!/bin/sh mysql -uroot -ptest database sql Then I run that script like this: ./script.sh output.txt Any delimiter is ok except for tab. Is this possible? Thanks, in advance, -Eric - 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
missing doc: identified by password
Doing a : mysql show grants for root@localhost; +---+ | Grants for root@localhost | | +---+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD |'6ffc60a31940f7bd' WITH GRANT OPTION | +---+ 1 row in set (0.00 sec) However I can't find anywhere in the docs about IDENTIFIED BY PASSWORD (the PASSWORD part in particular) I looked here: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#GRANT and http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Adding_users thanks, -- Andrew
Re: DBD::MySQL Help!!
Hi Rick, It looks similar to a problem I had on FreeBSD in not finding the shared library. I added this command to a startup file (mysql_server.sh) in rc.d directory. /sbin/ldconfig -m /usr/local/lib/mysql You may need to check if -m is the right option for openbsd but I am sure you need ldconfig! I hope this helps. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: Rick Kukiela [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 2:19 AM Subject: DBD::MySQL Help!! Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put root as the test user and my root sql users pw for the password, it does some stuff then it runs the make test and this is what happens... Any help?? Running make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl 5/5.6. 1/OpenBSD.i386-openbsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/00basedubious Test returned status 1 (wstat 256, 0x100) t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/10dsnlist.dubious Test returned status 1 (wstat 256, 0x100) t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/20createdrop..dubious Test returned status 1 (wstat 256, 0x100) t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/30insertfetch.dubious Test returned status 1 (wstat 256, 0x100) t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40bindparam...dubious Test returned status 1 (wstat 256, 0x100) t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40blobs...dubious Test returned status 1 (wstat 256, 0x100) t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40listfields..dubious Test returned status 1 (wstat 256, 0x100) t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40nulls...dubious Test returned status 1 (wstat 256, 0x100) t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/40numrows.dubious Test returned status 1 (wstat 256, 0x100) t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50chopblanks..dubious Test returned status 1 (wstat 256, 0x100) t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/50commit..dubious Test returned status 1 (wstat 256, 0x100) t/60leaks...skipped test on this platform t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/ak-dbddubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No such file or directory t/dbdadmin..dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 1-20 Failed 20/20 tests, 0.00% okay Failed Test Status Wstat Total Fail Failed List of Failed t/00base.t 1 256?? ?? % ?? t/10dsnlist.t 1 256?? ?? % ?? t/20createdrop.t 1 256?? ?? % ?? t/30insertfetch.t 1 256?? ?? % ?? t/40bindparam.t1 256?? ?? % ?? t/40blobs.t1 256?? ?? % ?? t/40listfields.t 1 256?? ?? % ?? t/40nulls.t1 256?? ?? % ?? t/40numrows.t 1 256?? ?? % ?? t/50chopblanks.t 1 256?? ?? % ?? t/50commit.t 1 256?? ?? % ?? t/ak-dbd.t 1 25690 90 100.00% 1-90 t/dbdadmin.t 1 25620 20 100.00% 1-20 1 test skipped. Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. *** Error code 2 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of Makefile). *** Error code 1 Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216
RE: Query speed
seems to me that the first query uses your primary key index. Since you have specified qualifications on crcid and tag in both aliases, it will resolve to a small number of rows in each alias table. The second query will join your aliases on the crcid index, and then the tag qualifications will resolve to a larger number of rows. A way to verify this is to run: select count(*) as rcount from server01_history a, server01_history b where a.day = b.day and a.crcid = 24 and a.tag = 100 and b.crcid = 24 and b.tag = 104 ; and select count(*) as rcount from server01_history a, server01_history b where a.crcid = b.crcid and a.tag = 100 and b.tag = 104; I bet the latter rcount value is much greater than the former. Did you run explains on these queries? braxton -Original Message- From: Roger Karnouk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 9:57 AM To: [EMAIL PROTECTED] Subject: Query speed I am trying to run two queries which seem to me should execute at abut the same speed. My table is setup as follows: day - number of days since 1970 crcid - a number between 0 and 24 tag - a number used to identify record type total - the value stored (the rest of the record is just to identify this value) the primary key is day,crcid and tag I also have and index on crcid and on day seperately Table contains about 1,000,000 records This query takes 0.02 sec to execute: select (a.day+4)%7 as dow,avg(b.total/a.total) as average from server01_history a, server01_history b where a.day = b.day and a.crcid = 24 and a.tag = 100 and b.crcid = 24 and b.tag = 104 group by dow; note: dow is day of week which is used to group This query takes 1min 47 sec to execute: select a.crcid, avg ( b.total/a.total ) as average from server01_history a, server01_history b where a.crcid = b.crcid and a.tag = 100 and b.tag = 104 group by a.crcid; Both queries are similar they both alias the same table in order to use two separate records. Does anyone know why one query is so much faster than the other, and what can I do to speed up the second query without slowing down the first. Roger Karnouk - 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
select query question
I have a table where patient visits are logged each visit, the table is: patientnumber,visitdate,location I need to select and count the number of records that have 2 or more entries with the same patientnumber in sql-english: select count(*) where there are two or more records with the same patientnumber Any help with the SQL to do this would be much appreciated. Thanks! Jon - 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
DELETE question
Anybody got a clue why this isn't deleting? The number is input in the previous section of code and I know it works correctly, but for some reason when it gets to here, it just skips to view (apparently), (even if I # out the Lock lines, so it isn't a lock problem). Am I going about getting the number into the query in the wrong way? If so, what is the correct manner to achieve this? Thanks in advance for your help, Dawn H -CODE BELOW- sub delete { $num=param('delete'); $num=$dbh-quote($num); GET_LOCK(edit,10) or bail_out(Cannot get lock, please wait a moment and try again); $sth = $dbh-prepare(DELETE FROM database WHERE id=$num) or bail_out(Cannot prepare to be deleted); $sth-execute() or bail_out(Cannot delete); RELEASE_LOCK(edit) or bail_out(An error occurred when attempting to release lock); view(); } - 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
extract day and hours/minutes from a date-time field but ugly results... HELP!
i want to extract day and hours/minutes from a date-time field. in order to to this i use e.g. for the hours: select HOUR(hora) as lahora from mytable which returns the hour but followed by an L, same for minutes, same for the date. why is this so and how can i avoid it? we run mySQL under Zope. thanks, tim database sql query -- Sent through GMX FreeMail - http://www.gmx.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with multi-part keys
Hello All, I've bumped into a problem and can't figure out how to solve it. If anyone has a spare minute to give me a hint on what's wrong I'd apreciate it a lot! The problem is that when I add 'use index (multi-part index)' to my queries, MySQL doesn't always use the whole key, but decides what left-most part of the key to use itself. Sometimes its decisions are rather strange to me. Here are some tests that show what I mean: CREATE TABLE test3 ( pr mediumint(8) unsigned NOT NULL default '0', a mediumint(8) unsigned default '0', b mediumint(8) unsigned default '0', data mediumint(8) unsigned default '0', KEY a (a), KEY b (b), KEY k (a,b) ); INSERT INTO test3 VALUES (1,0,0,9); INSERT INTO test3 VALUES (2,0,1,9); INSERT INTO test3 VALUES (3,1,0,9); INSERT INTO test3 VALUES (4,1,1,9); INSERT INTO test3 VALUES (5,1,2,9); INSERT INTO test3 VALUES (6,0,0,9); Test 1 == explain select R.data from test3 as R, test3 as L use index (k) where L.a=IF(R.a=0,1,0) and L.bR.b; # The result is OK (just what I expected): +---+---+---+--+-+--+--+ -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+--+ -+ | R | ALL | b | NULL |NULL | NULL |6 | | | L | index | a,b,k | k| 8 | NULL |6 | where used; Using index | +---+---+---+--+-+--+--+ -+ Test 2 == explain select R.data from test3 as R, test3 as L use index (k) where ((L.a=0 and R.a=1) or (L.a=1 and R.a=0)) and L.bR.b; # Why doesn't MySQL use the whole k index (8 bytes)? +---+---+---+--+-+--+--+ -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+--+ -+ | R | ALL | a,b,k | NULL |NULL | NULL |6 | where used | | L | range | a,b,k | k| 4 | NULL |5 | where used; Using index | +---+---+---+--+-+--+--+ -+ Test 3 == explain select R.data from test3 as R, test3 as L use index (k) where L.aR.a and L.bR.b; # k key isn't choosen by MySQL. Why? +---+--+---+--+-+--+--+- -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--+- -+ | R | ALL | a,b,k | NULL |NULL | NULL |6 | | | L | ALL | k | NULL |NULL | NULL |6 | range checked for each record (index map: 4) | +---+--+---+--+-+--+--+- -+ Test 4 == explain select R.data from test3 as R, test3 as L use index (k) where R.a=0 and L.a=0 and L.bR.b; # Why doesn't MySQL use the whole k index (8 bytes)? +---+--+---+--+-+---+--+ -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+---+--+ -+ | R | ref | a,b,k | a| 4 | const |2 | where used | | L | ref | a,b,k | k| 4 | const |2 | where used; Using index | +---+--+---+--+-+---+--+ -+ The bottom line is that I'd like to know if MySQL has a feature that makes it use a key even if the optimizer doesn't think it'a good one. Thanks in advance. Regards, Alexander Paperno. - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql and Powerbuilder - retrieval arguments
Hi All, I recently started development on an application using Powerbuilder and Mysql, and quickly discovered a frustrating problem. Most of my database tables are based on integer keys, and therefore, most datawindows I design have numeric retrieval arguments. The problem is, powerbuilder converts these arguments to scientific notation, and because of this, any key larger than 9 does not get properly matched. ie - when I try and retrieve a datawindow based on a key of 12, I trace the following SQL - select last_name from customer where customer_key = 1.2000+e01 I have tried messing around with the settings in both Powerbuilder and MyODBC, to no avail. I HAVE, however, come up with the following fix (for all of you who may have this same problem) - In your datawindow SQL painter, use the ROUND function to round your retrieval argument to the nearest integer. This seems to work fine for everything I have tested. ie - select last_name from customer where customer_key = round(:a_customer_key) I was wondering - am I the only one to have these problems? Is there another known solution so I don't have to modify SQL code? I would appreciate any knowledge anyone has concerning this interesting (bug?). Thanks to all who reply, Brad _ Get Your Private, Free E-mail from MSN Hotmail at 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: missing doc: identified by password
I guess I didn't phrase my point properly due to the emails I have been recieving =). I'm just stating that this feature isn't documented in the manual though it probably should be. sorry for the confusion. thanks, -- Andrew - Original Message - From: Andrew Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 11:01 AM Subject: missing doc: identified by password Doing a : mysql show grants for root@localhost; +--- + | Grants for root@localhost | +--- + | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '6ffc60a31940f7bd' WITH GRANT OPTION | +--- + 1 row in set (0.00 sec) However I can't find anywhere in the docs about IDENTIFIED BY PASSWORD (the PASSWORD part in particular) I looked here: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#GRA NT and http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h tml#Adding_users thanks, -- Andrew - 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
Current row number
How can you get the current row number in a query? Example: ROW_NUMBER (not ID) DATA - 1 AAA 2 BBB ... _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do I turn the Query Log option OFF?
I need to be able to turn the Query log option off, and cannot figure out how to do that. I have enabled --log-bin logging, to capture any update commands, but cannot figure out how to turn query logging off. In the mySQL doc it says to alter the mysql.server script -- but nowhere in the script does it have a -l -- so I'm not sure where to do this. I do have a global options file in /etc/my.cnf and it only has log-bin as an option within the [mysqld] section. However, when I restart mySQL, it continues to log queries. Has anyone successfully turned this thing off? Surely it must be easier than this -- I can't imagine large implementations logging every query --- the file gets HUGE very quickly. Kim
JOIN query gone awry
Greetings. I have two tables that are identical in structure, but each contains data for different years. Here is the desc of the first table: mysql desc counts2000; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | version | decimal(6,3)| YES | | NULL| | | sequence| tinyint(4) | YES | | NULL| | | dt_year | bigint(4) | YES | | NULL| | | dt_month| bigint(2) | YES | | NULL| | | dt_mon_name | varchar(10) binary | YES | | NULL| | | dt_day | bigint(2) unsigned zerofill | YES | | NULL| | | date_taken | date| YES | | NULL| | | exams | bigint(21) | | | 0 | | | dt_label| varchar(6) | YES | | NULL| | +-+-+--+-+-+---+ 9 rows in set (0.03 sec) The desc for the other is included at the end of the message. This first one has data for Jan/2000 - Jun/2000. The second has data for Jan/2001 - Apr/2001. I want to combine the two tables into one new one. Since they have a differing number of rows, but I want all of the rows from counts2000, I thought to use a JOIN. Here is the code I am trying to use: code starts here -- DROP TABLE IF EXISTS counts; CREATE TABLE counts SELECT AL1.sequence, AL1.dt_month, AL1.dt_day, AL1.dt_label, SUM(AL1.exams) AS y2000, SUM(AL2.exams) AS y2001 FROM counts2000 AL1 LEFT JOIN counts2001 AL2 USING (sequence,dt_label) WHERE AL1.version = '2' AND AL2.version = '2' GROUP BY AL1.sequence, AL1.dt_label ORDER BY AL1.sequence, AL1.dt_month, AL1.dt_day; ALTER TABLE counts ADD INDEX sequence (sequence); ALTER TABLE counts ADD INDEX dt_month (dt_month); ALTER TABLE counts ADD INDEX dt_day (dt_day); code ends here -- Seems like it should work. It does run, but the goal behind using the JOIN (to get all of the rows in counts2000) is not being met. I only gets rows from both tables where the row exists in both tables. I am running MySQL 3.23.34 (for Windows) on Windows 2000 Professional. Here is some of the data from counts2000 that is not showing up in the resultant table: 2.000 1 20005 May 01 2000-05-01 154 01-May 2.000 1 20005 May 02 2000-05-02 283 02-May 2.000 1 20005 May 03 2000-05-03 373 03-May 2.000 1 20005 May 04 2000-05-04 298 04-May 2.000 1 20005 May 05 2000-05-05 160 05-May 2.000 1 20005 May 06 2000-05-06 117 06-May 2.000 1 20005 May 07 2000-05-07 44 07-May 2.000 1 20005 May 08 2000-05-08 308 08-May 2.000 1 20005 May 09 2000-05-09 408 09-May Any ideas why the JOIN does not seem to be working? Thanks, Dan SUPPORTING DOCS --- mysql desc counts2001; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | version | decimal(6,3)| YES | | NULL| | | sequence| tinyint(4) | YES | | NULL| | | dt_year | bigint(4) | YES | | NULL| | | dt_month| bigint(2) | YES | | NULL| | | dt_mon_name | varchar(10) binary | YES | | NULL| | | dt_day | bigint(2) unsigned zerofill | YES | | NULL| | | date_taken | date| YES | | NULL| | | exams | bigint(21) | | | 0 | | | dt_label| varchar(6) | YES | | NULL| | +-+-+--+-+-+---+ 9 rows in set (0.03 sec) Dan Huston Decision Support Systems Cisco Networking Academy Program Cisco Systems 2375 E. Camelback Rd., Ste. 220 Phoenix, AZ 85016 Phone (602) 778-2730 Cell Phone (602) 300-6043
restore 'dumped' database
Hi, How do I restore a copied database that I've created with mysqldump? I have both the DuBois book and, of course, the online manual handy. I'm obviously looking in the wrong area of them because I can't find anything (I thought the keyword 'restore' would net me something, but no joy). I'll happily take my 'RTFM' beatings if someone would just point me to the appropriate section(s) of one or both... -Brian
Re: restore 'dumped' database
Check out mysqlimport and LOAD DATA INFILE, as well as the documentation for mysqldump: http://www.mysql.com/doc/m/y/mysqlimport.html http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.mysql.com/doc/m/y/mysqldump.html On Wed, 2 May 2001, Brian Warn wrote: Hi, How do I restore a copied database that I've created with mysqldump? I have both the DuBois book and, of course, the online manual handy. I'm obviously looking in the wrong area of them because I can't find anything (I thought the keyword 'restore' would net me something, but no joy). I'll happily take my 'RTFM' beatings if someone would just point me to the appropriate section(s) of one or both... -Brian - 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
Install problems ?
AIX 4.3.3 I have downloaded the mysql-3.23.37-ibm-aix4.3.3.0-rs6000.tar.gz binary, unpacked it with the following command % gzip -dc mysql-3.23.37-ibm-aix4.3.3.0-rs6000.tar.gz | tar -xvf - I skipped groupdadd and useradd because I am not a system administrator of my machine. I created a link of mysql % ln -s mysql-3.23.37-ibm-aix4.3.3.0-rs6000 mysql Then run the following command % scripts/mysql_install_db *Error *** exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. WARNING: The host 'bdvdc14i' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! end of error* - 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
Install Problems ? Solaris
Solaris I have downloaded mysql-3.23.37-sun-solaris2.7-sparc.tar.gz, try unpack with with following command gzip -dc mysql-3.23.37-sun-solaris2.7-sparc.tar.gz | tar -xvf - I got following error . x mysql-3.23.37-sun-solaris2.7-sparc/sql-bench/README, 4320 bytes, 9 tape blocks x mysql-3.23.37-sun-solaris2.7-sparc/sql-bench/Results, 0 bytes, 0 tape blocks x mysql-3.23.37-sun-solaris2.7-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error What command should I use to untar the archive. 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: Install Problems ? Solaris
There is a bug in the Solaris tar, it even says so on the download page. Get GNU Tar, it's also listed on the download page. At 03:36 PM 5/2/2001 -0700, EXT-Chung, Kenneth wrote: Solaris I have downloaded mysql-3.23.37-sun-solaris2.7-sparc.tar.gz, try unpack with with following command gzip -dc mysql-3.23.37-sun-solaris2.7-sparc.tar.gz | tar -xvf - I got following error . x mysql-3.23.37-sun-solaris2.7-sparc/sql-bench/README, 4320 bytes, 9 tape blocks x mysql-3.23.37-sun-solaris2.7-sparc/sql-bench/Results, 0 bytes, 0 tape blocks x mysql-3.23.37-sun-solaris2.7-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error What command should I use to untar the archive. 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] By working faithfully eight hours a day you may eventually get to be boss and work twelve hours a day. - Robert Frost, 1874 - 1963 - 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
Unusual dependency error w/ rpm??
Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1 /mysqlcd /bin /binls -l | grep sh -rwxr-xr-x 1 root root60592 Feb 3 2000 ash -rwxr-xr-x 1 root root 263064 Feb 3 2000 ash.static -rwxr-xr-x 1 root root 446800 Feb 2 2000 bash2 lrwxrwxrwx 1 root root3 May 27 2000 bsh - ash lrwxrwxrwx 1 root root4 May 27 2000 csh - tcsh lrwxrwxrwx 1 root root4 May 27 2000 sh - bash /bincd /usr/bin /usr/binls -l | grep perl -rwxr-xr-x 1 root root12872 Feb 2 2000 find2perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl5.00503 -rwxr-xr-x 1 root root31722 Feb 2 2000 perlbug -rwxr-xr-x 1 root root26305 Feb 2 2000 perlcc -rwxr-xr-x 1 root root16807 Feb 2 2000 perldoc -rws--x--x 2 root root 531516 Feb 2 2000 sperl5.00503 -rws--x--x 2 root root 531516 Feb 2 2000 suidperl /usr/bin Thank in advance, ChrisB - 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
i could just cry . . . mysql dead
I installed 7.0 with mysql on the redhat cd, and for a while it worked, then stopped. reinstalled everything, and now get: for /etc/rc.d/rc3.d/S85mysqld status mysqld dead but subsys locked Would partially run on safe_mysqld until I followed page 417 in the mysql manuyal, and now i get a very complicated long error related to the pid file, which I never could find anyway. How to uninstall, rpm -e won't work, and anysuggestion for starting over? 6.2 was so much kinder and it's not like i don't enjoy a challenge, but really. - 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: Unusual dependency error w/ rpm??
Odd... could be different versions or something. If you're sure you have them install the RPM with --nodeps I still HIGHLY recommend a source install, it's very simple and you have a lot more control. At 04:09 PM 5/2/2001 -0700, Chris Becker wrote: Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1 /mysqlcd /bin /binls -l | grep sh -rwxr-xr-x 1 root root60592 Feb 3 2000 ash -rwxr-xr-x 1 root root 263064 Feb 3 2000 ash.static -rwxr-xr-x 1 root root 446800 Feb 2 2000 bash2 lrwxrwxrwx 1 root root3 May 27 2000 bsh - ash lrwxrwxrwx 1 root root4 May 27 2000 csh - tcsh lrwxrwxrwx 1 root root4 May 27 2000 sh - bash /bincd /usr/bin /usr/binls -l | grep perl -rwxr-xr-x 1 root root12872 Feb 2 2000 find2perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl5.00503 -rwxr-xr-x 1 root root31722 Feb 2 2000 perlbug -rwxr-xr-x 1 root root26305 Feb 2 2000 perlcc -rwxr-xr-x 1 root root16807 Feb 2 2000 perldoc -rws--x--x 2 root root 531516 Feb 2 2000 sperl5.00503 -rws--x--x 2 root root 531516 Feb 2 2000 suidperl /usr/bin Thank in advance, ChrisB - 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] By working faithfully eight hours a day you may eventually get to be boss and work twelve hours a day. - Robert Frost, 1874 - 1963 - 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: Apache/PHP/MySQL - processes multiply until about 30, then doom
Repost - nobody has any ideas? I've run some stress tests, sending several thousand page requests, and the number of mysql processes goes up and down but over time continues to rise. It's up to about 22 now. When it gets to about 30, every request from the web server will be will fail. Could some of these processes be threads that are orphaned for some reason (perhaps Apache continuing to expire its own processes?) and hang around, idle? I speculate that there is some maximum number of processes and finally MySQL can't won't start another thread/process. GB On Tuesday 01 May 2001 05:26 pm, Gary E Bickford opined: I am running MySQL (3.23.27 at this point) with Apache1.3.12 and PHP3 on a PC running Redhat 6.0. My problem has survived upgrades of all components from earlier versions. Every PHP page has at least one query to a MySQL database for session tracking (home-rolled code, not PHPLib or anything off the shelf) There are also on some pages other queries, to a different database, same server (same mysql). Most of the latter are Phorum queries. Periodically the number of mysql instances that show up in 'ps auxww'1 gets to about 30 and mysql no longer listens to PHP/Apache. However I can still use the mysql shell with no problem, so MySQL is still running but can't hear anything from PHP. The only way to fix it is to run 'apachectl restart' or equivalent. 'graceful' doesn't do it. Im not sure if restarting MySQL instead works. After Apache is restarted, the mysql processes are down to 3 and everybody's happy again. I have been trying for months to figure out what is happening and how to fix it. I had heard at one point that there was a problem with Redhat 5.2 kernel that caused a similar problem, but I upgraded that but no joy. Temporarily I have built a kluge cron job that restarts apache every so often, which worked as long as the server was low volume. But now usage is dramatically increasing due to some new web sites that have been installed and announced to the entire corporation. So the problem is triggered before the restart cleans up the mess. I can't have it restarting every 20 minutes. I've also changed every instance of pconnect() to connect() where I can, but no difference. Can anybody tell me anything useful? I'm supposed to come back with a firm fixit schedule tomorrow morning, so please email me directly as well as on the list - I'm afraid I'll miss it in the volume on the list. If I don't get this fixed very shortly my consulting contract with this company will no doubt begin to fade out!! Thanks in advance, Gary Bickford --- -- 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
can not see data or tables in database
I set up a couple of databases last night in mysql and every thing is working just fine. Today when I try to access the data it is not there Using phpMyAdmin when I look at the databases that are completely empty of tables and data that also includes the mysql database. If I start up telnet and go into mysql it shows that all of the tables and data are their including the mysql data. This seems realy strange to me. Could you tell me what I need to do to correct this problem or at lest looking in the right direction. Thank you Richard Kurth - 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: Apache/PHP/MySQL - processes multiply until about 30, then doom
You can look into increasing the number of allowed connections that MySQL will accept... are you using connect or pconnect? At 04:23 PM 5/3/2001 -0700, Gary Bickford wrote: Repost - nobody has any ideas? I've run some stress tests, sending several thousand page requests, and the number of mysql processes goes up and down but over time continues to rise. It's up to about 22 now. When it gets to about 30, every request from the web server will be will fail. Could some of these processes be threads that are orphaned for some reason (perhaps Apache continuing to expire its own processes?) and hang around, idle? I speculate that there is some maximum number of processes and finally MySQL can't won't start another thread/process. GB On Tuesday 01 May 2001 05:26 pm, Gary E Bickford opined: I am running MySQL (3.23.27 at this point) with Apache1.3.12 and PHP3 on a PC running Redhat 6.0. My problem has survived upgrades of all components from earlier versions. Every PHP page has at least one query to a MySQL database for session tracking (home-rolled code, not PHPLib or anything off the shelf) There are also on some pages other queries, to a different database, same server (same mysql). Most of the latter are Phorum queries. Periodically the number of mysql instances that show up in 'ps auxww'1 gets to about 30 and mysql no longer listens to PHP/Apache. However I can still use the mysql shell with no problem, so MySQL is still running but can't hear anything from PHP. The only way to fix it is to run 'apachectl restart' or equivalent. 'graceful' doesn't do it. Im not sure if restarting MySQL instead works. After Apache is restarted, the mysql processes are down to 3 and everybody's happy again. I have been trying for months to figure out what is happening and how to fix it. I had heard at one point that there was a problem with Redhat 5.2 kernel that caused a similar problem, but I upgraded that but no joy. Temporarily I have built a kluge cron job that restarts apache every so often, which worked as long as the server was low volume. But now usage is dramatically increasing due to some new web sites that have been installed and announced to the entire corporation. So the problem is triggered before the restart cleans up the mess. I can't have it restarting every 20 minutes. I've also changed every instance of pconnect() to connect() where I can, but no difference. Can anybody tell me anything useful? I'm supposed to come back with a firm fixit schedule tomorrow morning, so please email me directly as well as on the list - I'm afraid I'll miss it in the volume on the list. If I don't get this fixed very shortly my consulting contract with this company will no doubt begin to fade out!! Thanks in advance, Gary Bickford --- -- 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] By working faithfully eight hours a day you may eventually get to be boss and work twelve hours a day. - Robert Frost, 1874 - 1963 - 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: Unusual dependency error w/ rpm??
because of problems w/ MySQL:Perl:DBD I need to either install MySQL from an rpm, or re-install Perl from a binary. The MySQL installed from binary ok, so I guess I'll keep it and recompile Perl. Perl was originally installed on my box from an rpm. I assume a recompile means uninstall reinstall. How do I UnInstall my current Perl version? Thanks, Chris B -Original Message- From: Scott Baker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 4:18 PM To: Chris Becker; [EMAIL PROTECTED] Subject: Re: Unusual dependency error w/ rpm?? Odd... could be different versions or something. If you're sure you have them install the RPM with --nodeps I still HIGHLY recommend a source install, it's very simple and you have a lot more control. At 04:09 PM 5/2/2001 -0700, Chris Becker wrote: Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1 /mysqlcd /bin /binls -l | grep sh -rwxr-xr-x 1 root root60592 Feb 3 2000 ash -rwxr-xr-x 1 root root 263064 Feb 3 2000 ash.static -rwxr-xr-x 1 root root 446800 Feb 2 2000 bash2 lrwxrwxrwx 1 root root3 May 27 2000 bsh - ash lrwxrwxrwx 1 root root4 May 27 2000 csh - tcsh lrwxrwxrwx 1 root root4 May 27 2000 sh - bash /bincd /usr/bin /usr/binls -l | grep perl -rwxr-xr-x 1 root root12872 Feb 2 2000 find2perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl5.00503 -rwxr-xr-x 1 root root31722 Feb 2 2000 perlbug -rwxr-xr-x 1 root root26305 Feb 2 2000 perlcc -rwxr-xr-x 1 root root16807 Feb 2 2000 perldoc -rws--x--x 2 root root 531516 Feb 2 2000 sperl5.00503 -rws--x--x 2 root root 531516 Feb 2 2000 suidperl /usr/bin Thank in advance, ChrisB - 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] By working faithfully eight hours a day you may eventually get to be boss and work twelve hours a day. - Robert Frost, 1874 - 1963 - 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
windoze and batch files
Hi all, unfortunately, I am forced to do some background mysql development work on a windoze box, which for reasons I wont go into here requires that I use the mysql console client. As many would know this does not allow any commands to be edited in the console as does linux. I decided that it would be easier to write a batch file to do some work but can't find out how to get mysql to process the batch file. Issuing the mysql batch file in dos mode wont work. Any help appreciated as I'm getting sick and tired of entering long queries at the mysql prompt and then retyping the whole thing if I make a small syntax error. Stan Bordeaux Injury Prevention Policy Officer Public Environmental Health Service 1/34 Davey St Hobart 7000 ph: (03)6233 3774 fax: (03)6223 1163 email: [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
Solaris Installation problems
Thanks. I got the gtar from the download page. Now I have unpacked it with mysql-3.23.37-sun-solaris2.7-sparc directory But I have another problems with running scripts/mysql_install_db % scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file or directory ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or directory Killed Installation of grant tables failed! Looks like I am missing a libcrypt_i.so.1, where am I supposed to get it ? 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: windoze and batch files
Perhaps you can type the query in notepad, and then past it into the mysql client's window. If that is not suitable and you still want to go with the batch file scheme, type type batchfilename | mysql -u ... ryan Hi all, unfortunately, I am forced to do some background mysql development work on a windoze box, which for reasons I wont go into here requires that I use the mysql console client. As many would know this does not allow any commands to be edited in the console as does linux. I decided that it would be easier to write a batch file to do some work but can't find out how to get mysql to process the batch file. Issuing the mysql batch file in dos mode wont work. Any help appreciated as I'm getting sick and tired of entering long queries at the mysql prompt and then retyping the whole thing if I make a small syntax error. Stan Bordeaux Injury Prevention Policy Officer Public Environmental Health Service 1/34 Davey St Hobart 7000 ph: (03)6233 3774 fax: (03)6223 1163 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date comparisions...
There are a whole heap of very useful date functions in chapter 7 of the manual that will make all your problems disappear. - Original Message - From: Roo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 23:00 Subject: Date comparisions... Hi all, I was recently attempting what I thought would be an easy search. I wanted to return all records with a birthdate (a DATE column) 'within' 30 days of the current date. The birthdate is stored as a -MM-DD, I have been having lots of trouble getting MySQL to return the correct records, my problems are.. 1.I need to ignore the year value as all birthdates will be previous to the current if the year is included. 2.I need to check if a birthdate is in the same month as the current month and that its day is not less than the current day. 3.Then I need to check how many days there are left in the current month, take it away from 30 and then check for birthdates in the following month within that many days. So much for being a simple problem! Anyone have any experience of doing this..? LINUX..MySQL 3.22.32 on apache thanks a bunch for any info Rolf ___ Computer games don't affect kids, I mean if pac man affected us as kids, we'd all run around in a darkened room munching pills and listening to repetitive music - 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: windoze and batch files
At 10:23 AM +1000 5/3/01, Bordeaux Stan wrote: Hi all, unfortunately, I am forced to do some background mysql development work on a windoze box, which for reasons I wont go into here requires that I use the mysql console client. As many would know this does not allow any commands to be edited in the console as does linux. Use mysqlc rather than mysql. Read this page first, you have to install a library to make it work: http://www.mysql.com/doc/W/i/Windows_running.html I decided that it would be easier to write a batch file to do some work but can't find out how to get mysql to process the batch file. Issuing the mysql batch file in dos mode wont work. You might have better luck if you use mysql batch. sends the output into your file, wiping it out. Any help appreciated as I'm getting sick and tired of entering long queries at the mysql prompt and then retyping the whole thing if I make a small syntax error. Stan Bordeaux Injury Prevention Policy Officer Public Environmental Health Service 1/34 Davey St Hobart 7000 ph: (03)6233 3774 fax: (03)6223 1163 email: [EMAIL PROTECTED] -- Paul DuBois, [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: can not see data or tables in database
At 4:27 PM -0700 5/2/01, Richard Kurth wrote: I set up a couple of databases last night in mysql and every thing is working just fine. Today when I try to access the data it is not there Using phpMyAdmin when I look at the databases that are completely empty of tables and data that also includes the mysql database. If I start up telnet and go into mysql it shows that all of the tables and data are their including the mysql data. This seems realy strange to me. Could you tell me what I need to do to correct this problem or at lest looking in the right direction. If you're running Linux, you might have the busted C library that makes SHOW DATABASES and SHOW TABLES return no results. -- Paul DuBois, [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: restore 'dumped' database
At 3:15 PM -0700 5/2/01, Brian Warn wrote: Hi, How do I restore a copied database that I've created with mysqldump? I have both the DuBois book and, of course, the online manual handy. I'm obviously looking in the wrong area of them because I can't find anything (I thought the keyword 'restore' would net me something, but no joy). I'll happily take my 'RTFM' beatings if someone would just point me to the appropriate section(s) of one or both... -Brian The dump file just contains SQL statements. Feed it to mysql: % mysql dbname dumpfile -- Paul DuBois, [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: i could just cry . . . mysql dead
Strongly suggest you go to the MySQL website and get mysql from there. Do not use redhat's mysql. - Original Message - From: Marc Bragg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 7:27 Subject: i could just cry . . . mysql dead I installed 7.0 with mysql on the redhat cd, and for a while it worked, then stopped. reinstalled everything, and now get: for /etc/rc.d/rc3.d/S85mysqld status mysqld dead but subsys locked Would partially run on safe_mysqld until I followed page 417 in the mysql manuyal, and now i get a very complicated long error related to the pid file, which I never could find anyway. How to uninstall, rpm -e won't work, and anysuggestion for starting over? 6.2 was so much kinder and it's not like i don't enjoy a challenge, but really. - 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: Date comparisions...
On Wed, May 02, 2001 at 04:00:17PM +0100, Roo wrote: Hi all, I was recently attempting what I thought would be an easy search. I wanted to return all records with a birthdate (a DATE column) 'within' 30 days of the current date. The birthdate is stored as a -MM-DD, I have been having lots of trouble getting MySQL to return the correct records, my problems are.. 1.I need to ignore the year value as all birthdates will be previous to the current if the year is included. 2.I need to check if a birthdate is in the same month as the current month and that its day is not less than the current day. 3.Then I need to check how many days there are left in the current month, take it away from 30 and then check for birthdates in the following month within that many days. So much for being a simple problem! Anyone have any experience of doing this..? LINUX..MySQL 3.22.32 on apache thanks a bunch for any info You're making it much too complicated. Try: select birthdate from table where concat(substring(now(),1,4),substring(birthdate,5,6)) between date_sub(now(), interval 30 day) and date_add(now(), interval 30 day) Much to my surprise this did not fail when there were birthdays on Feb. 29. -- The action required to sustain human life is primarily intellectual: everything man needs has to be discovered by his mind produced by his effort... Since knowledge, thinking, rational action are properties of the individual, since the choice to exercise his rational faculty or not depends on the individual, man's survival requires that those who think be free of the interference of those who don't. Since men are neither omniscient nor infallible, they must be free to agree or disagree, to cooperate or to pursue their own independent course, each according to his own rational judgment. Freedom is the fundamental requirement of man's mind. -- Ayn Rand Rick Pasotto email: [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: DELETE question
At 1:43 PM -0500 5/2/01, Dawn H wrote: Anybody got a clue why this isn't deleting? The number is input in the previous section of code and I know it works correctly, but for some reason How do you know? when it gets to here, it just skips to view (apparently), (even if I # out the Lock lines, so it isn't a lock problem). Am I going about getting the number into the query in the wrong way? If so, what is the correct manner to achieve this? Thanks in advance for your help, Dawn H -CODE BELOW- sub delete { $num=param('delete'); $num=$dbh-quote($num); GET_LOCK(edit,10) or bail_out(Cannot get lock, please wait a moment and try again); What's the deal with this? GET_LOCK() is a MySQL function, but it looks like you're executing executing it as a Perl function? $sth = $dbh-prepare(DELETE FROM database WHERE id=$num) Is database a database name or a table name? or bail_out(Cannot prepare to be deleted); $sth-execute() or bail_out(Cannot delete); RELEASE_LOCK(edit) or bail_out(An error occurred when attempting to release lock); Ditto for RELEASE_LOCK(). I suggest you use trace() to turn on debugging, or enable RaiseError when you connect to MySQL to force errors to terminate your program with an error message. view(); } Also: - For a DELETE, you don't need prepare() + execute(). Just use do(). - You don't need GET_LOCK() and RELEASE_LOCK() anyway for a single statement. The DELETE will execute atomically. MySQL will lock the table for your automatically while it's processing the DELETE. But it does look like you're quoting the number properly before inserting it into the query string. -- Paul DuBois, [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: i could just cry . . . mysql dead
Why you said that Do not use Mysql on RadHat' CD? Which is the problem?Thanks Rolf Hopkins wrote: Strongly suggest you go to the MySQL website and get mysql from there. Do not use redhat's mysql. - Original Message - From: Marc Bragg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 7:27 Subject: i could just cry . . . mysql dead I installed 7.0 with mysql on the redhat cd, and for a while it worked, then stopped. reinstalled everything, and now get: for /etc/rc.d/rc3.d/S85mysqld status mysqld dead but subsys locked Would partially run on safe_mysqld until I followed page 417 in the mysql manuyal, and now i get a very complicated long error related to the pid file, which I never could find anyway. How to uninstall, rpm -e won't work, and anysuggestion for starting over? 6.2 was so much kinder and it's not like i don't enjoy a challenge, but really. - 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
Preparing SQL Statements
Hi, I was wondering if MySQL allows the ability to perform a SQL Prepare on sql statements prior to performing an execute. I'm using ADO on Windows and with a CommandPtr object, you can set a property called Prepared, that will attempt to prepare sql statements and will keep them prepared for future use so that executes run quicker. I am also using MyODBC for the connection to my DB Server. I have tried to use preparing of SQL statements, but am receiving this error: 1006 Query SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE It's not an invalid Select statement as these statements have worked for months. So I'm wondering if it's MySQL, or perhaps MyODBC that does not support preparing the sql statements. Previously, I have worked with other databases using these ADO commands and this has not been a problem. Thanks, Sam - 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: i could just cry . . . mysql dead
Redhat's version of mysql has problems or known to. It's always better from source anyway. - Original Message - From: Taing Nguonq [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 9:45 Subject: Re: i could just cry . . . mysql dead Why you said that Do not use Mysql on RadHat' CD? Which is the problem?Thanks Rolf Hopkins wrote: Strongly suggest you go to the MySQL website and get mysql from there. Do not use redhat's mysql. - Original Message - From: Marc Bragg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 7:27 Subject: i could just cry . . . mysql dead I installed 7.0 with mysql on the redhat cd, and for a while it worked, then stopped. reinstalled everything, and now get: for /etc/rc.d/rc3.d/S85mysqld status mysqld dead but subsys locked Would partially run on safe_mysqld until I followed page 417 in the mysql manuyal, and now i get a very complicated long error related to the pid file, which I never could find anyway. How to uninstall, rpm -e won't work, and anysuggestion for starting over? 6.2 was so much kinder and it's not like i don't enjoy a challenge, but really. - 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 - 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: specifying a delimiter
At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote: Hi, Being new to MySQL, I am having a problem getting output from it to the shell that is formatted the way I need. I need a table to be written to a file with a delimiter. something like : #!/bin/sh mysql -uroot -ptest database sql Then I run that script like this: ./script.sh output.txt Any delimiter is ok except for tab. Is this possible? Thanks, in advance, Not with mysql by itself. You can use sed or tr to change the tab in mysql's output to something else. The syntax for tr varies among systems, but on one of my systems (RedHat), both of these work: mysql sql | tr '\t' : mysql sql | tr '\011' : -- Paul DuBois, [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: i could just cry . . . mysql dead
At 8:45 AM +0700 5/3/01, Taing Nguonq wrote: Why you said that Do not use Mysql on RadHat' CD? Which is the problem?Thanks RedHat's RPMs are broken. What happened when you tried rpm -e? Better to build from source or use mysql.com RPMs. Rolf Hopkins wrote: Strongly suggest you go to the MySQL website and get mysql from there. Do not use redhat's mysql. - Original Message - From: Marc Bragg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 7:27 Subject: i could just cry . . . mysql dead I installed 7.0 with mysql on the redhat cd, and for a while it worked, then stopped. reinstalled everything, and now get: for /etc/rc.d/rc3.d/S85mysqld status mysqld dead but subsys locked Would partially run on safe_mysqld until I followed page 417 in the mysql manuyal, and now i get a very complicated long error related to the pid file, which I never could find anyway. How to uninstall, rpm -e won't work, and anysuggestion for starting over? 6.2 was so much kinder and it's not like i don't enjoy a challenge, but really. -- Paul DuBois, [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: What do I do now?
At 11:52 PM -0600 5/1/01, Colin Faber wrote: why not just use the LOAD DATA INFILE option? That probably won't help much. All the mysqlimport does is issue a LOAD DATA statement for you. LOAD DATA LOCAL INFILE might help, though. Or mysqlimport --local. At least, if the file_name.csv file is on the client host. Bombardier Systems Consulting wrote: HELP!!! I sent a message to this forum a couple of days ago about a problem that I am having with MySQL 3.23.37 (and now 36) running under RedHat 7.1. I am trying to use the mysqlimport utility and continue to get the following error: mysqlimport: Error: Can't get stat of '/home/yada/yada/file_name.csv' (Errcode: 13), when using table: file_name This utility was working when I was running 3.23.36 and RedHat 7.0 but RedHat kept crashing and so I had to upgrade to 7.1. When I installed MySQL I got the 3.23.37 version of MySQL. I have since re-installed RedHat 7.1 and the MySQL 3.23.36 version and am getting the same error. I looked up the error in the documentation and tried the UMASK change, rebooted, created new directory and moved file into it...still same problem. ANY ASSISTANCE WOULD BE APPRECIATED! Jim - 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 -- Paul DuBois, [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: user setting own password.
At 4:50 PM -0700 5/1/01, Dato wrote: how does a user set his own password in mysql? I have searched through the archives, and have found only the 'st password..' command. this does not work. In my case, there are more then just one host in the user table and the set password command only changes the localhost entry, leaving me unable to connect with the new password form other hosts! how do I solve this? Any help would be appreciated. Thanks. Unless you're the root user, you can only change the password of the user that you're connected as. Allowing you change someone else's password would be a huge security breach. (The user table entries you refer to *are* for different users, because a user in MySQL is really a user+hostname combination.) You'll need to connect with the given user name from the various hosts to be able to change the corresponding passwords with the SET PASSWORD command. -- Paul DuBois, [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
accessing mysql via a c program
Hello, were can I find documentation regarding accessing mysql database via a c program?maybe some examples of a simple c program. Thanks Dana - 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: windoze and batch files
Stan: We do it every day. Use notepad (or whatever text editor you have available) to create the query file and save it a folder. Make sure C:\MYSQL\BIN is in your path, and open a DOS prompt. CD\ to the folder with the query file, and run it with a command line like: mysql -u{username} -p {dbname}{queryfile.txt} ...i.e.: mysql -ugerald -p databasedatabasequery.txt Supply the password when prompted to enter it. You might also want to try one of the free GUI utilities, like MySQLFront (http://www.mysqlfront.de). I happen to like MySQLFront because it has a query editor, table/column editor, etc. Gerald Jensen - Original Message - From: Bordeaux Stan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 7:23 PM Subject: windoze and batch files Hi all, unfortunately, I am forced to do some background mysql development work on a windoze box, which for reasons I wont go into here requires that I use the mysql console client. As many would know this does not allow any commands to be edited in the console as does linux. I decided that it would be easier to write a batch file to do some work but can't find out how to get mysql to process the batch file. Issuing the mysql batch file in dos mode wont work. Any help appreciated as I'm getting sick and tired of entering long queries at the mysql prompt and then retyping the whole thing if I make a small syntax error. Stan Bordeaux Injury Prevention Policy Officer Public Environmental Health Service 1/34 Davey St Hobart 7000 ph: (03)6233 3774 fax: (03)6223 1163 email: [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