Re: difference between fixed length tables MyISAM vs. ISAM
On Sun, May 19, 2002 at 06:26:54AM -0700, Henry Hank wrote: Hello All, I recently moved my database from mysql 3.22.29 to 3.23.41, and udated all my tables to MyISAM tables. Under ISAM, I could take the filesize of the ISD table and divide by the record length to get the exact number of records returned by select count(*) from that table (or vise-versa - it always worked). Ah, neat trick. :-) Now with the MyISAM tables, this does not seem to work - the files are always a little larger than the record count multiplied by the record length. Since these are all fixed length tables, where is the extra space comming from? It's not much - about .1% or between .5 and 1.5 megabytes out of a 20 million record fixed-length table. I don't think it is a deleted record space, since (a) very few records are ever deleted, and new inserts happen every 3 seconds and (b) the overage amount is never divisable by the record length. The extra space is probably coming from the fact that MyISAM files have some special bits (or bytes, actually) that it uses to keep track of things. This row header is stored at the beginning of each row in the file. It probably wouldn't be hard to figure out the exact size of the header, but there's at least one part of it (a special bitmask) that depends on the number of columns in your tabe--the more you have, the larger it is. Is there a forumula that will accurately calculate the size of MyISAM fixed-length files? Is there a new overhead associated with myisam tables? Probably, yeah. I just don't know it (yet?). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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 connection handshaking
On Mon, May 20, 2002 at 10:10:04AM +0800, Patrick Hsieh wrote: Hello list, I am planing to write a script to telnet mysql server(port:3306) and try to verify the server status. When I try something like this: home:~ #telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. , 3.23.49-log?m|zn:u`^,Connection closed by foreign host. home:~ # I'd recommend against that. Don't reinvent the wheel. Use the existing C library (or a wrapper around it, like Perl's DBI) to do it. You'll save yourself the hassle of having to adapt your code as the client/server protocol in MySQL changes. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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: MyISAM and innodb
On Thu, May 16, 2002 at 11:45:26AM -0400, adam nelson wrote: I'm finally getting around to working with InnoDB for real :-) Great. Anyway, is there any reason to still use MyISAM on any tables. Of course there is. Concurrency is my biggest problem (Locked tables, etc.). Then for you the anser might be no. My theory is that the tables that wouldn't benefit from converting to InnoDB are so small (5-50 rows?) that I might as well just convert every table for simplicity sake (I have 15 tables, some have 5 records, some 25,000). Can anyone enumerate the reasons not to use InnoDB (besides what's listed at http://www.innodb.com/ibman.html#InnoDB_restrictions) from a performance standpoint? Well, what sort of data volume are you trying to push? And how many concurrent insert/update/deletes do you need? The only reason I see for using myIsam would be a table with extremely high insert rates (web logs, tcp logs, etc.) and very few users (or none). I guess embedded applications might be concerned about the footprint of innodb as well? Right. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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: repication
On Thu, May 16, 2002 at 12:36:31PM -0400, vlady wrote: Hi all, I would like to know how often (delay in sec.) the slave checks the master for new records in the log, and if one can control that . The only delay is caused by the slave running a query and network latency. There's not other built-in delay in MySQL 3.23.xx replication. With MySQL 4.x, things get a bit more interesting. But let's cross that bridge when we come to it. :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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: indexing text fields possible?
On Mon, May 20, 2002 at 04:33:41PM +0200, andy wrote: Thank you Egor for you reply. I did read about indexing text column on the mysql site. So I tryed to index my column like described. After 1 hour, I had to reboot my machine because there was no other way. No other way? You could have killed MySQL. All the cpu was bussy and it seemed to me to be an endless loop. I doubt that it was endless. After rebooting I had to repair the file system (suse72) and tables. There was also a 130 MB tmp file I deleted. So what did I do wrong, or does it just take that long? The table contains about 40 MB of space. How much data are you attempting to index, and how large is your key_buffer? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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: Synchronize only database structures
On Thu, May 16, 2002 at 11:32:48AM -0400, Lance Lovette wrote: I have partitioned my data such that each client has its own database (clientdb1, clientdb2, ... clientdbN). All the databases have the same structure (same tables, columns, etc.). This design works great except for one caveat - when I make a change to the database structure I have to make the same change to all the client databases. Before I roll up my sleeves I thought I'd ask if there is an easy way to synchronize the structure of databases so I can make my changes to clientdb1 and then apply the changes to clientdb2...N. Not really. You'll need to write a Perl/Python/whatever script to automate the process. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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: MyISAM internal algorithms
On Mon, May 20, 2002 at 09:39:52AM -0600, Andrei Cojocaru wrote: I believe mySQL uses B-Trees (not binary trees), that's about all I know :) Right. The indexes are B-Tree structures (until R-Trees appear in 4.1, of course). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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 3.23.44 not using indexes
On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote: [snip] In a case like this (where so many rows are covered by the index) it's not self evident that a table scan is not faster than an index scan. Especially with many users using the key cache at the same time, a table scan is likely to use less resources from the system. x That reminds me. A while back (9 months, maybe), I seem to remember you discussion a re-write of the key cache so that it would use a more locking strategy. Is that supposed to happen in 4.0.x? I don't recall having seen a commit that affected the key cache yet. Thanks! Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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 rollbacks
On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote: Does anyone know where rollbacks are stored for innodb tables? I assume memory since I keep getting a table full error when trying to drop an index. sql,query I'm not exactly sure what you're asking, but the rollback information needs to be stored on disk. Otherwise it cannot recover form a crash. Anyway, I suspect that your problem is that your tablespace is full. Can you try added another file and see if that makes the problem go away? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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
Apache + php + MYSQL
Hi, I have my Database in MYSQL and wanna use PHP on Apache At the starting of the page I have given ?php $query = SELECT * FROM appl; // Establish a connection to the MySQL DBMS $connection = mysql_connect(linuxsrv, sameer, sameer); // Use the rcmms database mysql_select_db(rcmms, $connection); // Run a query through the connection $result = mysql_query($query, $connection); ? I says that mysql_connect Fatal error: Call to undefined function: mysql_connect() in /var/www/html/rcmms/appl.php on line 5 Please advice Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crash Incorrect Database
Hello, My hard drive has just failed on my database server, and I have rebuilt it and copied the data from backups back on to the drive, however mySQL cannot see all of the databases. A 'show databases' shows all of the databases, however 'use DBNAME' says ERROR 1102: Incorrect database name Now I have done a check on each of the tables in one of the 'missing' db's, and the database is still not available. (eg myisamchk -r -e table_name) Can anyone point me in the right direction. (FreeBSD v4.5, mySQL v3.23.49) Kind Regards, 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 escape net m a k i n g t h e n e t w o r k f o r y o u 465b South Road ph 8293 2526 KESWICK SA 5035 fx 8293 2949 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crash Incorrect Database
Stavros, As an absolute last resort try the following... Shutdown mysql first. copy your database backups to a safe place before doing this. Removed all tables first off. Then move the .MYD and .MYI and .frm files for each database. Run mysqladmin and re-create all of the tables again. and leave these tables with no data in them. Copy you backed up tables over the top of these tables in /usr/local/mysql/data (the .MYD and .MYI and .frm files) overwritting the MYD/MYI/frm files. You could even try just copying the MYD and MYI files over the top and skipping the FRM files, as they table form definition files which you;ve just recreated. in fact this could be a better thing to try. Then run myisamchk myisamchk -q -r TABLENAME then Start mysqld normally, all should be fine. Let me know how u go - Original Message - From: Stavros Patiniotis To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 5:21 PM Subject: Crash Incorrect Database Hello, My hard drive has just failed on my database server, and I have rebuilt it and copied the data from backups back on to the drive, however mySQL cannot see all of the databases. A 'show databases' shows all of the databases, however 'use DBNAME' says ERROR 1102: Incorrect database name Now I have done a check on each of the tables in one of the 'missing' db's, and the database is still not available. (eg myisamchk -r -e table_name) Can anyone point me in the right direction. (FreeBSD v4.5, mySQL v3.23.49) Kind Regards, 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 escape net m a k i n g t h e n e t w o r k f o r y o u 465b South Road ph 8293 2526 KESWICK SA 5035 fx 8293 2949 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem in configuring InnoDB tables. Help !
Hello alessio, Tuesday, May 21, 2002, 10:23:54 AM, you wrote: aavi Hi all, aavi I've got a problem in configuring my.ini file for using InnoDB tables. aavi I am using mysql ver. 3.23.49 and winnt ws sp6. aavi I read almost everything from the manual and I was not able to solve the aavi problem.(The problem is the same for both mysqd and mysqld-max-nt) aavi My 'my.ini' file looks as follows: aavi --- aavi [mysqld] aavi basedir=C:\mysql aavi datadir=C:\mysql/data aavi innodb_data_home_dir = C:\idb\data aavi innodb_data_file_path = ibdata1:50M aavi innodb_log_group_home_dir = c:\idb\log aavi innodb_log_arch_dir = c:\idb\alog aavi -- aavi For initialising Innodb I run the mysqld (or mysqld-max-nt) from the DOS aavi prompt. aavi When I use the 'my.ini' file with the lines concerning the InnoDB tables aavi the server does not start and I get the following message in the mysql.err aavi file: aavi - aavi InnoDB: Error: you must set the log group home dir in my.cnf the aavi InnoDB: same as log arch dir. aavi 020520 15:47:43 Can't init databases aavi --- aavi The same thing happens if I use the my.cnf file insted of the my.ini file. aavi If I erase the line concerning the InnoDB initialization in the 'my.ini' aavi everything is ok and works. aavi Please help me aavi Alessio aavi - aavi Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before aavi posting. To request this thread, e-mail [EMAIL PROTECTED] aavi To unsubscribe, send a message to the address shown in the aavi List-Unsubscribe header of this message. If you cannot see it, aavi e-mail [EMAIL PROTECTED] instead. hi I use Win2000 MySQL Max 3.23.49 and c:\winnt\my.ini MySQL Max it is installed by serves. mysql-max-nt.exe. I start tools with correct my.ini and through mysql.exe I receive access to base. The part my.ini which correctly is below given works. But I start MySQL from Win instead of from a DOS. innodb_data_file_path = ibdata1:200M;ibdata2:200M innodb_data_home_dir = d:\fomin\InnoDB\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = d:\fomin\InnoDB\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = d:\fomin\InnoDB\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 -- Best regards, maximmailto:[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: Apache + php + MYSQL
On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: Hi, I have my Database in MYSQL and wanna use PHP on Apache At the starting of the page I have given ?php $query = SELECT * FROM appl; // Establish a connection to the MySQL DBMS $connection = mysql_connect(linuxsrv, sameer, sameer); // Use the rcmms database mysql_select_db(rcmms, $connection); // Run a query through the connection $result = mysql_query($query, $connection); ? I says that mysql_connect Fatal error: Call to undefined function: mysql_connect() in /var/www/html/rcmms/appl.php on line 5 Hello, 1. make shure the PHP module is compiled into Apache, or runs as CGI. 2. If you have more questions: Please check following sites first (for documntation): www.apache.org, www.php.net, www.mysql.com Robert Vetter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crash Incorrect Database
Hello, Can you not have '.' in database names any more?? I just renamed one of the databases to something without .'s, and it worked. Kind Regards, 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 escape net m a k i n g t h e n e t w o r k f o r y o u 465b South Road ph 8293 2526 KESWICK SA 5035 fx 8293 2949 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 On Tue, 21 May 2002, Paul wrote: Stavros, As an absolute last resort try the following... Shutdown mysql first. copy your database backups to a safe place before doing this. Removed all tables first off. Then move the .MYD and .MYI and .frm files for each database. Run mysqladmin and re-create all of the tables again. and leave these tables with no data in them. Copy you backed up tables over the top of these tables in /usr/local/mysql/data (the .MYD and .MYI and .frm files) overwritting the MYD/MYI/frm files. You could even try just copying the MYD and MYI files over the top and skipping the FRM files, as they table form definition files which you;ve just recreated. in fact this could be a better thing to try. Then run myisamchk myisamchk -q -r TABLENAME then Start mysqld normally, all should be fine. Let me know how u go - Original Message - From: Stavros Patiniotis To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 5:21 PM Subject: Crash Incorrect Database Hello, My hard drive has just failed on my database server, and I have rebuilt it and copied the data from backups back on to the drive, however mySQL cannot see all of the databases. A 'show databases' shows all of the databases, however 'use DBNAME' says ERROR 1102: Incorrect database name Now I have done a check on each of the tables in one of the 'missing' db's, and the database is still not available. (eg myisamchk -r -e table_name) Can anyone point me in the right direction. (FreeBSD v4.5, mySQL v3.23.49) Kind Regards, 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 escape net m a k i n g t h e n e t w o r k f o r y o u 465b South Road ph 8293 2526 KESWICK SA 5035 fx 8293 2949 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Apache + php + MYSQL
On Tuesday 21 May 2002 09:51, Robert Vetter wrote: On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: in /var/www/html/rcmms/appl.php on line 5 Hello, 1. make shure the PHP module is compiled into Apache, or runs as CGI. rubbish, sorry. Make shure PHP is compiled with MySQL support. Robert Vetter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 about a SELECT With READ WRITE Lock?
I understand that a query like SELECT... FOR UPDATE will lock other threads from being able to modify those records in any way, however, other threads can still read them. I would like to be able to SELECT say 10 records and place a READ and WRITE lock on those rows so that the next SELECT thread will not grab those and will go on to the rows after those locked from the first thread. Is this possible? Anyone have any ideas on how this could be done? Thank you in advance! Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HOWTO: diffs between rows.
Probably a very simple one for you guys, but I'm stuck. Given a simple table (events): id int st time not null et time not null I know I can get duration by converting st and et to secs and subtracting (that bits easy), but how would I go about getting the gap between successive records IN MY SQL STATEMENT (without processing the result set in my application language (php)): i.e. id st et 1 09:00 10:00 2 10:15 10:45 3 11:45 12:00 ... i.e. my result wants to be (assuming data is good, and sort by st) id st et gap_since_last_row 1 09:00 10:00 0 (no prev row) 2 10:15 10:45 0:15 3 11:45 12:00 1:00 ... I suspect I should be using SQL variables, but docs seem a bit opaque. Anyone point me in right direction ? David. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Securing a Non-Secure Installation
How can one evaluation the security of a MySQL installation and what are the steps that should be taken to secure an installation from the ground up. Thanks 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
Query with ODBC
I'm using MySQL from ASP pages, I use MyODBC 3.50 and have a problem with a query. If I type the query directly in mysql it works OK but from ASP pages I get an error. I'm trying to use a multiline query separated by ; like this query1;query2; If I do like this query1; execute query2; execute it works but I want to do it all at once. Isn't this posible with MyODBC and ASP? I have done it with MicrosoftSQL and it works there. /Mattias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Evaluating a String
How do you do this: SELECT * FROM table1 WHERE table1.field1=0 -- SELECT * FROM table1 WHERE table1.field1=0 Is there a function in mysql that allows you to evaluate(dunno whether I use the correct term here) the string and not to treat it like a string? TIA. Ho Keat __ Do You Yahoo!? Yahoo! Kickin' Party - Win a 5-star getaway to exotic Bali! http://kickin.yahoo.com.sg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: HOWTO: diffs between rows.
You could join the table against itself, matching each row against every following record and then summarizing to find the next one. If your table is of a fair size, you'd need to play with the optimizer to make sure you get the efficiency you need. The SQL would be along the lines of: select max(curRow.id), time_to_sec(min(matchedRow.st)) - time_to_sec(max(curRow.et)) from events as curRow, events as matchedRow where curRow.et = matchedRow.st group by curRow.id On 21/5/02 at 10:43 am, David Shields [EMAIL PROTECTED] wrote: Probably a very simple one for you guys, but I'm stuck. Given a simple table (events): idint sttime not null ettime not null I know I can get duration by converting st and et to secs and subtracting (that bits easy), but how would I go about getting the gap between successive records IN MY SQL STATEMENT (without processing the result set in my application language (php)): i.e. idst et 1 09:00 10:00 2 10:15 10:45 3 11:45 12:00 i.e. my result wants to be (assuming data is good, and sort by st) idst et gap_since_last_row 1 09:00 10:00 0 (no prev row) 2 10:15 10:45 0:15 3 11:45 12:00 1:00 I suspect I should be using SQL variables, but docs seem a bit opaque. Anyone point me in right direction ? David. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: bug To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: when configuring the problem is that configure cant find some libs: libstdc++.so.3. libstdc++.so.2 exits What can I do? precise description of the problem (multiple lines) How-To-Repeat: ./configure -with-mit-threads Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table Installation of grant tables failed! /usr/libexec/ld-elf.so.1: Shared object libc_r.so.4 not found Examine the logs in ./data for more information. You can also try to start the mysqld demon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Engeniy V.Lyapin Organization: Albumin organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.22.32 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: FreeBSD andreyco 3.3-RELEASE FreeBSD 3.3-RELEASE #0: Thu Sep 16 23:40:35 GMT 1999 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: gcc version 2.7.2.3 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --wi th-low-memory --with-mit-threads=yes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Client
Do you mean, a character client for windows or the linux client? On linux I can do everything, delete, alter, insert, create, but I don't think that is going to solve my problem on windows. - Original Message - From: Andrei Cojocaru [EMAIL PROTECTED] To: Federico Coco [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Monday, May 20, 2002 1:47 PM Subject: Re: Mysql Client try the command line version of the client first then a GUI based one Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Federico Coco [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:57 AM Subject: Mysql Client I'm testing MySQL Client on Win98, my Server on Suse Linux 7.0. 1- I select database test 2-Commands--tables--Choose Tables, I choose f0001, I can see info Found 3 columns in 1 tables 3-Commands--Tables--Edit Tables here nothing happens. 4-Commands--Tables--Create Tables here nothing happens. What is going on? TIA. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: HOWTO: diffs between rows.
On Tue, 21 May 2002, David Shields wrote: Probably a very simple one for you guys, but I'm stuck. Given a simple table (events): idint sttime not null ettime not null I know I can get duration by converting st and et to secs and subtracting (that bits easy), but how would I go about getting the gap between successive records IN MY SQL STATEMENT (without processing the result set in my application language (php)): i.e. idst et 1 09:00 10:00 2 10:15 10:45 3 11:45 12:00 ... i.e. my result wants to be (assuming data is good, and sort by st) idst et gap_since_last_row 1 09:00 10:00 0 (no prev row) 2 10:15 10:45 0:15 3 11:45 12:00 1:00 ... I suspect I should be using SQL variables, but docs seem a bit opaque. Anyone point me in right direction ? David, get the manual, look at the JOIN command. You have to LEFT JOIN the table to itself on the condition that t2.id = (t1.id - 1) that looks like: SELECT ANY_FUNCTION(t1.st, t2.et) FROM mytable AS t1 LEFT JOIN mytable AS t2 ON t2.id = (t1.id -1) WHERE ... This gives you access to the columns of two subsequent rows and you may process the data as you like. I did not test this, but it should work. For the first row, as expected, all columns of the right table t2 are set to NULL. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Apache + php + MYSQL
[snip all kinds of stuff] ?php $query = SELECT * FROM appl; $connection = mysql_connect(linuxsrv, sameer, sameer); mysql_select_db(rcmms, $connection); $result = mysql_query($query, $connection); ? I says that mysql_connect Fatal error: Call to undefined function: mysql_connect() in /var/www/html/rcmms/appl.php on line 5 [/snip] Try... ?php $connection = mysql_pconnect(linuxsrv, sameer, sameer); mysql_select_db(rcmms, $connection); $result = mysql_query($query, $connection); $query = SELECT * FROM appl; ? Connections first, database selections next, then queries and results. If you get an undefined function now there is no MySQL support in your PHP compile. HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyISAM internal algorithms
Ok, so know you got me interested. What exactly are R-Trees. I know the structure of B trees, hadto program a small version of a B' tree before, but never heard of an R-Tree. Any explanation or link to where I might find some info would be appreciated. -Nick On Mon, May 20, 2002 at 09:39:52AM -0600, Andrei Cojocaru wrote: I believe mySQL uses B-Trees (not binary trees), that's about all I know :) Right. The indexes are B- Tree structures (until R-Trees appear in 4.1, of course). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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 mysql-unsubscribe- [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: Re: Bug in fulltext search in latest mysql-4.0.2 source
Hi! Vadim == Vadim P [EMAIL PROTECTED] writes: Vadim Sergei Golubchik wrote: rebuild your indexes (the proper way to do it is to issue REPAIR table_name USE_FRM Vadim Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? Yes, this would do the same thing as REPAIR, but a bit slower. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
restarting MySQL on OS X
I was wondering if anyone knew the proper way to restart MySQL on OS X? I did mysqladmin -p shutdown then safe_mysqld...is this the same as if the machine started up? -- --- Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso 5 Web Development/Hosting // MySQL Development // Apple DVD Studio Pro Authoring/Training // Macromedia Director/Flash Authoring --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
db name alias proxy
Hi! Grigory == Grigory Kolesov [EMAIL PROTECTED] writes: cut Grigory 1) Endiannes. I figured out that the size of packet is stored at the Grigory beginning of packet as little endian unsigned int. Grigory Is it so in all cases, or it just happens because both client and server Grigory run on little endian machines? The packets are always sent as little endians, independent of the architecture of the server/client. Grigory 2) Currently I rewrite only packets which contain: Grigory size uint+\x02+dbname Grigory size uint+something+\x00+dbname (connection init) Grigory size uint+\x03+\s*use\s*+dbname. Grigory I am not sure whether it is always correct. The above command will take care of the 'USE database' commands, but not be able to handle SQL commands where you directly refer to the database. Grigory 3) Does anyone need such tool, should I post it on web somewhere? You could always add it to the MySQL portal section at: http://www.mysql.com/portal/software/html/index.html Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select in select
Hello, I would like to do this witihn mysql: SELECT con.id,con.name FROM contacts con, registrar_contact reg WHERE NOT con.id IN (SELECT contactid FROM registrar_contact WHERE registrarid=1) can someone tell me how to do this ? contacts table consists of: id(primary key) name registrar_contact consists of: registrarid contactid(this is linked to contacts id field) (there is no primary key) thanks in advance. Regards, 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
Error 1030: error 127 (table handler)
Hello, approximatly twice a week I get Error 1030: error 127 (table handler) on one table. This table is around 2.3 GB, the indexfile around 2.2 GB. There are around 24.000.000 records in the table. I am running mysql 4.0.1-alpha on linux with 2.4.18 kernel. But I also got this error with older mysql versions (3.23) and kernels. Sometimes restarting mysql solves the problem, sometimes I have to check the table to get back a running system (no errors found) and sometimes I had to repair the index or data file. But I can not find any schema. Checking and repairing tables take multiple hours and stops our normal work. So it is very bad. Does anybody have an idea, how to solve this problem ? Does somebody else have problems like this ? Could there be misconfiguration responsible ? Many thanks Matthias Jaekle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyISAM internal algorithms
Hi, What i know : Indexing progressively, smaller regions of data space using a B tree like data structure. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 3:09 PM Subject: Re: MyISAM internal algorithms Ok, so know you got me interested. What exactly are R-Trees. I know the structure of B trees, hadto program a small version of a B' tree before, but never heard of an R-Tree. Any explanation or link to where I might find some info would be appreciated. -Nick On Mon, May 20, 2002 at 09:39:52AM -0600, Andrei Cojocaru wrote: I believe mySQL uses B-Trees (not binary trees), that's about all I know :) Right. The indexes are B- Tree structures (until R-Trees appear in 4.1, of course). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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 mysql-unsubscribe- [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
returning top two values
Hi, I have a table containing data on a number of families. I want to retrieve members of each family that have the two highest scoring values for a column. i.e the max and second max. Is there a function similar to max() or greatest() that will return the top 2 values when grouping by family ID? I can do this using perl in about three steps but would rather make life easier for myself if I can. Thanks in advance Rich mysql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: restarting MySQL on OS X
alex, chuck a copy of phpMyAdmin onto the machine. edit the phpMyAdmin configuration file to your username and password and load it up on the loopback address. you should find a button saying 'reload mysql' on the page. phpMyAdmin rules!!! cheers, jake on 21/5/02 1:43 pm, Alex Pilson at [EMAIL PROTECTED] wrote: I was wondering if anyone knew the proper way to restart MySQL on OS X? I did mysqladmin -p shutdown then safe_mysqld...is this the same as if the machine started up? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in select
Hello, I would like to do this witihn mysql: SELECT con.id,con.name FROM contacts con, registrar_contact reg WHERE NOT con.id IN (SELECT contactid FROM registrar_contact WHERE registrarid=1) can someone tell me how to do this ? contacts table consists of: id(primary key) name registrar_contact consists of: registrarid contactid(this is linked to contacts id field) (there is no primary key) thanks in advance. Regards, 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
Possible Bug in UPdATE in MySQL 4.0.1 alpha
Hi! Michael == Michael B Venezia [EMAIL PROTECTED] writes: Description: MichaelPossible Bug in UPDATE in MySQL 4.0.1 cut Michael Attempting backtrace. You can use the following information to find out Michael where mysqld died. If you see no messages after this, something went Michael terribly wrong... Michael Stack range sanity check OK, backtrace follows: Michael 0x807db7f Michael 0x823d64a Michael 0x8204447 Michael 0x821bbd6 Michael 0x820bb41 Michael 0x80d082f Michael 0x80b0479 Michael 0x8086de7 Michael 0x808a262 Michael 0x8084e57 Michael 0x808a694 Michael 0x8084296 Michael Stack trace seems successful - bottom reached Michael Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow Michael instructions on how to resolve the stack trace. Resolved Michael stack trace is much more helpful in diagnosing the problem, so please do Michael resolve it Michael, could you please read the above instructions and try to resolve the backtrace for us? cut How-To-Repeat: MichaelDid this query on a database called 'medical' below text MichaelUPDATE `Physical Examination Report` SET `History of Present Michael Illness`='moo\r\nfoo\r\nboo.' WHERE `ID Code of Appointment`=27 Any chance you could ftp a copy of the 'Physical Examination Report' table to ftp://support.mysql.com/pub/mysql/secret so that we could try to repeat the problem ? Just having the table definition formats is not enough to repeat a problem like this! cut 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
Re: restarting MySQL on OS X
There is a link for mysql-startupitem.pkg.tar.gz on http://www.entropy.ch/software/macosx/mysql/ This will install the startup stuff needed to do what you want. On 5/21/2002 5:43 AM, Alex Pilson [EMAIL PROTECTED] wrote: I was wondering if anyone knew the proper way to restart MySQL on OS X? I did mysqladmin -p shutdown then safe_mysqld...is this the same as if the machine started up? -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.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: Need help
Hi, I have a MySQL database with a table named CONNEXION. When i'm trying to do something with the specific table, i have the following error: ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145) Please can anybody help me? Thanks in advance -- ** Bertrand TACHAGOE_mails: [EMAIL PROTECTED] / [EMAIL PROTECTED] Network / information specialist SDNP SchoolNet Cameroon Phone: (237)221 25 53 Web site: www.sdnp.cm/tachago ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: restarting MySQL on OS X
Alex Pilson wrote: I was wondering if anyone knew the proper way to restart MySQL on OS X? I did mysqladmin -p shutdown then safe_mysqld...is this the same as if the machine started up? Not exactly the same. But for intents and purposes it does what you want. If you want to truly make it seem like the system went down and came up, do the following: # kill -9 safe_mysql pid # kill `cat /path/to/mysql.pid` # /path/to/safe_mysqld Or you can try this. # /etc/init.d/mysqld stop (or something similar) then # /etc/init.d/mysqld start -- -reid - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: restarting MySQL on OS X
At 9:20 AM -0400 5/21/02, Reid Sutherland (mysql) wrote: Alex Pilson wrote: I was wondering if anyone knew the proper way to restart MySQL on OS X? I did mysqladmin -p shutdown then safe_mysqld...is this the same as if the machine started up? Not exactly the same. But for intents and purposes it does what you want. If you want to truly make it seem like the system went down and came up, do the following: # kill -9 safe_mysql pid # kill `cat /path/to/mysql.pid` # /path/to/safe_mysqld Or you can try this. # /etc/init.d/mysqld stop (or something similar) then # /etc/init.d/mysqld start I knew there was more to this than what I was doing. Thanks I think this is what I am looking for. -- --- Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso 5 Web Development/Hosting // MySQL Development // Apple DVD Studio Pro Authoring/Training // Macromedia Director/Flash Authoring --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: returning top two values
Not a problem. I think the easist way to do it is SELECT * FROM families ORDER BY score DESC LIMIT 2 Of course you need your grouping statement in there but the ORDER BY section shouldntmake a difference. There are MAX and MIN functions but my understanding is that those will only return THE highest/lowest values and not say the highest two values. It would work Ibelieve if there were two families with the same highest score. Someone correct me if I'mwrong. -Nick Hi, I have a table containing data on a number of families. I want to retrieve members of each family that have the two highest scoring values for a column. i.e the max and second max. Is there a function similar to max() or greatest() that will return the top 2 values when grouping by family ID? I can do this using perl in about three steps but would rather make life easier for myself if I can. Thanks in advance Rich mysql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [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
SV: returning top two values
Hi Rich, Use the LIMIT 2 and sort the SELECT with ORDER BY family ID DESC // Jonny -Ursprungligt meddelande- Från: R.Dobson [SMTP:[EMAIL PROTECTED]] Skickat: den 21 maj 2002 14:57 Till: [EMAIL PROTECTED] Ämne: returning top two values Hi, I have a table containing data on a number of families. I want to retrieve members of each family that have the two highest scoring values for a column. i.e the max and second max. Is there a function similar to max() or greatest() that will return the top 2 values when grouping by family ID? I can do this using perl in about three steps but would rather make life easier for myself if I can. Thanks in advance Rich mysql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: select in select
[snip] SELECT con.id,con.name FROM contacts con, registrar_contact reg WHERE NOT con.id IN (SELECT contactid FROM registrar_contact WHERE registrarid=1) [/snip] Current versions of MySQL do not support sub-selects. HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: returning top two values
[snip] I want to retrieve members of each family that have the two highest scoring values for a column. i.e the max and second max. Is there a function similar to max() or greatest() that will return the top 2 values when grouping by family ID? [/snip] Try this query select foo, MAX(bar) from table order by bar DESC limit 2; HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 priviledges question
Could someone give me a brief description of the following priviledges and what they are used for...? 1) References Not yet implemented. Is that still true? 2) File ?? 3) Index Is this so the person can create an index, and if so, they must first have the alter statement right? I didnt see much in the mysql manual about these priviledges Thank you, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. 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
Best SQL Statement
Dear All, I have a table contains airline ticket prices, and I want to get the following data from this table The first 5 records of the lowest price of each airline from each city, and don't want to get a duplicated combination of (airline, city) in this result (even if I didn't see all airlines or all cities, I want to see only five records). I get the required results (in MSAccess) by doing the following: 1- Create a query Q1 with the following source: SELECT distinct [ticket cut rate].[primary airline] FROM [ticket cut rate] 2- Then Create a second Query Q2 with the following source: SELECT Q1.[primary airline], Min([ticket cut rate].[price per adult]) AS [MinOfprice per adult] FROM Q1 INNER JOIN [ticket cut rate] ON Q1.[primary airline] = [ticket cut rate].[primary airline] GROUP BY Q1.[primary airline]; 3- And I get the required results from the following Query: SELECT TOP 5 First([ticket cut rate].origin) AS FirstOforigin, [ticket cut rate].[primary airline], [ticket cut rate].[price per adult] FROM (Q1 INNER JOIN Q2 ON Q1.[primary airline] = Q2.[primary airline]) INNER JOIN [ticket cut rate] ON (Q2.[primary airline] = [ticket cut rate].[primary airline]) AND (Q2.[MinOfprice per adult] = [ticket cut rate].[price per adult]) GROUP BY [ticket cut rate].[primary airline], [ticket cut rate].[price per adult]; How can I get the same result with only one sql statement??? Oh by the way, can I create queries in MySQL just like MSAccess Please help bst rgds Hayan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in select
You can use JOIN... See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Gurhan -Original Message- From: van den Heuvel, Frank [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:47 AM To: '[EMAIL PROTECTED]' Subject: select in select Hello, I would like to do this witihn mysql: SELECT con.id,con.name FROM contacts con, registrar_contact reg WHERE NOT con.id IN (SELECT contactid FROM registrar_contact WHERE registrarid=1) can someone tell me how to do this ? contacts table consists of: id(primary key) name registrar_contact consists of: registrarid contactid(this is linked to contacts id field) (there is no primary key) thanks in advance. Regards, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Securing a Non-Secure Installation
There is no secure, nonsecure installation. You usually take security measurements after the installation.. The security mesaure you take before installation is to create a group and user called mysql to have appropriate permissions on the datadirs, socketfiles, etc. See: http://www.mysql.com/doc/P/r/Privilege_system.html Gurhan -Original Message- From: Frank Schmuck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 5:57 AM To: [EMAIL PROTECTED] Subject: RE: Securing a Non-Secure Installation How can one evaluation the security of a MySQL installation and what are the steps that should be taken to secure an installation from the ground up. Thanks 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Passwords
Hello~ I read the MySQL manual on how to set passwords but i'm a little confused. How can i remove privileges so that you cant log on anonymously? Thanks. Amy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need help
Use perror program to see what the error code means.. perror 145 Error code 145: Unknown error 145 145 = Table was marked as crashed and should be repaired Repair your table.. see: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html Gurhan -Original Message- From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:16 AM To: [EMAIL PROTECTED] Subject: Re: Need help Hi, I have a MySQL database with a table named CONNEXION. When i'm trying to do something with the specific table, i have the following error: ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145) Please can anybody help me? Thanks in advance -- ** Bertrand TACHAGOE_mails: [EMAIL PROTECTED] / [EMAIL PROTECTED] Network / information specialist SDNP SchoolNet Cameroon Phone: (237)221 25 53 Web site: www.sdnp.cm/tachago ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyCC problems with qt3.0.4
Hi!
This problem is now fixed in the current BK tree and will OK in 0.8.3.
Below is the modification you need to make MyCC work with Qt 3.04!
+++ mycc/src/CSqlEditor/syntaxhighliter_sql.cpp
@@ +125 @@
SyntaxHighlighter_SQL::SyntaxHighlighter_SQL()
: QTextPreProcessor(), lastFormat( 0 ), lastFormatId( -1 )
{
- formats.setAutoDelete(true);
+#ifdef WIN32
+ formats.setAutoDelete(true); //This avoids a mem-leak under Win32 ?
+#endif
hasSqlSyntaxHighlighting = false;
hasDatabaseSyntaxHighlighting = false;
QIntDictIteratorSqlFormat it(*g_SqlEditorStyles);
for ( ; it.current(); ++it )
if (it.current()-ID != SQLKeyWord::highlight_PARENTHESES_MATCHING)
addFormat(it.current()-ID, new QTextFormat(it.current()-Font,
it.current()-Color));
}
-Original Message-
From: Kevin Lester [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 2:36 PM
To: [EMAIL PROTECTED]
Subject: MyCC problems with qt3.0.4
I'm running a pretty standard install of RedHat 7.2 on a x86
machine. I compiled MyCC with qt3.0.4 and everything worked
well except when I closed a popup window the program would
seg fault. I re-compiled it using qt3.0.2 and it works fine
now. You might want to make sure that users know they must
use 3.0.2 if they want it to work properly. Of course
fixing the problem with qt3.0.4 would be nice as well. :)
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /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
Re: Error 1030: error 127 (table handler)
We've been seeing this quite often at our web application company. The development machines run debian linux with kernel 2.4.x (they differ) and ReiserFS, and on local installations of the web app, which puts DB, web server, and CGIs on the same box, we see frequent table corruption. Sometimes it's on the order of a couple of times a week, which is absolutely ridiculous considering how little the DB install is stressed on developer boxes. Fortunately the DB server used for the public cluster, which gets its own debian linux 2.4.x machine, and I *think* doesn't use ReiserFS (the maintenance crew has changed its collective mind several times, much to the annoyance of the development and QA teams), does *not* exhibit this problem, or so the crew claims. (Don't even ask about the politics of communication within our company...) This is clearly a BIG BIG worry for me, but the story I am handed (from some very dubious sources) is that it's an interaction between MySQL and ReiserFS and that as long as the public servers don't user ReiserFS we'll be fine. Can anybody actually lend credence to this claim? -rob On 21/5/02 at 2:49 pm, Matthias Jaekle [EMAIL PROTECTED] wrote: Hello, approximatly twice a week I get Error 1030: error 127 (table handler) on one table. This table is around 2.3 GB, the indexfile around 2.2 GB. There are around 24.000.000 records in the table. I am running mysql 4.0.1-alpha on linux with 2.4.18 kernel. But I also got this error with older mysql versions (3.23) and kernels. Sometimes restarting mysql solves the problem, sometimes I have to check the table to get back a running system (no errors found) and sometimes I had to repair the index or data file. But I can not find any schema. Checking and repairing tables take multiple hours and stops our normal work. So it is very bad. Does anybody have an idea, how to solve this problem ? Does somebody else have problems like this ? Could there be misconfiguration responsible ? Many thanks Matthias Jaekle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.44 not using indexes
Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote: Jeremy [snip] cut Jeremy That reminds me. A while back (9 months, maybe), I seem to remember Jeremy you discussion a re-write of the key cache so that it would use a more Jeremy locking strategy. Jeremy Is that supposed to happen in 4.0.x? I don't recall having seen a Jeremy commit that affected the key cache yet. Sanja has been trying to do improvements to the key cache code, but we are still not satisfied with this. He just went back to the sub select code, so we can't just now give a definite answer when we have a new key cache. (I am myself totally concentrating on getting 4.0.2-beta out; When this is done I hope to have time to take a look a the key cache problem) Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb rollbacks
On Tuesday 21 May 2002 12:24 am, Jeremy Zawodny wrote: On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote: Does anyone know where rollbacks are stored for innodb tables? I assume memory since I keep getting a table full error when trying to drop an index. sql,query I'm not exactly sure what you're asking, but the rollback information needs to be stored on disk. Otherwise it cannot recover form a crash. Anyway, I suspect that your problem is that your tablespace is full. Can you try added another file and see if that makes the problem go away? Jeremy Thanks for your reply Jeremy! I'm an Oracle person, so I tend to think of things being in multiple files/tablespaces. Do you know if there is a way to view the rollback stats? I've got 6GB of datafiles and only 1 table loaded with 46 rows, 14 indexes, and approx 1.6million records. I'm trying now to load all the data again in a seperate table to see what it takes to fill up the datafiles. Thanks again! -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak it - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin hanging on Solaris 8/Intel
Hello! I have a strange problem with mysqladmin on Solaris 8. I can't seem to shut down the server via mysqladmin -uroot -p shutdown. It just... well... sits there. Hitting ctrl-c gives bash-2.03$ mysqladmin shutdown ^CWarning; Aborted waiting on pid file: '/opt/db/simon.pid' after 121 seconds bash-2.03$ The Pidfile says 7962. ps -ef says mysqld is running with PID 7962. Connecting to the mysql server after running mysqladmin and terminating it works, but the uptime has been reset. I really wouldn't want to get rough with it, so how do I take it down gracefully with minimum danger of losing data? Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crash Incorrect Database
Stavros Patiniotis wrote: Hello, My hard drive has just failed on my database server, and I have rebuilt it and copied the data from backups back on to the drive, however mySQL cannot see all of the databases. A 'show databases' shows all of the databases, however 'use DBNAME' says ERROR 1102: Incorrect database name My first guess is a file/directory permissions problem. Make sure the backups you copied over are owned by the user the MySQL server runs as (probably mysql). -myk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Large table delete from ...
At 01:22 AM 5/19/2002, you wrote: Dear all, I have some large MySQL tables and II want to delete for example month 2-2002 entirelly from an sql table. I use now ... delete from table_name where year(data)=2002 and month(data)=2; I have almost 25.000.000 row and something like 7-8 mil is from month 2. Seems to make it for 2 hours and it's very much as time, I need other tables as well to clean up and then need to stop too much from clients the database. Can be do this in other way? Also if there a possibilities to export and delete this records?? Regards, Valics Lehel Valics, If you are using MyISAM tables, you may want to put each month into a separate table, and then have your query use Merge Tables (quite fast). To delete a month, delete all the rows from the table which takes a few milliseconds (MySQL is basially dropping the table and rebuilding it when you do a delete * from myisam_table or change your merge tables definition. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crash Incorrect Database
Hello, I'm not sure if my previous post made it to the list, but it seems that mysql no longer accepts '.' in database names. I merely changed the . with _ and the missing databases came alive :) Kind Regards, 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 escape net m a k i n g t h e n e t w o r k f o r y o u 465b South Road ph 8293 2526 KESWICK SA 5035 fx 8293 2949 0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0 On Tue, 21 May 2002, Myk Melez wrote: Stavros Patiniotis wrote: Hello, My hard drive has just failed on my database server, and I have rebuilt it and copied the data from backups back on to the drive, however mySQL cannot see all of the databases. A 'show databases' shows all of the databases, however 'use DBNAME' says ERROR 1102: Incorrect database name My first guess is a file/directory permissions problem. Make sure the backups you copied over are owned by the user the MySQL server runs as (probably mysql). -myk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting images and other blobs
Any suggestions on how to load images from a web site into a MySQL db? I would like to set up a page that allows you to select an image from the local machine and load it to my MySQL DB on my web server. I'm not sure if it would just be a regular insert statement or something else? Thanks... /Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is this a Bug?: Query returns an unexpected result.
Hi. On Tue, May 21, 2002 at 02:14:26PM +0300, [EMAIL PROTECTED] wrote: This bug was fixed interim, as it is no longer present in 4.0.2 nor in 3.23.51. Ah. Okay. Thanks for testing. This must be this change from 3.23.49, I guess: -- + Fixed unlikely caching bug when doing a join without keys. In this case the last used field for a table always returned NULL. -- Don't know why I missed it when I looked the first time. Sorry about the false alarm. Regards, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: difference between fixed length tables MyISAM vs. ISAM
Hi. Just a little addition to the original e-mail: you want to try SHOW TABLE STATUS Bye, Benjamin. On Mon, May 20, 2002 at 10:08:13PM -0700, [EMAIL PROTECTED] wrote: On Sun, May 19, 2002 at 06:26:54AM -0700, Henry Hank wrote: Hello All, I recently moved my database from mysql 3.22.29 to 3.23.41, and udated all my tables to MyISAM tables. Under ISAM, I could take the filesize of the ISD table and divide by the record length to get the exact number of records returned by select count(*) from that table (or vise-versa - it always worked). [...] -- [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: Help a newbie please
Hoa, Tuesday, May 21, 2002, 6:33:46 AM, you wrote: HD Please don't kill me. I want to learn about databases. I hear MySQL is a HD good start. I have RedHat Linux and I've download and (I believe) installed HD mysql. HD Okay, my questions are? What is the difference between the mysql server and HD the client program? :-) MySQL is a RDBMS (Relational DataBase Management System). Briefly MySQL server makes management of databases, data storage and processing and so on ... MySQL client program is used to communicate with MySQL server :) HD Do I need both? If you want to work with MySQL server you must have it :) As a client program you can use MySQL client program or any GUI or you can develop your own application :) HD What is the role of the server and HD what is the role of the client program? See above. HD How do I start inputing data into HD the database? At first you should create your database. How to create databases read in our manual: http://www.mysql.com/doc/C/r/Creating_database.html At second you should create a table: http://www.mysql.com/doc/C/R/CREATE_TABLE.html About inserting data into tables you can also read in our manual: http://www.mysql.com/doc/I/N/INSERT.html HD Thanks in advance for your help. HD Hoa -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: restarting MySQL on OS X
Alex, Tuesday, May 21, 2002, 3:43:16 PM, you wrote: AP I was wondering if anyone knew the proper way to restart MySQL on OS X? AP I did mysqladmin -p shutdown then safe_mysqld...is this the same as AP if the machine started up? mysqladmin shutdown - takes down your MySQL server. Using safe_mysqld you run MySQL server again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: GROUP BY on multiple fields apparently broken
matt, Sunday, May 19, 2002, 6:14:17 PM, you wrote: m Description: m mysql describe DLSummary; m ++--+--+-+-+---+ m | Field | Type | Null | Key | Default | Extra | m ++--+--+-+-+---+ m | DownloadID | int(10) unsigned | YES | MUL | NULL| | m | Year | int(10) unsigned | YES | MUL | NULL| | m | YDay | int(10) unsigned | YES | | NULL| | m | Count | int(10) unsigned | YES | | NULL| | m ++--+--+-+-+---+ m 4 rows in set (0.00 sec) m mysql show keys from DLSummary; m +---+++--+-+---+-+--++--++-+ m | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type m | Comment | m +---+++--+-+---+-+--++--++-+ m | DLSummary | 1 | Date |1 | Year| A | 1 | NULL | NULL | YES | BTREE m | | m | DLSummary | 1 | Date |2 | YDay| A | 377 | NULL | NULL | YES | BTREE m | | m | DLSummary | 1 | DownloadID |1 | DownloadID | A | 15378 | NULL | NULL | YES | BTREE m | | m +---+++--+-+---+-+--++--++-+ m 3 rows in set (0.01 sec) m BUG m mysql select Year,YDay,sum(Count) from DLSummary group by Year,YDay; m ERROR 1062: Duplicate entry '2001-125' for key 1 m BUG m mysql select Year,YDay,sum(Count) from DLSummary group by concat(Year,YDay); m +--+--++ m | Year | YDay | sum(Count) | m +--+--++ m | 2001 | 124 | 2140 | m | 2001 | 125 | 10302 | m . m This seems rather odd. GROUP BY Year,YDay is documented to be topologically m equivalent to GROUP BY CONCAT(Year,YDay) (well, more or less) but has m functional difference. m Bug tested in 4.0.2 @ BK 1.1272 (May 17th) and also on 4.0.2 as of around m March 2nd, so it's nothing recent. Thank you for your bug report! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: Re: Is this a Bug?: Query returns an unexpected result.
Benjamin, Monday, May 20, 2002, 9:21:02 PM, you wrote: BP On Mon, May 20, 2002 at 07:28:01PM +0300, [EMAIL PROTECTED] wrote: BP [...] II select II o.orderid, II o.shipping_date, II o.cancel_date II from orders o, member u II where o.userid = u.userid; BP [...] II the results of the last two queries are: II orderid shipping_date cancel_date II 1 2002-05-20 21:50:24 NULL II 2 2002-05-20 21:50:24 NULL II orderid shipping_date cancel_date II 1 2002-05-20 21:50:24 2002-05-20 21:50:24 II in the first query, cancel_date should not be null for orderid=1. It is fixed in v4.0.2 ... BP As the 4.0.x tree is still declared alpha, can we expect an back-port BP of the fix to the 3.23.x tree? Sure, it's fixed in 3.23.51, too. BP Benjamin. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: Re: error message....somewhat lost!
Simon, Monday, May 20, 2002, 7:24:28 PM, you wrote: SKC I'm running mysql-3.23.36-sun-solaris2.7-sparc. SKC And yes, I'm pretty sure that the server is installed. I can still SKC query the database using a DBI script and get results back. SKC My mysqld is in /usr/local/mysql/bin SKC When I try running it, I get this error message: SKC mysqld: Can't change dir to '/usr/local/mysql-3.23.36-sun-solaris2.7-sparc/var/' SKC (Errcode: 2) SKC 020520 9:14:29 Aborting Simon, if you have mysqld running why do you try to run it again? If you want to run another instance of mysqld check the following link: http://www.mysql.com/doc/m/y/mysqld_multi.html SKC I checked the path and there is no var directory in /usr/local/mysql-3.23.36-sun-solaris2.7-sparc SKC I'm really lost! Thanks for your advice! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: RE: Securing a Non-Secure Installation
Frank, Tuesday, May 21, 2002, 12:56:38 PM, you wrote: FS How can one evaluation the security of a MySQL installation and what are FS the steps that should be taken to secure an installation from the ground FS up. What did you mean security of a MySQL installation? Access to the MySQL server or secure connection or what? Your question is not clear enough for me ... FS Thanks FS Frank -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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 Client
Federico, Monday, May 20, 2002, 6:57:28 PM, you wrote: FC I'm testing MySQL Client on Win98, my Server on Suse Linux 7.0. FC 1- I select database test 2-Commands--tables--Choose Tables, I choose f0001, I can see info Found 3 FC columns in 1 tables 3-Commands--Tables--Edit Tables here nothing happens. 4-Commands--Tables--Create Tables here nothing happens. As I assume, you are using MySQLGUI. If so, Edit Table and Create tables are doing nothing ... FC What is going on? FC TIA. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: Re: Need help
Bertrand, Tuesday, May 21, 2002, 4:15:37 PM, you wrote: BT I have a MySQL database with a table named CONNEXION. When i'm trying to do BT something with the specific table, i have the following error: BT ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145) BT Please can anybody help me? BT Thanks in advance # perror 145 Error code 145: Unknown error 145 145 = Table was marked as crashed and should be repaired Try to repair table using myisamchk or REPAIR TABLE. Look at: http://www.mysql.com/doc/R/e/Repair.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: adodb
Given your query, you would access it like: $avgField = $avg-fields['avg(fieldname)']; You can also change your query to use an alias like: select avg(fieldname) as theAvg from tablename HTH, Scott -Original Message- From: bobbie bob [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:12 AM To: [EMAIL PROTECTED] Subject: adodb Hi i'm using adodb in my code to connect to mysql.Its workingfine for the queries which get the values from DB. 1) But When i use the Query $avg=$conn-Execute(select avg(fieldname) from tabname then i say print $avg it prints OBJECT when i try print $avg-fields[fieldname] it doesn't print anything. what shall i do? how do i print the value of avg in my php code. 2)$duration=$conn-Execute(select sum(UnixTimeStamp(F1) - UnixTimeStamp(F2)) from tabname print $duration doesn't print anything how do i print the result? plz help me.Mail to [EMAIL PROTECTED] Thanks prasad __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need help
Thanks, i had check and had already solve the problem. Gurhan Ozen [EMAIL PROTECTED] a dit : Use perror program to see what the error code means.. perror 145 Error code 145: Unknown error 145 145 = Table was marked as crashed and should be repaired Repair your table.. see: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html Gurhan -Original Message- From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:16 AM To: [EMAIL PROTECTED] Subject: Re: Need help Hi, I have a MySQL database with a table named CONNEXION. When i'm trying to do something with the specific table, i have the following error: ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145) Please can anybody help me? Thanks in advance -- ** Bertrand TACHAGO E_mails: [EMAIL PROTECTED] / [EMAIL PROTECTED] Network / information specialist SDNP SchoolNet Cameroon Phone: (237)221 25 53 Web site: www.sdnp.cm/tachago ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ** Bertrand TACHAGOE_mails: [EMAIL PROTECTED] / [EMAIL PROTECTED] Network / information specialist SDNP SchoolNet Cameroon Phone: (237)221 25 53 Web site: www.sdnp.cm/tachago ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Writing UDF
I was wondering if any one could help me with a about writing UDF's for mysql. If I reallocate more memory for the result string; ie char *myResult; myResult = (char *) calloc(1, resultSize); *res_length = (ulong) resultSize; return myResult; Do I have to free it anywhere - and if so where? Or will mysql handle this for me? Cheers Gav Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 too slow over the LAN
Hello, I have built an application that connects to a mysql database located on a remote server in our LAN. When running the application locally on the server and I open the main window (it as several forms and does a lot of queries to fill the fields, etc.) it takes about 2 to 3 seconds to open. However, when I use this application on some other client in the same LAN, this form takes about 20 to 30 seconds to open! Can someone help me with this? Thanks. - Email Enviado utilizando o serviço MegaMail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.44 not using indexes
Hi Monty, Michael Widenius wrote: Hi! Jeremy commit that affected the key cache yet. Sanja has been trying to do improvements to the key cache code, but we are still not satisfied with this. He just went back to the sub select code, so we can't just now give a definite answer when we have a new key cache. (I am myself totally concentrating on getting 4.0.2-beta out; When this is done I hope to have time to take a look a the key cache problem) 4.0.2 will be labelled beta ? Regards, Monty MySQL, sql, query -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Mysql Client
Do you mean, a character client for windows or the linux client? On linux I can do everything, delete, alter, insert, create, but I don't think that is going to solve my problem on windows. - Original Message - From: Andrei Cojocaru [EMAIL PROTECTED] To: Federico Coco [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Monday, May 20, 2002 1:47 PM Subject: Re: Mysql Client try the command line version of the client first then a GUI based one Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Federico Coco [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:57 AM Subject: Mysql Client I'm testing MySQL Client on Win98, my Server on Suse Linux 7.0. 1- I select database test 2-Commands--tables--Choose Tables, I choose f0001, I can see info Found 3 columns in 1 tables 3-Commands--Tables--Edit Tables here nothing happens. 4-Commands--Tables--Create Tables here nothing happens. What is going on? TIA. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Cross-platform Deployment issue.
Hi, I have an application in Java that access MySQL databases through JDBC. The issue is that I have to be able to move the database files across different platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP). If I go to the manual, MySQL says that the database files are compatible between computers with the same floating-point format. What is this about? How can the floating-point issue be overcome without having to export the data in one platform and export it to the other one? Thanks in advance. Bye, Francisco. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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: Inserting images and other blobs
There is a function called Load_File which will cause the mysqld to read the file into a field. It is designed for such things. Check out http://www.mysqldeveloper.com/faqs/index.pcgi?id=7 for more information. Keep in mind that generally it is better to use the file system to store files and the database to store data. The preferred way to do this with images is to just keep track of the name and location of the file in the database. Good luck with your application. Harrison - Original Message - From: Info_Best-IT [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 10:54 AM Subject: Inserting images and other blobs Any suggestions on how to load images from a web site into a MySQL db? I would like to set up a page that allows you to select an image from the local machine and load it to my MySQL DB on my web server. I'm not sure if it would just be a regular insert statement or something else? Thanks... /Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help Writing UDF
I am getting lots of emails sent to me for your address. Either you have a virus or you need to contact your hosting company Larry Thrall 2924 1/2 Main Street Santa Monica, CA 90405 t. 310.314.5126 f. 310.450.0143 -Original Message- From: Gav Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:34 AM To: [EMAIL PROTECTED] Subject: Help Writing UDF I was wondering if any one could help me with a about writing UDF's for mysql. If I reallocate more memory for the result string; ie char *myResult; myResult = (char *) calloc(1, resultSize); *res_length = (ulong) resultSize; return myResult; Do I have to free it anywhere - and if so where? Or will mysql handle this for me? Cheers Gav Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Query help
I can't seem to properly wrap my brain around left joins. If anyone knows of a good tutorial somewhere, I'd appreciate it. That having been said, I was hoping someone could help with this query I'm trying to do as I've been horribly unsuccessful. 3 tables: goal (own goals), goalopp (opponent goals), game Pertinent fields: goal.id goal.game goalopp.id goalopp.game game.id One game record for each game. One goal record for each own goal, one goal record for each opponent goal, each with a unique id in their table (goal.id, goalopp.id) and a reference to the game id (goal.game, goalopp.game). What I'm trying to do is get the number of games where the goal count is greater than the goalopp count for a set of games. Of course I could just loop through an array for each game, but I was hoping to do it with a single query. So what I'm getting at is essentially select (count game) where ((count goal) (count goalopp)) for each game where game.something='whatever' Help would be greatly appreciated. Age --- Adriano Age Manocchia [EMAIL PROTECTED] Cornell University AIM/Yahoo/MSN: SalsaSharkNet http://salsashark.net/ageICQ: 5962736 --- The capacity to blunder slightly is the real marvel of DNA. Without this special attribute, we would still be anaerobic bacteria, and there would be no music. -Lewis Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 too slow over the LAN
Hi, Look at mysqld.log and tell us what errors are. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Avalon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 6:46 PM Subject: Mysql too slow over the LAN Hello, I have built an application that connects to a mysql database located on a remote server in our LAN. When running the application locally on the server and I open the main window (it as several forms and does a lot of queries to fill the fields, etc.) it takes about 2 to 3 seconds to open. However, when I use this application on some other client in the same LAN, this form takes about 20 to 30 seconds to open! Can someone help me with this? Thanks. - Email Enviado utilizando o servio MegaMail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: my.cnf
On UNIX and Linux machines, there are a few places that MySQL will look for your my.cnf. The are detailed at: http://www.mysql.com/doc/O/p/Option_files.html However if none of these files exist, then MySQL will use the default values assigned for all neccesary settings. You can then just create the option files using your preferred text editor and next time you restart mysqld it will use those new values you specified. Harrison - Original Message - From: Amy Zediak [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 1:12 PM Subject: my.cnf According to the MySQL manual, the my.cnf option files are located in /etc but mine are not there. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Re: Passwords
Amy, Tuesday, May 21, 2002, 5:25:10 PM, you wrote: I read the MySQL manual on how to set passwords but i'm a little confused. How can i remove privileges so that you cant log on anonymously? Anonymous user - a user that is defined as '' (empty string) in table user. So, if you want to remove privileges from anonymous user, you should delete from privilege table rows where user='' or use REVOKE to take away privileges from anonymous user. Thanks. Amy -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
Cross-platform Deployment issue.
Hi, I have an application in Java that access MySQL databases through JDBC. The issue is that I have to be able to move the database files across different platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP). If I go to the manual, MySQL says that the database files are compatible between computers with the same floating-point format. What is this about? How can the floating-point issue be overcome without having to export the data in one platform and export it to the other one? Thanks in advance. Bye, Francisco. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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: InnoDB, possible bug?
Andrei, how many rows in ne satisfy (1) ne.playerid=28575, (2) ne.type=2? What version you are using? .48 was tuned to favor index searches over table scans. What does EXPLAIN SELECT say if you force the index usage with USE INDEX and STRAIGHT JOIN clauses? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Andrei Cojocaru [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, May 20, 2002 6:46 PM Subject: InnoDB, possible bug? Hello, I've just switched to InnoDB table from myISAM and it's been running pretty smoothly except on this SQL statement it doesn't use any indexes when there are, and therefore is very slow. mysql explain select pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from newsentries10 ne, pnews pn where ne.playerid=28575 and ne.type=2 and pn.newsid=ne.newsid; +---++---+-+-+---+-- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+---+-- --++ | ne| ALL| list_news,delete_news | NULL|NULL | NULL | 734023 | where used | | pn| eq_ref | PRIMARY | PRIMARY | 4 | ne.newsid | 1 || +---++---+-+-+---+-- --++ 2 rows in set (0.00 sec) (Notice that key for ne is NULL when there is obviously an index it could use, but doesn't, why?) the table structures for the two tables are: mysql desc newsentries10; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | newsid| int(10) unsigned| | MUL | 0 | | | playerid | int(10) unsigned| | MUL | 0 | | | hidestamp | int(10) unsigned| | | 0 | | | viewpoint | tinyint(3) unsigned | | | 0 | | | type | tinyint(3) unsigned | | | 0 | | | delmarker | tinyint(3) unsigned | | MUL | 0 | | +---+-+--+-+-+---+ 6 rows in set (0.00 sec) mysql desc pnews; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | newsid| int(10) unsigned| | PRI | NULL| auto_increment | | type | tinyint(3) unsigned | | | 0 | | | id| int(10) unsigned| | MUL | 0 | | | timestamp | int(10) unsigned| | | 0 | | +---+-+--+-+-++ 4 rows in set (0.00 sec) the indexs are: mysql show index from newsentries10; +---++-+--+-+--- +-+--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++-+--+-+--- +-+--++-+ | newsentries10 | 1 | delmarker |1 | delmarker | A | 0 | NULL | NULL | | | newsentries10 | 1 | list_news |1 | playerid| A | 0 | NULL | NULL | | | newsentries10 | 1 | list_news |2 | type| A | 0 | NULL | NULL | | | newsentries10 | 1 | delete_news |1 | newsid | A | 76379 | NULL | NULL | | +---++-+--+-+--- +-+--++-+ 4 rows in set (0.20 sec) mysql show index from pnews; +---++--+--+-+---+-- ---+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++--+--+-+---+-- ---+--++-+ | pnews | 0 | PRIMARY |1 | newsid | A | 139047 | NULL | NULL | | | pnews | 1 | id |1 | id | A | 139047 | NULL | NULL | | +---++--+--+-+---+-- ---+--++-+ 2 rows in set (0.07
Replication (possible) problems | 'show binlog' command is broken?
Greetings, We got the following lines in our error logfile on one of our slave servers: 020521 13:19:29 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno=2013) 020521 13:19:29 Slave: Failed reading log event, reconnecting to retry, log 'db-bin.024' position 833365852 020521 13:19:29 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db-bin.024' at position 833365852 It isn't the first one and I was wondering what could be cause? A network problem? Large data chunk, or something? I tried to see what was the event that cause that problem and the following commands only returns an error: show binlog events in 'db-bin.024' from 833365852 limit 5; ERROR 1064: You have an error in your SQL syntax near 'binlog events in 'db-bin.024' from 833365852 limit 5' at line 1 Any help is appreciated! Mihail Manolov Government Liquidation, LLC 202 467 6868 x.227 [EMAIL PROTECTED] www.govliquidation.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: my.cnf
You have to create it yourself. The base mysql install comes with example .cnf files ( 3 I think ) -Original Message- From: Amy Zediak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:12 PM To: [EMAIL PROTECTED] Subject: my.cnf According to the MySQL manual, the my.cnf option files are located in /etc but mine are not there. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inserting images and other blobs
On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote: Any suggestions on how to load images from a web site into a MySQL db? I would like to set up a page that allows you to select an image from the local machine and load it to my MySQL DB on my web server. I'm not sure if it would just be a regular insert statement or something else? Well, first you've got to get the file onto the local server. In PHP, you can use fopen() together with other functions to get the file from the user's machine onto the remote server. But I'm not sure you absolutely want to store it in the database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cross-platform Deployment issue.
Hi, I have an application in Java that access MySQL databases through JDBC. The issue is that I have to be able to move the database files across different platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP). If I go to the manual, MySQL says that the database files are compatible between computers with the same floating-point format. What is this about? How can the floating-point issue be overcome without having to export the data in one platform and export it to the other one? Thanks in advance. Bye, Francisco. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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: Query help
Here is a query that will do what you want I think: SELECT count(distinct goal.id) as ours, count(distinct goalopp.id) as theirs, game.id FROM game LEFT JOIN goalopp ON game.id=goalopp.game LEFT JOIN goal ON game.id=goal.game GROUP BY game.id HAVING ours theirs; We have to use a having statement to compare the number of goals since count() is an aggregate function. They can't be computed as part of the where clause as the where clause determines which should be counted in the function. Left Joins are needed in this case because it is possible that there might be 0 goals or goalopp for the game, in which case we still want the number (which would be 0). Hope that helps you understand some of the logic behind why the query has to be this way. Harrison - Original Message - From: Adriano Manocchia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 1:38 PM Subject: Query help I can't seem to properly wrap my brain around left joins. If anyone knows of a good tutorial somewhere, I'd appreciate it. That having been said, I was hoping someone could help with this query I'm trying to do as I've been horribly unsuccessful. 3 tables: goal (own goals), goalopp (opponent goals), game Pertinent fields: goal.id goal.game goalopp.id goalopp.game game.id One game record for each game. One goal record for each own goal, one goal record for each opponent goal, each with a unique id in their table (goal.id, goalopp.id) and a reference to the game id (goal.game, goalopp.game). What I'm trying to do is get the number of games where the goal count is greater than the goalopp count for a set of games. Of course I could just loop through an array for each game, but I was hoping to do it with a single query. So what I'm getting at is essentially select (count game) where ((count goal) (count goalopp)) for each game where game.something='whatever' Help would be greatly appreciated. Age --- Adriano Age Manocchia [EMAIL PROTECTED] Cornell University AIM/Yahoo/MSN: SalsaSharkNet http://salsashark.net/ageICQ: 5962736 --- The capacity to blunder slightly is the real marvel of DNA. Without this special attribute, we would still be anaerobic bacteria, and there would be no music. -Lewis Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Source For MySql
Hi, I know, this might be the dumbest question MySql is Open Source database, but I am not able from where to download the source code for MySql. Please help me Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Relations between tables....
How can I set up mysql so as if the id of an entry from table 1 is inserted in table 2 it will not allow me to delete the information in table 1? EX: table1 holds the description of the products (table1_id is the primary key of the table); table2 holds the information about all the purchased products and the customers. How can I set up table1 to lock all the entries that are used in table2 for reference? I appreciate any answer Thank you, Ciprian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 For MySql
On Tue, 21 May 2002, Mugdha Kulkarni wrote: Hi, I know, this might be the dumbest question MySql is Open Source database, but I am not able from where to download the source code for MySql. Please help me Thanks Here ya go. http://www.mysql.com/downloads/mysql.html Look on those pages, you'll find what you are looking for. Regards, Jason [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
Installation problem
Hi, I've been trying to install Msql-Mysql-modules-1.2216, but I'm getting the following error: After executing #perl Makefile.PL (I've also tried INC=-I/usr/lib perl Makefile.PL) . . . Looks good Note (probably harmless): No library found for -lgz . . . Then I type #make . . . LD_RUN_PATH=/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.96 gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/mysql/lib/mysql /usr/local/mysql/lib/mysql/libmysqlclient.a -lm -lz -L/usr/lib/gcc-lib/i386-redhat-linux/2.96 -lgcc /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status make[1]: *** [../blibl/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/usr/dragonsw/Msql-Mysql-modules-1.2216/mysql' make *** [subdirs] Error 2 I've already installed DBI and DataShowTable. I have no idea of what might be going on... Could you please help me here? Thanks in advanced Miguel Angel Tovar Security Consultant Insys, S.A. de C.V. E-mail: [EMAIL PROTECTED] Tel.: +52 (55) 5322-5216 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inserting images and other blobs
on 5/21/02 2:09 PM, Jim Philips at [EMAIL PROTECTED] wrote: On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote: Any suggestions on how to load images from a web site into a MySQL db? I would like to set up a page that allows you to select an image from the local machine and load it to my MySQL DB on my web server. I'm not sure if it would just be a regular insert statement or something else? Well, first you've got to get the file onto the local server. In PHP, you can use fopen() together with other functions to get the file from the user's machine onto the remote server. But I'm not sure you absolutely want to store it in the database. Yeah, I've heard there are lot's of disadvatages. But it would be cool if it actually was a good thing. So there's no good way to optimize MySQL to handle images well? Is it a Mysql thing or is it a Relational Database issue? /T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
strange fulltext behavior
SELECT ISBN,TITLE FROM tBooks WHERE tBooks.ISBN=1876340436 AND MATCH (tBooks.TITLE) AGAINST (britannica) ++-+ | ISBN | TITLE | ++-+ | 1876340436 | 2000 Lonely Planet Calendar | ++-+ 1 row in set (0.00 sec) Why is it so? I suspected to get an empty result set. MYSQL Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32) -- ./ premax ./ [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: Possible Bug in UPdATE in MySQL 4.0.1 alpha
On Tue, 21 May 2002, Michael Widenius wrote: Hi! Michael == Michael B Venezia [EMAIL PROTECTED] writes: Description: Michael Possible Bug in UPDATE in MySQL 4.0.1 cut Michael Attempting backtrace. You can use the following information to find out Michael where mysqld died. If you see no messages after this, something went Michael terribly wrong... Michael Stack range sanity check OK, backtrace follows: Michael 0x807db7f Michael 0x823d64a Michael 0x8204447 Michael 0x821bbd6 Michael 0x820bb41 Michael 0x80d082f Michael 0x80b0479 Michael 0x8086de7 Michael 0x808a262 Michael 0x8084e57 Michael 0x808a694 Michael 0x8084296 Michael Stack trace seems successful - bottom reached Michael Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow Michael instructions on how to resolve the stack trace. Resolved Michael stack trace is much more helpful in diagnosing the problem, so please do Michael resolve it Michael, could you please read the above instructions and try to resolve the backtrace for us? cut How-To-Repeat: Michael Did this query on a database called 'medical' below text Michael UPDATE `Physical Examination Report` SET `History of Present Michael Illness`='moo\r\nfoo\r\nboo.' WHERE `ID Code of Appointment`=27 Any chance you could ftp a copy of the 'Physical Examination Report' table to ftp://support.mysql.com/pub/mysql/secret so that we could try to repeat the problem ? Just having the table definition formats is not enough to repeat a problem like this! cut Regards, Monty I've uploaded the table as PhysicalExaminationReport.tar.gz to the above location. It is very small (actually it only contains one or two records if I recall) The following is the stack trace resolved... 0x807db7f handle_segfault__Fi + 383 0x823d64a pthread_sighandler + 154 0x8204447 _mi_compare_text + 71 0x821bbd6 _mi_ft_cmp + 158 0x820bb41 mi_update + 721 0x80d082f update_row__9ha_myisamPCcPc + 67 0x80b0479 mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates13thr_lock_type + 2473 0x8086de7 mysql_execute_command__Fv + 5723 0x808a262 mysql_parse__FP3THDPcUi + 270 0x8084e57 dispatch_command__F19enum_server_commandP3THDPcUi + 1319 0x808a694 do_command__FP3THD + 88 0x8084296 handle_one_connection__FPv + 546 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
info...
hi there ... can some one point in the right direction .. other than the mysql manul for mroe information on the INSERT SELECT statement whether or not it can handle date inserted from a form on a web page... Cheers Peter the only dumb question is the one that wasn't asked - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, possible bug?
I am using mysql 4.0.1-alpha on Linux 2.4.18, the info you requested is: select count(*) from newsentries10 where playerid=28575 and type=2; +--+ | count(*) | +--+ | 4218 | +--+ 1 row in set (13.81 sec) mysql select count(*) from newsentries10 where playerid=28575 and type=2; +--+ | count(*) | +--+ | 3705 | +--+ 1 row in set (9.72 sec) mysql select count(*) from newsentries10 where type=2; +--+ | count(*) | +--+ | 611932 | +--+ 1 row in set (9.92 sec) mysql explain select straight_join pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from newsentries10 ne, pnews pn where ne.playerid=28575 and ne.type=2 and pn.newsid=ne.newsid; +---++---+-+-+---+-- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+---+-- --++ | ne| ALL| list_news,delete_news | NULL|NULL | NULL | 774878 | where used | | pn| eq_ref | PRIMARY | PRIMARY | 4 | ne.newsid | 1 || +---++---+-+-+---+-- --++ 2 rows in set (0.01 sec) mysql mysql explain select pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from newsentries10 ne use index (list_news), pnews pn where ne.playerid=28575 and ne.type=2 and pn.newsid=ne.newsid; +---++---+-+-+---+-- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+---+-- --++ | ne| ALL| list_news,delete_news | NULL|NULL | NULL | 774878 | where used | | pn| eq_ref | PRIMARY | PRIMARY | 4 | ne.newsid | 1 || +---++---+-+-+---+-- --++ 2 rows in set (0.00 sec) mysql mysql explain select straight_join pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from newsentries10 ne use index (list_news), pnews pn where ne.playerid=28575 and ne.type=2 and pn.newsid=ne.newsid; +---++---+-+-+---+-- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+---+-- --++ | ne| ALL| list_news,delete_news | NULL|NULL | NULL | 774878 | where used | | pn| eq_ref | PRIMARY | PRIMARY | 4 | ne.newsid | 1 || +---++---+-+-+---+-- --++ 2 rows in set (0.00 sec) Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 12:40 PM Subject: Re: InnoDB, possible bug? Andrei, how many rows in ne satisfy (1) ne.playerid=28575, (2) ne.type=2? What version you are using? .48 was tuned to favor index searches over table scans. What does EXPLAIN SELECT say if you force the index usage with USE INDEX and STRAIGHT JOIN clauses? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Andrei Cojocaru [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, May 20, 2002 6:46 PM Subject: InnoDB, possible bug? Hello, I've just switched to InnoDB table from myISAM and it's been running pretty smoothly except on this SQL statement it doesn't use any indexes when there are, and therefore is very slow. mysql explain select pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from newsentries10 ne, pnews pn where ne.playerid=28575 and ne.type=2 and pn.newsid=ne.newsid; +---++---+-+-+---+-- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+---+-- --++ | ne| ALL| list_news,delete_news | NULL|NULL | NULL | 734023 | where used | | pn| eq_ref | PRIMARY | PRIMARY | 4 | ne.newsid | 1 || +---++---+-+-+---+-- --++ 2 rows in set (0.00 sec) (Notice that key for ne is NULL when there is obviously an index it could use, but doesn't, why?) the table
Importing data from Oracle
Hi, I am having two servers running Oracle and MySQL database. Views has been created for me in Oracle and I want to import data from that Oracle table to my MySQL table. I want a script like something main thing is I want to import data from that Oracle database to MySQL daily...like a scheduled job.. The mysqlimport statement imports data only from text filesbut in my case i want to run a scheduled script that imports data from Oracle to MySQL at a specified time... I am using MySQL version 3.23.22 Is there any tool available for free or any other way to do this..Please help me. Shankar __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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
