C API hangs on full disk
mysql_query (connection, qbuf); seems to hang if the disk is full. Surely this isn't right. The command line utility reports "disk full" but my poor C program hangs never to return from this call. What's up with that? (FreeBSD/Whatever version of MySQL was current this summer) -- With foxes we must play the fox. - unknown /"\ / http://www.vrx.net \ / ASCII RIBBON CAMPAIGN / http://killifish.vrx.net X AGAINST HTML MAIL/ [EMAIL PROTECTED] +1 (613) 473-1719 / \ AND POSTINGS/ http://www.mbz.org http://www.dnso.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
Help required MySql + PHP
Dear Members, I installed RedHat 7.1, Apache, PHP4 and MySQL in a Intel Pentium processor system. Everything works fine (i.e. MySQL, PHP, etc). But when I want to connect MySQL through PHP. It is giving an error 'call to unknown function "mysql_connect" in line in __' . Can any one provide a solution. Thanks in advance yours Karthikeyan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
does mysql.sock come with a linux 323 installation
I'd like to know if mysql.sock comes with a linux installation as I have follwed the instructions to install linux but it always says ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) . but mysql.sock does not seem to be anywhere on my linux machine thanks david - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: compile errors
HELP!! Can someone PLEASE help me with this issue? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:47 AM To: '[EMAIL PROTECTED]' Subject: FW: compile errors Anyone able to help with this? Or am I just stuck...? -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 6:47 PM To: '[EMAIL PROTECTED]' Subject: compile errors trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqlbinlog hangs
Version 3.23.46-max on a dual Xeon RedHat 7.2 machine with all RedHat patches and their latest -smp kernel. I turned on binary logging on a particular database with binlog-do-db= and later try this: mysqlbinlog -uroot -pxxxyyy binlogfilename-bin.001 It shows me the inserts and deletes that were logged but does not give the prompt back. It hangs and takes a CTRL-C to get back to the prompt. Redirecting output >file does the same thing, requires an interrupt. I kind of need this ability since I'm doing a poor-mans off-site replication this way as sort of a many-master to one slave type setup. I have all the masters save up a bunch of logged queries and once an hour or so mysqlbinlog >file dump them and copy them up to a master web server which imports them via the standard client. The masters are all on DSL with dynamic IPs so it's not really possible to have the "slave" connect to them for proper realtime replication. This is working great with over 30 remote internet-connected servers "replicating" to a master web server. This problem with mysqlbinlog hanging on this version is a show stopper though, I hope someone has an answer or it gets fixed if it's a known bug (at least now it's known). Since I've described this setup, an additional question. I occasionally miss a transaction or two and must manually update the entire databases to make sure everything is in sync. I do a mysqlbinlog >file and immediately do a "flush master" via the client to reset the binary log file. There appears to be a race condition where updates are being done to the database and hence the log file at the time the flush is done and an insert or update or two get lost in the shuffle. Just wondering if anyone is doing anything similar and has any pointers or suggestions. Thanks in advance! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow results with SELECT's that return large numbers of results
Hi, I think indexing the column(s) can help you. But there are certain criteria before you use indexs (like number of duplicate values in the column ..blah blah..) u can find more on this page http://www.linux-mag.com/cgi-bin/printer.pl?issue=2001-06&article=mysql i hope this will help you. Neeraj Chris Withers wrote: >Hi, > >If I have a SELECT that returns a large number of results, say > 1000, then >returns the results for the SELECT takes much over an order of magnitude longer >than if the results set had been, say, 100. > >Now, is there any way I can quickly return the length of the result set withotu >actually returning the result set itself? > >This is part of a searching application, and all a result size of > 1000 means >is that the user needs to refine their search parameters, so penalising them for >it is a problem ;-) > >Any help greatfully appreciated :-) > >Chris > >(MySQL question, obviously ;-) > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >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
(Please Help!!!!) Loading data file with MacRoman CharacterEncoding
Hi, Thanks for your clue. Please provide me with additional details as to how should I go about doing this (making Mysql use MacRoman encoding). 1)About compiling a particular character set with mysql, the manual says: MYSQL MANUAL: shell> ./configure --with-charset=CHARSET CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos, euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr, latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr. MacRoman is not listed here. 2)For using the SET OPTION CHARSET, the manual says... MYSQL MANUAL: CHARACTER SET character_set_name | DEFAULT This maps all strings from and to the client with the given mapping. Currently the only option for character_set_name is cp1251_koi8, but you can easily add new mappings by editing the `sql/convert.cc' file in the MySQL source distribution. The default mapping can be restored by using a character_set_name value of DEFAULT. Note that the syntax for setting the CHARACTER SET option differs from the syntax for setting the other options. Again, I don't know if that is the clue that I should follow and can MacRoman be enabled by that. 3)For using Charset definition files as suggested as the third solution in the manual, please provide me some lead as to how to do that. MYSQL MANUAL: The character sets available depend on the --with-charset=charset and --with-extra-charset= list-of-charset | complex | all options to configure, and the character set configuration files listed in `SHAREDIR/charsets/Index'. I don't know where to start from and how to get the MacRoman Support. Can anybody enlighten me on that?? Thanks in advance, Regards, Kundan Kumar -- Forwarded Message From: Kundan Kumar <[EMAIL PROTECTED]> Date: Tue, 04 Dec 2001 14:14:06 +0800 To: [EMAIL PROTECTED] Subject: Loading data file with MacRoman Character Encoding Hi All, I am running Mysql version 2.23.42 on Mac OS X version 10.1. I need to upload few files in Mysql which are in MacRoman Text Encoding. My default installation does not support the MacRoman Encoding. Currently I need to convert the file into ISO-8859-1 encoding before I can run the LOAD DATA INFILE. I am doing this with a text encoding conversion utility called 'Cyclone'. It is a Cocoa Application with all fancy gui and I can not run it silently from the shell. As I move to deploy my database, I would need to upload the files at a frequency of 5 minutes. Of course, this cyclone trick is not the correct answer, even with AppleScripts. What I need to know is: A) Is there any binary for Mac OS X which supports MacRoman Encoding? Mysql AB recently released binaries for Mac OS X (3.23.45 and 3.23.46), do these versions support that? Any future plans about when it would be in place? B) I have seen in the manuals about adding custom text encoding definitions to MySQL. But I am too non-technical to be able to work on that lead. Can someone point me to helpful documents on that? This is very important for my project as everything depends on whether I can even import the data in my database efficiently or not. Thanks and Regards, Kundan Kumar -- Forwarded Message From: Sinisa Milivojevic <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 5 Dec 2001 16:06:59 +0200 To: [EMAIL PROTECTED] Subject: Re: FW: Loading data file with MacRoman Character Encoding Hi! First : MySQL can take any encoding as long as it is SBCS (char = 1 byte). Second : If you write an email to an individual MySQL developer directly, please make sure that you have put a Cc to appropriate mailing list also. If you have a support contract, please state your support id, support level (type) and expiration date in the beginning of your E-mail and you can mail (or put a Cc) to [EMAIL PROTECTED] If you are looking for free support, please consider mailing to a public MySQL mailing list. You can find all the MySQL related mailing lists from the MySQL manual under chapter '2. MySQL Mailing Lists'. The lists are grouped by different operating systems and different purposes of the lists. http://www.mysql.com/manual.php?section=Questions If you did not receive an answer from a public MySQL mailing list, please verify that you: - E-mailed your question to the right mailing list. - Checked that your question is not covered in the MySQL manual. Search the manual with a couple of keywords at http://www.mysql.com/documentation/mysql/full/ or http://www.mysql.com/documentation/mysql/commented/ (Most of the questions asked in the MySQL mailing lists are covered in the MySQL manual) - Included enough information in your E-mail. Be aware that sometimes other MySQL users don't bother answering an E-mail that doesn't contain all the relevant information, even if they could have helped otherwise. Same thing, if the question is well covered in the MySQL manual and is considered as an FAQ. - Followed the guidelines at http://www.mysql.com/manual.php?se
Connection issue with Kylix to Mysql 3.23
I downloaded and installed the new patch from Borland that allows Kylix to use versions of MySQL 3.23 and newer. Most of the errors on connection stopped and it seems to connect. What I am getting now is a "username/password invalid" error. I have connected with Webmin, MySQL at a prompt and kmysql using the same me and password. I have checked on the web and found several others with the same issue but no answers. I am using Caldera 3.1 with updates and all of the software versions included with that distro. I would appreciate any help. Thanks. Edward J. Valentine, President, ProSoft Plus, Inc. 3 Cherry Park San Antonio, TX 78249 Voice: 210-694-0801 Fax: 210-699-9416 [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: need help
Hi,All: I need your help, When I compile the Msql-Mysql-Modules, I got errors, I am running Redhat7.1 with perl5.6.1, the whole process is just as follows: [root@wappy local]# cd Msql-Mysql-modules-1.2218 [root@wappy Msql-Mysql-modules-1.2218]# perl Makefile.PL Which drivers do you want to install? 1) MySQL only 2) mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2) 4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2 Enter the appropriate number: [3] 1 Do you want to install the MysqlPerl emulation? You might keep your old Mysql module (to be distinguished from DBD::mysql!) if you are concerned about compatibility to existing applications! [n] Where is your MySQL installed? Please tell me the directory that contains the subdir 'include'. [/usr] Which database should I use for testing the MySQL drivers? [test] On which host is database test running (hostname, ip address or host:port) [localhost] User name for connecting to database test? [undef] Password for connecting to database test? [undef] Creating files for MySQL Checking if your kit is complete... Looks good Note (probably harmless): No library found for -lgz Using DBI 1.18 installed in /usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules [root@wappy Msql-Mysql-modules-1.2218]# make /usr/local/bin/pod2text mysql/lib/DBD/mysql.pm >README make[1]: Entering directory `/usr/local/Msql-Mysql-modules-1.2218/mysql' cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm cp lib/Mysql.pm ../blib/lib/Mysql.pm cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/incl ude/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DB I -I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing -D_LARGEFILE_ SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.0418\" -DXS_VERSION=\"2.04 18\" -fpic -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL dbdimp.c dbdimp.c: In function `MysqlReconnect': dbdimp.c:2157: warning: assignment from incompatible pointer type /usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" < /usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI/Driver.xst > mysql.xsi /usr/local/bin/perl -I/usr/local/lib/perl5/5.6.1/i686-linux -I/usr/local/lib /perl5/5.6.1 /usr/local/lib/perl5/5.6.1/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.6.1/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c Warning: duplicate function definition 'rows' detected in mysql.xs, line 407 cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/incl ude/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DB I -I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing -D_LARGEFILE_ SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.0418\" -DXS_VERSION=\"2.04 18\" -fpic -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f ../blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux /2.96" cc -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql -o ../blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lm -l z -L/usr/lib/gcc-lib/i386-redhat-linux/2.96 -lgcc /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/usr/local/Msql-Mysql-modules-1.2218/mysql' make: *** [subdirs] Error 2 [root@wappy Msql-Mysql-modules-1.2218]# Could somebody tell me what's wrong. Thanks a lot. David Niu Dec.5th - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: optimize for SELECTs on multiple large tables
Hi again Florin, - Original Message - From: "Florin Andrei" <[EMAIL PROTECTED]> > SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM > event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid = > tcphdr.cid AND tcphdr.tcp_flags = '2'; Your only search condition is tcphdr.tcp_flags=2. So you will want to put the tcphdr first in the join and have this condition evaluated first (re-order your query and do EXPLAIN SELECT ), otherwise the server will still have to do a full table scan on the first two tables. > The actual table structure is this: > CREATE TABLE event ( sid INT UNSIGNED NOT NULL, > cid INT UNSIGNED NOT NULL, > [...] > PRIMARY KEY (sid,cid), Each of the three tables has this. Now look at your SELECT and the join condition, purely on the field cid. So, MySQL actually has no index to work with. The (sid,cid) can't be used since cid is not the first field; you can use the first part of a key on its own, not the last part (since the last part will have no ordering independently the first part). So, you will want to add an index on cid alone, for the event and iphdr tables (tcphdr table doesn't matter since your select will use the tcp_flags index to limit down the first part of the join, as described above). Making sense? Please post the output from EXPLAIN if the above info does not have the desired effect. Then we can look at exactly what the server is thinking. And of course we also want to hear from you when it's ligning fast! > (it's the typical Snort database, and i don't want to change it, because > many applications related to Snort expect it to be this way) Adding an index shouldn't affect other apps, so that's easy. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ 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: unicode charset support ? (and MacRoman too )
Hi all, I have written to this mailing lists twice before, but nobody seems responds. Please help, this charset problem is very disturbing. In my case I need to import text files with "MacRoman encoding" into mysql. I am working on Mac OS X. How do we get support for this encoding? Regards, Kundan On 11/29/01 9:15 PM, "yilmaz" <[EMAIL PROTECTED]> wrote: > hi mysql guru's, > does anyone put light on the unicode charset support of MYSQL? > i searced everywhere in the archives and the docs , but couldn't find > a related thing.It seems that it doesn't support, however i am > asking you to be sure. > My application needs to save both japanese and chinese charsets, > thus i must use unicode to support both of those charsets. > So far i was using mysql jsut for big5(traditional chinese ) charset, > it was working okey.When i try to save japanese characters i am having > trouble, the characters become garbled.??? > Any one who knows the solution for this. > thanks for helping me. > (note: my mysql version is 3.23, os is win2000) > > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > 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
Slow results with SELECT's that return large numbers of results
Hi, If I have a SELECT that returns a large number of results, say > 1000, then returns the results for the SELECT takes much over an order of magnitude longer than if the results set had been, say, 100. Now, is there any way I can quickly return the length of the result set withotu actually returning the result set itself? This is part of a searching application, and all a result size of > 1000 means is that the user needs to refine their search parameters, so penalising them for it is a problem ;-) Any help greatfully appreciated :-) Chris (MySQL question, obviously ;-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error 1045 - Access denied
Hello, I created the entries by adding them manually to the table (not using GRANT). And yes, I did run FLUSH PRIVILEGES. Anything else I should try doing? The MySQL manual didn't really provide much help. Thanks! Tyler - Original Message - From: "Carsten H. Pedersen" <[EMAIL PROTECTED]> To: "Tyler Longren" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 3:28 PM Subject: RE: Error 1045 - Access denied > > Hello, > > > > I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED] > > (using password: YES)" > > errors. I'm connecting to this MySQL server from a remote site. > > > > I don't see any reason for this. I KNOW that my password is correct. In > > the user table, the "Host" is set to % for the "mysql" user. There's also > > another entry for the "mysql" user and the host on that is set to > > "localhost". Could having 2 of the same usernames have an effect on this? > > I really don't see any reason that I can't connect to this MySQL > > server from > > a remote site. > > How were the entries created? Using GRANT ... or by editing > the user table directly? In the latter case, did you remember > to FLUSH PRIVILEGES? > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.bitbybit.dk/mysqlfaq > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: queries on particular table produce errors
I can't speak for other table formats but in MyIsam tables you can take your database down, rename the table's files (.frm .MYI .MYD), and restart the server. I'd make a backup if you are going to try it, though. Jon Gardiner. > -Original Message- > From: Alex Pukinskis [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 05, 2001 4:16 PM > To: [EMAIL PROTECTED] > Subject: Re: queries on particular table produce errors > > > On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote: > > > At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: > >>> group is a reserved word, use groups as table name > >> > >> That being the case, how do I drop or rename a table > called "group"? > > > > Try: > > > > ALTER TABLE 'group' RENAME new_table_name > > No luck: > > mysql> ALTER TABLE 'group' RENAME groups; > ERROR 1064: You have an error in your SQL syntax near ''group' RENAME > groups' at line 1 > > -Alex > -- > Alex Pukinskis > Internet Consultant > aboutChange > http://aboutchange.com > http://aboutcreative.net > 303-444-0012 > f: 303-444-0015 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
[solved] Re: InnoDB: How to increase table/DB size "after the fact"?
Ah, I finally found mention of this in the manual. Sorry to bother everyone. Thanks. --- Hello, To use InnoDB you have to put how large of a file MySQL is allowed to make by putting an entry in /etc/my.cnf such as the one I used: innodb_data_home_dir = /var/lib/mysql/innodb innodb_data_file_path = indb1:200M;indb2:200M that of course gives us 400M total. I have not yet found in the documentation just what we will need to do when our tables fill up and we need more space. Because of the way the InnoDB tables are created initially I get the impression that you can't increase the size shown in /etc/my.cnf later on. Or am I wrong - do we just increase the MB shown in /etc/my.cnf? Do we add a third files there (Example: innodb_data_file_path = indb1:200M;indb2:200M;indb3:500MB ) ? TIA Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.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: optimize for SELECTs on multiple large tables
Hi Florian, - Original Message - From: "Florin Andrei" <[EMAIL PROTECTED]> > I have this SQL query: > SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \ > tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123'; > (well, maybe there are more than two columns selected, and maybe a > little more than two tables, but you got the idea...) > The tables have 5...10 columns, every column is an integer type, and > they have A LOT of rows (the total amount of space occupied by those > tables on disk is 2 GB). > The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let > it run over night, in the morning i still didn't got any results, so i > killed the query). Well, you have to realise that the server can only use a one index per table (for obvious reasons). So, the first question is, which fields are indexed, and which index does the server use for this query. To find out the latter, as well as find out in which order the server joins the tables, use EXPLAIN with your query. The way you'll want to set up a join (applies to any SQL server) is to limit the number of rows as fast as possible. For instance, if a table has a male/female column, putting an index on that will only cut the number of rows to be searched by half, so there'll still be heaps of rows that need to be checked. In a select join, that might not be very efficient. So, first think about these things, to set up your indexes and the query properly. It IS possible to tweak the server for a particular query, if you find that the optimiser isn't picking the best index. If you use STRAIGHT_JOIN instead of the commas, you can specify the join order. And you can also direct the server to use (or ignore) specific indexes (see manual for details). Those are just a few things. > Splitting the big tables into small ones will not help, because i still > want to be able to run the SELECT across _all_ data (and it's not > convenient for my application). > I cannot modify the structure of the tables (the application requires a > certain table structure). You can actually split a table into multiple identical ones, by using MERGE tables (see manual). But that just makes managing them easier (and inserts into one table faster), it wouldn't speed up your SELECT. > So i wonder if there's any way to optimise MySQL so that i will be able > to actually do a SELECT on those tables. > Maybe tweak parameters like join_buffer_size? table_cache? Anyone has > some experience with these?... What's the best way to optimize MySQL for > running SELECTs on multiple large tables? Yes, server settings are important, and the 'right' settings depend on your system (amount of RAM, etc) as well as on your database and the type of queries that you run most often. There is no magic wand, I'm afraid. But... you may find it advantagious to do a MySQL training course (www.mysql.com/training/). Optimisation is a very important part of the course material, in this message I've just touched briefly on a few little items. > This is the only thing that keeps me from deploying MySQL in production > now. > > (Not to start a flamewar, just to acknowledge a fact: i ran the same SQL > statement, with the same data set, on "some other SQL servers", and i > got the result in 5 minutes, as opposed to MySQL still giving back > nothing after several hours. But i want to use MySQL because i need > something that can do INSERTs very fast, and MySQL is very, very good at > this. The only problem is, it is slow when it comes to SELECTs on > multiple large tables, and i'm not sure how to optimize it for that.) I'm confident that the MySQL server can do it just as fast, if not faster. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ 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: queries on particular table produce errors
Alex Pukinskis writes: > mysql> ALTER TABLE 'group' RENAME groups; > ERROR 1064: You have an error in your SQL syntax near ''group' RENAME > groups' at line 1 It should be ` (backtick) rather than ' (apostrophe/single quote). This is explained i the manual section on table/column names if I'm not completely mistake (could very well be, tho). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select statement group by unusual results
Chip, > > I have a database with 12 tables. I am running a query to select certain > > fields > > from 3 of the tables, like this - > > > > select Title, Details, StartDate, City, State > > from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations > > where phpCalendar_Details.EventLocationID = > phpCalendar_EventLocations.EventLocationID > > group by City; > > > > The problem is the StartDate field data for the first returned row is > carried down through > > all the rows, rather than picking up the correct StartDate data. All the > other data is > > picked up correctly. When I change group by to State or Title or any > field, I get the same > > problem, whatever the first returned field, it is carried down through > all the rows. How do I > > get around this, or what am I doing wrong? > > |From this can we assume (you don't give table schema) that StartDate is in > the |phpCalendar_Daily table and is > |the only field selected from that table? > | > |Take a look at the WHERE clause: the query is using three tables but only > joins two. > | > |Is that it? > |=dn > > I guess I left a bit out. Here's the set up - > 3 tables are phpCalendar_Details (fields are Title, Details), > phpCalendar_Daily (field StartDate) , phpCalendar_EventLocations (fields > are City, State). Two tables (_Details and _EventLocations) > have a common field - EventLocationID, the third table does not have a > field common to those two tables. I suppose I have to have one common to > all 3 to make it work? =you got it - that's why they're called "relational" databases! -otherwise there is no way of working out which row/StartDate from the phpCalendar_Daily table is relevant to the Event being described be the other two tables' data. =Should you be thinking about having an EventID which appears in both the phpCalendar_Details and phpCalendar_Daily tables - or collapsing the StartDate into the phpCalendar_Details table? Either way, it is beginning to sound like a db design/normalisation issue rather than a query-writing problem. =Hope it helps, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: optimize for SELECTs on multiple large tables
Florin Andrei writes: > SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \ > tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123'; > > The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let > it run over night, in the morning i still didn't got any results, so i > killed the query). What're the table structures (most importantly: what indices exist)? What does the data look like? What did EXPLAIN return? Anything else we should know? (that's a catch-all question from a sleepy and intoxicated person, in case you're wondering) //C - scratching his beard -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB: How to increase table/DB size "after the fact"?
Hello, To use InnoDB you have to put how large of a file MySQL is allowed to make by putting an entry in /etc/my.cnf such as the one I used: innodb_data_home_dir = /var/lib/mysql/innodb innodb_data_file_path = indb1:200M;indb2:200M that of course gives us 400M total. I have not yet found in the documentation just what we will need to do when our tables fill up and we need more space. Because of the way the InnoDB tables are created initially I get the impression that you can't increase the size shown in /etc/my.cnf later on. Or am I wrong - do we just increase the MB shown in /etc/my.cnf? Do we add a third fiels there (Example: innodb_data_file_path = indb1:200M;indb2:200M;indb3:500MB ) ? TIA Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.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: optimize for SELECTs on multiple large tables
On Wed, 2001-12-05 at 15:01, Robert Alexander wrote: > At 14:45 -0800 2001/12/05, Florin Andrei wrote: > >The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let > >it run over night, in the morning i still didn't got any results, so i > >killed the query). > > the hardware and OS SGI 1200 (dual PIII/800, 768MB RAM, SCSI) Linux Red Hat 7.2 > the actual query (formatted to be readable, please :> ) SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid = tcphdr.cid AND tcphdr.tcp_flags = '2'; When i ran the query, it just sat there, doing nothing: no disk activity, CPU usage was 0%... As i said, after several hours i had to kill it. This is actually a database for Snort; i'm sniffing a network and recording relevant info about IP packets into the database. The event table contains only the event id (cid) and the timestamp for the IP packet. The iphdr table contains the source- and destination- IP for the packet (identified by cid). The tcphdr table contains TCP-specific info for the packet (identified by cid). I need to extract the source- and destination- IP address for certain packets (TCP with SYN flag set). And maybe ORDER BY iphdr.ip_src, but that's not mandatory. The actual table structure is this: CREATE TABLE event ( sid INT UNSIGNED NOT NULL, cid INT UNSIGNED NOT NULL, signature INT UNSIGNED NOT NULL, timestampDATETIME NOT NULL, PRIMARY KEY (sid,cid), INDEX sig (signature), INDEX time (timestamp)); CREATE TABLE iphdr ( sid INT UNSIGNED NOT NULL, cid INT UNSIGNED NOT NULL, ip_src INT UNSIGNED NOT NULL, ip_dst INT UNSIGNED NOT NULL, ip_ver TINYINT UNSIGNED, ip_hlen TINYINT UNSIGNED, ip_tos TINYINT UNSIGNED, ip_len SMALLINT UNSIGNED, ip_id SMALLINT UNSIGNED, ip_flagsTINYINT UNSIGNED, ip_off SMALLINT UNSIGNED, ip_ttl TINYINT UNSIGNED, ip_protoTINYINT UNSIGNED NOT NULL, ip_csum SMALLINT UNSIGNED, PRIMARY KEY (sid,cid), INDEX ip_src (ip_src), INDEX ip_dst (ip_dst)); CREATE TABLE tcphdr( sid INT UNSIGNED NOT NULL, cid INT UNSIGNED NOT NULL, tcp_sport SMALLINT UNSIGNED NOT NULL, tcp_dport SMALLINT UNSIGNED NOT NULL, tcp_seq INT UNSIGNED, tcp_ack INT UNSIGNED, tcp_off TINYINT UNSIGNED, tcp_res TINYINT UNSIGNED, tcp_flags TINYINT UNSIGNED NOT NULL, tcp_win SMALLINT UNSIGNED, tcp_csumSMALLINT UNSIGNED, tcp_urp SMALLINT UNSIGNED, PRIMARY KEY (sid,cid), INDEX tcp_sport (tcp_sport), INDEX tcp_dport (tcp_dport), INDEX tcp_flags (tcp_flags)); (it's the typical Snort database, and i don't want to change it, because many applications related to Snort expect it to be this way) -- Florin Andrei "Engineering does not require science." - Linus Torvalds - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?
> I don't think it's a version problem because the R PM was mysql-3.23.33-4 and the tarball is mysql-max -3.23.46-pc-linux-gnu-i686.tar.gz. 33 != 46 I'd be surprised if that's not the reason for the problems you're having, especially considering how much has changed since 3.22. //C - points to the section on line length in the netiquette FAQ. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [SLE] Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?
Well, I got around the problem by replacing the old mysql/english directory with a new one from the tarball. I hope that was an o.k. thing to do. At 04:35 PM 12/5/2001 -0600, you wrote: >Using mysql-3.23.33-4 on SuSE Linux 7.1: >root@fluorite:/usr/sbin > uname -a >Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown > >We've been using MySQL for a while and we're trying to test InnoDB. According the >InnoDB page all we need to do is untar the package and overwrite /usr/sbin/mysqld. > >I also found I have to create to following directory/symlink: > >root@fluorite:/usr/bin > ls -l /usr/local/mysql/share/ >total 0 >lrwxrwxrwx1 root root 17 Dec 5 16:05 mysql -> /usr/share/mysql/ > >becauwe without that the new mysqld (mysqld-max) couldn't find >/usr/local/mysql/share/mysql/english/errmsg.sys. > >Now that I have that all set up, I'm getting the following errors: > >root@fluorite:/usr/bin > /usr/sbin/mysqld > >/usr/sbin/mysqld: Fatal error: Error message file >'/usr/local/mysql/share/mysql/english/errmsg.sys' had only 203 error messages, but it >should have at least 218 error messages. >Check that the above file is the right version for this program! > > >I don't think it's a version problem because the RPM was mysql-3.23.33-4 and the >tarball is mysql-max-3.23.46-pc-linux-gnu-i686.tar.gz. > >Can anyone give me some tips on what's wrong? Is there's something wrong with the >SuSE version of mysql-3.23.33-4 that's incompatible with >mysql-max-3.23.46-pc-linux-gnu-i686.tar.gz ? > >TIA > > >Jonathan Wilson >System Administrator > >Cedar Creek Software http://www.cedarcreeksoftware.com >Central Texas IT http://www.centraltexasit.com > > >-- >To unsubscribe send e-mail to [EMAIL PROTECTED] >For additional commands send e-mail to [EMAIL PROTECTED] >Also check the FAQ at http://www.suse.com/support/faq and the >archives at http://lists.suse.com Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.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: queries on particular table produce errors
On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote: > At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: >>> group is a reserved word, use groups as table name >> >> That being the case, how do I drop or rename a table called "group"? > > Try: > > ALTER TABLE 'group' RENAME new_table_name No luck: mysql> ALTER TABLE 'group' RENAME groups; ERROR 1064: You have an error in your SQL syntax near ''group' RENAME groups' at line 1 -Alex -- Alex Pukinskis Internet Consultant aboutChange http://aboutchange.com http://aboutcreative.net 303-444-0012 f: 303-444-0015 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?
Hi! On Dec 05, JW wrote: > Using mysql-3.23.33-4 on SuSE Linux 7.1: > root@fluorite:/usr/sbin > uname -a > Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown > > We've been using MySQL for a while and we're trying to test InnoDB. > According the InnoDB page all we need to do is untar the package and > overwrite /usr/sbin/mysqld. > > I also found I have to create to following directory/symlink: > > root@fluorite:/usr/bin > ls -l /usr/local/mysql/share/ > total 0 > lrwxrwxrwx1 root root 17 Dec 5 16:05 mysql -> /usr/share/mysql/ > > becauwe without that the new mysqld (mysqld-max) couldn't find >/usr/local/mysql/share/mysql/english/errmsg.sys. > > Now that I have that all set up, I'm getting the following errors: > > root@fluorite:/usr/bin > /usr/sbin/mysqld > > /usr/sbin/mysqld: Fatal error: Error message file > '/usr/local/mysql/share/mysql/english/errmsg.sys' had only 203 error > messages, but it should have at least 218 error messages. > Check that the above file is the right version for this program! > > > I don't think it's a version problem because the RPM was > mysql-3.23.33-4 and the tarball is > mysql-max-3.23.46-pc-linux-gnu-i686.tar.gz. It is version problem. > Can anyone give me some tips on what's wrong? Is there's something > wrong with the SuSE version of mysql-3.23.33-4 that's incompatible > with mysql-max-3.23.46-pc-linux-gnu-i686.tar.gz ? Replace /usr/local/mysql/share//errmsg.sys files by those from new rpm. MySQL stores error messages in these files. between 3.23.33 and 3.23.46 some new error messages were added, so new mysqld won't work with old errmsg.sys Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Turn off autocommit
Hi everyone, I'm using InnoDB tables, and I would like to turn the auto commit off. I do SET AUTOCOMMIT=0 in my.ini file. And when I restart the server, it won't start. Does anyone know why? Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 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: queries on particular table produce errors
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: >> group is a reserved word, use groups as table name > >That being the case, how do I drop or rename a table called "group"? Try: ALTER TABLE 'group' RENAME new_table_name HTH, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] "Life's unfair - but root password helps!" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: optimize for SELECTs on multiple large tables
At 14:45 -0800 2001/12/05, Florin Andrei wrote: >The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let >it run over night, in the morning i still didn't got any results, so i >killed the query). Hi Florin, It would help if you could also provide: the hardware and OS the actual query (formatted to be readable, please :> ) There's not really enough info in your posting to hazard a guess on a solution. Regards, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] "Life's unfair - but root password helps!" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select statement group by unusual results
"DL Neil" <[EMAIL PROTECTED]> on 12/05/2001 11:35:46 PM Internet mail from: Please respond to "DL Neil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> cc: Subject: Re: select statement group by unusual results Chip, > I have a database with 12 tables. I am running a query to select certain > fields > from 3 of the tables, like this - > > select Title, Details, StartDate, City, State > from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations > where phpCalendar_Details.EventLocationID = phpCalendar_EventLocations.EventLocationID > group by City; > > The problem is the StartDate field data for the first returned row is carried down through > all the rows, rather than picking up the correct StartDate data. All the other data is > picked up correctly. When I change group by to State or Title or any field, I get the same > problem, whatever the first returned field, it is carried down through all the rows. How do I > get around this, or what am I doing wrong? |From this can we assume (you don't give table schema) that StartDate is in the |phpCalendar_Daily table and is |the only field selected from that table? | |Take a look at the WHERE clause: the query is using three tables but only joins two. | |Is that it? |=dn I guess I left a bit out. Here's the set up - 3 tables are phpCalendar_Details (fields are Title, Details), phpCalendar_Daily (field StartDate) , phpCalendar_EventLocations (fields are City, State). Two tables (_Details and _EventLocations) have a common field - EventLocationID, the third table does not have a field common to those two tables. I suppose I have to have one common to all 3 to make it work? -- Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: queries on particular table produce errors
On Wednesday, December 5, 2001, at 03:44 PM, Philippe Parmentier wrote: > group is a reserved word, use groups as table name That being the case, how do I drop or rename a table called "group"? -Alex -- Alex Pukinskis Internet Consultant aboutChange http://aboutchange.com http://aboutcreative.net 303-444-0012 f: 303-444-0015 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: queries on particular table produce errors
Yes, group is a reserved word (think GROUP BY). See http://www.mysql.com/doc/R/e/Reserved_words.html I believe you can make this work by putting the table name in quotes, e.g. Select * FROM 'group'; but you will probably find it easioer to rename your table. Michael On Wed, 5 Dec 2001, Alex Pukinskis wrote: > Whenever I try to do anything with a specific table in my db, I get an > error. Here's the list of tables: > > mysql> show tables; > ++ > | Tables_in_acv2 | > ++ > | company| > | group | > | internet | > | knowing| > | person | > | personality| > | stress | > | vision | > ++ > 8 rows in set (0.01 sec) > > Some example errors: > > mysql> describe group; > ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 > mysql> select * from group; > ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 > > I don't see any syntax error, though, unless "group" is some kind of > reserved word that I shouldn't use as a table name... I get this error > for _any operation on that table (check, repair, etc. as well). This > doesn't happen for any other tables: > > mysql> describe company; > +---+-+--+-+-+---+ > | Field | Type| Null | Key | Default | Extra | > +---+-+--+-+-+---+ > | ID| int(11) | | | 0 | | > | name | varchar(30) | YES | | NULL| | > +---+-+--+-+-+---+ > 2 rows in set (0.01 sec) > > I'm using mysql-3.23.32 on Mac OS X Server 10.1.1. Thoughts? > > -Alex > > -- > Alex Pukinskis > Internet Consultant > aboutChange > http://aboutchange.com > http://aboutcreative.net > 303-444-0012 > f: 303-444-0015 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: queries on particular table produce errors
group is a reserved word, use groups as table name -Original Message- From: Alex Pukinskis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 11:39 PM To: [EMAIL PROTECTED] Subject: queries on particular table produce errors Whenever I try to do anything with a specific table in my db, I get an error. Here's the list of tables: mysql> show tables; ++ | Tables_in_acv2 | ++ | company| | group | | internet | | knowing| | person | | personality| | stress | | vision | ++ 8 rows in set (0.01 sec) Some example errors: mysql> describe group; ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 mysql> select * from group; ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 I don't see any syntax error, though, unless "group" is some kind of reserved word that I shouldn't use as a table name... I get this error for _any operation on that table (check, repair, etc. as well). This doesn't happen for any other tables: mysql> describe company; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | ID| int(11) | | | 0 | | | name | varchar(30) | YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.01 sec) I'm using mysql-3.23.32 on Mac OS X Server 10.1.1. Thoughts? -Alex -- Alex Pukinskis Internet Consultant aboutChange http://aboutchange.com http://aboutcreative.net 303-444-0012 f: 303-444-0015 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
optimize for SELECTs on multiple large tables
I have this SQL query: SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \ tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123'; (well, maybe there are more than two columns selected, and maybe a little more than two tables, but you got the idea...) The tables have 5...10 columns, every column is an integer type, and they have A LOT of rows (the total amount of space occupied by those tables on disk is 2 GB). The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let it run over night, in the morning i still didn't got any results, so i killed the query). Splitting the big tables into small ones will not help, because i still want to be able to run the SELECT across _all_ data (and it's not convenient for my application). I cannot modify the structure of the tables (the application requires a certain table structure). So i wonder if there's any way to optimise MySQL so that i will be able to actually do a SELECT on those tables. Maybe tweak parameters like join_buffer_size? table_cache? Anyone has some experience with these?... What's the best way to optimize MySQL for running SELECTs on multiple large tables? This is the only thing that keeps me from deploying MySQL in production now. (Not to start a flamewar, just to acknowledge a fact: i ran the same SQL statement, with the same data set, on "some other SQL servers", and i got the result in 5 minutes, as opposed to MySQL still giving back nothing after several hours. But i want to use MySQL because i need something that can do INSERTs very fast, and MySQL is very, very good at this. The only problem is, it is slow when it comes to SELECTs on multiple large tables, and i'm not sure how to optimize it for that.) -- Florin Andrei "Engineering does not require science." - Linus Torvalds - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select statement group by unusual results
Chip, > I have a database with 12 tables. I am running a query to select certain > fields > from 3 of the tables, like this - > > select Title, Details, StartDate, City, State > from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations > where phpCalendar_Details.EventLocationID = >phpCalendar_EventLocations.EventLocationID > group by City; > > The problem is the StartDate field data for the first returned row is carried down >through > all the rows, rather than picking up the correct StartDate data. All the other data >is > picked up correctly. When I change group by to State or Title or any field, I get >the same > problem, whatever the first returned field, it is carried down through all the rows. >How do I > get around this, or what am I doing wrong? >From this can we assume (you don't give table schema) that StartDate is in the >phpCalendar_Daily table and is the only field selected from that table? Take a look at the WHERE clause: the query is using three tables but only joins two. Is that it? =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-extending MySQL tablespace
Hello everyone, I've rewrote our existing our existing software to be compatible both for Oracle 8i and MySQL databases. I wanted to know, does MySQL support auto-extending of it's tablespace? I know how to manually do it, by adding data files, and restarting the server. Also, how could I check to see how much of pre-allocated space has been used. Is it the actual size? I'm using MySQL 3.23.44 max with InnoDB tables. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 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
queries on particular table produce errors
Whenever I try to do anything with a specific table in my db, I get an error. Here's the list of tables: mysql> show tables; ++ | Tables_in_acv2 | ++ | company| | group | | internet | | knowing| | person | | personality| | stress | | vision | ++ 8 rows in set (0.01 sec) Some example errors: mysql> describe group; ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 mysql> select * from group; ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 I don't see any syntax error, though, unless "group" is some kind of reserved word that I shouldn't use as a table name... I get this error for _any operation on that table (check, repair, etc. as well). This doesn't happen for any other tables: mysql> describe company; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | ID| int(11) | | | 0 | | | name | varchar(30) | YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.01 sec) I'm using mysql-3.23.32 on Mac OS X Server 10.1.1. Thoughts? -Alex -- Alex Pukinskis Internet Consultant aboutChange http://aboutchange.com http://aboutcreative.net 303-444-0012 f: 303-444-0015 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.
René,
> I want to select about 25 rows from a table, and sort them by two
> criteria. First, by each row's Series field ("Baby", "Genesis", "Super",
> "Predator", "Millennium" are the various Series, and the order I'd like
> the rows in the array). Within each Series, I'd like the rows sorted by
> their Price field, ascending. For example:
> Baby $5
> Baby $10
> Baby $15
> Genesis $20
> Genesis $35
> Genesis $50
> ...and so on.
> Now, I know how to structure my MySQL Select statment such that the rows
> it pulls from the table will be either sorted by Price OR by Series, but
> not both, in the way I'd like. Does anyone know if it's possibly to do
> this in the Select statement itself? (I'd rather do it that way, than
> resort in PHP.)
> The problem is, if I sort by the price field, the ordering of the series
> gets mixed up (since low-end models in higher-end series cost more than
> some higher-end models in lower-end series (confused?? I am :-) If I
> just sort by series, I don't get the prices in order within each series
> (big problem). And if I sort by BOTH series and price, which is the
> logical thing to do, and which many people have kindly suggested (and
> which I have tried), well, it doesn't work, because the series must be
> sorted in a non-alphabetical way.
>
> I've looked at PHP's myriad sorting functions, and well--maybe I need
> more sun (I live in Canada... winter...)--I can't see a 'simple' way to
> do a non-numerical, non-alphabetical (user-defined?) sort on the Series
> fields, then subsort each series by price.
> can you have another field in your table(s) for a "weighting" and then
> sort on that?
> otherwise you'll have to use php
> You know, in spite of all the good advice I've received, I think that's
> what I'll have to do. I say "have to" because inserting another field
> into the table creates some complications (long story... related to the
> web admin tool I made for editing the tables). Actually, come to think
> of it, there is an existing field that I could reuse for this purpose.
> Yes, that will work!
=Did you manage to solve this? There is a way to accomplish what you want, without
this resorting to an extra
field or PHP (providing the range of values in the Series field is manageable).
SELECT
SERIES
, PRICE
, FIELD( SERIES, "Baby", "Genesis", "Super", "Predator", "Millennium" ) as PRIORITY
FROM TblNm
ORDER BY PRIORITY, PRICE
NB not having access to your db I haven't properly tested this code, nor was I quite
clear from your
example/text about the relative importance of PRIORITY and PRICE in the sequencing, so
please experiment/test.
Regards,
=dn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trouble with InnoDB: Error message file errmsg.sys doesn't have enough messages?
Using mysql-3.23.33-4 on SuSE Linux 7.1: root@fluorite:/usr/sbin > uname -a Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown We've been using MySQL for a while and we're trying to test InnoDB. According the InnoDB page all we need to do is untar the package and overwrite /usr/sbin/mysqld. I also found I have to create to following directory/symlink: root@fluorite:/usr/bin > ls -l /usr/local/mysql/share/ total 0 lrwxrwxrwx1 root root 17 Dec 5 16:05 mysql -> /usr/share/mysql/ becauwe without that the new mysqld (mysqld-max) couldn't find /usr/local/mysql/share/mysql/english/errmsg.sys. Now that I have that all set up, I'm getting the following errors: root@fluorite:/usr/bin > /usr/sbin/mysqld /usr/sbin/mysqld: Fatal error: Error message file '/usr/local/mysql/share/mysql/english/errmsg.sys' had only 203 error messages, but it should have at least 218 error messages. Check that the above file is the right version for this program! I don't think it's a version problem because the RPM was mysql-3.23.33-4 and the tarball is mysql-max-3.23.46-pc-linux-gnu-i686.tar.gz. Can anyone give me some tips on what's wrong? Is there's something wrong with the SuSE version of mysql-3.23.33-4 that's incompatible with mysql-max-3.23.46-pc-linux-gnu-i686.tar.gz ? TIA Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.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
PHP + MySQL problem (strange behavior)
Hello, I'm having trouble determining what's going wrong with a MySQL query that I'm doing from PHP. I have a table with the following columns: id (int) name (varchar 20) starttime (int) duration (int) now, i have a row that has a starttime of 60, when i attempt to do the following update with PHP, it sets it to 0: "UPDATE mytable SET starttime=starttime-30 WHERE name = 'myname'" but when I run it from the MySQL command line, copy/pasted from the code, it sets the value of starttime to 30 as expected. Any thoughts on where this problem originates from? PHP or MySQL? They're pretty commonly used in unison so I'd imagine something like this should work fairly smoothly. I've also posted this to the PHP list in case there's someone there that's encountered this before. Javier Muniz Chief Technology Officer Granicus, LTD. Tel: (415) 522-5216 Fax: (415) 522-5215 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Upgrade MySQL
Hi, - Original Message - From: "Michael Tam" <[EMAIL PROTECTED]> > I am using MySQL 3.23.41 under Win2000. I wonder what is the easiest > way to upgrade the MySQL to 3.23.46 with my existing data and grant table? > >From what I see is that I need to dump the data tables as files, > uninstall the service, uninstall MySQL ( with the my.ini remains in the > system folder). Then install the latest version import the data back and > manually set the grant tables again. > am I write about this?? No. Well, it's always good to make a backup! But you can simply stop the service (no need to uninstall the service or mysql), and run the setup.exe of the new version. Then you can start the service again. It's that easy. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ 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
MYSQL-based commerce packages
I'm looking for a new commerce package, something run of a MySQL database. it's gotta have bulletproof (well, as close as you can get) session management. I wonder what others on the list are using and like? input is appreciated! 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: New binary installation problems.
On Wed, Dec 05, 2001 at 04:28:58PM -0500, David Hudgins wrote: : For some reason the binary install install of mysql on redhat linux is : putting the database files in /var/lib/mysql instead of : /usr/local/mysql/data. The data dir is present and holds mysql and test : databases, but when we populated the data base the new databases where put : into /var/lib/mysql. Will this cause problems? If so how can we change the : default data directory to /usr/local/mysql/data? Any assistance would be : greatly appreciated. Please reply to [EMAIL PROTECTED] Thanks very much. That's just how redhat does things. They're crazy like that. They also have more money than you or I, so they can do what they please. You should have an /etc/my.cnf file. You can edit the location of various files/directories in that file. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
select statement group by unusual results
I have a database with 12 tables. I am running a query to select certain fields from 3 of the tables, like this - select Title, Details, StartDate, City, State from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations where phpCalendar_Details.EventLocationID = phpCalendar_EventLocations.EventLocationID group by City; The problem is the StartDate field data for the first returned row is carried down through all the rows, rather than picking up the correct StartDate data. All the other data is picked up correctly. When I change group by to State or Title or any field, I get the same problem, whatever the first returned field, it is carried down through all the rows. How do I get around this, or what am I doing wrong? Thanks, Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New binary installation problems.
For some reason the binary install install of mysql on redhat linux is putting the database files in /var/lib/mysql instead of /usr/local/mysql/data. The data dir is present and holds mysql and test databases, but when we populated the data base the new databases where put into /var/lib/mysql. Will this cause problems? If so how can we change the default data directory to /usr/local/mysql/data? Any assistance would be greatly appreciated. Please reply to [EMAIL PROTECTED] Thanks very much. David Hudgins Code 935 System Administrator NASA Goddard Space flight center Code 935 Bld 28 Rm 196a Greenbelt MD 20771 [EMAIL PROTECTED]
RE: Error 1045 - Access denied
> Hello, > > I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED] > (using password: YES)" > errors. I'm connecting to this MySQL server from a remote site. > > I don't see any reason for this. I KNOW that my password is correct. In > the user table, the "Host" is set to % for the "mysql" user. There's also > another entry for the "mysql" user and the host on that is set to > "localhost". Could having 2 of the same usernames have an effect on this? > I really don't see any reason that I can't connect to this MySQL > server from > a remote site. How were the entries created? Using GRANT ... or by editing the user table directly? In the latter case, did you remember to FLUSH PRIVILEGES? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How do I get started?
go to http://www.mysql.com Get documentation, such as MYSQL Manual. Read it. No, you do not need MYSQL on your local system, but helps when testing, and learning. MYSQL is available for Unix/Linux and Windows systems. There ae many good books. The "bible" is Paul DuBois book, MYSQL. He often monitors and responds on this email list as well. -Original Message- From: Joe Kaczmarek [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 2:05 PM To: [EMAIL PROTECTED] Subject: How do I get started? I didn't know where else to turn, but I'm wondering the simple (and stupid) question of how do I get started using and learning MySQL. I recently switched to a hosting company that supports MySQL, but what do I need to get started using it and learning it? Does the MySQL only exist on a web host, or do I also have to have it on my machine to access and use it? How do I get started? Joe. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How do I get started?
I didn't know where else to turn, but I'm wondering the simple (and stupid) question of how do I get started using and learning MySQL. I recently switched to a hosting company that supports MySQL, but what do I need to get started using it and learning it? Does the MySQL only exist on a web host, or do I also have to have it on my machine to access and use it? How do I get started? Joe. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1045 - Access denied
Hello, I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED] (using password: YES)" errors. I'm connecting to this MySQL server from a remote site. I don't see any reason for this. I KNOW that my password is correct. In the user table, the "Host" is set to % for the "mysql" user. There's also another entry for the "mysql" user and the host on that is set to "localhost". Could having 2 of the same usernames have an effect on this? I really don't see any reason that I can't connect to this MySQL server from a remote site. Thanks all, Tyler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Dumped OK, Restore NOT
You know, I tried that, it it STILL didn't work. Then, after remembering to reboot my brain, I took a look at the smarts.sql that my ISP kindly dumped for me, to see what code/statements it might be missing--and lo and behold!--it didn't have a USE database; statement! Adding this one wee line made all the difference in the world. Your suggestions(s) work; I can now restore my database locally. Thanks everyone for your help and patience! (And my apologies for posting off-topic oh PHP--I've been suitably chastised, and will remember to name the subject OT: next time I feel tempted to ignore netiquette.) ...Rene On Wednesday, December 5, 2001, at 10:56 AM, Ernesto wrote: > > You should try: > > mysql -u username -p password database < dump.sql > > Example: > > mysql -u joe -p mypass smarts < smarts.sql > > > René Fournier wrote: > >> Little problem with MySQL 3.23.46 under Windows ME. I'm trying to >> create a database from an .sql file (the dumped remains of a >> functioning database--also MySQL). The dumping was easy, but I'm >> having a problem putting it back. I have a dumped file called >> smarts.sql that starts this way: >> - >> # MySQL dump 8.14 >> # >> # Host: localhostDatabase: smarts >> # >> # Server version3.23.38 >> # >> # Table structure for table 'about' >> # >> CREATE TABLE about ( >> id smallint(5) unsigned NOT NULL auto_increment, >> lang char(2) default NULL, >> recordname varchar(40) default NULL, >> key1 tinytext, >> key2 tinytext, >> status varchar(10) default NULL, >> title tinytext, >> par1 tinytext, >> PRIMARY KEY (id) >> ) TYPE=MyISAM; >> # >> # Dumping data for table 'about' >> # >> INSERT INTO about VALUES (1,'en','about' >> ---(and so on) >> This is what I'm doing to try to recreate the database locally: >> 1. I type "mysqladmin create smarts" >> OK--I see a new directory called "smarts" (no files in it) >> 2. I type "mysql smarts < smarts.sql" >> It pauses for a few seconds (seeming to input the file), then returns >> the DOS prompt with no message, error or otherwise. Seems to have >> worked, right? But when I check the 'smarts' database directory, there >> are no files in it. (Incidentally mysqld is running.) >> What am I doing wrong?? >> ...Rene --- René Fournier [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 is causing duplicate keys?
it should read: INSERT INTO recensioni VALUES( NULL,... In order fot auto_increment to work, you must use NULL. When you tried NULL, what SPECIFIC error did you get when it complained? FYI: it complains about the "duplicate key" because you already inserted a record with 300 in the PRIMARY KEY field. When you attempt to insert the next key with 300, that is an error. -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 1:16 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: What is causing duplicate keys? Hello, Always struggling on my php-odbc-MS access project, I managed to successfully add a record to a table. Now, no matter what I write in the first field (random numbers, AUTO, AUTO_INCREMENT...) I get this: Insert Into recensioni VALUES (300, 'riee', 'reworew', 'wer', 2001,'IT', 2.5, 'dond to it, 'rew', 'uno',1, 'Caro', 3, 'stuff', 20011205201040, 'writeurl, 1, '5/12/2001 20.10.40', '1', '1','enter keyword') Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again., SQL state 23000 in SQLExecDirect in C:\domini\mnet\inser_rec.php on line 109 Error in odbc_exec( no cursor returned ) How can I find out what I am duplicating? The first field is the unique key, but what should I send to Access to tell it just auto increment and go? If I put 0 or NULL it complains. Also, Andrew Hill siggested the use of odbc_tables and odbc_columns to get info about the structure of each column which I don't know in detail because the DB was written by the guy who quit, not me) What is the exact syntax of those instructions? I have tried to apply the manual, but without success on the second one. TIA, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] Re: compile problems on Solaris8
George Horvath wrote: > > > > Ok, I followed your advice and removed the soaris built gcc from > > > sunfreeware and downloaded the source instead. How ever now I am > > > getting this message when I try to compile gcc: > > > > > > # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu > > > Configuring for a sparc-sun-solaris2.8 host. > > > Created "Makefile" in /usr/local/objdir using "mh-frag" > > > /usr/ucb/cc: language optional software package not installed > > > *** The command '/usr/ucb/cc -o conftest -g conftest.c' failed. > > > *** You must set the environment variable CC to a working compiler. > > > > > > How do I find out what package am I missing? Can someone point to a > > > site with a good solaris 8 build of gcc I can use instead of > > > sunfreeware. I really prefer not to spend time on debugging the Sun > > > compiler. Unless of course it's just a simple addition of a package. > > > > > > > > > Thanks, > > > George > > > > > > > First, let me acknowledge that a couple of people have reported success > > building mysql with sunfreeware's precompiled gcc 2.95.3 since I wrote > > this. That was news to me, but it would imply that there may be a way to > > install it (precompiled gcc 2.95.3) that causes problems (perhaps it > > expects something else which is missing), or perhaps a set of mysql > > configure options which don't interact well with it. > > > > Second, I'm afraid you've misunderstood me, which probably means I wasn't > > clear. Sorry. /usr/ucb/cc is not a fully functional compiler and cannot > > be used to build software. Many people recommend removing /usr/ucb from > > your PATH for this reason, though I find putting it last, after the > > location of gcc, works just as well. You need a functional c compiler to > > build gcc. The usual procedure is to download and install sunfreeware's > > precompiled gcc 2.95.3, then use it to build gcc 2.95.3 from source. You > > can find directions at http://gcc.gnu.org/install/ > > > > Finally, I want to clarify that I don't claim that sunfreeware's > > precompiled gcc is broken. Many people use it without trouble. > > Personally, I found it quirky. It worked for most things, but didn't > > quite work for a few packages. Once I built and installed gcc from source > > using the binary, these quirks went away. YMMV. > > > > Michael > > I was actually considering doing this (use build to compile source) but I found it >counter intuitive using a reportedly buggy > build to compile a good one, but since now two people have suggested it I gave it a >try and it's compiling as a write this. > Oh..wait..it's finished...Sucsess! Now onto the install > > George Well, it installed fine and I was able compile mysql successfully. It's up and running right now. Thanks to all who helped out. George -- George Horvath Scotia Capital Markets ISS - Technology Application Group Tel: 416-945-4204 Fax: 416-945-4002 E-mail: [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
Blocked Delivery of email from tseekee@pd.jaring.my
BLOCKED DELIVERY OF EMAIL FROM [EMAIL PROTECTED] Our email scanner has detected a file type (or content) which we are not permitting through our systems. These namely include movies, executables and large pictures. Your email has been stopped. The intended sender will receive a notification of this message. This is ONLY a warning. You have not suffered any damage nor received any problem; You can safely ignore this email. You have been protected by the Inflex scanner http://pldaniels.com/inflex The files that were blocked are... MS-DOS executable (EXE), OS/2 or MS Windows End. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is causing duplicate keys?
Hello, Always struggling on my php-odbc-MS access project, I managed to successfully add a record to a table. Now, no matter what I write in the first field (random numbers, AUTO, AUTO_INCREMENT...) I get this: Insert Into recensioni VALUES (300, 'riee', 'reworew', 'wer', 2001,'IT', 2.5, 'dond to it, 'rew', 'uno',1, 'Caro', 3, 'stuff', 20011205201040, 'writeurl, 1, '5/12/2001 20.10.40', '1', '1','enter keyword') Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again., SQL state 23000 in SQLExecDirect in C:\domini\mnet\inser_rec.php on line 109 Error in odbc_exec( no cursor returned ) How can I find out what I am duplicating? The first field is the unique key, but what should I send to Access to tell it just auto increment and go? If I put 0 or NULL it complains. Also, Andrew Hill siggested the use of odbc_tables and odbc_columns to get info about the structure of each column which I don't know in detail because the DB was written by the guy who quit, not me) What is the exact syntax of those instructions? I have tried to apply the manual, but without success on the second one. TIA, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help with Auto Increment
In 3.23 or later: Just specify an ID of 1000 when you insert your first record. If every record thereafter is INSERTed with ID = NULL (or just not specified), then AUTO_INCREMENT will automatically bump up each ID field by one after the first one. If you are loading data from mysqlimport or LOAD DATA, you can insert a fake record with no values *except* ID, and specify ID = 999 . I got this information from "MySQL" by Paul DuBois (p. 93). I had just read that part of the book yesterday. Recommended! -- Erik On Wednesday, December 5, 2001, at 01:16 PM, Mysql List wrote: > Hi, > How do I start an autoincrement field at a certain value, say 1000? > I have a field as: > ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID) > How do I modify it to start at 1000? > > These all generate errors: > modify mytable ID AUTO_INCREMENT = 1000; > modify mytable ID = 1000; > modify mytable ID AUTO_INCREMENT 1000; > > And I can't find an example in the manual. > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Help with Auto Increment
quoted from: http://www.bitbybit.dk/mysqlfaq/faq.html#auto_increment In latter versions of MySQL, you can specify AUTO_INCREMENT=n as a table option. This will tell MySQL to use n for the initial value. Any new rows added will increment the counter by 1, as usual. This value is lost if you delete all rows from the table. In older versions, you need to insert a dummy row in your table, if you wish to ensure that the table increments from a certain value Whichever method you choose, the statment above still holds: do not specify a negative number as a starting value. -Original Message- From: Mysql List [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:17 PM To: mysql Subject: Help with Auto Increment Hi, How do I start an autoincrement field at a certain value, say 1000? I have a field as: ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID) How do I modify it to start at 1000? These all generate errors: modify mytable ID AUTO_INCREMENT = 1000; modify mytable ID = 1000; modify mytable ID AUTO_INCREMENT 1000; And I can't find an example in the manual. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Trying to determine bottleneck
Sun 450 Solaris 7 3 CPU MySQL binary install 50 million record table. Initially tested on dual CPU Intel Linux, now trying on Sun. During index create (via alter), it copies the base file (as documented). It spins the CPU at about 31%, with 7 threads active. There is almost NO iowait (fast fibre channel, spread across 4 external raid 5 sets via veritas). iostat says very low utilization, no wait-for-io, minimal usage, ie: 2MB per second copy. These disks can copy 40 MB per second without breaks a sweat. What is the bottleneck? Is it simply the internal MySQL copy routine? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[OT] Samba (was: User issues in installation. New beginner)
Although Samba is not needed for what you need, I suggest that you install it. I use it to easily share files (without FTP) on my home systems: RH Linux 7.0, Win98 be prepared to tinker around with the samba configuration files, though. -Original Message- From: Faizal Mangera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 11:59 AM To: [EMAIL PROTECTED] Subject: User issues in installation. New beginner Hey people, I've just set-up mysql on a redhat version6.1 of linux. I am new to both. If i log into the machine as root I can run mysql. If I log into the machine as a normal user I can't run mysql. Is it a case of permissions in linux? I need to be able to run mysql through a telnet window on a win98 machine. I have managed to telnet between the two but only as a normal user not as root. Should this be the case? Should I be able to telnet as root. I eventually want MS Access to call the databases on MySQL via ODBC (MyODBC)what configurations will I need to do to the two machines for this to possible? Do I need SAMBA installed? if so how? and why exactly? Any help will be greatly appreciated. Regards, Faizal. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Start-up
Hi I get the following errors on start-up; 011205 12:53:25 mysqld started /usr/local/libexec/mysqld: File './melges-bin.1' not found (Errcode: 13) 011205 12:53:25 Could not use melges-bin for logging (error 13) 011205 12:53:25 /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/melges.itcanada.com.pid' (Errcode: 13) 011205 12:53:25 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 011205 12:53:25 /usr/local/libexec/mysqld: Error on delete of '/usr/local/var/melges.itcanada.com.pid' (Errcode : 13) 011205 12:53:25 mysqld ended How do I resolve my problem? Thanks in advance Bernie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 issues in installation. New beginner
In General Terms: Most default linux installs do not allow root user to telnet in to the machine, this is good as a default. You need to add the user that you do logon as to the MySQL permissions. This can be found in the manual. To access your MySQL db from Access, all you need to do is install the MySQLODBC driver and setup an ODBC source to point the your server. You should enter another User to MySQL for this, and allow only that user from a specific IP address(the machine access is on). You do not need Samba for this. > Hey people, > > I've just set-up mysql on a redhat version6.1 of linux. I am new to both. > If i log into the machine as root I can run mysql. > If I log into the machine as a normal user I can't run mysql. > Is it a case of permissions in linux? > > I need to be able to run mysql through a telnet window on a win98 machine. > I have managed to telnet between the two but only as a normal user not as > root. Should this be the case? Should I be able to telnet as root. > > I eventually want MS Access to call the databases on MySQL via ODBC > (MyODBC)what configurations will I need to do to the two machines for this > to possible? Do I need SAMBA installed? if so how? and why exactly? > > Any help will be greatly appreciated. > > Regards, > > Faizal. > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Help with Auto Increment
Hi, How do I start an autoincrement field at a certain value, say 1000? I have a field as: ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID) How do I modify it to start at 1000? These all generate errors: modify mytable ID AUTO_INCREMENT = 1000; modify mytable ID = 1000; modify mytable ID AUTO_INCREMENT 1000; And I can't find an example in the manual. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 issues in installation. New beginner
Hey people, I've just set-up mysql on a redhat version6.1 of linux. I am new to both. If i log into the machine as root I can run mysql. If I log into the machine as a normal user I can't run mysql. Is it a case of permissions in linux? I need to be able to run mysql through a telnet window on a win98 machine. I have managed to telnet between the two but only as a normal user not as root. Should this be the case? Should I be able to telnet as root. I eventually want MS Access to call the databases on MySQL via ODBC (MyODBC)what configurations will I need to do to the two machines for this to possible? Do I need SAMBA installed? if so how? and why exactly? Any help will be greatly appreciated. Regards, Faizal. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error trying to create InnoDB database. HELP
At 10:08 -0700 2001/12/05, Weaver, Walt wrote: >When I start up mysqld, the datafiles and logfiles are created just fine. >But, when everything is done the following error appears: > >/usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' >doesn't exist This may be an obvious one, Walt, but did you run the mysql_install_db script as part of your installation? This script creates the basic tables MySQL needs. It's in .../scripts/mysql_install_db You also need to edit the my.cnf file. See section "2.3.1 Quick Installation Overview" in the manual. If you've done all this stuff, then you may want to check for proper pathnames and permissions. HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] "Life's unfair - but root password helps!" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error trying to create InnoDB database. HELP
Yup, somehow I must've missed that. Thanks... --Walt -Original Message- From: Mike(mickalo)Blezien [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 10:22 AM To: Weaver, Walt Cc: [EMAIL PROTECTED] Subject: Re: Error trying to create InnoDB database. HELP Did you run the 'mysql_install_db' script after installing MySQL?? the database 'mysql' should be located within the datadir, along with the other databases that are created. >>On Wed, 5 Dec 2001 10:08:38 -0700 , "Weaver, Walt" <[EMAIL PROTECTED]> wrote: >>Okay, I've finally gotten around to trying to create an InnoDB database. >>I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the >>--with-innodb parm. Everything installed wonderfully. >> >>When I start up mysqld, the datafiles and logfiles are created just fine. >>But, when everything is done the following error appears: >> >>/usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' >>doesn't exist >> >>I haven't yet found where the 'mysql.host' table comes from or where it's >>supposed reside. Anyone got any ideas while I work through the documentation >>I have available. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error trying to create InnoDB database. HELP
Did you run the 'mysql_install_db' script after installing MySQL?? the database 'mysql' should be located within the datadir, along with the other databases that are created. >>On Wed, 5 Dec 2001 10:08:38 -0700 , "Weaver, Walt" <[EMAIL PROTECTED]> wrote: >>Okay, I've finally gotten around to trying to create an InnoDB database. >>I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the >>--with-innodb parm. Everything installed wonderfully. >> >>When I start up mysqld, the datafiles and logfiles are created just fine. >>But, when everything is done the following error appears: >> >>/usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' >>doesn't exist >> >>I haven't yet found where the 'mysql.host' table comes from or where it's >>supposed reside. Anyone got any ideas while I work through the documentation >>I have available. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error trying to create InnoDB database. HELP
Dammit, never mind. I figured it out. Maybe someday I'll be able to ask an intelligent question here... --Walt -Original Message- From: Weaver, Walt Sent: Wednesday, December 05, 2001 10:09 AM To: [EMAIL PROTECTED] Subject: Error trying to create InnoDB database. HELP Okay, I've finally gotten around to trying to create an InnoDB database. I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the --with-innodb parm. Everything installed wonderfully. When I start up mysqld, the datafiles and logfiles are created just fine. But, when everything is done the following error appears: /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist I haven't yet found where the 'mysql.host' table comes from or where it's supposed reside. Anyone got any ideas while I work through the documentation I have available. Below is the full log file from the creation, along with the my.cnf file. Thanks, --Walt Weaver Bozeman, Montana Log from database creation: InnoDB: The first specified data file /data/mysql-3.23.44-innodb/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata1 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata2 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata2 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata3 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata3 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata4 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata4 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile0 size to 30 MB InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile1 size to 30 MB InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile2 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile2 size to 30 MB InnoDB: Doublewrite buffer not found: creating new 011205 09:38:36 mysqld ended InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 011205 9:38:36 InnoDB: Started 011205 9:38:36 /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist 011205 9:38:36 /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Normal shutdown 011205 09:38:36 mysqld ended my.cnf file: [client] port = 3306 [mysqld] port = 3306 skip-locking #skip-networking #skip-name-resolve # skip-grant-tables log-update set-variable = key_buffer=200M set-variable = sort_buffer=50M set-variable = record_buffer=25M set-variable = tmp_table_size=16M set-variable = max_allowed_packet=1M pid-file = /var/run/mysqld.pid #InnoDB stuff innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M innodb_data_home_dir = /data/mysql-3.23.44-innodb set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /data/mysql-3.23.44-innodb set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 #.._arch_dir must be the same as .._log_group_home_dir innodb_log_arch_dir = /data/mysql-3.23.44-innodb innodb_log_archive=0 set-variable = innodb_buffer_pool_size=150M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Grátis!! Registe o seu dominio na Internet
REGISTE O SEU DOMÍNIO GRÁTIS Se tem um daqueles endereços complicados do tipo, http://www.endereço.pt/paginas_pessoais/~minha_pagina/index.html, aproveite esta oportunidade para criar um endereço mais simples e fácil de comunicar, do tipo, www.minha_pagina.web.pt, SEM PAGAR NADA. O WEB.PT Free consiste num registo de domínio '.web.pt' ou '.inet.pt' ou 'icom.pt' ou 'kom.pt' ou 'zipbr.com' ou 'zipbr.net' ou 'zipurl.com' ou 'zipurl.net' e posterior redirecionamento para um outro endereço já existente. Normalmente chama-se a este tipo de serviços 'URL FORWARDS' ou 'REENCAMINHAMENTOS DE URL'. Visite o site http://www.web.pt e registe GRATUITAMENTE o seu domínio na Internet ou vá a http://free.web.pt para mais informaçőes. -- Esta mensagem foi-lhe enviada através do serviço Tell-a-Friend. Se năo desejar receber mais mensagens através deste serviço faça reply a esta mensagem colocando no assunto: 'unsubscrive [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: problem with LIKE when I'm using Ukrainian
Andrew Kharchuk writes: > I'm using ukrainian language filling the database. The next problem > occured: when i'm using "LIKE '$text' " at the 'SELECT" SQL statement > with some 2 letters in ukrainian letters in $text, mysql server regard them > as another letter (it make no distinction between them). Have you configured MySQL to use the correct charset? If not, have a look in the manual on how to do that. Oh, and October was 2 months ago. Please set your date to something closer to now. And you could install ntpd or something similar if you don't want to have to set the date and time manually. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error trying to create InnoDB database. HELP
Okay, I've finally gotten around to trying to create an InnoDB database. I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the --with-innodb parm. Everything installed wonderfully. When I start up mysqld, the datafiles and logfiles are created just fine. But, when everything is done the following error appears: /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist I haven't yet found where the 'mysql.host' table comes from or where it's supposed reside. Anyone got any ideas while I work through the documentation I have available. Below is the full log file from the creation, along with the my.cnf file. Thanks, --Walt Weaver Bozeman, Montana Log from database creation: InnoDB: The first specified data file /data/mysql-3.23.44-innodb/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata1 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata2 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata2 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata3 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata3 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata4 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata4 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile0 size to 30 MB InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile1 size to 30 MB InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile2 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile2 size to 30 MB InnoDB: Doublewrite buffer not found: creating new 011205 09:38:36 mysqld ended InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 011205 9:38:36 InnoDB: Started 011205 9:38:36 /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist 011205 9:38:36 /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Normal shutdown 011205 09:38:36 mysqld ended my.cnf file: [client] port = 3306 [mysqld] port = 3306 skip-locking #skip-networking #skip-name-resolve # skip-grant-tables log-update set-variable = key_buffer=200M set-variable = sort_buffer=50M set-variable = record_buffer=25M set-variable = tmp_table_size=16M set-variable = max_allowed_packet=1M pid-file = /var/run/mysqld.pid #InnoDB stuff innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M innodb_data_home_dir = /data/mysql-3.23.44-innodb set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /data/mysql-3.23.44-innodb set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 #.._arch_dir must be the same as .._log_group_home_dir innodb_log_arch_dir = /data/mysql-3.23.44-innodb innodb_log_archive=0 set-variable = innodb_buffer_pool_size=150M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Dumped OK, Restore NOT
> Anyways, if any PHP people here are--god forbid--actually using MySQL as > their database, I would GREATLY appreciate any help in this matter. I've > thoroughly read the mysqldump chapter in the docs, and gone through > several tutorials, but have found nothing on actually restoring a > database from a dumped file--ON Windows. Have you tried something like phpMyAdmin (or something similar, like Mascon)? Cheers Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crash Replication Server
Raffaella, try to compile the latest version 3.23.46 on your system with the gcc -g flag. MySQL AB does not have a ready binary on Tru64, so you have to compile yourself. If it still crashes, run the slave inside gdb and do bt full, so that we see where it crashes. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ >Hello list! > >I have installed MySQL 3.23.39 on Compaq Tru64 UNIX V5.1. I need to run two >servers on the same machine, one as master and another as slave. The >database used is InnoDB, I need to replicate only one database. >I start successfully the master. When I start the slave it go up and down. >The slave log file contains the following message: > >011205 12:25:08 mysqld restarted >011205 12:25:10 InnoDB: Started >/asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/bin/mysqld: ready for >connections >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=8388600 >record_buffer=131072 >sort_buffer=2097144 >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 = 225791 K >bytes of memory >Hope that's ok, if not, decrease some variables in the equation > > >This is the Slave my.cnf: > >[mysqld] >port=3307 >socket=/tmp/mysqld-repl.sock >server-id=2 >master-host=semarmx0031 >master-port=3306 >replicate-do-db=innodb ># You can write your other MySQL server options here ># ... ># >innodb_data_file_path = ibdata1:20M;ibdata2:20M >innodb_data_home_dir = >/asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/replica/innodb > > >This is the Master my.cnf > >[mysqld] >port=3306 >server-id=1 >log-bin=/asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/data/innodb/repl >ication.log >log-bin-index=/asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/data/innod >b/db.index.log >binlog-do-db=innodb ># You can write your other MySQL server options here ># ... ># >innodb_data_file_path = ibdata1:20M;ibdata2:20M >innodb_data_home_dir = >/asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/data/innodb > > >Any comments, suggestions? > Thank you very much in advance. > >Raffaella Graziano > >--- - > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Dumped OK, Restore NOT
That's why I cross-posted there as well. But I've found that posting to the mysql list doesn't help, more often than not--perhaps fewer subscribers. Anyways, if any PHP people here are--god forbid--actually using MySQL as their database, I would GREATLY appreciate any help in this matter. I've thoroughly read the mysqldump chapter in the docs, and gone through several tutorials, but have found nothing on actually restoring a database from a dumped file--ON Windows. On Wednesday, December 5, 2001, at 09:49 AM, Kurt Lieber wrote: > On Wednesday 05 December 2001 08:02 am, you wrote: >> Little problem with MySQL 3.23.46 under Windows ME. I > > This would be an excellent question for the MySQL mailing list. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > --- René Fournier [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: [OT] Re: compile problems on Solaris8
> > Ok, I followed your advice and removed the soaris built gcc from > > sunfreeware and downloaded the source instead. How ever now I am > > getting this message when I try to compile gcc: > > > > # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu > > Configuring for a sparc-sun-solaris2.8 host. > > Created "Makefile" in /usr/local/objdir using "mh-frag" > > /usr/ucb/cc: language optional software package not installed > > *** The command '/usr/ucb/cc -o conftest -g conftest.c' failed. > > *** You must set the environment variable CC to a working compiler. > > > > How do I find out what package am I missing? Can someone point to a > > site with a good solaris 8 build of gcc I can use instead of > > sunfreeware. I really prefer not to spend time on debugging the Sun > > compiler. Unless of course it's just a simple addition of a package. > > > > > > Thanks, > > George > > > > First, let me acknowledge that a couple of people have reported success > building mysql with sunfreeware's precompiled gcc 2.95.3 since I wrote > this. That was news to me, but it would imply that there may be a way to > install it (precompiled gcc 2.95.3) that causes problems (perhaps it > expects something else which is missing), or perhaps a set of mysql > configure options which don't interact well with it. > > Second, I'm afraid you've misunderstood me, which probably means I wasn't > clear. Sorry. /usr/ucb/cc is not a fully functional compiler and cannot > be used to build software. Many people recommend removing /usr/ucb from > your PATH for this reason, though I find putting it last, after the > location of gcc, works just as well. You need a functional c compiler to > build gcc. The usual procedure is to download and install sunfreeware's > precompiled gcc 2.95.3, then use it to build gcc 2.95.3 from source. You > can find directions at http://gcc.gnu.org/install/ > > Finally, I want to clarify that I don't claim that sunfreeware's > precompiled gcc is broken. Many people use it without trouble. > Personally, I found it quirky. It worked for most things, but didn't > quite work for a few packages. Once I built and installed gcc from source > using the binary, these quirks went away. YMMV. > > Michael I was actually considering doing this (use build to compile source) but I found it counter intuitive using a reportedly buggy build to compile a good one, but since now two people have suggested it I gave it a try and it's compiling as a write this. Oh..wait..it's finished...Sucsess! Now onto the install George -- George Horvath Scotia Capital Markets ISS - Technology Application Group Tel: 416-945-4204 Fax: 416-945-4002 E-mail: [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: Load ODBC Data
Hello ! With M$ Query it's achieved just by executing any modification query (insert,update,create etc). Check the permissions for user from who the ODBC connections is performing. Goodbye. Dannis. On Wed, Dec 05, 2001 at 04:46:22PM +0100, TOMASSONI Dominique wrote: > Hello the list, > > Is it possible to import ODBC data into a 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problems compiling under Solaris 2.6
Hmmm, Good thinking. However, the files needed (autoconf) is in /usr/local/bin - which is in my $PATH. a which shows autoconf so I know it can be seen without any problems. There is no ld.conf.so under solaris 2.6. Any more suggestions as I am having big problems with this. Thanks, Matt. -Original Message- From: Alan W. Rateliff, II [mailto:[EMAIL PROTECTED]] Sent: 05 December 2001 15:15 To: Matthew Darcy Subject: Re: Problems compiling under Solaris 2.6 On 05-Dec-01, Matthew Darcy said something totally profound about Problems compiling under Solaris 2.6 that made me ponder... MD> MD> Hi, MD> MD> I am running fully patched Solaris 2.6 on a Sun ultra 2 server. MD> MD> I am running a simple MD> MD> ./configure --enable-thread-safe-client --with-mysqld-user=dba MD> MD> and yes the dba account exists. MD> MD> There is 2 problems with this. MD> MD> 1.) if you examine the output of configure you will notice the it cannot MD> find autoconf - although if you view pkginfo output you will notice that MD> autoconf is present and in the search path. Why is this and how to fix ? Make sure that these packages are in your PATH. MOST SMC packages install in /usr/local, so having /usr/local/bin in your PATH should be sufficient. MD> 2.) if you read the end of the configure output you will notice an error. MD> I am unsure what this error means, and the librarys that it complains MD> COULD be missing are infact installed in the correct place. Make sure that ALL of your library directories are in your LD_LIBRARY_PATH, or listed in /etc/ld.so.conf. I'm not sure it /etc/ld.so.conf exists in Solaris 2.6 or not, as that majority of my work has been in Solaris 8. However, I have had successfull compiles under 2.4, 2.5.1, 2.6, 7, and 8. -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy < [EMAIL PROTECTED] > : Tallahassee, FL 32301 (850) 942-7021--- < [EMAIL PROTECTED] >< http://support.yourvillage.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: help with timestamp...
If you need a timestamp that is automatically updated when a record is inserted, replaced, or updated, declare one field in the record as TIMESTAMP: create table mytable ( myvalue int default 0, mytime TIMESTAMP } INSERT INTO mytable VALUES( 123, NULL ); -Original Message- From: *Himerus* [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:26 AM To: [EMAIL PROTECTED] Subject: help with timestamp... Can anyone give me a good link on how to put in a timestamp on a form that inserts directly into a sql database??? I keep trying it, but it's only coming thru as 00 , so on. Thanks. Newbie Jake. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Dumped OK, Restore NOT
Little problem with MySQL 3.23.46 under Windows ME. I'm trying to create a database from an .sql file (the dumped remains of a functioning database--also MySQL). The dumping was easy, but I'm having a problem putting it back. I have a dumped file called smarts.sql that starts this way: - # MySQL dump 8.14 # # Host: localhostDatabase: smarts # # Server version3.23.38 # # Table structure for table 'about' # CREATE TABLE about ( id smallint(5) unsigned NOT NULL auto_increment, lang char(2) default NULL, recordname varchar(40) default NULL, key1 tinytext, key2 tinytext, status varchar(10) default NULL, title tinytext, par1 tinytext, PRIMARY KEY (id) ) TYPE=MyISAM; # # Dumping data for table 'about' # INSERT INTO about VALUES (1,'en','about' ---(and so on) This is what I'm doing to try to recreate the database locally: 1. I type "mysqladmin create smarts" OK--I see a new directory called "smarts" (no files in it) 2. I type "mysql smarts < smarts.sql" It pauses for a few seconds (seeming to input the file), then returns the DOS prompt with no message, error or otherwise. Seems to have worked, right? But when I check the 'smarts' database directory, there are no files in it. (Incidentally mysqld is running.) What am I doing wrong?? ...Rene --- René Fournier [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: Optimizing date queries
>mysql ... which would prevent index usage. If your kind of query is > frequent and slow, you could split your DATETIME column into two > separate columns for DATE and TIME and put an index onto TIME. Ok, thanks for the help! Regards Emil -- Emil Rasmussen http://noget.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
Load ODBC Data
Hello the list, Is it possible to import ODBC data into a 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
Re: command line question..
Hello ! I often use that common scheme to parametrize my queries. #!/bin/bash #check parameters most commonly (only number of parameters) if [ $# !=NUMBER_OF_PARAMETERS_NEEDED ]; then echo "Too few parameters";exit 1; fi # these are queries in my "transactional" procedure # $1...$N are shell positional parameters and simultaneously are parameters of # quieries QUERY1="SELECT ... $1$2FROM... WHERE $3" QUERY2="INSERT $N." ... QUERYN="..." # now proceed queries /usr/bin/mysql -u USER -p -B database -e "$QUERY1;$QUERY2;;$QUERYN" the quotation marks after -e are required. I hope this help. Goodbye. Dannis. On Wed, Dec 05, 2001 at 09:50:47AM -0500, Gurhan Ozen wrote: > Hello everyone.. > I know that you can write the sql scripts into a text file and redirect it > to the mysql from command line.. Is there any way to add shell/system > commands to automate process? PArticularly, I am looking for a way to echo > files and put them in a blob column. > I am also wondering if there is any way to run system commands and shell > scripts from the mysql> prompt (like we do in most Unix programs by using ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 64bit mysql and gcc
On Wed, Dec 05, 2001 at 05:05:54PM +0200, Michael Widenius wrote: > > Hi! > > > Yes; Our Solaris binaries are currently 32 bit. > > The main reason for this is that I haven't seen any reports that gcc > should be able to produce production quality code on 64 bit sparc. > the sun compiler does, though. i wonder why sun is not supporting you on that. having a 64 bit open source database available easily might help getting those not so cheap sparc servers sold. and they are not selling databases. > If you know of any links or if you have additional information about > this, please email this to me. > > Regards, > Monty > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associé Liafa http://liafa.jussieu.fr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Re: Mac OSX and MySQL
Oh, okay, you want to know how to use NetInfo. Do "man niutil" and read the man pages on niutil. Also very useful, in the following link is a brief description of how to use NetInfo Manager to do the same thing if you prefer GUI: http://developer.apple.com/internet/macosx/osdb.html It tells you how to create a user. Erik PS: don't use System Preferences' "Users" to make dummy users for MySQL and other services. On Wednesday, December 5, 2001, at 10:04 AM, René Fournier wrote: >>> I have to create a MySQL for my PHP scripts. How do I do this in Mac >>> OSX? There are a bunch of command line tools, but I'm not sure which >>> one[s] to use. >> >> Not sure I understand this question. What do you mean by "create a >> MySQL for my PHP?" > > oops, I meant to write "create a MySQL user for my PHP scripts. In > other words, when my scripts try to connect to the database, they need > to supply a user id and password (and that must be certain id/pwd to > correspond with the 'real' online server we're using). So I would like > to know how to create this user/password under Mac OSX. (Thanks.) >> >> >>> Thanks. >>> >>> ...Rene >> >> Hope this helps, >> >> /Rob >> >> ~ >> Robert Alexander, Alpha Geek, Workmate.ca >> WWW Database Applications and Web Hosting >> http://www.workmate.ca 416-823-6599 >> mailto:[EMAIL PROTECTED] >> >> "Life's unfair - but root password helps!" >> >> - >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail > [EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> >> > --- > René Fournier > [EMAIL PROTECTED] > > > -- PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [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
Crash Replication Server
Hello list! I have installed MySQL 3.23.39 on Compaq Tru64 UNIX V5.1. I need to run two servers on the same machine, one as master and another as slave. The database used is InnoDB, I need to replicate only one database. I start successfully the master. When I start the slave it go up and down. The slave log file contains the following message: 011205 12:25:08 mysqld restarted 011205 12:25:10 InnoDB: Started /asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/bin/mysqld: ready for connections 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=8388600 record_buffer=131072 sort_buffer=2097144 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 = 225791 K bytes of memory Hope that's ok, if not, decrease some variables in the equation This is the Slave my.cnf: [mysqld] port=3307 socket=/tmp/mysqld-repl.sock server-id=2 master-host=semarmx0031 master-port=3306 replicate-do-db=innodb # You can write your other MySQL server options here # ... # innodb_data_file_path = ibdata1:20M;ibdata2:20M innodb_data_home_dir = /asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/replica/innodb This is the Master my.cnf [mysqld] port=3306 server-id=1 log-bin=/asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/data/innodb/repl ication.log log-bin-index=/asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/data/innod b/db.index.log binlog-do-db=innodb # You can write your other MySQL server options here # ... # innodb_data_file_path = ibdata1:20M;ibdata2:20M innodb_data_home_dir = /asp/.buttami/mysql-max-3.23.39-dec-osf5.1-alphaev6/data/innodb Any comments, suggestions? Thank you very much in advance. Raffaella Graziano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Mac OSX and MySQL
On Wednesday, December 5, 2001, at 12:24 AM, René Fournier wrote: > > I have to create a MySQL for my PHP scripts. How do I do this in Mac > OSX? There are a bunch of command line tools, but I'm not sure which > one[s] to use. Well, if you already have MySQL installed, then just use them as normal. Just remember that Unix syntax is different from DOS (lets you do more, actually). If you need to install MySQL, try these: http://developer.apple.com/internet/macosx/osdb.html the above link is for Apple's own recommendations for installing MySQL on Darwin. Just make sure that you use the source code for 3.23.45, not 3.43.44 (because the .44 doesn't shut down properly in Darwin). I used this technique (not the binary) and it works great. http://fink.sourceforge.net if you use Fink (debian-style package installer) you can have it install MySQL for you (as well as PHP and Apache) but I didn't go this route because I wanted more control over the install process. http://www.stepwise.com/Articles/Workbench/2001-10-11.01.html the above link isn't for MySQL at all, it's for PHP, but it's a useful article. Remember to add the "--with-mysql" configure option because this tutorial doesn't assume that you want to install MySQL. Any questions, email me. Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Re: FOLLOW UP on "column names not liked by odbc/php/access"
mweb, I suggest you use the ODBC Metadata functions in PHP to describe your database, e.g. odbc_tables, odbc_columns, odbc_primarykeys, odbc_foreignkeys, etc. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: mweb [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 05, 2001 6:44 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP] Re: FOLLOW UP on "column names not liked by > odbc/php/access" > > > On Wednesday 05 December 2001 12:21, Dr. Michael Wittmann wrote: > > > - you dont need apostrophes for numeric fields. you get the table > > definition using sql command 'DESC tablename' > > Thanks to Michael and all the others who pointed out my errors. The query > works now. The real problem however, which is REALLY slowing me down, > is that in this project I have to live with php+odbc+MS access, all on a > remote server. I know the DESC instruction above, but access won't take it > via odbc. It gave me this error: > > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL > statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or > 'UPDATE'., > SQL state 37000 in > SQLExecDirect in C/ etcetera.. > > This is the reason for all my questions in these days: is there really so > little knowledge/documentation on how to handle this particular > combination? > If it were all mysql+apache+php I would perfectly manage > everything by myself. > I have also posted to comp.databases.ms.access without luck so far. > > Again, any pointer to such resources is appreciated. In the > meantime, let me > thank you all once more for your quick and kind suggestions. > > regards, > mweb > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [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: Why can't I get SORT BY to work with FULLTEXT?
> First: please reply to the list, not directly to me.
> Then:
>
> I need a repeatable test case. That is
>
> CREATE TABLE ...
> INSERT INTO ... VALUSE (...),(...)...
> SELECT * FROM ... WHERE ... <= it works
> SELECT * FROM ... WHERE ... ORDER BY ... <= it does not
THIS QUERY WORKS:
SELECT * FROM products WHERE (MATCH
(title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber'))
THIS QUERY DOES NOT WORK -- RETURNS NOTHING:
SELECT * FROM products WHERE (MATCH
(title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber')) order by
item_no
HERE IS A TEST DATABASE:
CREATE TABLE products (
id mediumint(6) default NULL auto_increment,
numOfFileUploads tinyint(2) NOT NULL default '2',
category_id text NOT NULL,
item_no varchar(30) NOT NULL default '
',
title varchar(50) NOT NULL default '
',
short_desc text NOT NULL,
long_desc text NOT NULL,
spec_desc text NOT NULL,
p_weight float(6,2) NOT NULL default '0.00',
p_width float(6,2) NOT NULL default '0.00',
p_height float(6,2) NOT NULL default '0.00',
p_depth float(6,2) NOT NULL default '0.00',
retail_price float(7,2) NOT NULL default '0.00',
wholesale_price float(7,2) NOT NULL default '0.00',
taxable_list text NOT NULL,
special_expiration date NOT NULL default '-00-00',
special_retail_price float(7,2) NOT NULL default '0.00',
special_wholesale_price float(7,2) NOT NULL default '0.00',
quantity_breaks text NOT NULL,
within_category tinyint(1) NOT NULL default '0',
min_order float(7,2) NOT NULL default '0.00',
max_order float(7,2) NOT NULL default '0.00',
inventory mediumint(7) NOT NULL default '0',
inventory_flag_amount smallint(6) NOT NULL default '0',
inventory_allow_order tinyint(1) NOT NULL default '0',
inventory_decrease mediumint(6) NOT NULL default '1',
inventory_comment varchar(100) NOT NULL default '
',
shipping_comment varchar(50) NOT NULL default '
',
PRIMARY KEY (id),
FULLTEXT KEY text_search(item_no,title,short_desc,long_desc,spec_desc)
) TYPE=MyISAM;
INSERT INTO products VALUES (13,1,'::1::5::4::','102a','Scent Clip
2-Pack','From bows to firearms any big game hunting can be enhanced by the
Scent Clip™. Molded in tough polypropylene the Scent Clip is
inexpensive, easy to use, and the special Buna N O-Ring seal prevents leaks.
','Use multiple Scent Clips for cover scents, attractants, or curiosity
scents. Transport them on arrow shafts or bow limbs. When removed, the cap
conveniently fits into the bottom keeping the cap and housing together.
Simply clip it to a limb, corn stalk, etc. to catch the wind more
effectively. Leave the woods without leaving any scent trace behind.
\r\n\r\nVery effective with rut scents!
Patent Pending.\r\n\r\nTwo (2) Scent Clips (1 brown & 1 green) with seals
installed. (1) Little Shiner (reflective tape strip), & unscented cotton
balls. \r\n\r\n-Poly bagged.\r\n-Punched header card. \r\n-UPC
code.','4-3/4" x
6"','0.00','0.00','0.00','0.00','4.99','0.00','::','-00-00','0.00','0.00
','','','0.00','0.00',100,10,1,1,'','');
INSERT INTO products VALUES (11,1,'::3::','101','The Hunters Log ©','Provide
insight into big game movement with the Hunter\'s Log©. Record date and
time, wind direction, temperature, phase of the moon, location, and details
of each hunt. \r\n\r\nThe pocket size Hunter\'s Log is also ideal when
hunting out of state, for sketching maps of landmarks, roads, compass
bearings or making field notes for reference on future hunts.
\r\n\r\nEntries in the Hunter\'s Log will provide a legacy of hunting
experiences for generations to come.\r\n','-Poly bagged\r\n-Punched header
card\r\n-UPC coded.','4-3/4" x
7-1/2"','0.00','0.00','0.00','0.00','2.49','0.00','::','-00-00','0.00','
0.00','','','0.00','0.00',30,10,'',10,'','');
INSERT INTO products VALUES (21,1,'::5::','110','Predator Camo Slip On Camo
Caps set','(1) Green\r\n(1) Fall Gray','long
description','','0.00','0.00','0.00','0.00','7.99','0.00','::','-00-00',
'0.00','0.00','','','0.00','0.00',100,10,'',1,'','boo');
INSERT INTO products VALUES (24,1,'::5::','113','Service/Replacement Rubber
Kit / Std. Rubber parts','short desc','long
desc','','0.00','0.00','0.00','0.00','4.99','0.00','','-00-00','0.00','0
.00','','','0.00','0.00',100,10,'',1,'','');
Can you duplicate my problem?
Thanks!
-Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: 64bit mysql and gcc
> -Original Message- > From: Michael Widenius > Yes; Our Solaris binaries are currently 32 bit. > Hi, > The main reason for this is that I haven't seen any reports that gcc > should be able to produce production quality code on 64 bit sparc. > I've been involved with 64bity stuff here because we were trying to build a 64bit perl - for file handling reasons. > If you know of any links or if you have additional information about > this, please email this to me. I've not heard of any problems but then again I've not been looking - Sorry ! We use the Sun's cc complier - this is the standard complier here on Spark / Solaris. Have you had poblems with 64 bit gcc code ? One thing I've noticed is that few people are doing 64bit work in the Open Source world (well, certainly many perl XS modules are not 64 bit safe). And I64 could hardly be called "stable"! Thanks. Greg > > Regards, > Monty > PFIZER GLOBAL RESEARCH AND DEVELOPMENT This message and any attachment has been virus checked by the PGRD Sandwich Data Centre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OSX and MySQL
>> I have to create a MySQL for my PHP scripts. How do I do this in Mac >> OSX? There are a bunch of command line tools, but I'm not sure which >> one[s] to use. > > Not sure I understand this question. What do you mean by "create a > MySQL for my PHP?" oops, I meant to write "create a MySQL user for my PHP scripts. In other words, when my scripts try to connect to the database, they need to supply a user id and password (and that must be certain id/pwd to correspond with the 'real' online server we're using). So I would like to know how to create this user/password under Mac OSX. (Thanks.) > > >> Thanks. >> >> ...Rene > > Hope this helps, > > /Rob > > ~ > Robert Alexander, Alpha Geek, Workmate.ca > WWW Database Applications and Web Hosting > http://www.workmate.ca 416-823-6599 > mailto:[EMAIL PROTECTED] > > "Life's unfair - but root password helps!" > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --- René Fournier [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
command line question..
Hello everyone.. I know that you can write the sql scripts into a text file and redirect it to the mysql from command line.. Is there any way to add shell/system commands to automate process? PArticularly, I am looking for a way to echo files and put them in a blob column. I am also wondering if there is any way to run system commands and shell scripts from the mysql> prompt (like we do in most Unix programs by using ! . Any comments, suggestions?? If it is not possible to put text files from the command line mysql... what are your suggestions to accomplish the task? Thank you very much in advance. Gurhan Ozen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with LinuxThreads - CHECK TABLE causes crash in mysqld
Hi Konstantin, You don't mention what version of MySQL you are using so I will assume that you are using the most recent. There were many problems with the threads libraries and even some compiler bugs on 4.1 and 4.2. The are resolved by 4.3 and 4.4 (and soon to be 4.5) Is there any chance that you can update your server to one of these newer version. Also if you are running any other services than MySQL you may have security problems on that version. If you really need to get that particular setup going I think you will have to provide the developement team with more information. I also will assume since you build with Linux Threads you are using the latest ports. If you have with makefile you can modify confgiure to add a --with-debug to the MySQL configuration. The run MySQL with gdb and see exactly where it crashes.Also if you want to edit the Makefile you might try and remove --enable-assembler option. I would really suggest upgrading if you are going to use threaded progams. Best of luck. Ken - Original Message - From: "Smirnov Konstantin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 4:24 AM Subject: MySQL with LinuxThreads - CHECK TABLE causes crash in mysqld > Hello list! > > We have a dual-CPU machine with FreeBSD 4.1.1 (well-known problem with > MySQL, eh? ;)) Yesterday, after our server died 4 or 5 times during 8 > hours, I compiled MySQL with LinuxThreads. It works pretty cool now, > but two things annoy me very much: > 1. MySQL dies when I try to CHECK TABLE (output is: "illegal > instruction in mysqld; mysqld ended) > 2. Then, I can't REPAIR TABLE. MySQL dies on it again ;) > > Could anyone help me? > Thanks! > > Best regards, > Konstantin Smirnov, > eHouse, Moscow, Russia > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Optimizing date queries
> > It sounds to me as if you need to change your table design. You want to > search by hours only, > so you should have an hours column in your database. Either you should > break the date up into > DATE and TIME fields I have been thinking on doing that, but there was something about it, that i did not like. I dont know why, it just seems a strange thing to do, when there is a DATETIME datatype. But i might spilt them into a DATE and a TIME field, that is definitely one solution to the problem. Thanks! Regards Emil -- Emil Rasmussen http://sophistic.dk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mailing list
Ken Menzel writes: > Hi Sinisa and Colin, > Sinisa the PR database (Problem/Resolution Database) for freebsd is > a more formal version of > http://www.mysql.com/doc/B/u/Bugs.html . > > In FreeBSD eash problem is assigned a number in a database tracking > who submitted the bug, the date, the priority, and details about the > bug (IE a data damaging bug would get high priority). Also when the > problem is resolved you can see who resolved it and when, and what > the resolution was. > > The FreeBSD database is called GNATS but most people just call it PR. > See > http://www.freebsd.org/support.html#gnats > > Of course FreeBSD is a very large project! I am not suggesting that > this needs to be done. But as the MySQL project grows it might be > good to be aware of alternatives to the web page. Where people can > submit bugs directly to a tracking database. Then one can always go > back and see the status. > > I hope this helps. > > Ken Thanks for the info Ken ! I think that our bugs@ list is quite sufficient for it's purpose and frequency of bugs reported ... ;o) We also report back to the list on whether it was a bug and if it were we send a patch. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: data missing when going into database ( +revious Segmentation error)
On Wednesday 05 December 2001 05:51 am, Ian Moss wrote: > System: Linux proserver 2.2.14 #1 Sat Mar 25 00:45:35 GMT 2000 i686 unknown > Architecture: i686 > > Basically its all a lie that linux is more stable than windoze. > I've run mysql on pc's over the last year with no problems at all. > The amount of problems I've had with it Suse Linux is stupid. First, your problem very likely is that you are using SuSE 6.x which had a "safety" patch that break our binary. Upgrade your system to SuSE 7.2 for best results, or if that is too much hassle and you want a quick fix with an RPM, upgrade the kernel package to 2.2.16 - they cleaned up the safety patch in that version so our binary can run on it. Second, do not get frustrated with Linux. From the comments you have made it sounds like you have not had a lot of Linux experience. Just be patient and gain some. Things do not always work out of the box. The power of Linux is not in plug-and-play works-great-with-defaults - it is in the ability to customize the system to make it do what you want it to. The price to pay for that is that you have to know what you are doing, and this comes after you've invested some time and effort into understanding how things work. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BSDI 4.2 and Mysql
Hi Husri, you are low on memory (as the error says). try this, first remove the file config.cache from the mysql source directory then rerun config and add --with-low-memory to the list of commands: I use a shell scripte with this: rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure $DEBUG --enable-large-files --with-berkeley-db --with-innodb --with-lo w-memory Best of luck. Ken - Original Message - From: "Husri Hassan" <[EMAIL PROTECTED]> To: "Carlos M. Gutierrez" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 2:45 AM Subject: Re: BSDI 4.2 and Mysql > Ok, thanks Carlos M. Gutierrez > I got another error as below: > > mysql\""-DHAVE_CONFIG_H > -I./../include -I./../regex-I. > -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates > -fno-exceptions -fno-rtti -c sql_yacc.cc > sql_yacc.yy:5250: virtual memory exhausted > gmake[3]: *** [sql_yacc.o] Error 1 > gmake[3]: Leaving directory `/var/src/mysql-3.23.46/sql' > gmake[2]: *** [all-recursive] Error 1 > gmake[2]: Leaving directory `/var/src/mysql-3.23.46/sql' > gmake[1]: *** [all-recursive] Error 1 > gmake[1]: Leaving directory `/var/src/mysql-3.23.46' > gmake: *** [all-recursive-am] Error 2 > > -husri > > "Carlos M. Gutierrez" wrote: > > > On Wed, 5 Dec 2001, Husri Hassan wrote: > > > > > Got the below error messages when i run make command: > > > > If I recall correctly, you need to use 'gmake' instead of 'make' on BSDI. > > > > > make: don't know how to make mi_test_all. Stop > > > *** Error code 1 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mailing list
Hi Sinisa and Colin, Sinisa the PR database (Problem/Resolution Database) for freebsd is a more formal version of http://www.mysql.com/doc/B/u/Bugs.html . In FreeBSD eash problem is assigned a number in a database tracking who submitted the bug, the date, the priority, and details about the bug (IE a data damaging bug would get high priority). Also when the problem is resolved you can see who resolved it and when, and what the resolution was. The FreeBSD database is called GNATS but most people just call it PR. See http://www.freebsd.org/support.html#gnats Of course FreeBSD is a very large project! I am not suggesting that this needs to be done. But as the MySQL project grows it might be good to be aware of alternatives to the web page. Where people can submit bugs directly to a tracking database. Then one can always go back and see the status. I hope this helps. Ken - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 8:30 AM Subject: Re: mailing list > Colin Faber writes: > > Hi folks, > > > > I was wondering if anyone has given any thought to doing a questions@ > > list and possibly a PR system much like the freebsd project does? So as > > to lessen the amount of redundant information on this list? > > > > > > ps > > sql, select, database > > Hi! > > For us , the ignorant on freebsd project, can you elucidate in more > detail what would questions@ lists and PR system look like and do > exactly. > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimizing date queries
Emil, You might try to split the time stamp into separate date and time columns. That would allow you to cretae and use an index on time alone. At 14:24 2001-12-05 +0100, Emil Rasmussen wrote: >> >> WHERE myfield LIKE 'HH' >> >> However this query will probably not use your index either :) > >Yeah, it works, but still, it does not use my index as long as it is working >with strings. But neat trick anyway. > >Thanks > >Regards Emil >-- >Emil Rasmussen >http://noget.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 Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.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: 64bit mysql and gcc
Ian writes: > Here is the 2.8 package I just downloaded from one of your mirror sites. > > [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> ls mysqld > mysqld* > [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> file mysqld > mysqld: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, >stripped > > IW. > Thanks for the info. We shall fix it in the future releases. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Optimizing date queries
> WHERE myfield LIKE 'HH' > > However this query will probably not use your index either :) Yeah, it works, but still, it does not use my index as long as it is working with strings. But neat trick anyway. It sounds to me as if you need to change your table design. You want to search by hours only, so you should have an hours column in your database. Either you should break the date up into DATE and TIME fields, or you should break normalisation by having a separate, redundant, hours field. Either way, you can then index by the data you actually want to search by and get a fast response. Which you do, of course, depends upon your updating mechanisms. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: Very large table load/index questions
MySQL - spam bypasser > myisamchk --keys-used=3D0 -rq > You can enable/disable keys from command line in 3.23. While that would disable the key before the load, how do I re-enable them afterwards? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
data missing when going into database ( +revious Segmentation error)
mysql> use protodel; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'access' Didn't find any fields in table 'document' Didn't find any fields in table 'document_access_log' Didn't find any fields in table 'document_product' Didn't find any fields in table 'document_stats' Didn't find any fields in table 'product' Didn't find any fields in table 'product_access_log' Didn't find any fields in table 'product_stats' Didn't find any fields in table 'related_docs' Didn't find any fields in table 'type' Didn't find any fields in table 'user' Database changed it then seems to bomb out. This is following on from a Segmentation Error a couple of days ago. Architecture: Suse Linux >Synopsis: Segmentation error and data loss >Severity: critical >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.43 (Official MySQL binary) >Environment: System: Linux proserver 2.2.14 #1 Sat Mar 25 00:45:35 GMT 2000 i686 unknown Architecture: i686 Basically its all a lie that linux is more stable than windoze. I've run mysql on pc's over the last year with no problems at all. The amount of problems I've had with it Suse Linux is stupid. I'd prefer to recover the situation, but I can't see that happening. If no-one has any ideas how about pointers to the best way to re-install everything. (not really enough info the online docs) I dunno maybe I'm just a thick twonk, who's spent most of his comp time with windoze, and can't cope with anything more simple than pressing the 'next' button. Anyways with a bit of luck someone could shed some on light on things - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A mysql folder or a php build file
Hi, I am looking to export a PHP/MySQL application I have written. As far as the MySQL side goes I am unsure if I should simply send a MySQL folder (copied from the MySQL/Data directory) or a php file that would create all the neccessary MySQL tables the first (and only) time it ran. I can appreciate that some people might be a bit warry of simply droping folders in the Data directory but wasn't it designed to be used like that? Any one have an pro's and con's?? Alex - This mail sent through IMP: webmail.brad.ac.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
