rpm of plain MySQL-4.0.2 does not contain InnoDB; download rpm of MySQL-Max-4.0.2 instead
Hi! Due to an error in the build process, the rpm of plain MySQL-4.0.2 does not contain InnoDB. Please download the rpm of MySQL-Max-4.0.2 instead. The error in the build of the plain MySQL-4.0.2 rpm will be fixed in the coming days. Best regards, Heikki Tuuri Innobase Oy - 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 subtraction error
You can't subtract dates like that. You need to use the built in date/time functions. See the following: http://www.mysql.com/doc/D/a/Date_calculations.html http://www.mysql.com/doc/D/a/Date_and_time_functions.html Your query would be something like this: SELECT TO_DAYS(completion_date) - TO_DAYS(order_date) AS days_elapsed ... --jeff - Original Message - From: Brandon McCombs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 8:34 PM Subject: date subtraction error Hi, Maybe I'm missing something but I tried solution someone posted for someone else's problem concerning finding out # of days between 2 dates. I have 2 sets of dates I'm working with in my sample DB. order_date completion_date 2002-07-03 2002-07-09 and 2002-06-27 2002-07-08 Now the query I'm using is the following: select (completion_date-order_date) as days_elapsed from received where completion_date != 0; I get the following as a result: 6 81 Obviously there isn't 81 days between June 27th and July 8th. Can anyone tell me why mysql does the calculation this way and if there is a more correct way of doing the subtraction of the dates? Thanks Brandon - 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: Updates
Karl, - Original Message - From: karl [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, July 14, 2002 7:41 AM Subject: Updates Hello, This is similar to my post earlier...(I'm really racking my brains over this). I'm going to try and rephrase (shorten) my question: I've created a database that multiple users can search from. The results that USER1 returns must be unique even if USER2 uses the exact same lookup. So, I'm trying to put a HOLD on a record(s) that each USER is looking at, I'm trying to use TABLEB for indicating whos looking at what (who has a hold on certain records). I'm really hoping there is an efficient SQL approach to this, I'm trying to avoid using script to step painlessly through the tables record for record to apply HOLDS on records. if you use InnoDB type tables, you can do you searches inside a transaction (wrap the transaction in BEGIN ... COMMIT) with: SELECT ... FOR UPDATE That sets exclusive row level locks on each index record the SELECT looks at. You may want to tune innodb_lock_wait_timeout in my.cnf if the transactions last long. Any good ideas? Karl Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: using a '*.seq' file
Wouter, I did open it up in MSWord and found that there were no commands in the file, just data. What makes this worse is that each field is preceded with a tab and a character which identifies the field. Empty fields are omitted to the extent that although the fields run in the sequence A-Z and then a-z, the data shows gaps with no fields and no tabs. So a record might look like this: [tab]ABloggs, J[tab]BTitle of work[tab]F0123456789 and so on. The file obviously relates to a single table and weighs in at a mighty 98Mb. From what I can see I am going to have to write some sort of parser in PHP or similar in order to get the data into a decent format to work with before its ready for MySQL. If anyone's had to do anything like this before I would welcome any code, comments, help etc. Regards George - Original Message - From: Wouter van Vliet [EMAIL PROTECTED] To: George Pitcher [EMAIL PROTECTED] Sent: Friday, July 12, 2002 7:43 PM Subject: RE: using a '*.seq' file Hmm, i'm not that much into Oracle but I know that between most Database Systems small differences are there in the SQL syntax. What I would advice you to do is just try to run the .seq file (with a ./database.seq like command) and see what errors it returns. You can then try to eliminate the problem. Most problems will occur with datatypes I guess. Maybe check out some auto_increment issues ... if you're getting errors out of the .seq file with whom you don't know what to do, just mail the list. Note that an *.sql file is no more than a file containing raw SQL commands to be executed upon a database. You may as well call it *.MichaelJackson or whatever. ;). So yes, in basic the files seem to be the same. Or at least I hope so .. maybe try to open the file in some texteditor and see what it looks like. Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: George Pitcher [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 11 juli 2002 13:28 Aan: [EMAIL PROTECTED] Onderwerp: using a '*.seq' file I've been handed a 'data.seq' file containing a really useful database. This is currently hosted on my future employer's site using Oracle. I wish to look up some of the data there and pull it into my Filemaker database. I'm using Filemaker for historical reasons and plan to move to MySQL in a few months. What I want to do right now is see how valid the data will be and what I can do to access the data is a useul way, so I thought I would put it into MySQL and then try out Filemaker's ODBC tools. Is there an easy way to load the .seq file? Is a .seq file the same as a .sql file? Regards George in Edinburgh (but just for another 3 weeks) - 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
ERROR 1030: Got error 22 from table handler
Hi! grant == grant [EMAIL PROTECTED] writes: Description: grant when running a insert data infile command on a 500MB text file, I grant get the error ERROR 1030: Got error 22 from table handler from grant mysql. I did a listing of the database files and it looks like this: grant -rw-rw 1 root root 2147397632 Jul 3 09:46 finddata.MYD grant -rw-rw 1 root root 266409984 Jul 3 10:01 finddata.MYI grant -rw-rw 1 root root8866 Jul 3 08:45 finddata.frm grant I thought that Solaris 2.6 didn't have a problem with files over 2GB. How-To-Repeat: grant Generate a large database, up to the 2GB limit. It should blow up on you. Fix: grant unknown On Solaris 2.6 it depends on how you create the file system and how MySQL is compiled if you can create files bigger than 2G. You can verify the max file limit supported internally by MySQL by creating a file with MAX_ROWS=1 and then do a SHOW TABLE STATUS on the table. If the max data file length 2G then the limit is on the file system, in which case you probably have to do re-format your disk to get it to support larger files. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CREATE FUNCTION
Hi, Can anybody help me figuring how to control granting users permissions to created functions in MySQL like we do for SELECT, INSERT, ...etc or it is not possible and every one logged in to MySQL could simply use them like any other native function? Regards -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - 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
Extremely slow UPDATE in 4.02
Description: This very basic UPDATE command is very slow in 4.02 : UPDATE lang2 SET ref_id = 0; (could be also = 1, = 2, etc) It takes several minutes to run on a 235,000 records table, with high disk activity (fs_usage reveals many seek/read/write accesses). For comparison, it takes about 5 seconds to execute with mysql 4.01 with the exact same database (properly installed on both servers from a dump text file). How-To-Repeat: A) create this table: CREATE TABLE lang2 ( code int(11) NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', infos varchar(200) NOT NULL default '', motexp varchar(200) NOT NULL default '', lang_source tinyint(4) default NULL, lang_target tinyint(4) default NULL, id int(11) NOT NULL auto_increment, PRIMARY KEY (id), KEY code (code), KEY lang_source (lang_source), KEY lang_target (lang_target) ) TYPE=MyISAM; B) Insert 100,000 rows C) run this : UPDATE lang2 SET ref_id = 0; Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Dominique Peretti Organization: La Chose Interactive MySQL support: none Synopsis: UPDATE table SET column = n extremely slow Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.2-alpha (basic compilation without stop words) Environment: machine, os, target, libraries (multiple lines) System: Darwin localhost 5.5 Darwin Kernel Version 5.5: Thu May 30 14:51:26 PDT 2002; root:xnu/xnu-201.42.3.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/2.95.2/specs Apple Computer, Inc. version gcc-937.2, based on gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Jul 13 13:00 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Dominique Peretti / no stop words' --with-extra-charsets=complex --disable-shared - 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: CREATE FUNCTION
http://www.mysql.com/doc/P/r/Privileges.html Sameh Attia wrote: Hi, Can anybody help me figuring how to control granting users permissions to created functions in MySQL like we do for SELECT, INSERT, ...etc or it is not possible and every one logged in to MySQL could simply use them like any other native function? Regards -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.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: CREATE FUNCTION
Veysel Harun Sahin wrote: http://www.mysql.com/doc/P/r/Privileges.html Sameh Attia wrote: Hi, Can anybody help me figuring how to control granting users permissions to created functions in MySQL like we do for SELECT, INSERT, ...etc or it is not possible and every one logged in to MySQL could simply use them like any other native function? Regards Thanx Veysel for your concern; but unfortunately this did not help me. Creating functions is independent of tables or databases privileges. Is there a solution one can authorize using created functions? Regards -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - 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 (3.23.49) crash on netbsd_1.6BETA4
Description: No problems during compilation. Nonetheless the server won't start at all. Been unable to execute mysql_install_db --force after installation. hostname.err: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=16773120 record_buffer=131072 sort_buffer=524252 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80376 K bytes of memory Hope that's ok, if not, decrease some variables in the equation How-To-Repeat: upgrade to netbsd-current; apply netbsd-patches to mysql-src; make make install; safe_mysqld --user=mysql Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: mysql-server crashing on startup Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Source distribution) Environment: System: NetBSD 1.6_BETA4 cpu0: Intel Pentium III (Coppermine) (686-class), 800.07 MHz cpu0: I-cache 16 KB 32b/line 4-way, D-cache 16 KB 32b/line 2-way cpu0: L2 cache 256 KB 32b/line 8-way cpu0: features 387f9ffFPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,SEP,MTRR cpu0: features 387f9ffPGE,MCA,CMOV,FGPAT,PSE36,PN,MMX cpu0: features 387f9ffFXSR,SSE cpu0: serial number -0686-0001-B128-B299-DF2C total memory = 511 MB avail memory = 470 MB using 6144 buffers containing 26292 KB of memory swapctl -l: Device 512-blocks UsedAvail Capacity Priority /dev/raid1a 5241600 524160 0%0 RAID autoconfigure Configuring raid1: ecc... Some paths: /usr/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) (NetBSD nb2) Compilation info: CC='gcc' CFLAGS='-g -O3' CXX='gcc' CXXFLAGS='-g -O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1344510 Jul 12 15:52 /usr/lib/libc.a lrwxrwxr-x 1 root wheel 13 Jul 13 20:50 /usr/lib/libc.so - libc.so.12.83 lrwxrwxr-x 1 root wheel 13 Jul 13 20:50 /usr/lib/libc.so.12 - libc.so.12.83 -r--r--r-- 1 root wheel 685044 Jun 10 18:41 /usr/lib/libc.so.12.62.1 -r--r--r-- 1 root wheel 699791 Jul 12 16:14 /usr/lib/libc.so.12.83 Configure command: ./configure --prefix=/usr/local/mysql --with-debug=full --- gdb sessions: gdb /usr/local/libexec/mysqld /usr/local/mysql/var/mysqld.core: GNU gdb 5.0nb1 Copyright 2000 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type show copying to see the conditions. There is absolutely no warranty for GDB. Type show warranty for details. This GDB was configured as i386--netbsdelf... core was generated by `mysqld'. Program terminated with signal 11, Segmentation fault. Reading symbols from /usr/libexec/ld.elf_so...done. Loaded symbols for /usr/libexec/ld.elf_so Reading symbols from /usr/lib/libz.so.0...done. Loaded symbols for /usr/lib/libz.so.0 Reading symbols from /usr/lib/libcrypt.so.0...done. Loaded symbols for /usr/lib/libcrypt.so.0 Reading symbols from /usr/lib/libm.so.0...done. Loaded symbols for /usr/lib/libm.so.0 Reading symbols from /usr/lib/libc.so.12...done. Loaded symbols for /usr/lib/libc.so.12 #0 0x48269a4f in kill () from /usr/lib/libc.so.12 (gdb) backtrace full #0 0x48269a4f in kill () from /usr/lib/libc.so.12 # [ /usr/lib/libc.so.12 - libc.so.12.83 ] No symbol table info available. #1 0x8159f3d in pthread_sig_process () at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/sig.c:135 vector = (void (*)(void)) 0x81d9510 i = 11 j = 136156668 #2 0x8157f36 in __cleanup_after_resume () at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/signal.c:559 No locals. #3 0x8158043 in pthread_sched_resume () at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/signal.c:536 No locals. #4 0x815b5be in pthread_kill (pthread=0x81d9510, sig=11) at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/pthread_kill.c:91 pthread = (struct pthread *) 0x81d9510 sig = 11 pthread_ptr = (struct pthread **) 0x0 #5 0x80f6418 in write_core (sig=11) at stacktrace.c:220 sig = 11 #6 0x807f554
Re: CREATE FUNCTION
ahh sorry for misunderstand. the truth is that i have no idea about the solution of your problem but i would like to hear from you if you find a solution. Sameh Attia wrote: Veysel Harun Sahin wrote: http://www.mysql.com/doc/P/r/Privileges.html Sameh Attia wrote: Hi, Can anybody help me figuring how to control granting users permissions to created functions in MySQL like we do for SELECT, INSERT, ...etc or it is not possible and every one logged in to MySQL could simply use them like any other native function? Regards Thanx Veysel for your concern; but unfortunately this did not help me. Creating functions is independent of tables or databases privileges. Is there a solution one can authorize using created functions? Regards -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.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
compiling 4.0.2
Hi! Marko == Marko Djukic [EMAIL PROTECTED] writes: Marko Anyone know what this syntax error is about? trying to compile the 4.0.2 on a freebsd server... Marko Making all in sql Marko gmake[2]: Entering directory `/usr/home/oblo/xfer/mysql-4.0.2/sql' Marko byacc -d sql_yacc.yy mv y.tab.c sql_yacc.cc Marko byacc: e - line 75 of sql_yacc.yy, syntax error Marko %pure_parser/* We have threads */ Marko ^ The reason for the above is that you are using byacc instead of 'bison'. Fix: Execute in the MySQL directory: cd sql bison -d sql_yacc.yy mv y.tab.c sql_yacc.cc cd .. make all Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto_increment
Hi all, When i use MS access 2000 with odbc to fill my MySQL db(running on linux) auto_increment seems not to work . Is that normal? Or am i missing something? TIA Raymond - 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-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl., but need help with FIXes
In the last episode (Jul 13), R Blake said: BUG #1: sys/poll.h does not seem to exist in BSD variants (cref: http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but nonetheless, ./configure sets HAVE_POLL as defined, causing make to fail with sys/poll.h not found. WORKAROUND: == (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in (CHANGE) /* Define if you have the poll function. */ #define HAVE_POLL 1 (TO) /* Define if you have the poll function. */ /* #define HAVE_POLL 1 */ == The correct thing to do is probably to fix include/my_net.h. poll requires poll.h, not sys/poll.h. In addition, there should be an autoconf check for poll.h, instead of assuming that because you have a poll function there is also a poll.h. http://www.opengroup.org/onlinepubs/007904975/functions/poll.html --- include/my_net.h~ Mon Jul 1 06:16:44 2002 +++ include/my_net.hSun Jul 14 13:43:49 2002 @@ -38,7 +38,7 @@ #include arpa/inet.h #endif #ifdef HAVE_POLL -#include sys/poll.h +#include poll.h #endif #ifdef HAVE_SYS_IOCTL_H #include sys/ioctl.h BUG #2: a subsequent make fails with: ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o complete.o bind.o isearch.o display.o signals.o util.o kill.o undo.o macro.o input.o callback.o terminal.o xmalloc.o history.o histsearch.o histexpand.o histfile.o nls.o search.o shell.o tilde.o ranlib libreadline.a make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/readline' Making all in pstack make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in aout make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[3]: Nothing to be done for `all-am'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in libmysql make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' /bin/sh ../libtool --mode=compile cc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/private/var/mysql\ -DSHAREDIR=\/usr/local/var/mysql/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c libmysql.c cc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/private/var/mysql\ -DSHAREDIR=\/usr/local/var/mysql/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c libmysql.c -o libmysql.o libmysql.c: In function `mysql_real_connect': libmysql.c:1663: sizeof applied to an incomplete type make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha' make: *** [all-recursive-am] Error 2 [root@server] i don't have a FIX, but commenting out the offending code (also in 'manager.c') seems to do the trick The error is because GETHOSTBYNAME_BUFF_SIZE expands to sizeof(struct hostent_data) and hostent_data is not defined. I think that should be struct hostent instead (I can't find struct hostent_data defined anywhere on the systems I have access to). --- include/my_net.h~ Sun Jul 14 13:43:49 2002 +++ include/my_net.hSun Jul 14 14:00:37 2002 @@ -89,7 +89,7 @@ #endif /* !defined(HAVE_GETHOSTBYNAME_R_GLIBC2_STYLE) */ #elif defined(HAVE_GETHOSTBYNAME_R_RETURN_INT) -#define GETHOSTBYNAME_BUFF_SIZE sizeof(struct hostent_data) +#define GETHOSTBYNAME_BUFF_SIZE sizeof(struct hostent) struct hostent *my_gethostbyname_r(const char *name, struct hostent *result, char *buffer, int buflen, int *h_errnop); -- Dan Nelson
A beginners proplems.
Your patience please :) I am an absolute newbie. When I setup Mysql I made some mistakes and now I can't seem to get out of them. When I login as root and type mysql on the command line as root, I get the following: [william@localhost william]$ su Password: [root@localhost william]# mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [root@localhost william]# When I log in as a regular user and try to move forward, I get the following: [william@localhost william]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 3.23.47 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.02 sec) mysql USE mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql Any help would be appreciated. Thank you, Bill. - 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-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDSincl., but need help with FIXes
dan, thx for your reply! --On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Jul 13), R Blake said: BUG #1: sys/poll.h does not seem to exist in BSD variants (cref: http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but nonetheless, ./configure sets HAVE_POLL as defined, causing make to fail with sys/poll.h not found. WORKAROUND: == (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in (CHANGE) /* Define if you have the poll function. */ # define HAVE_POLL 1 (TO) /* Define if you have the poll function. */ /* #define HAVE_POLL 1 */ == The correct thing to do is probably to fix include/my_net.h. poll requires poll.h, not sys/poll.h. In addition, there should be an autoconf check for poll.h, instead of assuming that because you have a poll function there is also a poll.h. http://www.opengroup.org/onlinepubs/007904975/functions/poll.html --- include/my_net.h~ Mon Jul 1 06:16:44 2002 +++ include/my_net.hSun Jul 14 13:43:49 2002 @@ -38,7 +38,7 @@ #include arpa/inet.h #endif #ifdef HAVE_POLL -#include sys/poll.h +#include poll.h #endif #ifdef HAVE_SYS_IOCTL_H #include sys/ioctl.h that may be the case, assuming poll.h exists ANYWHERE on the system that unfortunately is the problem here (http://www.netsys.com/bsdi-users/2001-11/msg00093.html) i think your autoconf check suggestion makes sense, but where should the change be made in the autoconf or mysql distribution? BUG #2: a subsequent make fails with: ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o complete.o bind.o isearch.o display.o signals.o util.o kill.o undo.o macro.o input.o callback.o terminal.o xmalloc.o history.o histsearch.o histexpand.o histfile.o nls.o search.o shell.o tilde.o ranlib libreadline.a make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/readline' Making all in pstack make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in aout make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[3]: Nothing to be done for `all-am'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in libmysql make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' /bin/sh ../libtool --mode=compile cc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/private/var/mysql\ -DSHAREDIR=\/usr/local/var/mysql/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c libmysql.c cc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/private/var/mysql\ -DSHAREDIR=\/usr/local/var/mysql/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c libmysql.c -o libmysql.o libmysql.c: In function `mysql_real_connect': libmysql.c:1663: sizeof applied to an incomplete type make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha' make: *** [all-recursive-am] Error 2 [root@server] i don't have a FIX, but commenting out the offending code (also in 'manager.c') seems to do the trick The error is because GETHOSTBYNAME_BUFF_SIZE expands to sizeof(struct hostent_data) and hostent_data is not defined. I think that should be struct hostent instead (I can't find struct hostent_data defined anywhere on the systems I have access to). --- include/my_net.h~ Sun Jul 14 13:43:49 2002 +++ include/my_net.h Sun Jul 14 14:00:37 2002 @@ -89,7 +89,7 @@ #endif /*
Re: A beginners proplems.
on 7/14/02 3:29 PM, William Bradley, typed: mysql USE mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql use 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
redirect output to a file?
Hi, WIth the way eSKUeL (a PHP app I found on freshmeat) displays query results in a table, and the way that copying and pasting that data into a xls or doc file appears I'm hoping to be able to run queries manually on the mysql prompt and have the output redirected to a file so that I'm able to more easily print the output because I don't want all the information that eSKUeL displays on output either (it doesn't make a new page for results so you can see all the available commands as well and I don't want those visible when results are printed). Is there a way to redirect query output to a file? I didn't see anything in the manual that specified how to do this. By the way, when I copy and paste the data from the html table that eSKUeL displays the results in it appears in excel or word such that each piece of data that was within a cell is put onto a different line so everything is vertical when pasted, instead of having a full line for each record. Obviously that isn't useable. THanks Brandon - 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-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl., but need help with FIXes
In the last episode (Jul 14), R Blake said:
--On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Jul 13), R Blake said:
BUG #1:
sys/poll.h does not seem to exist in BSD variants (cref:
http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but
nonetheless, ./configure sets HAVE_POLL as defined, causing make to
fail with sys/poll.h not found.
The correct thing to do is probably to fix include/my_net.h. poll
requires poll.h, not sys/poll.h. In addition, there should be
an autoconf check for poll.h, instead of assuming that because
you have a poll function there is also a poll.h.
that may be the case, assuming poll.h exists ANYWHERE on the system
that unfortunately is the problem here
(http://www.netsys.com/bsdi-users/2001-11/msg00093.html)
It does exist on FreeBSD, NetBSD, and OpenBSD. So man poll doesn't
come up with anything on your system? I wonder where it's picking up
the poll function from, then. HAVE_POLL means it was able to link a
dummy program consisting of main(){ poll(); } .
i think your autoconf check suggestion makes sense, but where should
the change be made in the autoconf or mysql distribution?
mysql, since it's the one using poll. If there were an AC_FUNC_POLL
macro that did all the work for you, then it would go into autoconf,
but there isn't.
--
Dan Nelson
[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
MyCC-0.8.4 and MySQL-4.0.2
Hi all. I just upgraded to MySQL-4.0.2 (great work guys) and noticed that MyCC's user administration isn't displaying privileges properly, ie doesn't show them at all. (When I say upgrade, I mean a full uninstall new install, and import from mysqldump backups). Granting seems to work OK (I think) but anyway I'm a bit scared to use it at the moment... I assume this is because of the updates to MySQL's grant tables relating to the 'create temp table' privileges, but I'm just guessing here. Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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: Presentation
I need to make a presentation about the topics of mysql like history, phisical structure, logic structure, like that. Alexander --- Jeremy Zawodny [EMAIL PROTECTED] escreveu: On Sat, Jul 13, 2002 at 11:12:11PM -0300, Alexander Burbello wrote: Hi, I need to make a presentation about MySQL (structure, etc.) Anybody can help me. If anybody have a presentation (powerpoint, etc) would you be so kind to send me by e-mail, please. Can you be a little more specific? Saying structure, etc doesn't tell me *at all* what you intend to present. The structure of what? I have several presentations on-line here: http://jeremy.zawodny.com/mysql/ but I suspect that none of them will help you. Let me know if they do. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 45 days, processed 977,585,799 queries (250/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 ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.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
Beginner's question
I am writting a search engine using Mysql. I am trying to return a text object value ( which contains all of the html), but it is taking about 10 seconds to return each text value matching my query. Is there any way that a text value can be optimized? www.cs.uno.edu/~kkelly - 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-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDSincl., but need help with FIXes
--On Sunday, July 14, 2002 5:24 PM -0500 Dan Nelson
[EMAIL PROTECTED] wrote:
The correct thing to do is probably to fix include/my_net.h. poll
requires poll.h, not sys/poll.h. In addition, there should be
an autoconf check for poll.h, instead of assuming that because
you have a poll function there is also a poll.h.
that may be the case, assuming poll.h exists ANYWHERE on the system
that unfortunately is the problem here
(http://www.netsys.com/bsdi-users/2001-11/msg00093.html)
It does exist on FreeBSD, NetBSD, and OpenBSD. So man poll doesn't
come up with anything on your system? I wonder where it's picking up
the poll function from, then. HAVE_POLL means it was able to link a
dummy program consisting of main(){ poll(); } .
h good question. 'man poll' DOES come up with the man page, but
there's no trace of the header file even on a check of a 'virgin'
developer install
probably picking up the function in one of the system frameworks now
the question is which/where
i think your autoconf check suggestion makes sense, but where should
the change be made in the autoconf or mysql distribution?
mysql, since it's the one using poll. If there were an AC_FUNC_POLL
macro that did all the work for you, then it would go into autoconf,
but there isn't.
with your suggesion for fixing my_net.h, and the temp fix to config.h'
HAVE_POLL definition, all of the -related- problems go away
now i have to deal with this piecewise archive linking problem that's
causing make to die
/bin/sh ../libtool --mode=link cc -O -DDBUG_OFF -O3
-fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib
-L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib
-traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE
-DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH
-flat_namespace -undefined suppress -L/System/Library/Frameworks -L/usr/lib
-L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -o
libmysqlclient.la -rpath /usr/local/mysql/lib/mysql -version-info 11:0:0
libmysql.lo net.lo password.lo manager.lo get_password.lo errmsg.lo
my_init.lo my_static.lo my_malloc.lo my_realloc.lo my_create.lo
my_delete.lo mf_tempfile.lo my_open.lo .lo my_read.lo my_write.lo errors.lo
my_error.lo my_getwd.lo my_div.lo mf_pack.lo
my_messnc.lo mf_dirname.lo mf_fn_ext.lo f_format.lo mf_path.lo
mf_unixpath.lo my_fopen.lo my_symlink.lo
my_fstream.lo mf_loadpath.lo my_pthread.lo
my_thr_init.lo y_compress.lo array.lo my_once.lo list.lo my_net.lo
charset.lo hash.lo mf_iocache.lo mf_iocache2.lo
my_seek.lo my_pread.lo mf_cache.lo my_vsnprintf.lo md5.lo
my_getopt.lo my_gethostbyname.lo my_lib.lo strmov.lo strxmov.lo strxnmov.lo
strnmov.lo strmake.lo strend.lo nt2str.lo str2int.lo
strinstr.lo strcont.lo strcend.lo bcmp.lo
bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo
strtoll.lo llstr.lo ctype.lo ctype-big5.lo ctype-czech.lo
ctype-euc_kr.lo ctype-gb2312.lo ctype-gbk.lo ctype-latin1_de.lo
ctype-sjis.lo ctype-tis620.lo ctype-ujis.lo dbug.lo vio.lo viosocket.lo
viossl.lo viosslfactories.lo -lm
using piecewise archive linking...
ar cru .libs/libmysqlclient.a libmysql.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a net.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a password.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a manager.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a get_password.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a errmsg.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_init.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_static.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_malloc.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_realloc.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_create.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_delete.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a mf_tempfile.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_open.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a mf_casecnv.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_read.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_write.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a errors.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_error.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_getwd.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_div.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a mf_pack.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a my_messnc.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a mf_dirname.o
: .libs/libmysqlclient.a
ar cru .libs/libmysqlclient.a mf_fn_ext.o
:
RE: Beginner's question
Can you provide more information like are you using cgi to get the code and what language. What's your query look like? Are you full text indexing your text field? Do you have an index on the table? What's the table structure look like? Can you send a sample record? How many records in the table? I query on text fields that hold html code all the time and use c++ cgi. It takes less then a second to return my query. So probably going to need more info. Thanks. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Kyle and Beth Kelly [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 7:16 PM To: [EMAIL PROTECTED] Subject: Beginner's question I am writting a search engine using Mysql. I am trying to return a text object value ( which contains all of the html), but it is taking about 10 seconds to return each text value matching my query. Is there any way that a text value can be optimized? www.cs.uno.edu/~kkelly - 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
users privileges
I've read the Adding New Users Section and the initial and post setup section of the manual, but I still need some clarification: After an install and a working MySQL I see it like this (Mac OS XS): there are 3 users: mysql - created manually after installing MySQL and has a password root - a mysql root user whose password has been set me - myself, using my machine (I have also run chown on mysql to user mysql.) What privileges need to be set and at what levels? (I plan on using phpMyAdmin as well, if that makes a difference.) Thanks, Lloyd - 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: redirect output to a file?
Yes you can run querys from the mysql prompt and redirct them to a file. Here's how. Make a file and call it query. Inside the file put something like this: use db_mydatabase select * from tbl_mytable where something=somethingelse; Then from the prompt (not in the mysql prompt) use this command: mysql -h somehostname -u username -p query results enter the password for the user then edit the results file which it created and there you go. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Brandon McCombs [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 5:53 PM To: [EMAIL PROTECTED] Subject: redirect output to a file? Hi, WIth the way eSKUeL (a PHP app I found on freshmeat) displays query results in a table, and the way that copying and pasting that data into a xls or doc file appears I'm hoping to be able to run queries manually on the mysql prompt and have the output redirected to a file so that I'm able to more easily print the output because I don't want all the information that eSKUeL displays on output either (it doesn't make a new page for results so you can see all the available commands as well and I don't want those visible when results are printed). Is there a way to redirect query output to a file? I didn't see anything in the manual that specified how to do this. By the way, when I copy and paste the data from the html table that eSKUeL displays the results in it appears in excel or word such that each piece of data that was within a cell is put onto a different line so everything is vertical when pasted, instead of having a full line for each record. Obviously that isn't useable. THanks Brandon - 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: Beginner's question
Hi Kelly, | I am writting a search engine using Mysql. I am trying to return | a text object value (which contains all of the html), but it is | taking about 10 seconds to return each text value matching my query. | Is there any way that a text value can be optimized? An SQL query example of what you are doing currently would have been useful. Are you using '%LIKE%' for matching? Or is it taking 10 seconds for normal selects as well? I assume there is a good reason why you are storing the whole HTML in your database, because it includes a whole bunch of redundant tags, links etc. Editing your page may become one hell of a chore very soon (e.g., if you just need to update a link!). But anyway, as for the text stuff try the INSTR function (http://snipurl.com/instr) and see if that helps? Perhaps you could take a look at regular expressions in some way too (http://snipurl.com/mysql_regexp) but am not sure how useful that is unless I know your table structure. Meanwhile, you could also try a slightly different approach of having a separate HTML_SEARCH table which maintains a link to the html blobs in your current table, but saves ONLY the content (no html tags etc). This way, the db does not have to search for a whole bunch of redundant tags but still would have a link to your current html files which are saved in a separate table that is used only for a layout. Hope this helped, Shanx -- Shashank Tripathi www.shanx.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: A beginners proplems.
try logging in as follows [william@localhost william] mysql - u root -p it will then prompt you for your root password you should have access as root after that HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: William Bradley [mailto:[EMAIL PROTECTED]] Sent: 14 July 2002 20:29 To: [EMAIL PROTECTED] Subject: A beginners proplems. Your patience please :) I am an absolute newbie. When I setup Mysql I made some mistakes and now I can't seem to get out of them. When I login as root and type mysql on the command line as root, I get the following: [william@localhost william]$ su Password: [root@localhost william]# mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [root@localhost william]# When I log in as a regular user and try to move forward, I get the following: [william@localhost william]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 3.23.47 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.02 sec) mysql USE mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql Any help would be appreciated. Thank you, Bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and Visual Basic 6.0
Hi. I am begining using MySQL with Visual Basic 6.0 in Windows 98 first edition. Some times i to receive this message but i don't know why. Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa6015-3.MYI' (Errcode: 13) The SQL instruction is: alter table products add (unitprice double(7,2), precio2 double(7,2)) I don't know if use MySQL with VB and Windows is good idea. Thanks Carlos From: Shashank Tripathi [EMAIL PROTECTED] To: 'Kyle and Beth Kelly' [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: RE: Beginner's question Date: Mon, 15 Jul 2002 09:49:12 +0900 Hi Kelly, | I am writting a search engine using Mysql. I am trying to return | a text object value (which contains all of the html), but it is | taking about 10 seconds to return each text value matching my query. | Is there any way that a text value can be optimized? An SQL query example of what you are doing currently would have been useful. Are you using '%LIKE%' for matching? Or is it taking 10 seconds for normal selects as well? I assume there is a good reason why you are storing the whole HTML in your database, because it includes a whole bunch of redundant tags, links etc. Editing your page may become one hell of a chore very soon (e.g., if you just need to update a link!). But anyway, as for the text stuff try the INSTR function (http://snipurl.com/instr) and see if that helps? Perhaps you could take a look at regular expressions in some way too (http://snipurl.com/mysql_regexp) but am not sure how useful that is unless I know your table structure. Meanwhile, you could also try a slightly different approach of having a separate HTML_SEARCH table which maintains a link to the html blobs in your current table, but saves ONLY the content (no html tags etc). This way, the db does not have to search for a whole bunch of redundant tags but still would have a link to your current html files which are saved in a separate table that is used only for a layout. Hope this helped, Shanx -- Shashank Tripathi www.shanx.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 _ Charle con sus amigos online usando MSN Messenger: http://messenger.msn.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
Use MySQL and Visual Basic 6.0
Hi. I am begining using MySQL with Visual Basic 6.0 in Windows 98 first edition. Some times i to receive this message but i don't know why. Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa6015-3.MYI' (Errcode: 13) The SQL instruction is: alter table products add (unitprice double(7,2), precio2 double(7,2)) I don't know if use MySQL with VB and Windows is good idea. Thanks Carlos _ MSN. Más Útil cada Día. http://www.msn.es/intmap/ - 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 and Visual Basic 6.0
Hi Carlos and All, Oh ya, i am also trying to use VB6.0 and mysql in window environment but is not sure how well they work together, may i know which middle ware you use to bridge the communication between VB6 and Mysql. - Original Message - From: Carlos Rovetto [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 15 July, 2002 9:17 AM Subject: MySQL and Visual Basic 6.0 Hi. I am begining using MySQL with Visual Basic 6.0 in Windows 98 first edition. Some times i to receive this message but i don't know why. Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa6015-3.MYI' (Errcode: 13) The SQL instruction is: alter table products add (unitprice double(7,2), precio2 double(7,2)) I don't know if use MySQL with VB and Windows is good idea. Thanks Carlos From: Shashank Tripathi [EMAIL PROTECTED] To: 'Kyle and Beth Kelly' [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: RE: Beginner's question Date: Mon, 15 Jul 2002 09:49:12 +0900 Hi Kelly, | I am writting a search engine using Mysql. I am trying to return | a text object value (which contains all of the html), but it is | taking about 10 seconds to return each text value matching my query. | Is there any way that a text value can be optimized? An SQL query example of what you are doing currently would have been useful. Are you using '%LIKE%' for matching? Or is it taking 10 seconds for normal selects as well? I assume there is a good reason why you are storing the whole HTML in your database, because it includes a whole bunch of redundant tags, links etc. Editing your page may become one hell of a chore very soon (e.g., if you just need to update a link!). But anyway, as for the text stuff try the INSTR function (http://snipurl.com/instr) and see if that helps? Perhaps you could take a look at regular expressions in some way too (http://snipurl.com/mysql_regexp) but am not sure how useful that is unless I know your table structure. Meanwhile, you could also try a slightly different approach of having a separate HTML_SEARCH table which maintains a link to the html blobs in your current table, but saves ONLY the content (no html tags etc). This way, the db does not have to search for a whole bunch of redundant tags but still would have a link to your current html files which are saved in a separate table that is used only for a layout. Hope this helped, Shanx -- Shashank Tripathi www.shanx.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 _ Charle con sus amigos online usando MSN Messenger: http://messenger.msn.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 - 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
ODBC and TimeStamp
I have a MySQL TimeStamp in my table. If I try to do a query via ODBC, I get an error on the field. Any suggestions? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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: Innodb
Hi Cal, Thanks for the tip. But any reasons as to why 3.23.51-max is preferred to 3.23.49-max-nt? cheers, Ki Mien -Original Message- From: Cal Evans [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 11:34 PM To: Ki Mien [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED], Heikki Tuuri [EMAIL PROTECTED] Subject:RE: Innodb 3.23.51-max if you are using Windows. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Ki Mien [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 10:17 AM To: [EMAIL PROTECTED]; Heikki Tuuri Subject: Innodb Hi all, Can anyone out there tell me which version of mysql is more stable or preffered for using Innodb. I am currently using mysql version 3.23.49-max-nt-log. cheers, Ki Mien Take part in the Penning on Squares Chinese Essay Writing Contest. Submit your masterpieces or vote for your favourite works, and win attractive prizes. Be there or be SQUARE! http://sea.litcontest.lycosasia.com cOntact @ Lycos http://contact.lycosasia.com = 10MB for email and filestore + lots of other goodies... - 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 Take part in the Penning on Squares Chinese Essay Writing Contest. Submit your masterpieces or vote for your favourite works, and win attractive prizes. Be there or be SQUARE! http://sea.litcontest.lycosasia.com cOntact @ Lycos http://contact.lycosasia.com = 10MB for email and filestore + lots of other goodies... - 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-max-nt 4.0.1-alpha shutdown problem
When mysqld-max-nt.exe is started with options --console --standalone and after issuing mysqladmin -u root shutdown mysqld reports a shutdown, but does not exit. mysqld-max don't have this problem. OS Windows 2000. Roman Vorobiev. e-mail: [EMAIL PROTECTED] _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
user
Hello, is possible to create user which will be not able to create other users and will have full access to all existing databases and databases which will be created in future? Thank you. Regards, Michal Dvoracek [EMAIL PROTECTED] mysql,query,sql - 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
Restoring DB
Hello all, Is there any way in mysql to restore the data back after flushing off all the data already present using a single command. I am having backup of the db and i want to restore the data back in the database by flushing off all the data already present. Thanx in advance Regards, Charitha - 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 Poll
MysqlFront is thé best tool for me. http://anse.de/mysqlfront/download.php Works on remote databases to, nice and smooth interface, exporting tables in various formats, export/import from one active db to another ... B. -Original Message- From: Correale, Ernest [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 05:19 To: '[EMAIL PROTECTED]' Subject: RE: MySQL Poll I have been using MySQLAdmin for some time. It has a few oddities about refreshing local data but other than that it's very good. The other tool that I just started working with is MyCC. So far I like that one alot as well. Both are worth looking at. MySQLAdmin is not free but thats of little concern to me since I feel purchasing a product is a good way to show support for the MySQL project. -Original Message- From: Marvin Cummings To: [EMAIL PROTECTED] Sent: 7/14/02 10:17 PM Subject: MySQL Poll If it's ok with the site admin, I'd like to post a poll to see what utilities are being used to administer mysql on w2k. I was dreading having to actually use a command prompt to manage and administer mysql until I found this mysql-front tool, which seems to handle all of those responsibilities. So I guess my question is what tools are being used? Again this is on a w2k server running apache php4. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
