MySQL 5.1.9-beta has been released
Hi, MySQL 5.1.9-beta, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point in time - if you can't find this version on some mirror, please try again later or choose another download site. This is a new Beta development release, fixing recently discovered bugs. NOTE: This Beta release, as any other pre-production release, should not be installed on production-level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has worked very hard to ensure a high level of quality, protect your data by making a backup as you would for any software beta release. Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version. Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version. This section documents all changes and bug fixes that have been applied since the last official MySQL release. If you would like to receive more fine-grained and personalised update alerts about fixes that are relevant to the version and features you use, please consider subscribing to MySQL Network (a commercial MySQL offering). For more details please see http://www.mysql.com/network/advisors.html. We welcome and appreciate your feedback! Functionality added or changed: * SHOW PLUGIN was renamed to SHOW PLUGINS. SHOW PLUGIN now is deprecated and generates a warning. (Bug#17112: http://bugs.mysql.com/17112) * mysqld_safe no longer checks for a mysqld-max binary. Instead, mysqld_safe nows checks only for the standard mysqld server unless another server binary is specified explicitly. (Bug#17861: http://bugs.mysql.com/17861) * For partitioned tables, the output of SHOW TABLE STATUS now shows in the Engine column the name of the storage engine used by all partitions for the table; in the Create_options column, the output now shows partitioned for a partitioned table. This change also affects the values shown in the corresponding columns of the INFORMATION_SCHEMA.TABLES table. (Bug#17631: http://bugs.mysql.com/17631) * The NDBCluster storage engine now supports CREATE TABLE statements of arbitrary length. (Previously, CREATE TABLE statements for MySQL Cluster tables could contain a maximum of 4096 characters only.) (Bug#17813: http://bugs.mysql.com/17813) * Large file support was re-enabled for the MySQL server binary for the AIX 5.2 platform. (Bug#13571: http://bugs.mysql.com/13571) Bugs fixed: * NDB Cluster: BLOB columns did not work correctly with user-partitioned NDB tables. (Bug#16796: http://bugs.mysql.com/16796) * mysql_config returned incorrect libraries on x86_64 systems. (Bug#13158: http://bugs.mysql.com/13158) * mysql_reconnect() sent a SET NAMES statement to the server, even for pre-4.1 servers that do not understand the statement. (Bug#18830: http://bugs.mysql.com/18830) * COUNT(*) on a MyISAM table could return different results for the base table and a view on the base table. (Bug#18237: http://bugs.mysql.com/18237) * For mysql.server, if the basedir option was specified after datadir in an option file, the setting for datadir was ignored and assumed to be located under basedir. (Bug#16240: http://bugs.mysql.com/16240) * For full-text searches in boolean mode, and when a full-text parser plugin was used, a MYSQL_FTPARSER_PARAM::ftparser_state could have been corrupted by recursive calls to the plugin. (Bug#18836: http://bugs.mysql.com/18836) * EXTRACT(QUARTER FROM date) returned unexpected results. (Bug#18100: http://bugs.mysql.com/18100) * TRUNCATE did not reset the AUTO_INCREMENT counter for MyISAM tables when issued inside a stored procedure. (Bug#14945: http://bugs.mysql.com/14945) Note: This bug did not affect InnoDB tables. Also, TRUNCATE does not reset the AUTO_INCREMENT counter for NDBCluster tables regardless of when it is called (see Bug#18864: http://bugs.mysql.com/18864). * The server was always built as though --with-extra-charsets=complex had been specified. (Bug#12076: http://bugs.mysql.com/12076) * Partition pruning did not work properly for some kinds of partitioning and subpartitioning, with certain WHERE clauses. (Partitions and subpartitions that should have been marked as used were not so marked.) The error could manifest as incorrect content in
Re: innodb file per table
Duzenbury, Rich wrote: Hi all, I've inherited an innodb database that is configured like: innodb_file_per_table innodb_data_file_path = ibdata1:3000M;ibdata2:3000M;ibdata3:3000M;ibdata4:3000M:autoextend Um, doesn't this allocate 12G that winds up being unused, since innodb_file_per_table is set? If so, what is the correct way to reclaim the 12G? Thanks! Regards, Rich Duzenbury Hi, but you don't know __when__ innodb_file_per_table was set! So it's possible that many innodb tables actually reside in ibdata[1-4]. Check your data directory to see the individual innodb files/tables (*.ibd). Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Undeleting an entire Database?
clint lenard schrieb: Hey guys, Well, I was unable to find anything on Google and I don't expect to find a miracle... but I figured why not. On Sunday morning I was trying to delete a Table through PHPMyAdmin and well... I dropped the entire DB without backing it up before. Stupid mistake, I know. So, I'm using Fedora Core OS/Linux and I was wondering if there was any way to undelete this db? I lost about 350 new members on my site + all kinds of blogs, comments, messages, etc. Is there ANY way to get this info back? If not, It's not a huge deal... I suppose. I just wanted to see if anyone might know of any special ways to get some of the data back. Thanks! - Clint Lenard Ahaha. Yeah probably you do some backups from now on whenever you want to delete something. There are ways to undelete files on linux systems but i do not know how. Probably look for undeleteing files on unix and you might find a clue. Otherwise. On unix: What's gone stays gone! :D -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Undeleting an entire Database?
clint lenard schrieb: Hey guys, Well, I was unable to find anything on Google and I don't expect to find a miracle... but I figured why not. On Sunday morning I was trying to delete a Table through PHPMyAdmin and well... I dropped the entire DB without backing it up before. Stupid mistake, I know. So, I'm using Fedora Core OS/Linux and I was wondering if there was any way to undelete this db? I lost about 350 new members on my site + all kinds of blogs, comments, messages, etc. Is there ANY way to get this info back? If not, It's not a huge deal... I suppose. I just wanted to see if anyone might know of any special ways to get some of the data back. Thanks! - Clint Lenard Ah probably you have logged the insertings and updatings, there might be a binarylog around there. You can use that also to restore the DB. good luck ~ -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld vs. mysql-max
Hi Payne, Payne wrote: Hey, I got a box that is dying, it is currently running MySQL-Max, I want to move the DB from it to a box that is running just plain jane MySQL, what will happen and will it work. I know, strange but I am not sure what the Max does. we cannot tell either, as you do not list the versions involved. Basically, max is standard with some more advanced stuff added, typically the cluster table handler (aka NDB) and some options considered experimental (like big tables, big joins etc.). The exact feature difference varies from version to version, as some of the experimental features are later considered stable and well-tested and then get included in the standard server. The main difference that will remain is the issue of the cluster handler; and as long as you do not use it, its inclusion in Max does not make a difference to you. In short: Most likely, the difference will not matter for you (for otherwise you would know about it). Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Undeleting an entire Database?
The binary log will be available if you got setting the synronization between server A and server B. So to restore the db, server A can be use binary log in server B to re-execute all the insert/update/delete/create/drop query in log. If log is available since created the db then re-execute all the log will recover back the db. But the case is if re-execute all the log mean the db will re-drop again...To solve this, change the db structure or rename the db, then will cause to re-execute position stop, then drop query will not run. Good luck. On 4/26/06, Barry [EMAIL PROTECTED] wrote: clint lenard schrieb: Hey guys, Well, I was unable to find anything on Google and I don't expect to find a miracle... but I figured why not. On Sunday morning I was trying to delete a Table through PHPMyAdmin and well... I dropped the entire DB without backing it up before. Stupid mistake, I know. So, I'm using Fedora Core OS/Linux and I was wondering if there was any way to undelete this db? I lost about 350 new members on my site + all kinds of blogs, comments, messages, etc. Is there ANY way to get this info back? If not, It's not a huge deal... I suppose. I just wanted to see if anyone might know of any special ways to get some of the data back. Thanks! - Clint Lenard Ah probably you have logged the insertings and updatings, there might be a binarylog around there. You can use that also to restore the DB. good luck ~ -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie Locking Question
David T. Ashley wrote: Nigel wrote: mod_php will persist the MySQL connection holding open any lock or syncronisation token obtained through any of the three methods : begin/commit, lock/unlock tables or get_lock/release_lock. PHP does ensure that even in the event of timeouts or fatal errors any shutdown handlers registered are still executed so it is possible to clean up properly whichever method is used. http://uk.php.net/manual/en/function.register-shutdown-function.php If you use php's pdo with transactions it perform a rollback for you on abort or completion. What is a pdo? Thanks, Dave. PHP's newest official way to talk to databases: http://www.*php*.net/*pdo *http://wiki.cc/*php*/PDO http://www.phpro.org/tutorials/Introduction-to-PHP-PDO-(PHP-Data-Objects).html Nigel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
utf8 character collation not working
MySQL list, I have a database on a server that contains English and Japanese text. I have tried to ensure at every turn that all text encoding is in utf8. On the web hosting server where the live site resides, everything is working fine. But on my testing environment at home, the Japanese text displays as question marks. Japanese text that is written directly into the PHP/HTML displays correctly. Only Japanese text retrieved from the database displays incorrectly. All the Japanese text was initially entered on the hosting server. To get the database duplicated onto my testing environment, I exported the database, and then imported it again. I also checked the .sql file that was generated to ensure that the utf8 encoded Japanese was still readable as Japanese before importing it. Further, when I look at the database in phpMyAdmin, it displays the Japanese correctly. I had a similar problem a few months back, and at the time, it was advised that I add the following lines to /etc/mysql/my.cnf: init-connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci I've done this, and so these are my collation variables: Variable Session value Global value character set clientutf8 utf8 character set connection utf8 utf8 character set database utf8 utf8 character set results utf8 utf8 character set server utf8 utf8 character set system utf8 utf8 character sets dir /usr/share/mysql/charsets/ /usr/share/mysql/charsets/ collation connection utf8_general_ci utf8_general_ci collation database utf8_general_ci utf8_general_ci collation server utf8_general_ci utf8_general_ci This solved the problem last time. But this time the same solution does not seem to be working. I hope I have described the problem in enough detail. If not, please let me know. Is there any other character set related setting that I may need to do on my local MySQL server to correctly display Japanese? My home set up: Ubuntu Dapper Drake 6.06 MySQL MySQL 4.1.15 phpMyAdmin 2.7 PHP 4.4.2 Any help would be much appreciated. Thank you. -- Dave M G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help for my jointure
--- Patrick Aljord [EMAIL PROTECTED] wrote: I have a table confs like this: id int 5 auto_increment primary key; conf text; and another table conf_ip like this: id int 5 auto_increment primary key; conf_id int 5; ==foreing key of confs ip varchar 150; I would like to select id, conf from confs where ip!='some val'; how can I do this? thanx in advance Pat What is the question you want answered? What you wrote can answer some questions but that may not be the actual query you are trying to write. Please describe in words what you are looking for and I (or someone else on the list) will be able to respond with an appropriate query. Shawn Green __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ANN] DBManager Professional 3.3.0
DBTools Software is pleased to announce the availability of the new DBManager Professional 3.3.0 Enterprise Edition. This release brings a lot of new features and lots of improvements and bug fixes. See the short list below: - New Visual Interface - New Procedure Builder with support for Functions and Triggers - New Form Designer, now supporting subforms, menus and images inplace - Diagram Designer redesigned - Table Designer was remodeled and now includes information about the table changes before commit - Database Dump Wizard has plenty of new options. One particular is the possibility to create a dump for older versions. This is useful if one needs to dump and reload the database into different server versions - Implemented Drag Drop operation for extended objects like: Stored Procedures, Functions, Views, etc - Query Builder has being redesigned to add more useful information about queries and other objects as well as allow editing external queries - Many improvements and bugs fixed The full list of changes can be viewed at http://www.dbtools.com.br/EN/article.php?id=00062. To download the new version go to http://www.dbtools.com.br/En/downloads. What is DBManager Professional? DBManager is a Windows application for database management. It supports MySQL, PostgreSQL, Interbase, Firebird, SQlite, DBF Tables (Clipper, DBase III, IV, V, FoxPro), MSAccess, MSSQL Server/MSDE, Oracle, Sybase and ODBC Datasources (read only). Among its features you will find: - Complete database structure management for Tables, Indexes, Foreign Keys, Check Constraints, Triggers, Domains, Stored Procedures, User Defined Functions, Schemas/Namespaces, Tablespaces, etc - Query Builder and Query Designer to build and test queries, with features like: codesense and codetip, syntax coloring editor, help on SQL/DDL/DML commands, results with blob shown as image, Query Planner and Debugger - Procedure Builder (Extended from Query Builder) to develop and test Stored Procedures, Functions, Triggers and Views - Diagram Designer to visually create database diagrams - Form and Report Builders - Database Compare to synchronize database structure - Lots of wizards to import and export data. From MSAccess, ODBC, MSExcel, HTML, XML, Text CSV, Text Fixed to any of the database engine supported by DBManager - Database Migration Wizard to move structure and data between databases - Database Control Version System: catalog your database versions and create DDL files with a complete database or just the difference between versions - Web Script Generator, a wizard to create script for the web in PHP and ASP - And much more For more details on DBManager Professional check http://www.dbtools.com.br/EN/dbmanagerpro Best Regards, DBTools Software http://www.dbtools.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help for my jointure
On 4/26/06, Patrick Aljord [EMAIL PROTECTED] wrote: I have a table confs like this: id int 5 auto_increment primary key; conf text; and another table conf_ip like this: id int 5 auto_increment primary key; conf_id int 5; ==foreing key of confs ip varchar 150; ok, sorry all for not being specific enough. I figured a query which is half working like that: select c.id, c.conf from confs as c inner join conf_ip as i on c.id = i.conf_id where i.ip!='someip I would like the select to return all the c.id that are in conf and all that don't have a c.ip='someip'. The problem is that if there is a record that have the c.id=i.conf_id but an ip different than localhost, my query will still return the corresponding c.id and I don't want that. I tried something like that but couldn't get it to work: select c.id, c.conf from confs as c inner join conf_ip as i on c.id = i.conf_id where (select i.ip from conf_ip where ip='$ip')=0 hope yo usee what I mean Thanx in advance Pat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to get result set from stored procedure?
yes it is true, you have to check if the constant CLIENT_MULTI_STATEMENT is set or not. basically this constant has for value 65536. HTH Alain On 4/25/06, Juri Shimon [EMAIL PROTECTED] wrote: Hello Juri, Tuesday, April 25, 2006, 5:49:25 PM, you wrote: JS mysql=mysql_init(NULL); JS mysql_real_connect(mysql, NULL, User, pwd, test, MYSQL_PORT, NULL, 0); JS mysql_query(mysql, call test()); JS results to error: PROCEDURE test.test can't return a result set in the given context JS What's wrong? I've solved it: CLIENT_MULTI_STATEMENTS. Thanks to All! -- Best regards, Jurimailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help for my jointure
--- Patrick Aljord [EMAIL PROTECTED] wrote: On 4/26/06, Patrick Aljord [EMAIL PROTECTED] wrote: I have a table confs like this: id int 5 auto_increment primary key; conf text; and another table conf_ip like this: id int 5 auto_increment primary key; conf_id int 5; ==foreing key of confs ip varchar 150; ok, sorry all for not being specific enough. I figured a query which is half working like that: select c.id, c.conf from confs as c inner join conf_ip as i on c.id = i.conf_id where i.ip!='someip I would like the select to return all the c.id that are in conf and all that don't have a c.ip='someip'. The problem is that if there is a record that have the c.id=i.conf_id but an ip different than localhost, my query will still return the corresponding c.id and I don't want that. I tried something like that but couldn't get it to work: select c.id, c.conf from confs as c inner join conf_ip as i on c.id = i.conf_id where (select i.ip from conf_ip where ip='$ip')=0 hope yo usee what I mean Thanx in advance Pat Yes, I think I do. What you have is a table of 'conf' (whatever they are) that can have multiple IP addresses (see table `conf_ip`). What I think you want to know is which confs do not have a particular IP address. There are several ways to write this query. One of the more straightforward ways to write this is to use a temporary table (depending on your version, this should work well written as a subquery, too). CREATE TEMPORARY TABLE tmpMatches (key(conf_id) SELECT DISTINCT conf_id FROM conf_ip WHERE ip = 'some_ip_value'; SELECT c.id, c.conf FROM confs c LEFT JOIN tmpMatches m ON m.conf_id = c.id WHERE m.conf_id IS NULL; DROP TEMPORARY TABLE tmpMatches; What we do is generate a list of all of the conf's that do have the target IP and save that list into a temporary table. Then we run a query that finds every conf EXCEPT those we just located in the first step. Last we clean up after ourselves by getting rid of the temp table. Make sense? Shawn Green Database Administrator __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)
I think I said that earlier, but the distance between two zip codes deal is inaccurate, yet useful, for instance on a Classified Ads Web site. As for the Zip+4, I do not know of any database that gives the latitude and longitude for them specifically. But I am certain it has to exist. The US Post Office sells there Zip+4 database for I think a thousand dollars. From there I guess you could use some tool to translate these Zip+4 into their lat/lon values, but bombarding someone's Web site with tens of thousands of requests to do that translation is not necessarily a nice thing to do. I know that http://www.gpsvisualizer.com/convert?form=address is a site where you are invited to do it, by sending your CSV. You are also invited to click on the many ads. Also, in order to do the Zip+4 translation, you need a good CASS certification script. Most of these products are expensive. You could program your own, but from talking to a programmer who created such a product, it takes years to come with a good one, because people misspell their street addresses in so many ways, it's not even funny. For information, the Canadian Post Office 6-character postal code is a zip+4 code of some sort, as the 3 first alphanumerical are the equivalent of the 5-digit US zip code and the last 3 the equivalent or the 4-digit plus 4. -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:19 PM To: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) My confusion is that I have some formulas to plug in these values, but it seems to me that if I use the wrong set of data, my zipcodes will be wrong too. I also don't understand why there is even such a difference. I can understand a few decimal points being different, but I don't understand how they are positive and negative, when it's supposed to be based upon the equator and the prime meridian. Since they're US zipcodes, it's not like we're in different parts of the world or anything. -Original Message- From: Gmail User [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 6:03 AM To: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote: So for a sanity check, I decided to look online and punch in some to see what the real lat/long should be. Well, different sites give different values, and not only are they slightly off, but sometimes they're _positive_ or _negative_!? UGH! Not sure what your confusion is. It is a matter of notation. The negative value represents West where it is negative (as would be the East; note how there is no W mentioned there). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)
That is exactly the issue. Also if you use the real address to determine the lat/lon instead of the zip code, the result will be different. -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 6:55 PM To: [EMAIL PROTECTED]; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) You could further explain the lats and longs being slightly off by the use of a different datum. There are many many datums utilised by different geographical/geological authorities. This difference could become quite large dependent upon the datum used. As gmail user as noted, negative = West and South, positive = North and East. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 April 2006 11:17 AM To: Daevid Vincent Cc: mysql@lists.mysql.com Subject: Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) Daevid Vincent wrote: My confusion is that I have some formulas to plug in these values, but it seems to me that if I use the wrong set of data, my zipcodes will be wrong too. I also don't understand why there is even such a difference. I can understand a few decimal points being different, but I don't understand how they are positive and negative, when it's supposed to be based upon the equator and the prime meridian. Hasn't that already been explained here? Sign is entirely a matter of convenience and convention. PB -Original Message- From: Gmail User [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 6:03 AM To: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote: So for a sanity check, I decided to look online and punch in some to see what the real lat/long should be. Well, different sites give different values, and not only are they slightly off, but sometimes they're _positive_ or _negative_!? UGH! Not sure what your confusion is. It is a matter of notation. The negative value represents West where it is negative (as would be the East; note how there is no W mentioned there). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Alternate forms of given name, lookup table
Does anyone know where I mind find a table to look up alternate forms of a certain given name? For example; if I give it Bob it gives me Robert and if I give it Bill it gives me Will and William. Or if I give it either Dick, Rick or Richard it gives me back the other two. Also, once I have this lookup table and I am trying get Bob in my table A to match with Robert in my table B what would the query look like. Just to start here is kind of what I have been doing so far... SELECT a.FName a.MName, a.LName, a.Street, a.City, a.State, a.ZIP, a.Phone FROM TableA as a, TableB as b WHERE a.LName = b.LName AND LEFT(a.MName, 1) = b.MInitial AND a.ZIP = b.ZIP ## the following will match names like Chris and Christopher. I need to replace this with something better. ( (b.FName like concat(a.FName, '%') AND a.FName = a.FName) OR (a.FName like concat(b.FName, '%') AND b.FName = b.FName) ) ORDER BY a.LName, a.FName -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Out of memory (Needed xxx ...
Getting this error from JDBC while inserting a VERY large VARBINARY or MEDIUMTEXT field, ~250MB. I'm guessing this is an error from the server? Is there a way to have the server start streaming to disk sooner with a LOB? Is there a property I'm not setting? TIA, R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
VIEW not working with myODBC in XP and Access 2003
I have a critical problem that I hope there is a simple solution for. I've just spent a couple days converting a very messy hack to populate a table using a much more elegant VIEW solution now. Everything is going great, except now the whole point of this VIEW is so that people using MS Access (or other ODBC) can use the VIEW. It doesn't work!?! I've followed all of this: http://dev.mysql.com/doc/refman/5.0/en/msaccess-setup.html I can import/link any other non-VIEW table. I've given FULL permissions to my ODBC user in mysql.mysql.user (and other appropriate) places just in case. Access pops up an error box that says Could not execute query; could not find linked table I'm using these versions: Windows XP http://dev.mysql.com/downloads/connector/odbc/3.51.html [EMAIL PROTECTED]:/lockdown# mysql --version mysql Ver 14.12 Distrib 5.0.15, for pc-linux-gnu (i686) using readline 4.3 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Out of memory (Needed xxx ...
Hi Robert, are you using the extended parameters to increase the jvm heap memory ? ie. java -Xms256m -Xmx512m Carlos On 4/26/06, Robert DiFalco [EMAIL PROTECTED] wrote: Getting this error from JDBC while inserting a VERY large VARBINARY or MEDIUMTEXT field, ~250MB. I'm guessing this is an error from the server? Is there a way to have the server start streaming to disk sooner with a LOB? Is there a property I'm not setting? TIA, R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: Out of memory (Needed xxx ...
I am, the java heap is set to 2G. But I don't think it is my java process that is running out of memory, I believe it is the MySQL server. -Original Message- From: Carlos Proal [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 4:53 PM Cc: mysql@lists.mysql.com Subject: Re: Out of memory (Needed xxx ... Hi Robert, are you using the extended parameters to increase the jvm heap memory ? ie. java -Xms256m -Xmx512m Carlos On 4/26/06, Robert DiFalco [EMAIL PROTECTED] wrote: Getting this error from JDBC while inserting a VERY large VARBINARY or MEDIUMTEXT field, ~250MB. I'm guessing this is an error from the server? Is there a way to have the server start streaming to disk sooner with a LOB? Is there a property I'm not setting? TIA, R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Out of memory (Needed xxx ...
And whats the size of your max_allowed_packet variable ? Carlos On 4/26/06, Robert DiFalco [EMAIL PROTECTED] wrote: I am, the java heap is set to 2G. But I don't think it is my java process that is running out of memory, I believe it is the MySQL server. -Original Message- From: Carlos Proal [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 4:53 PM Cc: mysql@lists.mysql.com Subject: Re: Out of memory (Needed xxx ... Hi Robert, are you using the extended parameters to increase the jvm heap memory ? ie. java -Xms256m -Xmx512m Carlos On 4/26/06, Robert DiFalco [EMAIL PROTECTED] wrote: Getting this error from JDBC while inserting a VERY large VARBINARY or MEDIUMTEXT field, ~250MB. I'm guessing this is an error from the server? Is there a way to have the server start streaming to disk sooner with a LOB? Is there a property I'm not setting? TIA, R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: Out of memory (Needed xxx ...
It's not set, but I am streaming the LOG to the server, would max packet impact this situation? Also, wouldn't I get a different error, i.e. Packet Too Large? From: Carlos Proal [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 4:59 PM To: Robert DiFalco Cc: mysql@lists.mysql.com Subject: Re: Out of memory (Needed xxx ... And whats the size of your max_allowed_packet variable ? Carlos On 4/26/06, Robert DiFalco [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I am, the java heap is set to 2G. But I don't think it is my java process that is running out of memory, I believe it is the MySQL server. -Original Message- From: Carlos Proal [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 4:53 PM Cc: mysql@lists.mysql.com Subject: Re: Out of memory (Needed xxx ... Hi Robert, are you using the extended parameters to increase the jvm heap memory ? ie. java -Xms256m -Xmx512m Carlos On 4/26/06, Robert DiFalco [EMAIL PROTECTED] wrote: Getting this error from JDBC while inserting a VERY large VARBINARY or MEDIUMTEXT field, ~250MB. I'm guessing this is an error from the server? Is there a way to have the server start streaming to disk sooner with a LOB? Is there a property I'm not setting? TIA, R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Consenus on best column type for Latitude / Longitude?
Just curious the majority use. I've been using decimal(18,14), but that appears bigger than necessary... Maybe varcar(21) for latitude, and varchar(22) for longitude? ...Rene
