Re: map polygon data for popular us cities

thank you all for the links and notes. ~viraj On Thu, Feb 3, 2011 at 7:08 AM, Gavin Towey wrote: > Openstreetmap.org is as close as you'll get. I'd be surprised if they have > shapes for cities beyond just lat/lon point data, but they should have shapes > data for zips, c

map polygon data for popular us cities

dear list, where can i find a list of map polygons for united states cities? any open database? or tool to obtain correct coordinates? i googled but couldn't find anything useful.. may be the terms i use are not the correct keywords :( any help or advice would be really appreciated. ~

Re: How can I obtain the corrosponding Signature file for a MySQL package to verify package

sorry for not reading it correctly.. yep.. seems like a good catch. .asc is not linked or available in keyserver for bu...@mysql.com. cut and paste the provided build key in the manual and gpg --import could be a solution ~viraj On Thu, Dec 2, 2010 at 10:58 PM, Varuna Seneviratna wrote: >

Re: How can I obtain the corrosponding Signature file for a MySQL package to verify package

http://dev.mysql.com/downloads/mysql/ you can see the md5 sum close to the download button ~viraj On Thu, Dec 2, 2010 at 7:48 PM, Varuna Seneviratna wrote: > According to the Doc > http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html the > Signature file for a MySQL pa

Re: INSERT INTO multiple tables

is it mysqli query or 'multi_query'? http://php.net/manual/en/mysqli.multi-query.php ~viraj On Sun, Apr 11, 2010 at 10:27 PM, Gary wrote: > I am experimenting with multiple tables, it is only a test that is my local > machine only. This is the current code, which does not wor

ft_min_word_len does not pick up on a debian box

ltext index. still no luck. what am i missing here? ~viraj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: ERROR 1442 (HY000) when delete inside trigger statement

> > That is correct. There is as far as I know no way in a MySQL trigger to > neither to do operations on the table the trigger belongs to (obviously > except the row that the trigger is operating on through the NEW variables) > nor reject an insert, update, or delete. > than

ERROR 1442 (HY000) when delete inside trigger statement

other articles which had ended up with no solution. (with before update, it's possible to set new values to NEW.*, but did not find anything useful to do a successful delete) could somebody please confirm this is not possible!!! so i can think about some other workaround :) thanks ~viraj

slow performance with MERGE tables

`city_id` mediumint(8) unsigned default NULL, `provider_id` mediumint(8) unsigned default NULL, UNIQUE KEY `ac_ind` (`user_name`,`acct_session_id`,`nas_ip`,`acct_status_type`), KEY `nas_ind` (`nas_ip`) ) TYPE=MRG_MyISAM UNION=(a

RE: install mysql on RedHat7.1

body explain me how to install latest mysql tar.gz on RedHat linux 7.1,step by step, or send me a link to a good tutorial. V.k. Abaya -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 8:52 AM To: 'Viraj Kalinga Abayarathna '; &

AIX 5L binaries?

Hello, Are there any plans for releasing AIX 5L pre-compiled binaries? I notice there are some MySQL RPMs available from other locations but they are not the latest version. If not, are there any pointers to AIX 5L compilation steps? Viraj

Re: insert delayed and timestamps

the unlock). So this answers my question, the value from the delayed temporary table is used. Thanks, Viraj. > -Original Message- > From: Viraj Alankar [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 8:50 AM > To: [EMAIL PROTECTED] > Subject: insert delayed and t

help optimizing log table deletes

he delete query can take up to 1 minute to execute. This prevents any other inserts from taking place since the table is locked. I was wondering how I can design this better to avoid this problem. My thought was to go to InnoDB bu

insert delayed and timestamps

record was inserted into to the destination table (i.e. unknown at insert time) or the temporary 'delayed' table? It seems logical it would use the delayed table timestamp value, but I would like to confirm. sql Viraj. - Be

delete vs delete quick

sql Hello, I'm confused as to what 'delete quick' does and when to use it. The manual states: If you specify the word QUICK then the table handler will not merge index leafs during delete, which may speed up certain kind of deletes. What does this actual

sql help examining log table

50 And then going through each one of these rows in my program to see if they are all the same subject. Is there a way I can do this logic in the select query instead? Thanks, Viraj. - Before posting, please check: http://

Select_full_join counter

Hello, The MySQL manual states that the Select_full_join status counter should be 0. Can someone explain to me what this actually counts and why it is bad to not have this 0? I have some queries that I'm not sure how else to optimize. Thanks,

database= in my.cnf causes mysqldump to fail

to remove the 'database=' line from ~/.my.cnf. Is this normal? Viraj. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

Help on optimizing

_full_join | 606616| And it is rising. This is the only query I am doing on the database. The MySQL docs say this should be 0. Is there something wrong my design or is there anything I can do to improve the speed? Thanks, Viraj.