Re: Newbie: MS Word + MyODBC + MySQL
Hello Mr.Venu, yes, of course, I took a look at it and I checked this out. It was quite useable for mass-mailings, but not for single letters. e.g. My database contains a lot of adresses. I created a dialogbox, where I enter a name and now the corresponding adress will be looked up in th DB. now if mysql returned only one row, a *.DOT document is loaded and I cut and past each part of the adress from my hidden SQL result into the letterhead. Problem is, that I have to use a second document for keeping the SQL-Result and - which is a larger Problem - I cannot update any DB records. regards, Felix - Original Message - From: Venu [EMAIL PROTECTED] To: Felix Schepmann [EMAIL PROTECTED] Sent: Saturday, January 26, 2002 8:10 PM Subject: RE: Newbie: MS Word + MyODBC + MySQL Hi, -Original Message- From: Felix Schepmann [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 26, 2002 12:21 AM To: [EMAIL PROTECTED] Subject: Newbie: MS Word + MyODBC + MySQL Hi There ! I am quite new to this MyODBC topic, though I am used to create Perl programs connecting to MySQL DBs. Currently I am able to fetch rows from the DB via MyODBC and show them in a blank document as a table. Usually this is how I add data into my documents (like invoices, etc.): I open a new document, get the data into a blank table, get the contents of the table and then copy and paste the data into my document. Is there a better way, to get the data from the DB, e.g. using the DB directly as a datasource? Is there a way how I can update the DB with new data, e.g. write some kind of front-end within Word's VB ? IS there a FAQ for all my Word-questions? Did u had a time to look into the following section of the manual under 'WORD'. http://www.mysql.com/doc/M/y/MyODBC_clients.html Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, 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
Re: server problems and CPU usage issues
Tuesday, January 29, 2002, 1:57:21 AM, David Piasecki wrote: I have a server here that is troubling me - I have a database server that is lagging no matter what I do. When I start the server, I can watch CPU usage slowly creep up to 99% and it never drops. The queries that are hitting the database are not terribly involved, and should be completing quickly, but of course over time the queries take longer and longer to complete. Eventually queries take an excruciatingly long time and of course users on the web site are simply stopping. The machine is a dual processor intel 1ghz with 2 gigs of ram running FreeBSD currently using 3.23.43 of mysql (though we have tried other versions with the same result). The database is getting anywhere from 0 to 20 simultaneous connections, and most of the queries are extremely short and sweet, with just a handful that would take several seconds to complete. At this point I am wondering if this might be either a hardware or operating system problem. The server has been rebooted numerous times with the same end result. Has anyone else had similar problems? Any ideas? wrong threads library -- Dimitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: print database schema
Check out this program. Just wish there was an OS X version :-( http://www.datanamic.com/dezign/index.html -- greg willits -- [EMAIL PROTECTED] From: Steven Wren [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 16:22:12 +1000 (EST) To: Paul DuBois [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: print database schema Hello more of a visual tool. The program I did see had views of all the tables as if you had done a describe table_name for each table, then had lines linking the relationships between tables (similar to what you can view in Access , even though i hate to admit I have used it :) would just be good for management and seeing where you can improve indexes etc... thanks. Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane On Tue, 29 Jan 2002, Paul DuBois wrote: At 14:42 +1000 1/29/02, Steven Wren wrote: Hello I was wondering if anyone knew of a program that would allow you to print out a complete database. I have seen it on a PostGre DB, so I am sure MySQL should have something... You mean mysqldump --no-data db_name ? cheers! Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Replication of selected DB
Hi, It is said that if the connection is lost then there will be an entry of the .err file. But nothing of that sort is happening here. Connection is not lost, and replication is also not taking place. Can any one help to get the solution. On Tue, 29 Jan 2002, Jai Kumar Shinde wrote: Hi, Check the error, not in mysqld.log ..its in hostname.err Jai -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 9:52 AM To: Girish Nath Cc: [EMAIL PROTECTED] Subject: Replication of selected DB Hi, I have to replicate the selected Database. I have followed all the steps given in the manual page. But i am not getting the result as i need. There is no error message in the mysqld.log. The message in the log file is replication is started. But the replication is not happening. Can you help me to solve this. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using LIMIT to select random rows
On Sun, 27 Jan 2002, Michael Widenius wrote: One way to do this is to do as follows: SELECT something FROM sometable WHERE somevar=somevalue ORDER BY RAND() LIMIT 10 OK. I still think that my extended LIMIT syntax would be a good idea, because ORDER BY RAND() does not seem to be very fast. I tried adding a field that numbers all instances of a certain ID (this probably breaks some normalization rule). This way I could simulate what things would be like with an extended LIMIT syntax. This SQL statement: SELECT varWord FROM dictionaryword WHERE intTypeID='11' AND (intTypeCounter26) executed a lot faster than: SELECT varWord FROM dictionaryword WHERE intTypeID='11' ORDER BY RAND() LIMIT 25 Thus, I still think it would be a good idea to be able to say: SELECT COUNT(*) AS greve FROM dictionaryword WHERE intTypeID='11' and then: SELECT varWord FROM dictionaryword WHERE intTypeID='11' LIMIT number1,1, number2,1,number3,1,number4,1,.. team called Monty Kaj and wrote a PacMan clone called Blipp for the ABC80 computer decades ago? Man, that game was cool! ;) Yes, it was I who wrote that games ages ago... Cool! I played it a lot as a kid. Ulf Härnhammar System Developer ST-Registry St Eriksgatan 117, E2 SE-113 43 Stockholm SWEDEN (GMT+1) Telephone: +46 (0)8-545 476 04 Facsimile: +46 (0)8-32 63 33 E-mail: [EMAIL PROTECTED] Web: http://www.nic.st/ The STreet domain - your Internet address - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 probems: swap space is insufficient for optimization
Hi, I have an Sun Ultra 2 with 500Megs of swap and I constantly get the following swap space messages when I try to install mysql-3.23.39. - Note: The following compile may take a long time. If it fails, re-run configure with --with-low-memory CC -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/export/home/MYSQL/mysql\ -DDATADIR=\/export/home/MYSQL/mysql/var\ -DSHAREDIR=\/export/home/MYSQL/mysql/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -DHAVE_RWLOCK_T -c sql_yacc.cc sql_udf.h, line 79: Warning (Anachronism): Cannot cast from void* to double(*)(st_udf_init*,st_udf_args*,unsigned char*,unsigned char*). sql_udf.h, line 98: Warning (Anachronism): Cannot cast from void* to long long(*)(st_udf_init*,st_udf_args*,unsigned char*,unsigned char*). sql_udf.h, line 117: Warning (Anachronism): Cannot cast from void* to void(*)(st_udf_init*,st_udf_args*,unsigned char*,unsigned char*). sql_udf.h, line 130: Warning (Anachronism): Cannot cast from void* to void(*)(st_udf_init*,st_udf_args*,unsigned char*,unsigned char*). item_cmpfunc.h, line 286: Warning (Anachronism): Formal argument 4 of type extern C int(*)(const void*,const void*) in call to 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. sql_yacc.yy, line 1463: Warning (Anachronism): Cannot cast from void* to Item*(*)(). sql_yacc.yy, line 1465: Warning (Anachronism): Cannot cast from void* to Item*(*)(Item*). sql_yacc.yy, line 1467: Warning (Anachronism): Cannot cast from void* to Item*(*)(Item*,Item*). sql_yacc.yy, line 1469: Warning (Anachronism): Cannot cast from void* to Item*(*)(Item*,Item*,Item*). 10 Warning(s) detected. After 6423 alloc calls, swap space is insufficient for optimization of routine __1cHyyparse6F_i_ at optimization level -O3 current routine started again at -O2 After 18086 alloc calls, swap space is insufficient for optimization of routine __1cHyyparse6F_i_ at optimization level -O2 current routine started again at -O1 After 18089 alloc calls, swap space is insufficient for optimization compiler(iropt) error: optimizer terminating - I get the exact same error when trying to compile on a 2.6 starfire domain with 1.5 Gigs of swap space. I don't understand this failure as the same version of mysql compiles (with the same compilers) on lower-end sun4d sun4m systems running much less swap. Do I really need to run the --with-low-memory option ?? Thanks in advance, -- frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unix binary installations somewhere other than in /usr/local
On 28 Jan, Paul DuBois wrote: On 28 Jan John A. Murdie wrote: I decided that it was probably simpler just to build from source - I'm on a Solaris 2.8 system - and so it proved to be. I was careful to use the recommended configure options. I found that I had to build in the installation directory - `make install' didn't copy the `scripts' sub-directory to the installation directory, for instance, when (in my first attempt) I unpacked the source in one directory (the build directory) and configured for another (the installation directory). For my second and successful build I made the build and installation directories the same. I can't find, however, any documentation of a command to clean the build files (e.g. `configure', `INSTALL-SOURCE' etc.) from the build/installation directory. Is there a `make tidy' or something similar? (`make clean' looks as if it would delete the executables!) make distclean removes the most stuff. Rather too much, I'm afraid - the executables and libraries too. What baffles me is that `make install' doesn't install the `scripts' directory (and probably other necessary files), so it appears that you have to build in the final installation directory (which is not conventional under Unix - I build other programs under /tmp and then do `make install'). When you build in the installation directory you have a lot of build materials left in your installation when it's done. It does no harm, of course, but I'd like to tidy up. (All I can think of is to remove files that are not present in a binary distribution - using a script which calls comm(1) perhaps.) I've scoured the `INSTALL-SOURCE' document, and can find no mention of this nuisance. -- John A. Murdie Experimental Officer (Software) Department of Computer Science University of York England - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Images in MySql
Eric, Monday, January 28, 2002, 2:30:47 PM, you wrote: ETK Eric here from South Africa. ETK I'm fairly new at using mysql and need to access images via a php website. ETK What is the best way to store images or reference to images like jpg and ETK gifs in a mysql db? Also what would the sql ETK querie look like to call the and view the image. Is there any documentation ETK specificaly geared towards to images in mysql. You can store images in database using blob data type, see http://www.mysql.com/doc/B/L/BLOB.html In other way, you can store references to images. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Statement preparing
Hello, I'm developing an application with MySQL using the C API. I would like to implement a mechanism to prepare some queries in advance and just bind the parameters before execution. I have found in the documentation a way to do that using the DBI Interface but not for C API. Is it possible to prepare statements for execution in an application built with the C API? Any help/comments would be appreciated. TIA. Pedro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
disconnecting from database
I'm developing in asp and connect to databases using something like this: (using ODBC) set db = Create.ServerObject(ADODB.Connection) db.open databaseName; This works fine and I can get and insert data with no trouble. However, when I do: db.close set db=nothing Nothing happens. The connection remains in sleep mode with no info (output from process list) and only disconnects when the connection is timed out. This is a problem when many users are using a page simutaneously with many connections created... changing the max connection limit is not a real option as it slows everything down when many connections are made. Any idea on what I can do disconnect from the dabase? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB help !!
thanks for your quick reply !! that's fine !! I have done the max.RPM installation part. but what is fix up the startup scripts so that binary will be the one started. When I am trying show variables like have_%; +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_gemini | NO| | have_innodb | NO| | have_isam | YES | | have_raid | NO| | have_openssl | NO| +---+---+ 6 rows in set (0.00 sec) It's not showing innoDB support. Ideally it should show after installing the max.RPM. shouldn't it ?? Please, help me as much you can !! I have been stuck at this place. Thanks and regards, Chetan Lavti -Original Message- From: Arjen Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:42 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: InnoDB help !! Hi, On Tue, 2002-01-29 at 14:10, Chetan Lavti wrote: I have downloaded and installed MySQL ( rpm's). Now, I want to configure it with InnoDB option, as given in the manual, but can't see the below configure file anywhere. // cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb can anybody help me about this.. The info you mention is used when compiling from the source. You do not need to do this. Download the -Max .RPMs for your 3.23.xx version, and install those (keep the normal RPM you have already installed). This will set up a binary with InnoDB support, and fix up the startup scripts so that binary will be the one started. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help on client connection
xgao, Tuesday, January 29, 2002, 3:45:30 AM, you wrote: x Hi all x I try to connect mysql on turbolinux with my windows mysql client but the x client tells me my host is not allowed to connect the mysql server. Please refer the following link: http://www.mysql.com/doc/C/o/Connecting.html You can also see info about privileges at: http://www.mysql.com/doc/P/r/Privileges_provided.html or at: http://www.mysql.com/doc/A/c/Access_denied.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
How to load data into non-empty tables
Cindy, Tuesday, January 29, 2002, 1:28:59 AM, you wrote: CY Hello, CY Can anyone tell me how to load data into non-empty tables? Can you CY give me an example? CY Any help appreciates! Look in the manual about LOAD DATA at: http://www.mysql.com/doc/L/O/LOAD_DATA.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
[NEWBIE]Can't run mysql client
Stephane, Monday, January 28, 2002, 1:29:40 PM, you wrote: SP I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box. SP Everything seems to be OK (the server runs) but I cannot connect to it using SP mysql client: SP When I enter mysql -u etc... SP I've got a bash: mysql: command not found SP Any idea ? Are you sure you have installed ALL packages that MySQL consist of ? Please be sure that MySQL-client package is installed. SP Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Source Install / Config problems
Samy, Monday, January 28, 2002, 8:09:37 PM, you wrote: SE Hope some of you could help me here. SE I have done SE ./configure --prefix=/ussr/loca/mysql SE --localstatedir=/usr/loca/mysql/data SE --withunix-socket-path=/tmp/mysql.sock SE make SE make install Since ~1991, Soviet Union is not the best place to install MySQL. :) Seriously saying, you should better take the binary distribution from MySQL site and install it. Compiling MySQL from source is not as easy as it seems. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Help with hanging MySQL server
Ed, Monday, January 28, 2002, 11:26:44 PM, you wrote: EC Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on EC a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the EC box, mysql will start, but connections to the database just hang. EC mysqldmin, etc. all hang also. /tmp/mysqld.sock is being created, but when EC we do a telnet localhost 3306, it connects, but we don't get the EC characteristic 3.23.36garbage string that we would normally see. Any EC hints? Yes, take the right-compiled MySQL binary distribution from http://www.mysql.com. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: InnoDB help !!
Matthew, Tuesday, January 29, 2002, 6:37:32 AM, you wrote: MW You can only do this while compiling it from source. MW Matthew Walker MW Ecommerce Project Manager MW Mountain Top Herbs MW -Original Message- MW From: Chetan Lavti [mailto:[EMAIL PROTECTED]] MW Sent: Monday, January 28, 2002 9:11 PM MW To: [EMAIL PROTECTED] MW Subject: InnoDB help !! MW hi, MW I have downloaded and installed MySQL ( rpm's). Now, I want to configure MW it with InnoDB option, as given in the manual, MW but can't see the below configure file anywhere. MW // cd /path/to/source/of/mysql-3.23.37 MW./configure --with-innodb Yes, the configure script is only available in source tree. Take the MySQL-Max distribution from http://www.mysql.com/ and read http://www.mysql.com/doc/I/n/InnoDB.html to do the initial setup. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 probems: swap space is insufficient for optimization
Frank, Tuesday, January 29, 2002, 12:33:03 PM, you wrote: FRSE I have an Sun Ultra 2 with 500Megs of swap and I constantly get the FRSE following swap space messages when I try to install mysql-3.23.39. [] FRSE -- FRSE I get the exact same error when trying to compile on a 2.6 starfire FRSE domain with 1.5 Gigs of swap space. FRSE I don't understand this failure as the same version of mysql compiles FRSE (with the same compilers) on lower-end sun4d sun4m systems running FRSE much less swap. FRSE Do I really need to run the --with-low-memory option ?? If you _really_ want to compile by yourself, yes. But we recommend you to run the precompiled binary from MySQL website: http://www.mysql.com/ FRSE -- frank -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: InnoDB help !!
Chetan, Tuesday, January 29, 2002, 7:02:18 AM, you wrote: CL thanks for reply, CL but I have installed MySQL on Linux using the RPM files and while using CL RPM files should I have to give the option while installing? As while CL using the RPM files there is no compilation. CL It is no where mentioned in the manual with the RPM files. can you CL please, help me out in details. Simply install and run the MySQL-Max server version. Don't forget to read the manual: http://www.mysql.com/doc/I/n/InnoDB.html CL Chetan Lavti -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Problem with norwegian characters
Torkil, Monday, January 28, 2002, 5:47:48 PM, you wrote: TJ A friend of mine is having a problem with the 3 norwegian characters æ Æ, ø TJ Ø and å Å. (html: æ ø and å) TJ When a string is inserted with either of these characters, and later TJ selected and returned, they do not appear as they are supposed to. I.e: Ø TJ becomes O. TJ Also: Alphabetically sorting strings with these characters in them does not TJ work. TJ How do I set MySQL database language?? Or what do I need to do? Try to set norwegian character set. Get some more info at: http://www.mysql.com/doc/C/h/Character_sets.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql access control
Joachim,
Monday, January 28, 2002, 2:15:51 PM, you wrote:
JH I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4)
JH After the installation of mysql I run the mysql_install_db script
JH I could change the passwords for root so I reset the GRANT table using
JH ../safe_mysqld --skip-grant-tables
JH and than I set the passwords manually using
JH myql -u root mysql
JH mysql INSERT INTO user (Host,User,Password)
JH VALUES(''%','root',PASSWORD('abc'));
JH mysql INSERT INTO user (Host,User,Password)
JH VALUES('localhost','root',PASSWORD('abc'));
JH mysql FLUSH PRIVILEGES;
JH I can set the password for e.g root (atleast I don't get any error message) using
JH mysqladmin -h localhost -u root -p password 'def'
JH but when I try to access the DB using
JH mysql -h localhost -u root -p mysql
JH (depending on the password) I get the following error message:
JH ERROR 1044: Access denied for user: 'root@localhost' to
JH database 'mysql' (if I use abc as password)
JH or
JH ERROR 1045: Access denied for user: 'root@localhost'
JH (Using password: YES) (if I use def as password)
See the output of following:
SHOW GRANTS FOR root@localhost;
I think that you get something like that:
GRANT USAGE ON *.* TO 'root'@'localhost'
IDENTIFIED BY PASSWORD 'your_password'
USAGE is a synonym for no privileges.
Use GRANT statement to set privileges for user. For example:
GRANT ALL ON *.* TO 'root'@localhost
IDENTIFIED BY 'password' WITH GRANT OPTIONS
Check the following link: http://www.mysql.com/doc/G/R/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ 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
'where not exists' problem
Jessica, Monday, January 28, 2002, 3:13:11 PM, you wrote: JR Can anyone help me - JR I am trying to extract data on the availability of a holiday villa using the JR statement JR 'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM JR Reservation WHERE PossDate Between ArrDate And DeptDate AND JR Reservation.VillaID=\'Adonis\')'. JR (This was originally done on an Access database) JR I get an error message that says JR 'you have an error in your SQL syntax near exists(SELECT PossDate FROM JR Reservation WHERE PossDate Between ArrDate And DeptD ', JR so I presume it doesn't like the 'where not exists' part. JR Can anyone tell me of an alternative to this please?? MySQL doesn't support subselects, check the following link: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html You can also try to use temporary tables. See at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Trouble in unsubscribing
could you be subscribed under two (or more) email addresses? Peter -Original Message- From: Yuxia Li [mailto:[EMAIL PROTECTED]] Sent: 29 January 2002 06:15 To: [EMAIL PROTECTED] Subject: Re: Trouble in unsubscribing Hi: Does anyone know how to unsubcrib from sql mailing list? I tried twice a few days ago but still getting emails. I even receieved a confirm which told me my email has been removed from the mysql list after I unsubcribed. My mail box can't stand for getting too many emails a day. Thanks a lot! helen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Source Install / Config problems
SE ./configure --prefix=/ussr/loca/mysql Typo I used /usr/local/mysql To make a long stroty short , I downloaded the source rpm and started over , now I have the mysql.sock file. Looks like the download was currupt. I nned to use the sourcee as I am compliling some other stuff as well. Ist want to get a good compile first. 2ndly, The docs I am using use the following sysntex , ./configure --prefix=/usr/local/mysql \ --localstatedir=/usr/loca/mysql/data \ withunix-socket-path=/tmp/mysql.sock Note the back slash at the end. Whats the back slash for ? I used ./configure --prefix=/usr/local/mysql --localstatedir=/usr/loca/mysql/data --with-unix-socket=tmp/mysql.sock All on one line. Also how do you set the linux box (suse 7.2) to start mysql on boot up ? SE --localstatedir=/usr/loca/mysql/data SE --withunix-socket-path=/tmp/mysql.sock SE make SE make install Since ~1991, Soviet Union is not the best place to install MySQL. :) Seriously saying, you should better take the binary distribution from MySQL site and install it. Compiling MySQL from source is not as easy as it seems. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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
Bug w. replication slaves
Hi there, I wish to setup replication between a pair of mysql servers. However since my slave only has an ADSL connection to the master I want to compress the data between them. A small wrapper around zlib does this for me. My slave mysql must therefore connect to a port on the local machine that will connect onto the real master. However... if you put master-host=localhost into my.cnf then mysql tries to use the /tmp/mysql.sock. Fair enough. Putting master-host=ip address of local server, master-port=12345 however also tries to use the /tmp/mysql.sock. This should clearly not happen unless BOTH master-host and master-port match the server that has the socket. Given that a client presumably can't tell whether the socket is for the same mysqld process as some host,port combo I would suggest that automatic switching to the socket should only be used for localhost (127...) ip addresses. I've not looked into the sources yet to see whether theres some other obscure option to do what I'm trying to achieve but will do later (unless someone tells me about it first!). I'll probably produce a patch (and post it here) for the above behavior. Regards, Chris -- Chris Wilson [EMAIL PROTECTED] http://www.wapmx.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: starting mysql deamon
Tried that , but I used the source to compile , and put it into /usr/local/mysql So every thing is diffrent. Haveing relied on YaST I do not know how to do it manualy , where and what files to edit. I came from the windows world an jumpt on to linux back during suse 5.1 days. Tells you how good suse/yast is. Its come along a lot. --- Matthew Walker [EMAIL PROTECTED] wrote: Use YaST to edit your configuration file. Scroll down to 'start_mysql', and set it to 'yes'. Hit F10, and wait while it reconfigures things. Enjoy. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Samy Elashmawy [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 11:17 AM To: [EMAIL PROTECTED] Subject: starting mysql deamon How do you start mysql autamaticaly on boot up ? Am running suse 7.2 linux with mysql installed to /usr/loca/mysql Thanks Samy __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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: Trouble in unsubscribing
Hi all, there must be some kinds of technical difficulties as I'm also not able to unsubscribe at the moment. At 14:28 29.01.02 +, you wrote: could you be subscribed under two (or more) email addresses? Peter -Original Message- From: Yuxia Li [mailto:[EMAIL PROTECTED]] Sent: 29 January 2002 06:15 To: [EMAIL PROTECTED] Subject: Re: Trouble in unsubscribing Hi: Does anyone know how to unsubcrib from sql mailing list? I tried twice a few days ago but still getting emails. I even receieved a confirm which told me my email has been removed from the mysql list after I unsubcribed. My mail box can't stand for getting too many emails a day. Thanks a lot! helen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel:+49 (0)221 - 2949 154 fax:+49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site Linux is like a wigwam. No gates, no windows but an apache inside - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using LIMIT to select random rows
Hi! Ulf == Ulf Harnhammar [EMAIL PROTECTED] writes: Ulf On Sun, 27 Jan 2002, Michael Widenius wrote: One way to do this is to do as follows: SELECT something FROM sometable WHERE somevar=somevalue ORDER BY RAND() LIMIT 10 Ulf OK. I still think that my extended LIMIT syntax would be a good idea, Ulf because ORDER BY RAND() does not seem to be very fast. If you want to have a true random order of rows, MySQL must first find all the rows that matches the where clause. Compared to that, the speed of ORDER BY and LIMIT is normally neglectable! (MySQL do also optimize ORDER BY combined with LIMIT fairly well) Ulf I tried adding a field that numbers all instances of a certain ID (this Ulf probably breaks some normalization rule). This way I could simulate what Ulf things would be like with an extended LIMIT syntax. This SQL statement: Ulf SELECT varWord FROM dictionaryword WHERE intTypeID='11' AND Ulf (intTypeCounter26) Ulf executed a lot faster than: Ulf SELECT varWord FROM dictionaryword WHERE intTypeID='11' ORDER BY RAND() Ulf LIMIT 25 The queries are not comparable as the second query will have to first retrieve all the rows, not just those that has been previously marked. Another thing is that the second query will every time return a different set of rows, which is probably what you want in the first place. Ulf Thus, I still think it would be a good idea to be able to say: Ulf SELECT COUNT(*) AS greve FROM dictionaryword WHERE intTypeID='11' Ulf and then: Ulf SELECT varWord FROM dictionaryword WHERE intTypeID='11' LIMIT number1,1, Ulf number2,1,number3,1,number4,1,.. Which would in almost all cases be much slower than doing ORDER BY RAND. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(Sort of ) replication issue
David, Monday, January 28, 2002, 10:43:38 PM, you wrote: DS REALFROM: David Shields [EMAIL PROTECTED] DS HOUR: 2002012901 DS You wrote: DS What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html DS for more info about mysqldump. DS well, no, not really : DS site1 - has apache / php / mysql + database x DS site2 - has apache / php / mysql + database y DS site3 - has apache / php / mysql + database z DS at 9:00 am all databses (x,y,z) are same. DS during day, people at 1 update x, people at 2 update y, people at 3 update z. DS at (say) 23:00 , I want to put all x's changes into y and z, all y's DS changes into x and z, all z's changes into x and y. mysqldump x x.dmp mysqldump y y.dmp mysqldump z z.dmp DS would require that i then do a diff of x, y and apply all diffs to x, DS all diffs to y ... and so on - it looks like an over-engineered solution DS to me. What I was asking is whether replication would ease my pain. I think, replication in any form is not a solution for you in this case. You have to think hard what you want from the database and which data and what changes should be done by various people on various databases. That's a software design question, not MySQL's one. Why don't you run all these sites using one MySQL server? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: InnoDB help !!
Chetan, Tuesday, January 29, 2002, 4:06:30 PM, you wrote: CL thanks for your quick reply !! CL that's fine !! I have done the max.RPM installation part. CL but what is fix up the startup scripts so that CL binary will be the one started. CL When I am trying show variables like have_%; CL +---+---+ CL | Variable_name | Value | CL +---+---+ CL | have_bdb | NO| CL | have_gemini | NO| CL | have_innodb | NO| CL | have_isam | YES | CL | have_raid | NO| CL | have_openssl | NO| CL +---+---+ CL 6 rows in set (0.00 sec) CL It's not showing innoDB support. Ideally it should show after installing CL the max.RPM. shouldn't it ?? CL Please, help me as much you can !! I have been stuck at this place. Did you run mysqld-max after installation? If you don't have my.cnf, create it in /etc Specify configuration parameters in my.cnf. You can find startup information at: http://www.mysql.com/doc/I/n/InnoDB_start.html CL Chetan Lavti -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Cannot connect
I am a new user to MySQL. The server is running, but I keep getting the following error: Host 'www.usapa.army.mil' is not allowed to connect to this MySQL server. When I enter the mysqladmin version command, I get the following: mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.47 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 14 min 29 sec Threads: 1 Questions: 3 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.003 Why am I getting Host is not allowed to connect? CHARLES PALMER Automation Support Branch US Army Publishing Agency Comm - (703) 428-0562 DSN - 328-0562 Fax - (703) 325-6737 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slaves (bin-logs?) do not respect --lines-terminated-by switch of mysqlimport
Description: slaves does not honore the mysqlimport --lines-terminated-by='\n\n' switch How-To-Repeat: i've set up two machines as master - slave. i start out with a running replication in a sane state. now i do on the master: mysql -e ' drop table TOR5; create table TOR5 ( lx_company INT NOT NULL, lx_type INT NOT NULL, request_min INT NOT NULL, request_texts tinytext NOT NULL, INDEX (lx_company), INDEX (lx_type), INDEX (request_min));' mysqlimport --lines-terminated-by='\n\n' TOR5 sdb.TOR5: Records: 6488 Deleted: 0 Skipped: 0 Warnings: 8 using input like this (tab-separated) 8-- 826 11811263601 Analogplatine mit wand komlett/ Best.-Nr.: 3450 246/7 Analogplatine komplett mit wand #3450246-7 147248441263611 Akku 6V 1,2Ah f=FCr Netzteil brille 797 35031263701 Kapsulotomiespitze Nr.:VE 201726 Kapsulotomiespitze VE 201726 Oertli-Spitzen VE 201726 Kapsolutomie-Spitze VE201726 8-- and this is what i get: on the master: mysql select count(*) from TOR5; +--+ | count(*) | +--+ | 6488 | +--+ and on the slave: mysql select count(*) from TOR5; +--+ | count(*) | +--+ |13966 | +--+ for the example above on the master: mysql select * from TOR5 where request_min=1263701; ++-+-+-+ | lx_company | lx_type | request_min | request_texts | ++-+-+- |797 |3503 | 1263701 | Kapsulotomiespitze Nr.:VE 201726 Kapsulotomiespitze VE 201726 Oertli-Spitzen VE 201726 Kapsolutomie-Spitze VE201726 | ++-+-+-+ 1 row in set (0.01 sec) and the slave: mysql select * from TOR5 where request_min=1263701; ++-+-+--+ | lx_company | lx_type | request_min | request_texts| ++-+-+--+ |797 |3503 | 1263701 | Kapsulotomiespitze Nr.:VE 201726 | ++-+-+--+ 1 row in set (0.00 sec) the slave does not honore multiline records, but read each line as a separate record and create thousands of rows like that: mysql select * from TOR5 where lx_company 1 limit 3; ++-+-+---+ | lx_company | lx_type | request_min | request_texts | ++-+-+---+ | 0 | 0 | 0 | | | 0 | 0 | 0 | | | 0 | 0 | 0 | | ++-+-+---+ Fix: Submitter-Id: Originator:kai uwe tempel Organization: university leipzig MySQL support: none Synopsis: slaves (bin-logs?) do not respect --lines-terminated-by switch of mysqlimport Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.47 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.47-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 20 hours 39 min 45 sec Threads: 1 Questions: 129 Slow queries: 2 Opens: 27 Flush tables: 2 Open tables: 4 Queries per second avg: 0.002 Environment: System: Linux pc59 2.4.17 #10 Thu Dec 27 09:05:25 CET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jan 28 18:44 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 563068 Jan 25 13:45 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root
Re: installation probems: swap space is insufficient for optimization
Hi Egor, the ./configure --with-low-memory works but I don't understand why the same version of mysql compiles successfully on smaller system with less swap ? There surely can't be a requirement for 500 Megs swap for an ultra 2 and 1.5 Gigs for a starfire ? thanks, -- frank Egor Egorov wrote: Frank, Tuesday, January 29, 2002, 12:33:03 PM, you wrote: FRSE I have an Sun Ultra 2 with 500Megs of swap and I constantly get the FRSE following swap space messages when I try to install mysql-3.23.39. [] FRSE -- FRSE I get the exact same error when trying to compile on a 2.6 starfire FRSE domain with 1.5 Gigs of swap space. FRSE I don't understand this failure as the same version of mysql compiles FRSE (with the same compilers) on lower-end sun4d sun4m systems running FRSE much less swap. FRSE Do I really need to run the --with-low-memory option ?? If you _really_ want to compile by yourself, yes. But we recommend you to run the precompiled binary from MySQL website: http://www.mysql.com/ FRSE -- frank -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting started
At 16:25 +0100 1/29/02, Lutz, Helmuth wrote:
Paul,
thanks for answering. Because of my job I have to succeed this
correspondence from within another location and machine.
Could you please give some more explaination to a bloody guy to Unix and
the terminal like me:
1)
Kill the server (kill -9), bring it back up with -S (skip grant tables)
so that you can reset the root password:
This is Unix I understand. Should the line look like this:
[hlutz:/usr/local/mysql] hlutz% kill -9
Not quite. You must specify a process id (PID). Use ps and grep to find
the MySQL processes. For example:
% ps ax | grep mysql
251 ?? S 0:00.08 sh /usr/local/mysql/bin/safe_mysqld
287 ?? S 0:01.65 /usr/local/mysql/libexec/mysqld
This tells me that I need to kill processes 251 and 287. (If you only
kill mysqld, safe_mysqld will probably just start up a new one.) So the
kill command looks like this, for the PIDs shown above:
% kill -9 251 287
You'll need to run this command either as root (who can kill anything) or
else as the login account used to run the server.
2)
How to bring it back with -S (skip grant tables) ???
Figure out where mysqld is installed (for me, that's
/usr/local/mysql/libexec/mysqld) and invoke it like this (either as
root or as the login account used to run the server):
% /usr/local/mysql/libexec/mysqld -Sg
(As someone else pointed out, the option is -Sg, not just -S.)
3)
UPDATE user SET Password=PASSWORD('new-password')
WHERE User='root' AND Host='localhost';
FLUSH PRIVILEGES;
Is this MySQL. Are this 3 lines 2 commands (because every MySQL command
ends with a ;)
Yes, two SQL statements. Connect to the server (you don't need any
user name or password at this point) to use the mysql database:
% mysql mysql
Should the lines look like this:
[hlutz:/usr/local/mysql] hlutz% UPDATE user SET
Password=PASSWORD('new-password') WHERE User='root' AND Host='localhost';
...MySQL message comes here
[hlutz:/usr/local/mysql] hlutz% FLUSH PRIVILEGES;
...MySQL message comes here
Run those statements from mysql.
Then quit mysql and shut down the server:
% mysqladmin -p -u root shutdown
Enter password: - enter your new password here
Then restart the server however you normally start it.
Thanks, Helmuth
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OS X still can't stop mysqld without sure kill
I compiled mysql 3.23.47 from source and still can't shutdown the daemon with a mysql.server stop or a simple kill command. Only way to stop it is with a kill -9. I previously installed the precompiled binary and had the same problem. I guess this isn't fully fixed with the .45 version as was posted, though it appears that some of you are not having the problem anymore. So how much potential damage am I doing with a sure kill? I'm running OS X 10.1.2 on an iBook 600. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql web-based admin tool?
I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 PASSWORD function
Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Any clues? John Kemp, Director, Software Development Streetmail Inc. http://www.streetmail.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
replicate-wild-ignore under mutual master-slave relation
Hello, I have two servers under a mutual master-slave relationship. I need to ignore certain databases when replicating. I tried to use replicate-ignore-db but according to the MySQL manual this won't work for cross database updates. The manual suggests using replicate-wild-ignore-table instead. I tested it and it worked fine when making changes to records or tables: Changes in server_A.test_database.table_x don't show in server_B.test_database.table_x which is what I wanted. BUT if I make changes to the database itself (drop it for example), then the database disappears in both servers. I tried a similar test using replicate-wild-do-table and got the same results. Apparently those options only apply to changes in records and tables, not to the database itself. Am I wrong? Is there an option like replicate-ignore-db that will work for cross updates? Thanks in advance. Tony Romo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 web-based admin tool?
Hi, The most widely used tool to reach MySQL over PHP is phpMyAdmin. You can obtain it from http://www.phpwizard.net/projects/phpMyAdmin/ - Original Message - From: Ed Lazor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 5:53 PM Subject: mysql web-based admin tool? I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 web-based admin tool?
Hi, On Tuesday 29 January 2002 16:53, Ed Lazor wrote: I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed Maybe it's phpMyAdmin... http://phpmyadmin.sf.net/ Regards, Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how can i set a password to mysql??
admin, Tuesday, January 29, 2002, 4:38:56 PM, you wrote: bashmysqladmin -u root ? Find your answers at: http://www.mysql.com/doc/D/e/Default_privileges.html and at: http://www.mysql.com/doc/G/R/GRANT.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Cannot connect
Palmer, Tuesday, January 29, 2002, 5:19:00 PM, you wrote: Peoen I am a new user to MySQL. The server is running, but I keep getting the Peoen following error: Peoen Host 'www.usapa.army.mil' is not allowed to connect to this MySQL Peoen server. [] Peoen Why am I getting Host is not allowed to connect? You can find more info about connecting to the MySQL Server if you look at: http://www.mysql.com/doc/C/o/Connecting.html Check your privileges. If you have problems with privileges you can get some more info at: http://www.mysql.com/doc/G/R/GRANT.html or http://www.mysql.com/doc/A/c/Access_denied.html Peoen CHARLES PALMER -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: MySQL PASSWORD function
In the last episode (Jan 29), John Kemp said:
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
The algorithm is in the sql/password.c file.
Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
that we're trying to implement role-based security using our existing
MySQL table of users, accessed via Java Servlet auth functions, which
can read the User table through JDBC. BUT they don't know anything
about PASSWORD-encrypted passwords, so I need to write something that
hashes the password entered in the same way MySQL hashes a password (or
abandon the use of servlet auth :-)
Just have mysql do it:
select (PASSWORD('thepassword') = password) from user where user='theuser';
will return 1 if 'theuser's password is 'thepassword', and 0 otherwise.
--
Dan Nelson
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL PASSWORD function
John Kemp writes: Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Any clues? John Kemp, Director, Software Development Streetmail Inc. http://www.streetmail.com Hi! We use our own hash algorithm with usage of salt. Take a look at sql/password.c ... -- 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: mysql web-based admin tool?
Phpmyadmin is pretty good for what you ar elooking for. You can find it at: http://www.phpwizard.net/projects/phpMyAdmin/ Gurhan -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:54 AM To: [EMAIL PROTECTED] Subject: mysql web-based admin tool? I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
R: mysql web-based admin tool?
You could find a useful tool at http://www.phpwizard.net/projects/phpMyAdmin/ Hy Moreno -Messaggio originale- Da: Ed Lazor [mailto:[EMAIL PROTECTED]] Inviato: martedi 29 gennaio 2002 16.54 A: [EMAIL PROTECTED] Oggetto: mysql web-based admin tool? I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL +VCS?
Has anyone on this list used Veritas Cluster Server to build an HA MySQL solution? If so, please email me. I am in the process of attempting to do this. So far, I have been able to deal well with the hardware agents (network, disk, nfs, cpu). However, when it comes to creating software agents for MySQL, I am struggling. If anyone (even those who haven't attempted this) has any ideas for software agents, please respond. Thanks Shon Stephens [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql web-based admin tool?
Ed, Have you checked out phpMyAdmin? It can be downloaded at: http://phpwizard.net/projects/phpMyAdmin/ I use it with all my clients and it's great! For when I want a bit more control I Telnet, but most of the time I use this to help my with my databases. I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- John McConnell Narwhal Design 126 Covered Bridge Road North Ferrisburgh, VT 05473 802.425.7037 [EMAIL PROTECTED] http://www.narwhaldesign.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: MySQL PASSWORD function
I think mysql uses the system crypt() function. This is, no-doubt, available through some well hidden Java class. Just do man crypt to learn about crypt(). Chris On Tue, 29 Jan 2002 10:59:55 -0500 John Kemp [EMAIL PROTECTED] wrote: Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Any clues? John Kemp, Director, Software Development Streetmail Inc. http://www.streetmail.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 -- Chris Wilson [EMAIL PROTECTED] http://www.wapmx.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help with setting up the JDBC driver
Billy, Where is the source code you are trying to compile located? Is it same as where you keep your .jar file? If not, give java_home/jre/lib/ext path to javac as an -classpath option ... The drivers don't know where to find the databases.. Your program specifies them the server IP, username, password, etc. for connection. Gurhan -Original Message- From: Billy Bob [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: Help with setting up the JDBC driver I am trying to install the jdbc driver to work with MySQL. I have added the file: mm.mysql-2.0.8-bin.jar to the directory: java_home/jre/lib/ext. The problem is when I run my class i get a class not found error even though the mm.mysqlbin.jar is in the lib/ext directory. What am i doing wrong? There are no spelling errors etc. Adding the jar to my classpath messes up running java at all. Please help. Also, how does the JDBC driver know where to find MySQL on my computer? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL PASSWORD function
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
that we're trying to implement role-based security using our existing
MySQL table of users, accessed via Java Servlet auth functions, which
can read the User table through JDBC. BUT they don't know anything
about PASSWORD-encrypted passwords, so I need to write something that
hashes the password entered in the same way MySQL hashes a password (or
abandon the use of servlet auth :-)
Any clues?
How about using the PASSWORD function directly?
SELECT PASSWORD('thepassword'), Password
FROM user
WHERE User='username';
-- if they match, the unencrypted password matches.
Alternatively,
SELECT PASSWORD('thepassword')=Password
FROM user
WHERE User='username';
will return 1 on a match, 0 on non-match (watch out for
nonexisting usernames).
/ 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
Lost Data #2
{ Am I to assume there is no solution to my problem? }
Greetings,
I have two large tables in a database with a few million entries. There is only one
column in each table.
Everything was working okay until today. The size of the table files is 1gb+ but
PHPMyAdmin says it has no records.
When I try to export 200,000 of the contents to a text file:
mysql select * from tbl_name limit 0,20 into outfile outfilename.txt;
It takes a couple minutes of processing but the resulting file is still 0k in size.
PHPMyAdmin still says 0 records. But the table files are huge - 800mb to 1gb.
Before I noticed this, I transferred the tables to another computer with MySQL
installed. It took a long time to transfer so I know the file really was huge. But
now on both computers the results are the same - no records.
I ran:
mysqlcheck table tbl_name;
and it says that it's fine.
mysqlrestore table tbl_name;
Only takes the 1gb table files and turns them into 10k files, still no records.
Thankfully I have a backup on the other computer now that the table files are 10k.
The other computer still has the 1gb files.
Is there any way to restore this data??? This happened suddenly with two different
tables, at the same time. They were the two largest tables in the database - other
unaffected tables are smaller.
Thank you,
- Scott Wang
[EMAIL PROTECTED]
http://www.scottscomputing.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
Advice
Hi Guys I've been using MySQL for a few years now, but always on medium sized projects. I think the biggest thing I ever did has maybe 200k records in it. Now all of a sudden I have a client with a requirement for a database that we estimate will be in the range of 1 to 4 TERABYTES of data... Now this data is largely static (though there will be a few updates and some insertions) non-transactional, and needs to be searched on several indexes. Furthermore its image data, plus metadata (which the searching is done on). Anyone have experience with this kind of application? Is MySQL going to handle it? What are the upwards limits on scalability? Ideally from a system design perspective I'd like to have ALL the data in the database itself and in a single set of tables. Unfortunately the images themselves are up to 10 megs each. Is it even POSSI BLE to use blobs in that context? I know someone is going to suggest putting the image data outside the database, but for various reasons I consider that a last resort, not the least of which is security requirements are so high that running other protocols to access data thats outside tables is problematic. I'd love to hear about other's experience in this area. Thanks ahead of time :o). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Source Install / Config problems
Samy, Tuesday, January 29, 2002, 4:54:24 PM, you wrote: SE ./configure --prefix=/ussr/loca/mysql SE SE Typo I used /usr/local/mysql SE To make a long stroty short , I downloaded the source SE rpm and started over , now I have the mysql.sock file. SE Looks like the download was currupt. I nned to use the SE sourcee as I am compliling some other stuff as SE well. Ist want to get a good compile first. But I strongly suggest you NOT to compile MySQL with yourself. It's much better and more reliable to get the binary distribution from http://www.mysql.com. SE ./configure --prefix=/usr/local/mysql \ SE --localstatedir=/usr/loca/mysql/data \ SE withunix-socket-path=/tmp/mysql.sock SE Note the back slash at the end. Whats the back slash SE for ? It is to ignore the line break in shell. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: installation probems: swap space is insufficient for optimization
Frank, Tuesday, January 29, 2002, 5:30:33 PM, you wrote: FRSE the ./configure --with-low-memory works but I don't FRSE understand why the same version of mysql compilesFRSE successfully on smaller system with less FRSE swap ? God knows. Compiling such a complicated system like MySQL is tricky anyway. FRSE There surely can't be a requirement for 500 Megs swap FRSE for an ultra 2 FRSE and 1.5 Gigs for a starfire ? General requirement for swap file for Unix OS = (RAM * 2)... So if you have 256mb RAM I'd suggest you to put 500mb swapfile.. FRSE -- frank -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: MySQL Clients Hang
--On Tuesday, January 29, 2002 2:08 AM -0600 Ed Carp [EMAIL PROTECTED] wrote: What seems to be happening is that the open of the db hangs. So, when you attempt to connect with a client, mysql tries to look at the grant tables and hangs waiting for access. This is just a guess though. When you connect with a client, mysql_real_connect opens a socket to the server, does the handshaking, then authenticates and passes the query info. When I connect, I don't get anything, and gdb says the client is hung in one of the net_read routines, which makes sense - the client is waiting for something from the server. Yes, exactly. To authenticate you it has to consult the grant tables, i.e. the tables in the mysql db. It has to open those files. I never see the file opens. Is this a MySQL issue or not? I'm not sure - I just downloaded MySQL-3.23.47-1.i386.rpm and installed it (this is supposedly the static version of the server, no?) and it gave me exactly the same result, which if it was a Linux issue, it shouldn't react the same, since it was linked statically, so I'm leaning towards it being a MySQL issue of MySQL not handling an error condition properly. Yes, I think it is a mysql issue in that the mysql server does not respond. It is likely that in both of our situations something has changed in the environment to make the server go catatonic. I just can't figure out what it is and mysql is not helping me figure it out at all. No error message, no core, no nothing. Bill +--- | Bill MacAllister | Senior Programmer, Pride Industries | 10030 Foothills Blvd., Roseville CA 95747 | Phone: +1 916.788.2402Fax: +1 916.788-2540 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Possible Index problem?
I am using mysql verison 3.23.41-nt I am working with the following two tables. mysql show create table table1; | Table | Create Table - | table1 | CREATE TABLE `table1` ( `Column1` varchar(63) NOT NULL default '', `Column2` varchar(31) default NULL PRIMARY KEY (`Column1`) ) TYPE=MyISAM | mysql show create table table2; | Table | Create Table -- | table2 | CREATE TABLE `table2` ( `Column1` varchar(63) default NULL KEY `idx1` (`Column1`) ) TYPE=MyISAM | ++ 1) When i run the first query through explain the expected results happen mysql explain SELECT table1.column1 FROM table1, table2 WHERE table1.column1 = table2.column2; +-+---+---+-+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+---+-+ | table1 | index | PRIMARY | PRIMARY | 63 | NULL | 57379 | Using index | | table2 | ref | idx1 | idx1| 64 | table1.column1| 1 | Using index | +-+---+---+-+-+---+---+-+ However, when i select an additional column, the following unexpected results happen mysql explain SELECT table1.column1, table1.column2 FROM table1, table2 WHERE table1.column1 = table2.column2 +-+--+---+--+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+---+-+ | table1 | ALL | PRIMARY | NULL |NULL | NULL | 57379 | | | table2 | ref | idx1 | idx1 | 64 | table1.column1| 1 | Using index | +-+--+---+--+-+---+---+-+ 2) Also, look at the following scanario mysql explain SELECT table1.column1 FROM table1, table2 WHERE table1.column1 = table2.column2 order by table1.column1 asc; +-+---+---+-+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+---+-+ | table1 | index | PRIMARY | PRIMARY | 63 | NULL | 57379 | Using index | | table2 | ref | idx1 | idx1| 64 | table1.column1| 1 | Using index | +-+---+---+-+-+---+---+-+ However, when i select an additional column, the following unexpected results happen mysql explain SELECT table1.column1, table1.column2 FROM table1, table2 WHERE table1.column1 = table2.column2 order by table1.column1 asc +-+--+---+--+-+---+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+---++ | table1 | ALL | PRIMARY | NULL |NULL | NULL | 57379 | Using filesort | | table2 | ref | idx1 | idx1 | 64 | table1.column1| 1 | Using index| +-+--+---+--+-+---+---++ I am baffled as to why simple selecting an extra column results in the index no longer being used even though the where clause has not changed. If anybody could provide me an explain as to why this is occuring with a solution, it would be greatly appreciated. TIA __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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: [NEWBIE]Can't run mysql client
mysql must be in your PATH. Is it? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 8:30 AM To: [EMAIL PROTECTED] Subject: [NEWBIE]Can't run mysql client Stephane, Monday, January 28, 2002, 1:29:40 PM, you wrote: SP I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box. SP Everything seems to be OK (the server runs) but I cannot connect to it using SP mysql client: SP When I enter mysql -u etc... SP I've got a bash: mysql: command not found SP Any idea ? Are you sure you have installed ALL packages that MySQL consist of ? Please be sure that MySQL-client package is installed. SP Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Advice
Tod Harter writes: Hi Guys I've been using MySQL for a few years now, but always on medium sized projects. I think the biggest thing I ever did has maybe 200k records in it. Now all of a sudden I have a client with a requirement for a database that we estimate will be in the range of 1 to 4 TERABYTES of data... Now this data is largely static (though there will be a few updates and some insertions) non-transactional, and needs to be searched on several indexes. Furthermore its image data, plus metadata (which the searching is done on). Anyone have experience with this kind of application? Is MySQL going to handle it? What are the upwards limits on scalability? Ideally from a system design perspective I'd like to have ALL the data in the database itself and in a single set of tables. Unfortunately the images themselves are up to 10 megs each. Is it even POSSI BLE to use blobs in that context? I know someone is going to suggest putting the image data outside the database, but for various reasons I consider that a last resort, not the least of which is security requirements are so high that running other protocols to access data thats outside tables is problematic. I'd love to hear about other's experience in this area. Thanks ahead of time :o). Hi! A number of our registered customers has database of that size. But in order to optimise things, I do not think it is wise to store such huge images in tables. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost Data #2
Scott -
I recently had a similar problem with a JSP application I built using MySQL
on the backend.
Don't know what the issue is/was but I did notice that if I was updating
rows in a table on a regular basis - PHPmyAdmin 2.2 says I have a lot of
overhead in the table. I'm not sure what is causing the problem but I
think when the overhead reaches a limit - it dumps data in the row or
table. I can't say for sure- but I think overhead had something to do with
it. I'm still looking for a workaround.
In the meantime - a back-up is smart
Mark
-Original Message-
From: Scott Wang [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, January 29, 2002 10:35 AM
Subject: Lost Data #2
{ Am I to assume there is no solution to my problem? }
Greetings,
I have two large tables in a database with a few million entries. There is
only one column in each table.
Everything was working okay until today. The size of the table files is
1gb+ but PHPMyAdmin says it has no records.
When I try to export 200,000 of the contents to a text file:
mysql select * from tbl_name limit 0,20 into outfile
outfilename.txt;
It takes a couple minutes of processing but the resulting file is still 0k
in size. PHPMyAdmin still says 0 records. But the table files are huge -
800mb to 1gb.
Before I noticed this, I transferred the tables to another computer with
MySQL installed. It took a long time to transfer so I know the file really
was huge. But now on both computers the results are the same - no records.
I ran:
mysqlcheck table tbl_name;
and it says that it's fine.
mysqlrestore table tbl_name;
Only takes the 1gb table files and turns them into 10k files, still no
records.
Thankfully I have a backup on the other computer now that the table files
are 10k. The other computer still has the 1gb files.
Is there any way to restore this data??? This happened suddenly with two
different tables, at the same time. They were the two largest tables in the
database - other unaffected tables are smaller.
Thank you,
- Scott Wang
[EMAIL PROTECTED]
http://www.scottscomputing.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyCC 0.8.1 is released
Hi! MySQL Control Center (MyCC) is the new GUI client for MySQL databases. MyCC is developed and provided by MySQL AB - a commercial company that builds its business providing services around the MySQL database. MyCC is a platform independent graphical client which is based on Trolltech's QT toolkit. Currently source code as well as Linux static and Win32 binaries are provided. Compiling MyCC for other platforms should not require too much effort as long as MySQL QT compile properly. All users are recommended to upgrade to the latest version. MyCC 0.8.1 includes several bug-fixes and enhancements. Changes in release 0.8.1-alpha -- * MyCC now has support for Adding, Removing and Modifying users. * Updated the Spanish Translation File. * Several Minor bug fixes. * Fixed a bug that crashed Win9X / ME platforms * MyCC is now compatible with MySQL 3.22 * All non-working features are now disabled. * Better Memory Management. * Loading many tables now takes a lot less time. * All icons are now cached to provide better performance. * Fixed an bug in the Database Tree view. * Optimized several parts of the code. * Added Table retrieval method option in the server registration dialog. * Added 'Test Connection' in the server registration dialog. Please send comments / bug-reports and feature-requests to [EMAIL PROTECTED] You can download the latest version from: http://www.mysql.com/downloads/gui-mycc.html Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ 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
Error
Hi, I'm brasiliam, so.. my english is very bad I'm a error: Warning: Host 'fire1.uniube.br' is not allowed to connect to this MySQL server Tanks Joabe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
show table status
Hi, my problem is that when i do a show table status like al% one of my innodb tables (named 'aluno') says to have 255 rows. But, in fact, it have 286 rows, by: select count (*) from aluno; Someone can help me ? __ Quer ter seu próprio endereço na Internet? Garanta já o seu e ainda ganhe cinco e-mails personalizados. DomíniosBOL - http://dominios.bol.com.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Advice
On Tuesday 29 January 2002 12:40, Sinisa Milivojevic wrote: Tod Harter writes: Hi Guys I've been using MySQL for a few years now, but always on medium sized projects. I think the biggest thing I ever did has maybe 200k records in it. Now all of a sudden I have a client with a requirement for a database that we estimate will be in the range of 1 to 4 TERABYTES of data... Now this data is largely static (though there will be a few updates and some insertions) non-transactional, and needs to be searched on several indexes. Furthermore its image data, plus metadata (which the searching is done on). Anyone have experience with this kind of application? Is MySQL going to handle it? What are the upwards limits on scalability? Ideally from a system design perspective I'd like to have ALL the data in the database itself and in a single set of tables. Unfortunately the images themselves are up to 10 megs each. Is it even POSSI BLE to use blobs in that context? I know someone is going to suggest putting the image data outside the database, but for various reasons I consider that a last resort, not the least of which is security requirements are so high that running other protocols to access data thats outside tables is problematic. I'd love to hear about other's experience in this area. Thanks ahead of time :o). Hi! A number of our registered customers has database of that size. But in order to optimise things, I do not think it is wise to store such huge images in tables. What would be the performance considerations? Considering it theoretically if I (for instance) set things up so that I had an ftp server for the images and stored filenames in a column then as far as raw data transfer efficiency its tcp either way. I guess the question becomes one of how does the database deal with blobs internally? Given that the data is images its essentially opaque data to the RDBMS (ie there would never be any reason to search the blob columns themselves, just recover them based on searches of other indexes). I guess the other related question with indexes is how big a deal is it to have such huge indexes? In a practical sense its one data set, so I really would like to have indexes covering the whole thing. The number of records runs up into the low millions. Queries will need to be done on maybe up to 4 or 5 columns in that data set. Can I expect a query like that to complete in a time frame of under 1 minute? What kind of hardware would be recommended to get that sort of performance? We will be building out the entire system, so essentially its up to us to define that. I'd considered something in the order of a top of the line dual processor Pentium 4 class system with a couple of SAN boxes and fibre channel. I expect its no challenge to throw a few gigs of ram at it, but naturally there is NO way to put enough ram in a box to even come close to holding complete indexes... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT: Calculating resources
Hi everybody! I am developing a site under PHP and Mysql which is now in the first steps. My question is, (since I don't administer the server), how can I calculate the resources that the system will need to run as smothly as possible? I mean, for example I am planning to use temporary table to gather subsets of data from a big table but I don't know how many temporary tables can I create at the same time, and not crashing the server in the process. Which configuration should I ask the administrator to meet from the point of view of the server features? If someone can give me a hint, i´ll be absolutely happy! Thanx in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Advice
Tod Harter writes: What would be the performance considerations? Considering it theoretically if I (for instance) set things up so that I had an ftp server for the images and stored filenames in a column then as far as raw data transfer efficiency its tcp either way. I guess the question becomes one of how does the database deal with blobs internally? Given that the data is images its essentially opaque data to the RDBMS (ie there would never be any reason to search the blob columns themselves, just recover them based on searches of other indexes). I guess the other related question with indexes is how big a deal is it to have such huge indexes? In a practical sense its one data set, so I really would like to have indexes covering the whole thing. The number of records runs up into the low millions. Queries will need to be done on maybe up to 4 or 5 columns in that data set. Can I expect a query like that to complete in a time frame of under 1 minute? What kind of hardware would be recommended to get that sort of performance? We will be building out the entire system, so essentially its up to us to define that. I'd considered something in the order of a top of the line dual processor Pentium 4 class system with a couple of SAN boxes and fibre channel. I expect its no challenge to throw a few gigs of ram at it, but naturally there is NO way to put enough ram in a box to even come close to holding complete indexes... Hi! You should go by the book. Normalize schema, optimise queries, tune MySQL etc .. Choose right hardware, system software etc ... You can expect it to complete in a second if you have followed the above guidelines. -- Consider taking our support. Visit https://order.mysql.com 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
AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting started
Paul, I do not know why, but it did not work. Please see yourself: This lines I could not copy and paste because the results are on a not connected Mac and this is a windows machine. So I had to write it by hand (- but looked 2 times at the text) Your example: % ps ax | grep mysql 251 ?? S 0:00.08 sh /usr/local/mysql/bin/safe_mysqld 287 ?? S 0:01.65 /usr/local/mysql/libexec/mysqld Figure out where mysqld is installed (for me, that's /usr/local/mysql/libexec/mysqld) and invoke it like this (either as root or as the login account used to run the server): % /usr/local/mysql/libexec/mysqld -Sg --- mysqld is listed in /usr/local/mysql/bin. My results: --- [localhost:/usr/local/mysql] hlutz% ps ax | grep mysql 255 ?? S 0:00.17 sh ./bin/safe_mysqld 298 ?? S 0:01.09 /usr/local/mysql/bin/mysqld 358 ?? S+ 0:00.01 grep mysql --- I ran it a second time to explore: [localhost:/usr/local/mysql] hlutz% ps ax | grep mysql 255 ?? S 0:00.17 sh ./bin/safe_mysqld 298 ?? S 0:01.09 /usr/local/mysql/bin/mysqld 358 ?? R+ 0:00.00 grep mysql [localhost:/usr/local/mysql] hlutz% su root Password: [localhost:/usr/local/mysql] root# kill -9 255 298 [localhost:/usr/local/mysql] root# cd I do not know why I changed the directory but I think it should not be the problem [localhost:~] root# /usr/local/mysql/bin/mysqld -Sg Fatal error: Please read security section of the manual to find out how to run mysqld as root! 020129 18:45:15 Aborting 020129 18:45:15 /usr/local/mysql/bin/mysqld: Shutdown Complete I changed the user and ran it a second time to explore: [localhost:~] root# su hlutz [localhost:~] hlutz% cd /usr/local/mysql [localhost:/usr/local/mysql] hlutz% /usr/local/mysql/bin/mysqld -Sg /usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/mysql-3.23.46/data/' (Errcode: 13) I think it was wrong when I spoke of 3.23.47 in the mail-reference line!!! 020129 18:47:31 Aborting 020129 18:47:31 /usr/local/mysql/bin/mysqld: Shutdown Complete [localhost:/usr/local/mysql] hlutz% stopped here because it seems not to work properly. --- Can there be anything with the user mysql and the group mysql which I created with the NetInfo Manager? I can not login within the terminal as user mysql (% su mysql). A password is wanted, but I did not set one on OSX level. Can there be anything with accessrights because all files in /usr/local/mysql belong to the group mysql and user mysql and not partly to root (and wheel before - whatever user wheel is). Thanks, Helmuth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error
I m franch a little latin, no u re not an error. see at www.mysql.com if u can found doc into your language have a look at grant / revoke command to make 'fire1.uniube.br' allowed to query the server. GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY password all is too much u can try : ALL PRIVILEGES FILERELOAD ALTER INDEX SELECT CREATE INSERT SHUTDOWN DELETE PROCESS UPDATE DROPREFERENCES USAGE insert,select,update,delete is well - Original Message - From: Joabe Fuzaro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 7:37 PM Subject: Error Hi, I'm brasiliam, so.. my english is very bad I'm a error: Warning: Host 'fire1.uniube.br' is not allowed to connect to this MySQL server Tanks Joabe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help megetting started
At 20:14 +0100 1/29/02, Lutz, Helmuth wrote: Paul, I do not know why, but it did not work. Please see yourself: This lines I could not copy and paste because the results are on a not connected Mac and this is a windows machine. So I had to write it by hand (- but looked 2 times at the text) Your example: % ps ax | grep mysql 251 ?? S 0:00.08 sh /usr/local/mysql/bin/safe_mysqld 287 ?? S 0:01.65 /usr/local/mysql/libexec/mysqld Figure out where mysqld is installed (for me, that's /usr/local/mysql/libexec/mysqld) and invoke it like this (either as root or as the login account used to run the server): % /usr/local/mysql/libexec/mysqld -Sg --- mysqld is listed in /usr/local/mysql/bin. My results: --- [localhost:/usr/local/mysql] hlutz% ps ax | grep mysql 255 ?? S 0:00.17 sh ./bin/safe_mysqld 298 ?? S 0:01.09 /usr/local/mysql/bin/mysqld 358 ?? S+ 0:00.01 grep mysql --- I ran it a second time to explore: [localhost:/usr/local/mysql] hlutz% ps ax | grep mysql 255 ?? S 0:00.17 sh ./bin/safe_mysqld 298 ?? S 0:01.09 /usr/local/mysql/bin/mysqld 358 ?? R+ 0:00.00 grep mysql Looks okay. [localhost:/usr/local/mysql] hlutz% su root Password: [localhost:/usr/local/mysql] root# kill -9 255 298 [localhost:/usr/local/mysql] root# cd I do not know why I changed the directory but I think it should not be the problem Right, it shouldn't. [localhost:~] root# /usr/local/mysql/bin/mysqld -Sg Fatal error: Please read security section of the manual to find out how to run mysqld as root! 020129 18:45:15 Aborting Okay, then try adding the --user=mysql option to the command. 020129 18:45:15 /usr/local/mysql/bin/mysqld: Shutdown Complete I changed the user and ran it a second time to explore: [localhost:~] root# su hlutz [localhost:~] hlutz% cd /usr/local/mysql [localhost:/usr/local/mysql] hlutz% /usr/local/mysql/bin/mysqld -Sg /usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/mysql-3.23.46/data/' (Errcode: 13) I think it was wrong when I spoke of 3.23.47 in the mail-reference line!!! 020129 18:47:31 Aborting 020129 18:47:31 /usr/local/mysql/bin/mysqld: Shutdown Complete [localhost:/usr/local/mysql] hlutz% stopped here because it seems not to work properly. --- Can there be anything with the user mysql and the group mysql which I created with the NetInfo Manager? I can not login within the terminal as user mysql (% su mysql). A password is wanted, but I did not set one on OSX level. Actually, you could do that. First su to root, then as root su to mysql. When you're root you can su to anyone. Can there be anything with accessrights because all files in /usr/local/mysql belong to the group mysql and user mysql and not partly to root (and wheel before - whatever user wheel is). That just indicates that you want to run the server as the mysql user by adding --user=mysql to the mysqld -Sg command. Thanks, Helmuth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: bug in join on bdb table
Carsten Hammer writes: Hi, I just experienced the following bug in tables created as berkeley tables: on bdb tables: mysql SELECT jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name FROM verarbeitung right join jobs on (verarbeitung.verarbeitung = jobs.verarbeitung) order by jobs.number; +++---+--+--+ | number | status | filename | source_file | name | +++---+--+--+ | 1 | 1 | NULL | NULL | NULL | | 2 | 1 | /u/lpqueues/debis/data.40 | /etc/hosts | NULL | | 3 | 1 | /u/lpqueues/debis/data.41 | /etc/hosts | NULL | | 4 | 1 | /pfad/zum/datenfile | DEFSYSM.SAF0006.SAF00066.JOB07513.D103.? | NULL | | 5 | 1 | /pfad/zum/ogottogott | DEFSYSM.SAF0006.SAF00064.JOB07514.D103.? | NULL | +++---+--+--+ 5 rows in set (0.15 sec) Hi! I have tested your report and it works just fine. I get the same results that correspond to the your second result set. I did not use ISAM, but MyISAM though, as this is a table handler that is actively maintained. -- 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: Accessing MySQL Using ASP
- Original Message - From: sdfine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 28, 2002 12:06 Subject: Accessing MySQL Using ASP Does anyone have a good example of accessing and displaying data in a MySQL database using ASP and displaying it on a web page? I'm a VB programmer and I'm new to accessing databases from the web and just need one good example to tie everything together. Thanks Here's a small one off the top of my head. Obviously you will have to set up an ODBC DSN on the web server for this to work. I use MySQL with IIS 5 and ASP all the time and have no problems. % @Language = VBScript % % Response.buffer = true % % Dim conDB' ADODB connection object Dim rsBirthdays' Query recordset Dim strSQL' SQL query ' Create ADODB connection instance Set conDB = Server.CreateObject(ADODB.Connection) ' Create ADODB recordset instance Set rsBirthdays = Server.CreateObject(ADODB.Recordset) ' Open a recordset strSQL = SELECT firstname, lastname, birthday FROM employees order by lastname; rsBirthdays.Open strSQL, conDB % html body table border=1 trthFirst Name/ththLast Name/ththBirthday/th/tr % Do While Not rsBirthdays.EOF % tr td%= rsBirthdays(firstname) %/td td%= rsBirthdays(lastname) %/td td%= FormatDateTime(rsBirthdays(birthday), 1) %/td % Loop % /table /body /html % ' Close recordset rsBirthdays.Close ' Close connection conDB.Close % A. Clausen [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
pb while adding new field to a db ?
Hi all, I hava a mysql database wich contain some country name only country names some a old like USSR ... I have to add some field into this db from the file found at the ripe net ftp.ripe.net file : iso3166-countrycodes.txt see part of this file : Some Codes from ISO 3166 Updated by the RIPE Network Coordination Centre. Source: ISO 3166 Maintenance Agency Latest change: Thu Aug 7 17:59:51 MET DST 1997 Country A 2 A 3 Number -- AFGHANISTAN AF AFG 004 ALBANIA AL ALB 008 ALGERIA DZ DZA 012 AMERICAN SAMOA AS ASM 016 List of changes applied, as specified in registration newsletters: Newsletter III-1, 1989-12-5: Burma deleted, Myanmar added (same numeric value, change of country name) my bd countain field like : country_us, country_de how can I elegantly add the field from the ripe file that I didn't hav into my db ? thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with latest solaris 8 binary distribution?
The tarball seems to be missing libmysqlclient.so, I can get the database server started fine, and can connect to it using client applications. However, any attempt at using the dynamic client libs fails for obvious reasons. Am I missing something? Maybe downloading the wrong tarball? Or do I need to install from source? Thanks, Javier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please Help with Pattern Matching
I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work. mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) Thanks in advance, Douglas -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Pattern Matching Problem
Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entries containing M, W or F. Is there a way to do this? mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) I need to be able to say select schdays from courses where schdays LIKE %schdays% Here is my code from the program: my $sth2 = $dbh-prepare(select id,schdays,time_to_sec(timein),time_to_sec(time out) from courses where schdays LIKE \\%$cschdays\%\ AND done=\Yes\etc.. So I need to be able to match any pattern with $cschdays. Do I need to parse out the letters and pattern match each one?? It should be easier. Thanks, Douglas [EMAIL PROTECTED] -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
making software with mySQL server
Hi all, I want to know how to make software using mySQL as the database server. I'm using SuSE Linux 7.3Pro + KDE 2.2.2 I've open a project in KDevelop 2.0 and put this link -lmysqlclient but I can't go thru: MYSQL mysql Am I missing something else Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Please Help with Pattern Matching
At 14:59 -0500 1/29/02, Douglas Brantz wrote: I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work. It's unclear what you're expecting to happen. From the output of the second query, it looks like only one entry actually has MWF in it. If that's so, why would you expect the first query to return more than one row? Do you mean you want entries that have M *or* W *or* F? mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) Thanks in advance, Douglas -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pattern Matching Problem
At 03:15 PM 1/29/2002 -0500, Douglas Brantz wrote: Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entries containing M, W or F. Is there a way to do this? mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) I need to be able to say select schdays from courses where schdays LIKE %schdays% Here is my code from the program: my $sth2 = $dbh-prepare(select id,schdays,time_to_sec(timein),time_to_sec(time out) from courses where schdays LIKE \\%$cschdays\%\ AND done=\Yes\etc.. So I need to be able to match any pattern with $cschdays. Do I need to parse out the letters and pattern match each one?? It should be easier. I'd do this by doing a pattern match on %M% and then joining it with a pattern match on %W% and then joining it with a pattern match on %F%. I forget which type of join you want, it's the one that is logical-OR. You may wish this was easier (and there may be an easier way of doing it), but the fundamental problem is that you think pattern matching in SQL works differently to how it actually works. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OLE DB Driver for VB App
Is there an OLE DB Provider for MySQL or should I use the Generic ANSI SQL provider (if there are one of those)? Trying to use MySQL as a backend database for a project but performance is slower than using even MS Access - surely there must be a provider out there that blow away at least MS Access! Thank you. Stephen R. Kramer Lead Developer RS Systems - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Please Help with Pattern Matching
Doug, MySql is doing what it is supposed to... If you specify '%MWF%' it will only select the values with the string literal 'MWF' in it. If you would like to match all the rows that have either M or W or F in it, then use a query like : select schdays from courses where schdays LIKE %M% OR LIKE %W% OR LIKE %F%; This will return every row that has either M or W or F in the schdays field. Gurhan -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 2:59 PM To: [EMAIL PROTECTED] Subject: Please Help with Pattern Matching I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work. mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) Thanks in advance, Douglas -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Please Help with Pattern Matching
In the last episode (Jan 29), Douglas Brantz said: I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work. mysql select schdays from courses where schdays LIKE %MWF%; | MWF | mysql select schdays from courses where schdays LIKE %M%; | MWF | | MW | | MW | | M | | M | I see nothing wrong here. Your first statement says give me all rows with the string MWF in schdays. Your second statement says give me all rows with the string M in schdays. If you want all rows with M, W, or F in schdays, you'll want something like WHERE schdays LIKE %M% OR schdays LIKE %W% OR schdays LIKE %F%. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pattern Matching Problem
At 15:15 -0500 1/29/02, Douglas Brantz wrote: Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entries containing M, W or F. Is there a way to do this? Yes, but you can't do it with LIKE except in an ugly way: WHERE schdays LIKE %M% OR schdays LIKE %W% OR schdays LIKE %F% You're better off using regular expressions and the REGEXP operator. Regular expressions allow character classes (match any character listed inside square brackets): WHERE schdays REGEXP [MWF] You could also use alternation, although that's more useful when you're trying to match any of several multiple-character strings: WHERE schdays REGEXP (M|W|F) mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) I need to be able to say select schdays from courses where schdays LIKE %schdays% Here is my code from the program: my $sth2 = $dbh-prepare(select id,schdays,time_to_sec(timein),time_to_sec(time out) from courses where schdays LIKE \\%$cschdays\%\ AND done=\Yes\etc.. So I need to be able to match any pattern with $cschdays. Do I need to parse out the letters and pattern match each one?? It should be easier. Thanks, Douglas [EMAIL PROTECTED] -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pattern Matching Problem
SELECT schdays FROM courses WHERE (schdays LIKE M) OR (schdays LIKE W) OR (schdays LIKE F) Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:15 PM To: [EMAIL PROTECTED] Subject: Pattern Matching Problem Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entries containing M, W or F. Is there a way to do this? mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) I need to be able to say select schdays from courses where schdays LIKE %schdays% Here is my code from the program: my $sth2 = $dbh-prepare(select id,schdays,time_to_sec(timein),time_to_sec(time out) from courses where schdays LIKE \\%$cschdays\%\ AND done=\Yes\etc.. So I need to be able to match any pattern with $cschdays. Do I need to parse out the letters and pattern match each one?? It should be easier. Thanks, Douglas [EMAIL PROTECTED] -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/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
Pattern Matching Solved
Paul Dubois helped me on this: Check page 520 of his book. REGEXP [MWF] matches all I need everything inside the [...] (brackets). Thank you again Paul. That problem fixed now moving on to the next one. Douglas -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:24 PM To: Douglas Brantz; [EMAIL PROTECTED] Subject: RE: Please Help with Pattern Matching Doug, MySql is doing what it is supposed to... If you specify '%MWF%' it will only select the values with the string literal 'MWF' in it. If you would like to match all the rows that have either M or W or F in it, then use a query like : select schdays from courses where schdays LIKE %M% OR LIKE %W% OR LIKE %F%; This will return every row that has either M or W or F in the schdays field. Gurhan -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 2:59 PM To: [EMAIL PROTECTED] Subject: Please Help with Pattern Matching I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work. mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) Thanks in advance, Douglas -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Please Help with Pattern Matching
Try this: select schdays from courses where schdays Regexp[MWF]; -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 2:59 PM To: [EMAIL PROTECTED] Subject: Please Help with Pattern Matching I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work. mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) Thanks in advance, Douglas -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Need some easy select assistance
Given this example: table CARS has got an entity Labourghini with car_id=5 table NEWS has got an entity Lambourghini displays new super model with date=2002-05-02, news_id=735 and car_id=5 Now: I want this output: NEWS HEADLINES date: headline (car_brand) Can I do this without 2 select queries? As of now, I would typically first select news, then get the car_id from news and the do a select in the cars table, based on what kind of car_id the news entity returned. This should be pretty straight forward... I hope :) - Torkil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pattern Matching Problem Solved
Thanks to everyone for being so helpful with this solution. Douglas -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:46 PM To: Douglas Brantz; [EMAIL PROTECTED] Subject: RE: Pattern Matching Problem SELECT schdays FROM courses WHERE (schdays LIKE M) OR (schdays LIKE W) OR (schdays LIKE F) Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:15 PM To: [EMAIL PROTECTED] Subject: Pattern Matching Problem Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entri es containing M, W or F. Is there a way to do this? mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) I need to be able to say select schdays from courses where schdays LIKE %schdays% H ere is my code from the program: my $sth2 = $dbh-prepare(select id,schdays,time_to_sec(timein),time_to_sec(time out) from courses where schdays LIKE \\%$cschdays\%\ AND done=\Yes\etc.. So I need to be able to match any pattern with $cschdays. Do I need to parse out the letters and pattern match each one?? It should be easier. Thanks, Douglas [EMAIL PROTECTED] -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 82 8-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pattern Matching Problem
Since the days in a week are not likely to change, why not have an indexed column for each day? For example, select id from courses where day_m = 1 and day_t = 0 and day_w = 1 and day_h = 0 and day_f = 1; Wouldn't this approach be more efficient than a full table scan with regular expression matching on each row? You could add two more columns, days_mwf and days_th, to speed up the common queries. Bret -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:46 PM To: Douglas Brantz; [EMAIL PROTECTED] Subject: RE: Pattern Matching Problem SELECT schdays FROM courses WHERE (schdays LIKE M) OR (schdays LIKE W) OR (schdays LIKE F) Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:15 PM To: [EMAIL PROTECTED] Subject: Pattern Matching Problem Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entries containing M, W or F. Is there a way to do this? mysql select schdays from courses where schdays LIKE %MWF%; +-+ | schdays | +-+ | MWF | +-+ 1 row in set (0.00 sec) mysql select schdays from courses where schdays LIKE %M%; +-+ | schdays | +-+ | MWF | | MW | | MW | | M | | M | +-+ 5 rows in set (0.00 sec) I need to be able to say select schdays from courses where schdays LIKE %schdays% Here is my code from the program: my $sth2 = $dbh-prepare(select id,schdays,time_to_sec(timein),time_to_sec(time out) from courses where schdays LIKE \\%$cschdays\%\ AND done=\Yes\etc.. So I need to be able to match any pattern with $cschdays. Do I need to parse out the letters and pattern match each one?? It should be easier. Thanks, Douglas [EMAIL PROTECTED] -- Douglas R. Brantz Computer Consultant Fine Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need some easy select assistance
At 09:50 PM 1/29/2002 +0100, Torkil Johnsen wrote: Given this example: table CARS has got an entity Labourghini with car_id=5 table NEWS has got an entity Lambourghini displays new super model with date=2002-05-02, news_id=735 and car_id=5 Now: I want this output: NEWS HEADLINES date: headline (car_brand) SELECT date, headline, carname FROM news, cars where news.car_id = cars.car_id - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need some easy select assistance
Given this example:
table CARS
has got an entity Labourghini with car_id=5
table NEWS
has got an entity Lambourghini displays new super model with
date=2002-05-02, news_id=735 and car_id=5
I want this output:
NEWS HEADLINES
date: headline (car_brand)
Can I do this without 2 select queries?
I *believe* what you want is this:
SELECT news.*, cars.{car_name/brand_field}WHERE
cars.car_id = 5 AND
cars.car_id = news.car_id;
Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyCC version 0.0.8 alpha - BUG
I got this address from the MyCC README file. If it is the wrong one, my apologies - could you send me the right one. Description: Starting MyCC on a W2000 native dual monitor PC results in the main window spanning both monitors. Details: Normally, when an application is started on a native dual monitor system, the application should appear entirely within the bounds of one of the monitors, it should not span both. By 'native dual monitor' I mean a system where no special or third-party hardware or drivers are used; the dual monitor support is only provided by the native W2000 multi-monitor support. Installation was normal - no complaints. Installed in c:\bin\mysql\contrib\mycc. System was not re-started after installation. MyCC was started by double-click on desktop icon. Behavior observed on first start. MyCC exited by 'X' icon on right end of main window caption with no intervening operation. Behavior observed on second start. MyCC again exited in same fashion. Behavior observed on third start. Main window sized horizontally only to fit entirely on monitor 1. MyCC exited. Behavior observed on fourth start. Window position on exit not saved or not used on restart. Main window sized both horizontally and vertically. Main window moved both horizontally and vertically. MyCC exited. Behavior observed on fifth start. System: Windows 2000 Professional SP2. Display 1: NVIDIA GeForce 2 MX, AGP, BIOS 3.11.00.18.29. Driver by NVIDIA, version 5.12.10.0650. Resolution 1280x960x32 Display 2: Matrox Mystique PCI, BIOS 1.3-0. Driver by Matrox, (package) version 5.33.006 Resolution 1280x960x32 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need some easy select assistance
Yes it is so easy.. You just need to use table joins.. Check out: http://www.mysql.com/doc/J/O/JOIN.html Gurhan -Original Message- From: Torkil Johnsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:50 PM To: [EMAIL PROTECTED] Subject: Need some easy select assistance Given this example: table CARS has got an entity Labourghini with car_id=5 table NEWS has got an entity Lambourghini displays new super model with date=2002-05-02, news_id=735 and car_id=5 Now: I want this output: NEWS HEADLINES date: headline (car_brand) Can I do this without 2 select queries? As of now, I would typically first select news, then get the car_id from news and the do a select in the cars table, based on what kind of car_id the news entity returned. This should be pretty straight forward... I hope :) - Torkil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB help !!
Hi, On Wed, 2002-01-30 at 00:06, Chetan Lavti wrote: thanks for your quick reply !! that's fine !! I have done the max.RPM installation part. but what is fix up the startup scripts so that binary will be the one started. When I am trying show variables like have_%; +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_gemini | NO| | have_innodb | NO| | have_isam | YES | | have_raid | NO| | have_openssl | NO| +---+---+ 6 rows in set (0.00 sec) It's not showing innoDB support. Ideally it should show after installing the max.RPM. shouldn't it ?? No. In any 3.23 version, the default for all alternate table types is off. You have to explicitly enable them by specifying their configuration parameters. See http://www.mysql.com/doc/I/n/InnoDB_start.html and the rest of the InnoDB chapter in the online manual for configuration details. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: exporting data to a new DB
Hello everyone, I need to export some data from one DB to another. Suppose I'm connected to DB1 and my trying to get stuff from there and insert into DB2. I'm using Insert Select statements. Once I'm connected to DB1, do I have to establish separate connection for DB2? An example Insert Select : Insert into db2.Pad_Analysis_Data (column names) Select * from db1.Pad_Analysis_Data; Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:41 PM To: Demirchyan Oganes-AOD098 Subject: Re: exporting data to a new DB Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello everyone, I need to export some data from one DB to another. Suppose I'm connected to DB1 and my trying to get stuff from there and insert into DB2. I'm using Insert Select statements. Once I'm connected to DB1, do I have to establish separate connection for DB2? An example Insert Select : Insert into db2.Pad_Analysis_Data (column names) Select * from db1.Pad_Analysis_Data; Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT DISTINCT BINARY crashes mysql on null values
Description:
Executing a SELECT DISTINCT statement in conjunction
with the BINARY cast operator will crash MySQL server
when the column being cast contains one or more null
values.
How-To-Repeat:
Executing the following code from a mysql prompt will
cause the MySQL server to crash and restart.
create temporary table wassup (
rowid int not null AUTO_INCREMENT PRIMARY KEY,
col1 varchar(10) null
)
;
insert into wassup
(col1)
values
('aaa'),
('AAA'),
(NULL)
;
select distinct binary col1 from wassup
;
Fix:
Work-arounds: Defining the column as binary during the create
table statement alleviates the need for the binary cast during
selects, and thereby eliminates the crashes. Alternatively,
adding where col1 is not null to the select statement
will also work.
Submitter-Id: submitter ID
Originator:Steve Severance
Organization:
MySQL support: none
Synopsis: SELECT DISTINCT BINARY crashes mysql on null values
Severity: non-critical
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.47 (Official MySQL RPM)
Environment:
System: Linux vexweb1 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Jan 4 16:56 /lib/libc.so.6 - libc-2.2.2.so
-rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so
-rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a
-rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: exporting data to a new DB
At 15:48 -0600 1/29/02, Demirchyan Oganes-AOD098 wrote: Hello everyone, I need to export some data from one DB to another. Suppose I'm connected to DB1 and my trying to get stuff from there and insert into DB2. I'm using Insert Select statements. Once I'm connected to DB1, do I have to establish separate connection for DB2? Not if they're both hosted by the same MySQL server. And if they're not, you can't do this anyway. :-) An example Insert Select : Insert into db2.Pad_Analysis_Data (column names) Select * from db1.Pad_Analysis_Data; Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SELECT DISTINCT BINARY crashes mysql on null values
I tried this on an existing table using a char(50) column with 956 entries,
of which I have 1 valid entry and 954 NULL values. I have 2 records returned
1 = valid entry, 1 = NULL and mysql did not crash.
Is it only when you are using temporary tables? Or have you tried this on
multiple tables to get the same effect?
Neil Silvester
Webmaster
Heat and Control Pty Ltd
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 30 January 2002 7:45 AM
To: [EMAIL PROTECTED]
Subject: SELECT DISTINCT BINARY crashes mysql on null values
Description:
Executing a SELECT DISTINCT statement in conjunction
with the BINARY cast operator will crash MySQL server
when the column being cast contains one or more null
values.
How-To-Repeat:
Executing the following code from a mysql prompt will
cause the MySQL server to crash and restart.
create temporary table wassup (
rowid int not null AUTO_INCREMENT PRIMARY KEY,
col1 varchar(10) null
)
;
insert into wassup
(col1)
values
('aaa'),
('AAA'),
(NULL)
;
select distinct binary col1 from wassup
;
Fix:
Work-arounds: Defining the column as binary during the create
table statement alleviates the need for the binary cast during
selects, and thereby eliminates the crashes. Alternatively,
adding where col1 is not null to the select statement
will also work.
Submitter-Id: submitter ID
Originator:Steve Severance
Organization:
MySQL support: none
Synopsis: SELECT DISTINCT BINARY crashes mysql on null values
Severity: non-critical
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.47 (Official MySQL RPM)
Environment:
System: Linux vexweb1 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Jan 4 16:56 /lib/libc.so.6 -
libc-2.2.2.so
-rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so
-rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a
-rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so
Configure command: ./configure --disable-shared
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--without-berkeley-db --without-innodb --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock
--prefix=/ --with-extra-charsets=complex --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--mandir=/usr/man '--with-comment=Official MySQL RPM'
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
Submit/View images using PHP/MySQL
Hi, Can anyone point me to some good examples of how to add images using PHP 4 (from within a browser) to a MySQL database running on MacOSX, which is already configured working, then display the images by selecting their name or category etc, again within the browser. I also need to restrict the size of the file upload to approx 300kb I found a good example at http://www.weberdev.com but it's a little too cut-down for me! Thanks Mike C -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing data from SQL Server into MySQL
I am in the process of migrating our data from m$ SQL Server to MySQL. I am having a heck of a time trying to figure out how to deal with m$ SQL Server's data type called 'uniqueidentifier'. I have tried very large varchar's and blob's and even longtext but I always get datatype conversion errors when i'm sucking the data across (in Perl, and m$ access) I searched the mailing list archives but didn't find anything useful. I'm hoping someone out there has already jumped this hurtle and can point me in the right direction. Jeremy McNamara, Systems Engineer ISPhone Inc. http://www.isphone.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
next insert id
database,sql,query,table I need to find out what the next value will be in an auto_increment field will be. could someone help me out with the select statement? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
