Help in Administration
Hi, Sorry to bother you people but I've just locked myself out of my own DB. I was installing some stupid program which required me to do some changes in the permissions and now I get this error Access Denied for user: 'root@localhost' (Using password: NO). I've tried several ways o get out of this mess, even the documentation of MySQL but there is no mention of this error. So help me out here, people! Schajee __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help in Administration
On 05 August 2001 23:42 -0700 Schajee Achmad wrote, now I get this error Access Denied for user: 'root@localhost' (Using password: NO). I've tried several ways o get out of this mess, even the documentation of MySQL but there is no mention of this error. Run up mysql with the '--skip-grant-tables' option, which will cause the server to come up, and ignore the permissions table, so you should be able to login, fix the problem up, and then _remember_ to re-start the server again without this option, or you'll give full access to everyone... Regards, -Kp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in Administration
On Sun, Aug 05, 2001 at 11:42:53PM -0700, Schajee Achmad wrote: Hi, Sorry to bother you people but I've just locked myself out of my own DB. I was installing some stupid program which required me to do some changes in the permissions and now I get this error Access Denied for user: 'root@localhost' (Using password: NO). I've tried several ways o get out of this mess, even the documentation of MySQL but there is no mention of this error. Check the manual for 'skip-grant-tables' http://www.mysql.com/doc/C/o/Command-line_options.html Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 50 days, processed 420,205,148 queries (95/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libmysqlclient[_r].so + pthreads + gdb
It is gdb-5.0, Mandrake 8 version, with patch for threaded application under new glibc/kernel. On Sunday 05 August 2001 12:54, you wrote: Vladimir Zidar writes: Description: mysql refuses connection [local/unix-socket] when client is ran under GDB, and linked with pthread library. It doesn't need to call any pthread_*() function, it just fails when linked with it. How-To-Repeat: #include stdio.h #include mysql/mysql.h main() { MYSQL m; if(mysql_connect(m, NULL, root, mysqlroot)) { printf(Connect okay\n); mysql_close(m); } else { fprintf(stderr, MYSQL:%d %s\n, mysql_errno(m), mysql_error(m)); } } gcc m2.c -o m2 -D_REENTRANT -lmysqlclient_r gdb ./m2 run This looks most likely like gdb issue. Try the latest gdb snapshot available. -- == Mail : [EMAIL PROTECTED] WWW : http://www.mindnever.org Phone : +381 63 550 161 ICQ : 15414204 == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mirroring of database
Greetings!! I want a solution for mirroring of database on two machines simultaneously. i.e at the same point of time i want to insert/update/delete on two machines having same database. any suggestion/solution to this problem? thanx and regards, Madan Rai
How to upgrade mysql version on linux
hi we are using two different servers for our operation. unfortunately they have installed two different version of mysql. on one server we are using 3.22.32 ( mysqldump 7.1 ) on another server we are using 3.23.23 ( mysqldump 8.8 ) i want to know how to update the two versions to the present latest versions. this is why because i wnat transfer the database to only one server. i tried with mysqldump option,but when i try to install to get inot another server. i is dumping. i think due to version problem. if any one has solution, let me know. Regards and thanks. Bharat Kumar, SurgoSystems (Singapore) Pte Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: perforamnce
Date |Sat, 4 Aug 2001 12:53:15 +0100 From |Tadej Guzej [EMAIL PROTECTED] Hello! TG What is better: TG CREATE INDEX ix1(field1, field2, field3); TG or TG CREATE INDEX ix1(field1), ix2(field2), ix3(field3); TG I have a large table of some 30,000,000 records and am wondering TG which indexing gives better performance and why. TG How do I optimize search on this table - I'm using lots of OR statements in WHERE clause. TG Thanks in advance, Quote: MySQL uses multiple-column indexes in such a way that queries are fast when you specify a known quantity for the first column of the index in a WHERE clause, even if you don't specify values for the other columns. http://www.mysql.com/doc/M/u/Multiple-column_indexes.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
Can't compile .40 on HPUX 11.00 - linker problem with innobase
Hi, I can't *link* MySql on my HP-UX box due a linkage problem: ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/com/libcom.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase /sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/lib ut.a -lrt ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lcrypt -lnsl -lm -lpthread /usr/bin/ld: Data Linkage Table (+z) overflow in file ../innobase/row/librow.a(row0ins.o) - use +Z option to recompile collect2: ld returned 1 exit status *** Error exit code 1 Stop. *** Error exit code 1 Any idea? I configured MySQl with the following lines: export CXX=gcc export CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti -O3 ./configure --with-low-memory --with-berkeley-db --with-innodb --prefix=/opt/mysql --disable-shared gcc version 2.95.2 19991024 (release) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Convert Outlook into MySQL
Hi, Does anybody knows if there is an easy and fast way to convert MS Outlook 2000 contacts database into a MySQL table? It's very important for for to have transferred into MySQL a 256 chars key that is being used from Outlook as the primary key for the contacts. Thanks in advance Sophokles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Convert Outlook into MySQL
Hi, Does anybody knows if there is an easy and fast way to convert MS Outlook 2000 contacts database into a MySQL table? It should be very easy for you to export your Contacts folder to MySQL. Simply choose the 'Import and Export...' menu command and tell Outlook to export to a tab-seperated file. You can then import this file to MySQL using the LOAD DATA INFILE syntax. One thing to watch out for though is that any Outlook fields with line breaks in them will be exported with the contents of just these fields quoted with speech-marks. You will need to add a OPTIONALLY ENCLOSED BY '' parameter to the LOAD DATA command. For example: LOAD DATA LOCAL INFILE 'outlook_contacts.txt' INTO TABLE tbl_name FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\r\n'; Also, if you are looking to automate the process, then I'm sure you can write some VBScript to control the export from Outlook. It's very important for for to have transferred into MySQL a 256 chars key that is being used from Outlook as the primary key for the contacts. I'm not sure what key field in Outlook you're referring to, but as far I can tell, all the fields that are present in the Contacts store are exported to the text file. Regards, Basil Hussain --- Internet Developer, Kodak Weddings 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
Borland MySQL client
Hi there guys, Hope things are well with you, and you are managing to get some holiday this season! We are considering to use your product for our on-line metering applicatons. I don't know whether you can help me, but I haven't been able to compile the Borland Win32 MySQL client - mysql++-1.7.1-win32-borland.zip. I tried to use bcc 5.2 (as instructed), and 5.3 and 5.5. I notice that in the make file supplied, the BIN director referred to is a CBuilder one. I think the bcc used there is 5.3 plus, not 5.2 - thats just for the Borland C++ IDE. Do you use CBuilder functions that are not available in the normal compiler distribution ? Would you have a latest sure-fire way of compiling this code ? Look forward to hearing from you. Cheers now, Nigel Orchard Pilot Systems (London) Ltd 10 Barley Mow Passage Chiswick London W4 4PH +44 (0)20 8762 9845 www.pilotsystems.com
reading error
I experience entries in hostname.err like 010806 11:05:48 Aborted connection 1780 to db: 'pferdezeitung' user: 'pferdezeitung' host: `localhost' (Got an error reading communication packets) The frequency of serious problems has dropped since we changed RAM modules. The ISP tells me that he performed fsck after that which proves to him that there is _no_ hardware problem on the machine. So - what else can be the cause of the error? If I have few of those (reading or writing), the machine still runs, but if I have lots of them in the same second (say 40), mysqld and httpd change to status D in top and load average rises, response times get very bad. They have a cron job checking the bad condition every minute, which will kill and restart http, now every 5 hours or so, so we can live with it somehow. Before they changed RAM (and upgraded from 384 MB to 768), restart frequency was about 30 minutes. Anything I can do or tell my ISP? We run on Intel single CPU 700 MHz, Linux Suse with Kernel 2.2.19, Server Apache/1.3.19 PHP/4.0.4pl1 I told him that Sinisa recommended Kernel 2.4 and they tell me, that all of their machines run with 2.2.19 with no problems. They tell me they have one client with more than 1 million hits per day and a huge MySQL database, who never had problems. I asked about check free space on both datadir and TMPDIR and they say no problem. We run 3.23.33 and they don't dare to change versions because of possible problems. I don't have any experience. I suppose I could unpack and just change executables, but I am reluctant to try. We moved to that ISP 4 weeks ago. Before that, we never had any errors of that kind (reading or writing) AFAICS. We didn't have any problems the first 10 days (or we didn't notice them), then all of a sudden things went crazy. Quite naturally, I looked for programming errors first, but I can't find any and it doesn't look like there are any. We did have those errors right from the start, though, roughly 6.000 per day, more than 60.000 until we had massive problems and I found out about it in hostname.err. Any ideas where I can look at or test? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
whats wrong here?
LOAD DATA LOCAL INFILE '/tmp/phpFBsb3v' REPLACE INTO TABLE agents FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''' LINES TERMINATED BY '\n' (agent_id,first_name,last_name,email_address,area_code,area,have_picture,abo ut) anybody see anything wrong in this ??? I've also tryed '\r' and '\r\n' for line termination. I'm using phpmyadmin 2.2.0rc3 with MySql 3.22.32 Heres a sample of my text file: '9805','JEANNIE','ANDERSON','[EMAIL PROTECTED]',' AR','Arlington',1,'Jeannie AndersonPrudential Network Realty2771-7 Monument Rd.Jackso' '1904','BILL','BACALIS','[EMAIL PROTECTED]','AR','Arl ington',0,'Bill BacalisWhen' '10730','CHERYL','BISTRICKY','[EMAIL PROTECTED]', 'AR','Arlington',0, '1890','JULIA','BLANTON','[EMAIL PROTECTED]','AR','A rlington',0,' Julia Blanton Education Graduate New Hanover High School, Wilmington, NC Community College, Ala' '9311','BOB','DANGOIA','[EMAIL PROTECTED]','AR','Arlin gton',1,'Bob Dangoia, CSP, CSA IIBus' '3516','JOANNE','DOHERTY','[EMAIL PROTECTED]','AR', 'Arlington',1,'JoAnne Doherty, ABR, CRS, GRIFocused on ServiceLicensed Broker' '1945','CONNIE','GLENN','[EMAIL PROTECTED]','AR','Arl ington',0,'Connie Glenn Education BS in History, Ed. - Trevecca Nazarene Univeristy, Nashville, TN Graduate F.C.C.J. - Real Estate Licensing' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with show tables
M Thanks for all the replies - it shows me to look a little harder M next time before I send a question to the mailing list. Thanks, but M ... M I did as it told but it still return an empty set. Here are the M results: M [..skip..] M You can see that I am attached to a database and that tables exist M but 'show tables;' doesn't seem to work. I am sure it is user error M but could you please show me my error. IMHO sounds like a bug. I think you should submit bugreport. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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
Transaction safe tables for Mac OS X
Hi, Are there any transaction safe tables for Mac OS X you can use? Thanks, Willy Faes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Borland MySQL client
Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do. It's ok to do join on table1, table2 and table3 as long as they are limited to 10 records each, as in all of the examples you find on the net. But what about my tables. I have one with 1,14 million and one with 136.000 and a third with 65.000 records. What I want to do is to check for a match between a record from table1 in table2 and from table1 to table3 ex. from table1 to 2: select * from table1 where col1 in (select col2 from table2); If I where to do a join on those tables I would, to my knowledge, end up with a temp table with 1,14 * 136.000 * 65.000 records.. And that's a HUGE table. I'm actually not even going to try it, because I'm pretty sure it won't work. The only solution I seem to find, is to include two new columns in table1, where you give them either TRUE or FALSE based on the info put into table2 and table3. So whenever I do an insert in table2 or 3, I also update corresponding record in Table1 with TRUE in either one of the two columns. - Would this be the 'right' way to do it? :) This way I only have to retrieve the record from table1, check for TRUE value in the two columns, if they are TRUE retrieve record from table2 and from table3. Would be nice to hear from someone who manages good sized databases. Regards Erlend Stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Duplicate entry for SELECT query
Ivan Lulukyan writes: Hi All. Strange thing.The query below: select concat(domain,path,file) as url, title, '' as blank1, docdate, size, date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author, class,charset,lang,'content' as content, count(*) as suma from words as w left join aname_word as aw on w.ID=aw.wordID left join anames as a on a.ID=aw.anameID left join files as f on f.ID=a.fileID left join paths as p on p.ID=f.pathID left join domains as d on d.ID=p.domainID left join file_names as fn on fn.ID=f.file_nameID left join path_names as pn on pn.ID=p.path_nameID left join charsets as c on c.ID=f.charsetID left join classes as l on l.fileID=f.ID left join class_names as ln on ln.ID=l.classID where ((word like 'acc')) group by f.ID having qu0 order by r desc answer me with ERROR 1062 at line 1: Duplicate entry '4783' for key 1 How can it be? Regards, Ivan Lulukyan ACC Armenia Hi! Please CHECK all of the above tables for a corruption. If any of them is corrupted, REPAIR it and try again the above query. If the above errors happens with non-corrupted tables and with our latest binary for your OS, we would like to take a closer look at it. -- 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: Compiling error in complete.c: filename_completion_function
Sebastian Kayser writes: Hi, i get the following error when trying to compile MYSQL 3.23.40 with only the --prefix option set: complete.c: In funtion `filename_completion_function´: complete.c:1467: syntax error before `*´ complete.c:1481: `directory´ undeclared (first use in this function) complete.c:1484: `DIR´ undeclared (first use in this function) but in complete.c these lines are as follows: 1463: filename_completion_function (text,state) 1464: char *text; 1465: int state; 1466: { 1467: static DIR *directory = (DIR *)NULL; . . . 1481: if (directory) It seems as if it doesn't get the DIR type. What's wrong with this ? I've read someone else that this can be because of a missing file libread.a, but this file is located at /usr/lib/libread.a Can someone help ? Thanks, Sebastian Kayser Hi! You have something wrong on your system. Some include files has messed in and changed things. It is also possible that your dirent.h file is missing or is messed. You can either use ready made readline for your system, or use gcc -E and find out which include file messes up. -- 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
Index length too long, but no index specified!
Hi, I cannot find my answer of this problem in the manual. When trying to add the table below to mysql (3.23.36) I get the error that says the index is too long. But how can it complain about a index in this table when no index is defined for this table? Do mysql create a pseudo primary key when no primary key is defined? CREATE TABLE NPGE_RETTEN_TMP ( NP_NR NUMERIC(7,0) NOT NULL, GE_NR NUMERIC(18,0) NOT NULL, ORTSANGABE VARCHAR(100), TELEFON_NR VARCHAR(50), TELEFAX_NR VARCHAR(50), TEL_VORWAHL VARCHAR(20), BUCHTITEL VARCHAR(100), ANREDETITEL VARCHAR(20), BT_SCHLUESSEL VARCHAR(5), BEMERKUNG VARCHAR(100), LOESCHKZ VARCHAR(1), U_VERSION VARCHAR(1) ); Normally, I've got this error when using KEY(x, y, x) where the column length of x, y and z overrides 500 chars. Help, anyone? Regards, Johan Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't compile .40 on HPUX 11.00 - linker problem with innobase
Andre, I have not seen that problem before. Maybe you could try to add export CFLAGS=+Z to your configure lines. Look that it actually compiles InnoDB files with the +Z option, whatever it means. Actually it may be enough to do the configure only in mysql/innobase directory (InnoDB has its own configure script there) and then recompile only the innobase subtree. Regards, Heikki http://www.innodb.com Copied message: Hi, I can't *link* MySql on my HP-UX box due a linkage problem: ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/com/libcom.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/lib ut.a -lrt ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lcrypt -lnsl -lm -lpthread /usr/bin/ld: Data Linkage Table (+z) overflow in file ../innobase/row/librow.a(row0ins.o) - use +Z option to recompile collect2: ld returned 1 exit status*** Error exit code 1Stop. *** Error exit code 1 Any idea? I configured MySQl with the following lines: export CXX=gcc export CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti -O3 ./configure --with-low-memory --with-berkeley-db --with-innodb --prefix=/opt/mysql --disable-shared gcc version 2.95.2 19991024 (release) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: link errors when compiling the client
Caryl Rahn writes: I am getting link error when I try to compile with the mysqlclient library. I tried adding -lgz at the end of my link line as the documentation suggests. It cannot find -lgz What can I do to fix this? Thanks, Caryl Rahn Senior Operations Programmer Siemens Building Technologies, Inc. Security Systems Division (954) 377-5955 It is -lz, not -lgz ... What error message do you get ?? -- 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: (almost) unable to compile with gcc 3.0
[EMAIL PROTECTED] writes: Description: When compiling with gcc-3.0 there are problems with libstdc++, which is not linked to the executables There also seems to be a problem with libwrap, who is complaining about functions being called with wrong number of arguments (this is not a prob with 2.95.4) How-To-Repeat: Compile mysql with gcc 3.0 Fix: set LDFLAGS=-lstdc++ Hi! MySQL must NOT be linked with libstdc++ ! To prevent that export CXX=gcc before running configure on the fresh tarball. -- 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
Need help: workaround for sub-selects?
(sorry for the double-post, but I had wrong subcect on the previous one) Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do. It's ok to do join on table1, table2 and table3 as long as they are limited to 10 records each, as in all of the examples you find on the net. But what about my tables. I have one with 1,14 million and one with 136.000 and a third with 65.000 records. What I want to do is to check for a match between a record from table1 in table2 and from table1 to table3 ex. from table1 to 2: select * from table1 where col1 in (select col2 from table2); If I where to do a join on those tables I would, to my knowledge, end up with a temp table with 1,14 * 136.000 * 65.000 records.. And that's a HUGE table. I'm actually not even going to try it, because I'm pretty sure it won't work. The only solution I seem to find, is to include two new columns in table1, where you give them either TRUE or FALSE based on the info put into table2 and table3. So whenever I do an insert in table2 or 3, I also update corresponding record in Table1 with TRUE in either one of the two columns. - Would this be the 'right' way to do it? :) This way I only have to retrieve the record from table1, check for TRUE value in the two columns, if they are TRUE retrieve record from table2 and from table3. Would be nice to hear from someone who manages good sized databases. Regards Erlend Stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Borland MySQL client
I will forward your mail to the programmer that contributed Borland version. -- 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: libmysqlclient[_r].so + pthreads + gdb
Vladimir Zidar writes: It is gdb-5.0, Mandrake 8 version, with patch for threaded application under new glibc/kernel. That one is not very good for threaded apps. That is why we use gdb from snapshots. -- 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: Index length too long, but no index specified!
I just tried with your definition and it worked fine. Johan Andersson schrieb am Montag, 6. August 2001, 14:03:42: Hi, I cannot find my answer of this problem in the manual. When trying to add the table below to mysql (3.23.36) I get the error that says the index is too long. But how can it complain about a index in this table when no index is defined for this table? Do mysql create a pseudo primary key when no primary key is defined? CREATE TABLE NPGE_RETTEN_TMP ( NP_NR NUMERIC(7,0) NOT NULL, GE_NR NUMERIC(18,0) NOT NULL, ORTSANGABE VARCHAR(100), TELEFON_NR VARCHAR(50), TELEFAX_NR VARCHAR(50), TEL_VORWAHL VARCHAR(20), BUCHTITEL VARCHAR(100), ANREDETITEL VARCHAR(20), BT_SCHLUESSEL VARCHAR(5), BEMERKUNG VARCHAR(100), LOESCHKZ VARCHAR(1), U_VERSION VARCHAR(1) ); Normally, I've got this error when using KEY(x, y, x) where the column length of x, y and z overrides 500 chars. Help, anyone? Regards, Johan Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to Oracle schema conversion utility
Here's a MySQL to Oracle schema conversion utility that I've written. It's rather more functional than the m2o one posted recently. Tim. p.s. I could have implemented the SQL 'create table' parser using Parse::YAPP and the yacc syntax in the mysql source code but I wanted to use this as an excuse to play with Parse::RecDescent. #!/home/value/apps/perl -w =head1 NAME mysql2ora - Convert MySQL schema into Oracle schema (including triggers etc) =head1 SYNOPSIS mysql2ora [-options] mysql_schema.sql oracle_schema.sql =head1 DESCRIPTION Converts MySQL schema into Oracle schema, including emulation of some MySQL features... Handles the emulation of an auto_increment field by defining a sequence and a trigger that uses the sequence to automatically set the auto_increment field. (Has an option to specify the initial value of the sequence.) Handles the emulation of a timestamp field by defining a and a trigger that automatically sets the timestamp field. Automatically detects all Oracle reserved words for both table and field names, and supports multiple methods to deal with them. Automatically detects long names (30) characters and truncates them intelligently to ensure that they remain unique. (It applies the same techniques to the names of automatically generated sequences and triggers.) Automatically generates CHECK clauses for enumerated types (and sets the length of the field to the length of the longest valid value). For SET types it automatically sets the length of the field to the sum of the length of the valid values allowing for a comma delimiter between each. (It doesn't generate a CHECK clause for SET types. That'll be a little task for someone.) For partial-field indices it has some huristics to do reasonable things in some cases. (But typically you'll need to reconsider those for Oracle anyway.) =head2 OPTIONS =over 4 =item B--only Ignore any tables with names that don't match the specified regular expression. =item B--drop Add DROP statements into the generated SQL before each new schema object is created. =item B--autoinc Specify the start value of all generated auto_increment sequences. Defaults to 1. If you are migrating existing data then this should be greater than the highest value in any auto_increment field in your database. =item B--unreserve Specify an sprintf() format string to use to Iunreserve a reserved word. The default is 'C%s', in other words, don't change the name just put double quotes around it to make it acceptable to Oracle. If you use this approach then you'll need to quote all references to the field in your SQL statements. If you run your mysqld in ANSI mode then you can use double quotes for both MySQL and Oracle SQL and thus use the same SQL statements for both. Another common alternative is 'C%s_', which just appends an underscore character to the name. =back =head2 LIMITATIONS The parser has been tested on the output of Cmysqldump -d and not on hand-written SQL. So it's possible that some legal SQL will not parse correctly. Also, it has only been tested on the schemas that I have available to me. It's quite probable that for some less common types it doesn't do the right thing. The parser error handling isn't good. I know that Parse::RecDescent can generate good errors but I don't seem to be using it the right way to get them. =head2 TO DO (by someone) Add optional support for the auto_increment trigger storing the last value into a session global to simplify emulation of last_insert_id. CHECK clause for SET types. Handle embedded quotes etc in default values etc. Query mysql db to set initial start value of auto_increment sequence =head2 AUTHOR Copyright Tim Bunce, 2001. Released under the same terms as Perl. =cut use strict; use Carp; use Parse::RecDescent; use Data::Dumper; use Getopt::Long; use vars qw(%VARIABLE %opt); %opt = ( maxname = 30, # oracle names must be =30 chars d = 0, quiet = 0, autoinc = 1, unreserve = '%s', ); GetOptions(\%opt, 'd!', 'quiet!', 'drop!', 'prefix!', 'only=s', 'unreserve=s', 'autoinc=s', 'maxname=i', ) or die; # Enable warnings within the Parse::RecDescent module. $::RD_ERRORS = 1; # Make sure the parser dies when it encounters an error $::RD_WARN = 1; # Enable warnings. This will warn on unused rules c. $::RD_HINT = 1; # Give out hints to help fix problems. $::RD_TRACE = $opt{d}?90:undef; # Trace behaviour to help fix problems. my $grammar = '_EOGRAMMAR_'; { my @col_defn; my @key_defn; my $schema_obj_name = '(initial)'; } VALUE : /[-+]?\.?\d+(?:[eE]\d+)?/ { $item[1] } | /'.*?'/ # XXX doesn't handle embedded quotes { $item[1] } | /NULL/ { 'NULL' } NAME: ` /\w+/ ` { $item[2] } | /\w+/ { $item[1] } parens_value_list : '(' VALUE(s /,/) ')' { $item[2] } parens_name_list
Re: Borland MySQL client
Erlend Stromsvik writes: Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do. It's ok to do join on table1, table2 and table3 as long as they are limited to 10 records each, as in all of the examples you find on the net. But what about my tables. I have one with 1,14 million and one with 136.000 and a third with 65.000 records. What I want to do is to check for a match between a record from table1 in table2 and from table1 to table3 ex. from table1 to 2: select * from table1 where col1 in (select col2 from table2); cut Would be nice to hear from someone who manages good sized databases. Regards Erlend Stromsvik Regardless of whether you use join's or subselects, the same number of rows has to be reviewed. What you have calculated is a Cartesian product, not join. But not as much as you think. JOIN's require that common columns are defined, which is done in ON or in WHERE clause. Make sure that you have proper indices on those columns and join will be much faster then corresponding sub-select. -- 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: Borland MySQL client
I can't comment on whatever Borland client you're talking about but MySQL supports multiple table joins. It's all in your sql coding. I built a yellow pages directory using MySQL that consists of several tables. One has 500,000 records another has 2,000,000 records, others are smaller having between 3 and 1000 records. Most calls involve joining both the two large tables and three or four of the smaller tables. Fred Steinkopf - Original Message - From: Erlend Stromsvik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 7:45 AM Subject: Re: Borland MySQL client Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do. It's ok to do join on table1, table2 and table3 as long as they are limited to 10 records each, as in all of the examples you find on the net. But what about my tables. I have one with 1,14 million and one with 136.000 and a third with 65.000 records. What I want to do is to check for a match between a record from table1 in table2 and from table1 to table3 ex. from table1 to 2: select * from table1 where col1 in (select col2 from table2); If I where to do a join on those tables I would, to my knowledge, end up with a temp table with 1,14 * 136.000 * 65.000 records.. And that's a HUGE table. I'm actually not even going to try it, because I'm pretty sure it won't work. The only solution I seem to find, is to include two new columns in table1, where you give them either TRUE or FALSE based on the info put into table2 and table3. So whenever I do an insert in table2 or 3, I also update corresponding record in Table1 with TRUE in either one of the two columns. - Would this be the 'right' way to do it? :) This way I only have to retrieve the record from table1, check for TRUE value in the two columns, if they are TRUE retrieve record from table2 and from table3. Would be nice to hear from someone who manages good sized databases. Regards Erlend Stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transaction safe tables for Mac OS X
Willy, people have written quite a lot of compiling MySQL on OS X. It should be possible. Below is an ad of a CD which contains the OS X version. Obviously the producers of the CD have been able to compile. Regards, Heikki http://www.innodb.com Copied message: Hi, Are there any transaction safe tables for Mac OS X you can use? Thanks, Willy Faes OpenBase 1.0 includes full installation and configuration of MySQL 3.23.39, unixODBC 2.0.7, BerkeleyDB and InnoDB for Mac OS X. For MySQL administration, the CD will optionally install and configure Apache Web Server, PHP 4.0.6 and phpMyAdmin 2.2.0rc1. And the CD is only $30. Details at http://www.openosx.com/openbase/index.html. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
test SQL statement? ie Parse but do not execute SQL statement?
Hey all; I'm Trying to parse an SQL statement using the database without actually running it. For example, I have a tool that generates my SQL for me to accommodate changes in schema. I want to be able to test the generated SQL statements by putting pre-defined dummy values in, and sending the statement to the mysqld. I'm asking for some way to tell the mysqld to parse the statement, but not run it -- some kind of NOOP SELECT * FROM ... or NOOP DELETE FROM users WHERE... Is there such a capability now? Allan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-3.23.40 - Compiler errors with Sun WorkShop 6
Description: mysqld.cc will not compile with Sun Workshop 6 CC: Sun WorkShop 6 2000/08/30 C++ 5.1 Patch 109490-01 Failing with the following errors: -- make[3]: Entering directory `/home/unit/cu/dcv/src/local/mysql-3.23.40/sql' CC -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr /local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H - I./../include -I./../regex-I. -I../include -I.. -I. -I/usr/local/include -O3 -DDB UG_OFF -O -DHAVE_CURSES_H -I/home/unit/cu/dcv/src/local/mysql-3.23.40/include -DHAVE_RWLOCK_T -c mysqld.cc item_cmpfunc.h, line 286: Warning (Anachronism): Formal argument 4 of type extern C int(*)(const void*,const void*) i n call to std::qsort(void*, unsigned, unsigned, extern C int(*)(const void*,const void*)) is being passed int(*)(const void*,const void*). log_event.h, line 290: Warning: thd hides Load_log_event::thd. mysqld.cc, line 637: Warning (Anachronism): Formal argument 2 of type extern C void(*)(int) in call to sigset(int, ex tern C void(*)(int)) is being passed void(*)(int). mysqld.cc, line 1215: Warning (Anachronism): Formal argument 2 of type extern C void(*)(int) in call to sigset(int, e xtern C void(*)(int)) is being passed void(*)(int). mysqld.cc, line 1216: Warning (Anachronism): Formal argument 2 of type extern C void(*)(int) in call to sigset(int, e xtern C void(*)(int)) is being passed void(*)(int). mysqld.cc, line 1224: Warning (Anachronism): Assigning void(*)(int) to extern C void(*)(int). mysqld.cc, line 1272: Warning (Anachronism): Formal argument 3 of type extern C void*(*)(void*) in call to pthread_cr eate(unsigned*, const _pthread_attr*, extern C void*(*)(void*), void*) is being passed void*(*)(void*). mysqld.cc, line 1361: Warning (Anachronism): Formal argument 3 of type extern C void*(*)(void*) in call to pthread_cr eate(unsigned*, const _pthread_attr*, extern C void*(*)(void*), void*) is being passed void*(*)(void*). mysqld.cc, line 1484: Error: Cannot use const char* to initialize char*. mysqld.cc, line 1784: Warning (Anachronism): Assigning int(*)(unsigned,const char*,int) to extern C int(*)(unsigned,c onst char*,int). mysqld.cc, line 1846: Warning (Anachronism): Formal argument 3 of type extern C void*(*)(void*) in call to pthread_cr eate(unsigned*, const _pthread_attr*, extern C void*(*)(void*), void*) is being passed void*(*)(void*). mysqld.cc, line 1855: Warning (Anachronism): Formal argument 3 of type extern C void*(*)(void*) in call to pthread_cr eate(unsigned*, const _pthread_attr*, extern C void*(*)(void*), void*) is being passed void*(*)(void*). mysqld.cc, line 2028: Warning (Anachronism): Formal argument 3 of type extern C void*(*)(void*) in call to pthread_cr eate(unsigned*, const _pthread_attr*, extern C void*(*)(void*), void*) is being passed void*(*)(void*). mysqld.cc, line 2122: Warning (Anachronism): Formal argument 3 of type extern C void*(*)(void*) in call to pthread_cr eate(unsigned*, const _pthread_attr*, extern C void*(*)(void*), void*) is being passed void*(*)(void*). 1 Error(s) and 13 Warning(s) detected. make[3]: *** [mysqld.o] Error 1 -- Note the Error, line 1484. The code round here is -- static void open_log(MYSQL_LOG *log, const char *hostname, const char *opt_name, const char *extension, enum_log_type type) { char tmp[FN_REFLEN]; ... // get rid of extention if the log is binary to avoid problems if (type == LOG_BIN) { char* p = strrchr(opt_name, FN_EXTCHAR); if (p) *p = 0; } log-open(opt_name,type); } -- It's trying to modify the buffer pointed to by opt_name, which is declared as `const'. How-To-Repeat: Try to compile it! Fix: Me, I'd take a copy of opt_name into a local buffer first. In fact you seem to have one to hand, though you could fall foul of limited buffer size. A workaround is to remove the `const' from opt_name, but that seems messy (it's typically poking at command line arguments). Submitter-Id: submitter ID Originator: Organization: E-Mail: [EMAIL PROTECTED] PHONE: +44 24 7652 3037 Rob McMahon, IT Services, Warwick University, Coventry, CV4 7AL, England MySQL support: none Synopsis: Modification of const string in mysqld.cc Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.40 (Source distribution) Environment: System: SunOS crocus 5.7 Generic_106541-14 sun4u sparc SUNW,Ultra-Enterprise Architecture: sun4 Some paths: /usr/local/bin/perl
Truncated User List
Hi, Wondering if anyone can here can help, We've got a small selection of MySQL databases used by our customers (for websites). Until now we've used the Debian package of MySQL (latest deb. version), however the systems are being updated we're starting to use source builds, (this is where the problem starts). I have 3.23.39 built installed, we installed the old databases on the new machine by shutting down the sql server duplicating the /var/lib/mysql directory structure. When the users are listed on the new machine however half are missing, I am very confused as I don't seem to be able to make them reappear ! I have looked in the /var/lib/mysql/mysql/user. files can see them /etc/my.cnf is looking in the right place I feel I may have overlooked something, can anyone help ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Borland MySQL client
I'm new to the list,though I've been using MySQL in relatively simple modes for some time now. If you want to join three tables, t1, t2, t3. If you want to select from t1 where t1.c2 has a value in t2.c12 AND where t1.c3 has a value in t3.c13, then first make sure that t1.c2 and t2.c12 have similar types (e.g. both char(10)), then make sure that t1.c3 and t3.c13 have similar types, then create four indexes (one each for t1.c2, t1.c3, t1.c12 and t1.c13). Then the query should be something like SELECT t1.* FROM t1,t2,t3 WHERE t1.c1 = t2.c12 AND t1.c3 = t3.c13; You should also read up as much as you can on EXPLAIN, and you should use EXPLAIN on any SELECT that might end up being really big. HTH, Lezz Giles Frederick L. Steinkopf wrote: I can't comment on whatever Borland client you're talking about but MySQL supports multiple table joins. It's all in your sql coding. I built a yellow pages directory using MySQL that consists of several tables. One has 500,000 records another has 2,000,000 records, others are smaller having between 3 and 1000 records. Most calls involve joining both the two large tables and three or four of the smaller tables. Fred Steinkopf - Original Message - From: Erlend Stromsvik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 7:45 AM Subject: Re: Borland MySQL client Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do. It's ok to do join on table1, table2 and table3 as long as they are limited to 10 records each, as in all of the examples you find on the net. But what about my tables. I have one with 1,14 million and one with 136.000 and a third with 65.000 records. What I want to do is to check for a match between a record from table1 in table2 and from table1 to table3 ex. from table1 to 2: select * from table1 where col1 in (select col2 from table2); If I where to do a join on those tables I would, to my knowledge, end up with a temp table with 1,14 * 136.000 * 65.000 records.. And that's a HUGE table. I'm actually not even going to try it, because I'm pretty sure it won't work. The only solution I seem to find, is to include two new columns in table1, where you give them either TRUE or FALSE based on the info put into table2 and table3. So whenever I do an insert in table2 or 3, I also update corresponding record in Table1 with TRUE in either one of the two columns. - Would this be the 'right' way to do it? :) This way I only have to retrieve the record from table1, check for TRUE value in the two columns, if they are TRUE retrieve record from table2 and from table3. Would be nice to hear from someone who manages good sized databases. Regards Erlend Stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Leslie Giles Software Release Manager Avici Systems Inc [EMAIL PROTECTED] Phone: 978.964.2030 Fax: 978.964.2100 Do not fear the merge - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 DATA INFILE performance testing
I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( value CHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique values time in seconds 10 0.05 100 0.05 1K 0.10 10K 0.75 100K 10 500K 125 1M 500 5M 55000 My concern is the last entry of 5 million entries. Is there a mysql system variable I should reset to improve performance? Thanks Jeff Tanner Viathan Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Slow Query
Hi there, I have a query that is taking 19 - 23 sec's to complete, it used to take 5 sec or less to complete, the only thing we have added are a new database unrelated to this on. The system is a Sun Ultra 10s running Solaris 2.7 with 256mb and 333mhz processor. Mysql version is 3.22.27. Any Idea's, suggestions would be helpful. Here is the query in question: SELECT mlsnumber,streetnumber,streetdirect,FORMAT(currentprice,0), streetnam,unitnumber,municname,state,zipcd,salesassoc, listagentname,FORMAT(numrooms,0),FORMAT(numbedrooms,0),fullbaths FROM custmls where listingoffice = 0251 AND (listingstatus = 'ACT' or listingstatus = 'A*') AND scategory = 1 order by currentprice asc Here is the Explain for the query: +-+---+---+--+-+--+---+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+--+-+--+---+---+ | custmls | range | key1 | key1 |NULL | NULL | 20737 | | +-+---+---+--+-+--+---+---+ 1 row in set (0.02 sec) Also here is the indexes for the table: mysql show index from custmls; +-++---+--+---+---+- --+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |Cardinality |sub_part | +-++---+--+---+---+- ---+--+ | custmls | 0 | PRIMARY | 1 | mlsnumber | A | 85045 | NULL | | custmls | 1 | agentcode | 1 | salesassoc| A | NULL | NULL | | custmls | 1 | key1 | 1 | listingstatus | A | NULL | NULL | | custmls | 1 | keyprice | 1 | currentprice | A | NULL | NULL | +-++---+--+---+---+- ---+--+ 4 rows in set (0.02 sec) Here is the variables for the system: mysql show variables; ++-+ | Variable_name | Value | ++-+ | back_log | 5 | | connect_timeout| 5 | | basedir| /export/home/usr/mysql/ | | datadir| /export/home/usr/mysql/var/ | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000| | join_buffer| 131072 | | flush_time | 0 | | key_buffer | 33550336| | language | /export/home/usr/mysql/share/mysql/english/ | | log| OFF | | log_update | OFF | | long_query_time| 10 | | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections| 100 | | max_connect_errors | 10 | | max_delayed_insert_threads | 20 | | max_join_size | 4294967295 | | max_sort_length| 1024| | net_buffer_length | 16384 | | pid_file | /export/home/usr/mysql/var/mail.pid | | port | 3306| | protocol_version | 10 | | record_buffer | 1044480 | | skip_locking | OFF | | skip_networking| OFF | | socket | /tmp/mysql.sock | | sort_buffer| 4194296 | | table_cache| 512 | | thread_stack | 65536 | | tmp_table_size | 1048576 | | tmpdir | /var/tmp/ | | version| 3.22.27
Win32 SSH connection to Linux MySql db
All, I have read everywhere of people getting this to work in loads of newsgroups, but I can't seem to find the actuall answer! I have downloaded ssh32 and SecureCRT, both apparently can do the job. I have a RedHat 6.2 install and want to talk to MySql (latest version) over MyODBC using SSH Can someone please post the answer here?
Search results are differant on console and in webmin
I sometimes access mysql through webmin and sometimes via the console (using telnet from a remote machine). I have a table of users (name,password,login) and when I view it on the console I see a few fields appear to be missing a few characters. When I view it via webmin those same fields show all their characters. Any idea what the problem could be? (Or is it actually a problem?) Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:
hi, is it possible to use queris of SQL at MySql? dikla sharvit fls-dba 65513, 65486 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mass data load
Not very familiar with the features of MySQL regarding data loading. Does MySQL has some tool like SQL*Loader in Oracle? Can I use some control file to help load a bunch of data in a mass mode from some text input file into MySQL database? Any ideas or pointers to on-line help resouce are greatly appreciated. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 DATA INFILE performance testing
Jeff Tanner writes: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 125 1M 500 5M 55000 My concern is the last entry of 5 million entries. Is there a mysql system variable I should reset to improve performance? Thanks Jeff Tanner Viathan Seattle, WA No, but you could crate a table without index and add primary key after loading of data. -- 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
installation
Hi, I installed the mysql-3.22.26a version on my linux machine and executed the following commands Untar it and change into the source directory tree: tar -xvzf mysql-3.22.26a.tar.gz cd mysql-3.22.26a Configure the package; I used following options: ./configure --prefix=/opt/mysql Build it: make Install it; as root: make install You'll then need to configure the installation: As root, create the grant tables: scripts/mysql_install_db As root, start the server: /opt/mysql/bin/safe_mysqld As root, create the mysql user: useradd -c MySQL Administrator -d /opt/mysql -g users mysql As root, give the installation tree to the mysql user: chown -R mysql.users /opt/mysql Now when i execute the mysqladmin version command it says can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'.The MySQL server is running but there is no /mysql/mysql.sock so what do i need to do now.Thank you. -venkat __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow and fast query problem
Hi (I hope I'm not asking to many 'stupid' questions... :) This query runs very fast (time 0.01 seconds): SELECT * from DB_GNIST.varer WHERE kategori = 24010 ORDER BY utgivelses_aar DESC LIMIT 10; This one is slow (time 0.73seconds): SELECT * from DB_GNIST.varer WHERE kategori = '24010' ORDER BY utgivelses_aar DESC LIMIT 10; Fast (0.49 seconds): SELECT count(*) from DB_GNIST.varer WHERE kategori = '24010' ODER BY utgivelses_aar DESC LIMIT 10; slow (10.47seconds): SELECT count(*) from DB_GNIST.varer WHERE kategori = 24010 ODER BY utgivelses_aar DESC LIMIT 10; Fast (0.83) SELECT * from DB_GNIST.varer a LEFT JOIN DB_GNIST.vare_bilder b ON a.isbn = b.isbn WHERE kategori = '24010' ODER BY utgivelses_aar DESC LIMIT 10; Slow (10.30) SELECT * from DB_GNIST.varer a LEFT JOIN DB_GNIST.vare_bilder b ON a.isbn = b.isbn WHERE kategori = 24010 ODER BY utgivelses_aar DESC LIMIT 10; I can't seem to find the any documentation about how col = 'something' is handled by mysql and how col = something is handled. They are obviously handled in different ways. If you look at the two first queries, the fast one is 73 times faster than the slow one. That's a huge difference. On the last two queries the one with kategori = 24010 will return a few more records than the first one. But if I replace = with LIKE both queries returns the same number of records, but the first one will still be much faster. Anyway, if I have missed something in the manual, please just tell me and I'll go back reading it. Erlend Stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 DATA INFILE performance testing
DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 125 1M 500 5M 55000 My concern is the last entry of 5 million entries. Is there a mysql system variable I should reset to improve performance? Thanks Jeff Tanner Viathan Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD DATA INFILE performance testing
Thanks Tim for your reply But I am unfamiliar with DELAY_KEY_WRITE. I looked at both Tuning Server Parameters and LOAD DATA INFILE sections. Jeff Tanner Viathan Seattle, WA -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:00 AM To: Jeff Tanner Cc: '[EMAIL PROTECTED]' Subject: Re: LOAD DATA INFILE performance testing DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 125 1M 500 5M 55000 My concern is the last entry of 5 million entries. Is there a mysql system variable I should reset to improve performance? Thanks Jeff Tanner Viathan Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD DATA INFILE performance testing
Thanks Sinisa for your reply, Interesting alterative. I tried: a) ALTER TABLE foo DROP PRIMARY KEY b) LOAD DATA INFILE file INTO TABLE foo c) ALTER TABLE foo ADD PRIMARY KEY (value) However, there was no noticable improvement in performance. Even though loading the file into a table sans primary key was very much faster, but adding back the primary key negated any performance improvement than if just loading the file into a table with a primary key. Jeff Tanner Viathan Seattle, WA -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 8:33 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: LOAD DATA INFILE performance testing Jeff Tanner writes: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 125 1M 500 5M 55000 My concern is the last entry of 5 million entries. Is there a mysql system variable I should reset to improve performance? Thanks Jeff Tanner Viathan Seattle, WA No, but you could crate a table without index and add primary key after loading of data. -- 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: LOAD DATA INFILE performance testing
DELAY_KEY_WRITE=ON by default Jeff -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:00 AM To: Jeff Tanner Cc: '[EMAIL PROTECTED]' Subject: Re: LOAD DATA INFILE performance testing DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique values into table from a single file (each value on a new line) # of unique valuestime in seconds 10 0.05 1000.05 1K 0.10 10K0.75 100K 10 500K 125 1M 500 5M 55000 My concern is the last entry of 5 million entries. Is there a mysql system variable I should reset to improve performance? Thanks Jeff Tanner Viathan Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql-3.23.40 - Compiler errors with Sun WorkShop 6
Rob McMahon writes: Description: mysqld.cc will not compile with Sun Workshop 6 CC: Sun WorkShop 6 2000/08/30 C++ 5.1 Patch 109490-01 Failing with the following errors: cut mysqld.cc, line 1484: Error: Cannot use const char* to initialize char*. char* p = strrchr(opt_name, FN_EXTCHAR); This is a known issue with Sun compiler, due to different strchr prototype. Change that line to : char* p = strrchr((const char *)opt_name, FN_EXTCHAR); -- 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
1054 error
I'm new to MySQL and I get a 1054 error on this SQL query sent by a PHP 4 script: 1054: Unknown column 'pricerange' in 'field list' $sql is INSERT INTO CCC_reviews (restname, type, specialties, address, phone, hours, pricerange, creditcards, reservations, rating, miscinfo, area, wheelchair, maplink, byline, date, reviewsum, review) VALUES ('Junkyard dog', 'Bakery', 'dogburgers', 'who cares', 'none', 'none', 'Moderate', 'Y', 'N', '1 1/2', 'Place stinks', 'North', 'N', 'somewhere', 'By Junkyard Bob', 'August 6, 2001', 'blah blah blah sum', 'blah blah blah real thing') The column pricerange does exist, and I've verified there's no trailing space or the like. Anyone know what's wrong? Thanks. Mike Kent The Indianapolis Star - Information Technology Internet mail:AOL messenger: mkent INI [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
Fw: UDF parameters
Hello, Is there a way to get parameters list for compiled UDF without its source available? If there, how can I get this parameters list? Best regards, Igor Brynskich 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
editor
is there any editor available (eg vi on UNIX) that runs on MS-DOS to make writing queries easier in MYSQL. I am a newbie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and fast query problem
IF kategori is an integer then the first one is the proper way to query it. The second one is forcing MySQL to convert a string to an int before comparing. (At least I THINK that's the problem.) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Erlend Stromsvik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 10:53 Subject: slow and fast query problem Hi (I hope I'm not asking to many 'stupid' questions... :) This query runs very fast (time 0.01 seconds): SELECT * from DB_GNIST.varer WHERE kategori = 24010 ORDER BY utgivelses_aar DESC LIMIT 10; This one is slow (time 0.73seconds): SELECT * from DB_GNIST.varer WHERE kategori = '24010' ORDER BY utgivelses_aar DESC LIMIT 10; Fast (0.49 seconds): SELECT count(*) from DB_GNIST.varer WHERE kategori = '24010' ODER BY utgivelses_aar DESC LIMIT 10; slow (10.47seconds): SELECT count(*) from DB_GNIST.varer WHERE kategori = 24010 ODER BY utgivelses_aar DESC LIMIT 10; Fast (0.83) SELECT * from DB_GNIST.varer a LEFT JOIN DB_GNIST.vare_bilder b ON a.isbn = b.isbn WHERE kategori = '24010' ODER BY utgivelses_aar DESC LIMIT 10; Slow (10.30) SELECT * from DB_GNIST.varer a LEFT JOIN DB_GNIST.vare_bilder b ON a.isbn = b.isbn WHERE kategori = 24010 ODER BY utgivelses_aar DESC LIMIT 10; I can't seem to find the any documentation about how col = 'something' is handled by mysql and how col = something is handled. They are obviously handled in different ways. If you look at the two first queries, the fast one is 73 times faster than the slow one. That's a huge difference. On the last two queries the one with kategori = 24010 will return a few more records than the first one. But if I replace = with LIKE both queries returns the same number of records, but the first one will still be much faster. Anyway, if I have missed something in the manual, please just tell me and I'll go back reading it. Erlend Stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mass data load
Dear Bing, control file to help load a bunch of data in a mass mode from some text Use LOAD DATE [LOCAL] INFILE, check the MySQL manual chapter 7 for this! Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Bing Du [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 5:08 PM Subject: mass data load Not very familiar with the features of MySQL regarding data loading. Does MySQL has some tool like SQL*Loader in Oracle? Can I use some control file to help load a bunch of data in a mass mode from some text input file into MySQL database? Any ideas or pointers to on-line help resouce are greatly appreciated. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:
Dear Dikla, is it possible to use queris of SQL at MySql? I don't exactly get what you mean, but well ... MySQL is an SQL database system, if that's your question. It is quite ANSI SQL92 compatible, and knows alot of Oracle extensions as well. So, if your question is, if you can use SQL statements written for some other SQL database system, the answer will probably be yes as well ... Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Dikla Sharvit [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 5:58 PM Subject: FW: hi, is it possible to use queris of SQL at MySql? dikla sharvit fls-dba 65513, 65486 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Installing multiple versions of mysql
I am currently trying to install mysql on a linux machine that already has mysql running. I went into the safe_mysqld script and modified the tcp port to point to 3308 and the mysql.sock file to point to /tmp/tmp/mysql.sock. I was able to get this to work with one of the newer versions of mysql 3.23.40, by doing the above and using the following config command: ./configure \ --with-tcp-port=3308\ --with-unix-socket-path=/tmp/tmp/mysql.sock\ --prefix=/usr/mysql The funny thing is, a message pops up saying that I didn't need to configure the version I had. However, safe_mysqld wasn't working otherwise. Anyway, I couldn't use this version of mysql with a php build procedure I was using, so I used an older mysql version 3.22.32. Any time I try the above (and I use a different port number even from the one above, which I deleted and killed anyway), the final message always states (mysqld daemon ended). Any clues would be greatly appreciated. Thanks in advance. Armando __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQLException Error Before start of result set
Hi My Java servlet (on ApacheTomcat) with database connection to MySQL keeps reporting same error from a Resultset via a PreparedStatement. It's catching an SQLException sqle error: Before start of result set. and showing a blank screen instead of showing printed messages having checked inputted parameters against the database. Servlet contains lot of ifs, elses, comparing parameter Strings (yes, using .equals() ) against the rs. object. I've lost the plot on this. Any ideas anyone? Cheers, Lucy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: editor
Dear Naintara, what about Notepad (the windows standard editor)? Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Naintara Jain [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, August 06, 2001 7:02 PM Subject: editor is there any editor available (eg vi on UNIX) that runs on MS-DOS to make writing queries easier in MYSQL. I am a newbie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: editor
Yes, have a look at urSQL (http://www.urbanresearch.com/ursql). You may also want to have a look at MyODBC and the various clients available from mysql.com, including mysqlgui. On Mon, 6 Aug 2001, Naintara Jain wrote: is there any editor available (eg vi on UNIX) that runs on MS-DOS to make writing queries easier in MYSQL. I am a newbie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with RPM upgrading from 3.22.23 to 3.23.40
Hi I'm receiving the following error when trying to upgrade from 3.22.32 to 3.23.40 OS: RedHat Linux 6.1 Hardware: HP Netserver E60 After closing down the MySQL daemon, then issue: rpm -Uvh MySQL-3.23.40-1.i386.rpm I get errors, saying that there is a conflict with mysqldump. Any ideas would be much appreciated. Trying to get the hang of it on my test server before applying it to Production. Thanks Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: editor
Ick !!! This question had come up on the list about 2 weeks ago... I like: WinVI (I know that the Emacs lovers will respond soon) at: http://www.winvi.de/en/ For other versions and 'ports' of VI, see The VI Lovers Homepage at: http://www.thomer.com/thomer/vi/vi.html - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Naintara Jain [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Monday, August 06, 2001 12:08 PM Subject: Re: editor Dear Naintara, what about Notepad (the windows standard editor)? Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Naintara Jain [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, August 06, 2001 7:02 PM Subject: editor is there any editor available (eg vi on UNIX) that runs on MS-DOS to make writing queries easier in MYSQL. I am a newbie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Localization..
I have a table which contain data of some different charsets, some of them are multi-byte character.. They are currently stored in raw, binary format.. In order to make % match those multi-byte characters correctly, I am planning to convect the table format to correct charset. However, i cannot find any infomation on how to create a table with multi-charsets. May anyone give me some hints here? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Just wondering....
I have been considering a database backend for a new website I am creating. If this site becomes successful I may be looking at several hundred concurrent users. Can MySQL handle this? Is there a limit to the number of connections?? Any info would be greatly appreciated. Check this lists archive.. this has been discussed into great dept.. several times.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mass data load
Stefan, Hrmm...which manual did you refer to? I found some LOAD DATA info in the on-line manual http://www.mysql.com/documentation/mysql/bychapter/. But its chapter 7 is about 'MySQL Full-text Search'. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix [EMAIL PROTECTED] 08/06/01 11:45AM Dear Bing, control file to help load a bunch of data in a mass mode from some text Use LOAD DATE [LOCAL] INFILE, check the MySQL manual chapter 7 for this! Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Bing Du [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 5:08 PM Subject: mass data load Not very familiar with the features of MySQL regarding data loading. Does MySQL has some tool like SQL*Loader in Oracle? Can I use some control file to help load a bunch of data in a mass mode from some text input file into MySQL database? Any ideas or pointers to on-line help resouce are greatly appreciated. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Import data question
I have a table I want to import some records into. The table has 4 columns - user_id, name, account, password. The file I have to be imported has 3 columns - password,name,account. I have been trying to use load data infile and keep ending up with a lot of junk in the database. The file is of this format - password,name,account password,name,account etc File name is users and table name is users. mysql load data infile '/usr/home/chip/users' into table users - (name,password,account) - fields terminated by ','; ERROR 1064: You have an error in your SQL syntax near 'fields terminated by ','' at l ine 3 mysql Regards, Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
WANTED: Utility to reverse engineer existing database
I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in Administration
Hi, Sorry to bother you people but I've just locked myself out of my own DB. I was installing some stupid program which required me to do some changes in the permissions and now I get this error Access Denied for user: 'root@localhost' (Using password: NO). http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0 / 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: WANTED: Utility to reverse engineer existing database
On Mon, Aug 06, 2001 at 04:57:41PM -0400, Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Tried mysqldump? :) Greetz, Peter -- Against Free Sex! http://www.dataloss.nl/Megahard_en.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WANTED: Utility to reverse engineer existing database
For mysql you can use mysqldump Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Data load
I'm trying to import data (approx. 2000 records), but am unable due to the following circumstances; My host doesn't allow access into the mysqldb directory for security purposes (shared server). This is the directory where MySQL is looking for the import file. I then tried to use LOCAL but I'm using version 3.22.14b and local isn't available until 3.22.6. Does anyone know of a work around for this? I've seen where example code for books on MySQL can be loaded using tar. How is this file created in order to create a database from a single tar file. Thanks!
Re: WANTED: Utility to reverse engineer existing database
mysqldump It comes with MySQL. - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 3:57 PM Subject: WANTED: Utility to reverse engineer existing database I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WANTED: Utility to reverse engineer existing database
Yup. You can use mysqldump (comes with the MySQL distribution). See the MySQL manual for details: http://www.mysql.com/doc/m/y/mysqldump.html You can also use a graphical tool such as urSQL (MS Windows + MyODBC) to accomplish the scripting if you wish (http://www.urbanresearch.com/ursql). On Mon, 6 Aug 2001, Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API Compile Error
Good Afternoon - I receive the following error when attempting to compile an application to use the C API. gcc -oclient1 client1.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status Any ideas would be much appreciated. Best Regards, Rob = ~~ Robert A. Doornbos, Jr. Leader, Forecast Systems Group WeatherNews, Inc. (USA) [EMAIL PROTECTED](530) 893-0308 ~~ __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: WANTED: Utility to reverse engineer existing database
Got it! Thanks. -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 5:11 PM To: Kevin Cc: [EMAIL PROTECTED] Subject: Re: WANTED: Utility to reverse engineer existing database For mysql you can use mysqldump Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: WANTED: Utility to reverse engineer existing database
Check out CaseStudio at www.casestudio.com. Mark Chalkley On Monday, August 06, 2001, 5:40:15 PM, you wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? CHP mysqldump ? CHP / Carsten CHP -- CHP Carsten H. Pedersen CHP keeper and maintainer of the bitbybit.dk MySQL FAQ CHP 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
Out of memory
Title: Blank I'm getting this error Out of memory (Needed 8164 bytes) I thinking this is a squid issue and not a mysql issue but I seem to run across alot of ? about it with Mysql database. I just need to be pointed in the right directions Vien HuynhleClearsail Communications
Out of memory
Title: Blank Also I getting this error when I am unable to do my selects I'm getting this error Out of memory (Needed 8164 bytes) I thinking this is a squid issue and not a mysql issue but I seem to run across alot of ? about it with Mysql database. I just need to be pointed in the right directions Vien HuynhleClearsail Communications
Fwd: Error with RPM upgrading from 3.22.23 to 3.23.40
Well, I answered by own question. The trick is to install the client utilities first! Then the server. ie: rpm -Uvh MySQL-client-3.23.40-1.i386.rpm rpm -Uvh MySQL-3.23.40-1.i386.rpm Peter Date: Mon, 06 Aug 2001 15:27:14 -0400 To: [EMAIL PROTECTED] From: Peter Fleming [EMAIL PROTECTED] Subject: Error with RPM upgrading from 3.22.23 to 3.23.40 Hi I'm receiving the following error when trying to upgrade from 3.22.32 to 3.23.40 OS: RedHat Linux 6.1 Hardware: HP Netserver E60 After closing down the MySQL daemon, then issue: rpm -Uvh MySQL-3.23.40-1.i386.rpm I get errors, saying that there is a conflict with mysqldump. Any ideas would be much appreciated. Trying to get the hang of it on my test server before applying it to Production. Thanks Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
./configure error
Hi, I am attempting to compile mysql but when running ./configure it errors out when Checking for termcap functions library... configure: error: No curses/termcap library found And it returns me to the command prompt. I can't seem to find this library that it is asking me for. Any ideas. Michael Blood - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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++ API under Mac OS X
I was able to compile and install the MySQL++ API on my Mac OS X system, however, whenever I try to run a program linked against the library, I get undefined symbol errors. dyld: bin/wopsql Undefined symbols: __t12basic_string3ZcZt18string_char_traits1ZcZt23__malloc_alloc_template1i0. nilRep ___iomanip_setw__FR3iosi __t23__malloc_alloc_template1i0.__malloc_alloc_oom_handler __t24__default_alloc_template2b0i0._S_end_free __t24__default_alloc_template2b0i0._S_free_list __t24__default_alloc_template2b0i0._S_heap_size __t24__default_alloc_template2b0i0._S_start_free __t12basic_string3ZcZt18string_char_traits1ZcZt24__default_alloc_template2b0i0. nilRep Seems like a similar problem as described in the post: http://www.geocrawler.com/archives/3/362/1999/5/50/1804413/ However, the solution in that post does not produce any different results. This even happens for the MySQL++ example programs. Anyone have any suggestions? I'd really really like to be able to use this in a project I'm working on, but MySQL++'s lack of portability seems rather insane. Tons of patching required to just get it working on minor gcc version increments. Is this inflexibility due to the design of MySQL++, design of GNU's STL, or all both? -Halim Chtourou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to delete a database table?
how can i delete a database table? ty louie miranda --- (axishift.ath.cx) PGPID: 0xDABA60C7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to delete a database table?
DROP TABLE table_name; On Tue, 7 Aug 2001 10:15:43 +0800, louie miranda [EMAIL PROTECTED] wrote: how can i delete a database table? ty louie miranda --- (axishift.ath.cx) PGPID: 0xDABA60C7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php 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: how to delete a database table?
To remove rows from a table: mysql delete from your_table_name; See: http://www.mysql.com/doc/D/E/DELETE.html To completely remove the table from the database: mysql drop table your_table_name; See: http://www.mysql.com/doc/D/R/DROP_TABLE.html On Tue, 7 Aug 2001, louie miranda wrote: how can i delete a database table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: solairs 8 x86 get signal 11 with bdb support
Greetings, I appologize for not responding sooner, as I have had ISP problems, and work has been killing me...so to speak. :) I attempted running some of the programs under the bdb/build_unix directory, but none of them would run either. I ended up giving up and going with InnoDB, which works perfectly. I also have a copy of the latest Berkeley DB installed on my machine that I use for other software, and attempted compiling with that version, but I received the same results. It doesn't appear to be a problem with the bdb code supplied with mysql. I will recompile with debug support to see if I can't get more details on why it is crashing. Thanks, Brian On Wed, 25 Jul 2001, Timothy Smith wrote: On 2001 Jul 23, [EMAIL PROTECTED] wrote: Description: Whenever I compile mysql 3.23.40 with Berkeley DB support, I get a signal 11 when attempting to start the mysql server. If I omit Berkeley DB support, everything starts fine. Synopsis: solairs 8 x86 get signal 11 with bdb support Release: mysql-3.23.40 (Source distribution) Brian, I'm not sure how well Berkeley DB is supported on x86 Solaris. Can you try running some of the programs inside the bdb/build_unix directory, to see if they crash or if they work? If they also crash, then something is wrong with the way bdb is being built. You might try getting a stock BerkeleyDB from sleepycat.com; if it works and ours doesn't, then clearly there is something wrong with how we're building ours. For example, try running 'db_printlog -V', to see if it prints out its version. Another thing to do is to pass the --with-debug flag to configure when you build MySQL, and run mysqld under a debugger to find out exactly where it crashes. You can find detailed instructions on how to do this in our manual: http://www.mysql.com/doc/D/e/Debugging_server.html If you could do this, it would help us a lot! Thanks, Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-time Developer /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ 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
Nested Queries in MySQl
Hi all, I have not been using MySQL for too long but have been using SQL7.0 for a while now, so I am generally familiar with the structure. My basic problem right now is trying to figure out how to get MySQL to do nested queries such as ... select count(*) from (select count(*) as A, group_col from my_table group by group_col) as B Could someone help me out with getting the nested query to work, (I know this can be done here with a distinct but work with me here.) Thanks in advance. Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about users
I created a perl script that opens that database like this: my $dbh = DBI-connect( 'DBI:mysql:devjournal:username=mjohnson:host=morpheus' ); This works great if I run the script from another machine, but if i run in on morpheus it says that [EMAIL PROTECTED] does not have access. If I leave off the host part it works fine. But I would like to be able to run this script unchanged for any machine including morpheus. I have added myself as mjohnson@localhost and mjohnson@%, do I need to add myself as [EMAIL PROTECTED]? thanks for your help! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't start MYSQL on Linux
I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . It always ends immediately. When I look at the /var/log/mysql.log, the message says: mysql started /usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13) mysql ended I tried start safe_mysqld from many directories and without any success. Can anyone please help me out? Thanks. Ling Wang _ 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: Can't start MYSQL on Linux
Ling Wang [EMAIL PROTECTED] writes: I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . You're not supposed to. To start mysql, as any service, do service mysqld start (which is equivalent to running the initscript like this /etc/init.d/mysqld start). This will automatically initialize the database the first time it runs. To make it start when your system starts, do chkconfig mysqld on What you've done (and too many others, where do they get this idea?) is that you've created the database files as root. Then you start the database, which will run as mysql. This user can obviously not write to root's files. Change the ownership manually, and try again - with service mysqld start. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Nested Queries in MySQl
Date |6 Aug 2001 19:59:46 -0700 From |Steven Robillard [EMAIL PROTECTED] Hello! SR Hi all, I have not been using MySQL for too long but have been using SQL7.0 for a while now, so I am generally familiar with the structure. SR My basic problem right now is trying to figure out how to get MySQL to do nested queries such as ... SR select count(*) from (select count(*) as A, group_col from my_table group by group_col) as B SR Could someone help me out with getting the nested query to work, (I know this can be done here with a distinct but work with me here.) Thanks in advance. MySQL does'nt support nested queries now. You can try to play with JOIN syntax http://www.mysql.com/doc/J/O/JOIN.html ___ Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C API Compile Error
Date |Mon, 6 Aug 2001 14:46:13 -0700 (PDT) From |Rob Doornbos [EMAIL PROTECTED] Hello! RD Good Afternoon - RD I receive the following error when attempting to RD compile an application to use the C API. RD gcc -oclient1 client1.c -I/usr/local/mysql/include RD -L/usr/local/mysql/lib -lmysqlclient RD /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): RD In function `my_uncompress': RD my_compress.o(.text+0x9a): undefined reference to RD `uncompress' RD /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): RD In function `my_compress_alloc': RD my_compress.o(.text+0x12a): undefined reference to RD `compress' RD collect2: ld returned 1 exit status RD Any ideas would be much appreciated. RD Best Regards, RD Rob Try to add -lz to gcc command line, gcc -oclient1 client1.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lz ___ Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ./configure error
Date |Mon, 6 Aug 2001 19:14:09 -0600 From |Michael Blood [EMAIL PROTECTED] Hello! MB Hi, MB I am attempting to compile mysql but when running ./configure it errors out MB when Checking for termcap functions library... configure: error: No MB curses/termcap library found MB And it returns me to the command prompt. MB I can't seem to find this library that it is asking me for. MB Any ideas. You need to setup curses library. In your case it's may be 'ncurses'. ___ Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Import data question
Date |Mon, 6 Aug 2001 13:48:41 -0700 From |[EMAIL PROTECTED] Hello! C I have a table I want to import some records into. The table has 4 columns C - C user_id, name, account, password. C The file I have to be imported has 3 columns - C password,name,account. C I have been trying to use load data infile and keep ending up with a lot of C junk in the database. C The file is of this format - C password,name,account C password,name,account C etc C File name is users and table name is users. mysql load data infile '/usr/home/chip/users' into table users C - (name,password,account) C - fields terminated by ','; C ERROR 1064: You have an error in your SQL syntax near 'fields terminated by ','' at l C ine 3 mysql You need to use right LOAD DATA syntax. LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES TERMINATED BY '\n'] [IGNORE number LINES] [(col_name,...)] So, columns name must be at end of query LOAD DATA INFILE '/usr/home/chip/users' fields terminated by ',' INTO TABLE users (name,password,account) ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Localization..
Date |Tue, 7 Aug 2001 04:01:17 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have a table which contain data of some different charsets, SC some of them are multi-byte character.. SC They are currently stored in raw, binary format.. SC In order to make % match those multi-byte characters correctly, SC I am planning to convect the table format to correct charset. SC However, i cannot find any infomation on how to create a table SC with multi-charsets. May anyone give me some hints here? Look here: http://www.mysql.com/doc/L/o/Localization.html And here: http://www.mysql.com/doc/M/u/Multi-byte_characters.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
INET_ATON
hey folks, i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax errors near '(100.100.100.100)' at line 1 no manner of quoting that i can think of solves this. i tried the examples at the bottom of http://www.mysql.com/doc/M/i/Miscellaneous_functions.html and they got the same error. am i missing something easy here? is this a known issue? perhaps a version thing? i am running 3.22.32. thanks, mike -- mike cullerton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: installation
Date |Mon, 6 Aug 2001 08:37:06 -0700 (PDT) From |Venkat Nipun Gajjala [EMAIL PROTECTED] Hello! VNG Hi, VNG I installed the mysql-3.22.26a version on my VNG linux machine and executed the following commands VNG Untar it and change into the source directory tree: VNG tar -xvzf mysql-3.22.26a.tar.gz VNG cd mysql-3.22.26a VNG Configure the package; I used following options: VNG ./configure --prefix=/opt/mysql VNG Build it: VNG make VNG Install it; as root: VNG make install VNG You'll then need to configure the installation: VNG As root, create the grant tables: VNG scripts/mysql_install_db VNG As root, start the server: VNG /opt/mysql/bin/safe_mysqld VNG As root, create the mysql user: VNG useradd -c MySQL Administrator -d /opt/mysql -g users VNG mysql VNG As root, give the installation tree to the mysql user: VNG chown -R mysql.users /opt/mysql VNG Now when i execute the mysqladmin VNG version command it says can't connect to local MySQL VNG server through socket '/var/lib/mysql/mysql.sock'.The MySQL VNG server is running but there is no /mysql/mysql.sock so what VNG do i need to do now.Thank you. You need to give write access to /var/lib/mysql/mysql.sock for your mysql user. for example by chown mysql /var/lib/mysql -R chmod 755 /var/lib/mysql ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Help Slow Query
Date |Mon, 6 Aug 2001 09:59:04 -0500 From |Patrick J. Militzer [EMAIL PROTECTED] Hello! PJM Hi there, PJM I have a query that is taking 19 - 23 sec's to complete, it used to take 5 sec PJM or less to complete, the only thing we have added are a new database unrelated PJM to this on. PJM The system is a Sun Ultra 10s running Solaris 2.7 with 256mb and 333mhz PJM processor. Mysql version is 3.22.27. PJM Any Idea's, suggestions would be helpful. At first try to upgrade your mysql to current version. In my case it's give more than 50% bonus. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Truncated User List
Date |Mon, 6 Aug 2001 13:51:09 +0100 From |Steve Wright [EMAIL PROTECTED] Hello! SW Hi, SW Wondering if anyone can here can help, SW We've got a small selection of MySQL databases used by our customers (for SW websites). SW Until now we've used the Debian package of MySQL (latest deb. version), SW however the systems are being updated we're starting to use source builds, SW (this is where the problem starts). SW I have 3.23.39 built installed, we installed the old databases on the new SW machine by shutting down the sql server duplicating the /var/lib/mysql SW directory structure. SW When the users are listed on the new machine however half are missing, I am SW very confused as I don't seem to be able to make them reappear ! SW I have looked in the /var/lib/mysql/mysql/user. files can see them SW /etc/my.cnf is looking in the right place SW I feel I may have overlooked something, can anyone help ? You must use mysqldump utility for data export and then import old data to the table. It's much clean way. http://www.mysql.com/doc/m/y/mysqldump.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Transaction safe tables for Mac OS X
Date |Mon, 6 Aug 2001 13:44:28 +0200 From |Willy Faes [EMAIL PROTECTED] Hello! WF Hi, WF Are there any transaction safe tables for Mac OS X you can use? WF Thanks, WF Willy Faes You must use innodb or bdb tables for transaction safe. Both may normaly compilled on Mac OS ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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