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, counties, states and countries if I recall correctly. > > -Original Message- > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De > Meersman > Sent: Wednesday, February 02, 2011 7:59 AM > To: viraj > Cc: mysql@lists.mysql.com > Subject: Re: map polygon data for popular us cities > > On Wed, Feb 2, 2011 at 11:30 AM, viraj wrote: > >> dear list, >> where can i find a list of map polygons for united states cities? any >> open database? or tool to obtain correct coordinates? >> > > A bit offtopic here, but I suspect that most such databases will be > proprietary and thus payable through the nose. Have a look at the > OpenStreetMap project, I suspect their database might be accessible under > some open license. > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > IMPORTANT: This email message is intended only for the use of the individual > to whom, or entity to which, it is addressed and may contain information that > is privileged, confidential and exempt from disclosure under applicable law. > If you are NOT the intended recipient, you are hereby notified that any use, > dissemination, distribution or copying of this communication is strictly > prohibited. If you have received this communication in error, please reply > to the sender immediately and permanently delete this email. Thank you. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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. ~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: 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: > I want to know about veryfing the Signature not the Md5 as described in the > page http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html.I > did verify Md5 checksum. > > > On 2 December 2010 22:51, viraj wrote: >> >> 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 package can be obtained from the download >> > page.But I am not able to locate it? >> > >> > -- >> > Kind Regards >> > Varuna Seneviratna >> > > > > > -- > Kind Regards > Varuna Seneviratna > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 package can be obtained from the download > page.But I am not able to locate it? > > -- > Kind Regards > Varuna Seneviratna > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 work , I have tried > to concatonate the insert statements. I have tried multiple $query > variables, but it is just overwriting itself (only the last one gets > inserted). I also tried writing the $query as an array, which got me an > error message (saying it was expecting a string and I offered an array). > > Someone point me in the right direction? > > Gary > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > http://www.w3.org/1999/xhtml";> > > > Untitled Document > > > > > > > First Name > Last Name > Street Address /> > Town > State > Zip Code > Telephone > Fax > E-Mail > Comments rows="15"> > > > > > > $fname=($_POST['fname']); > $lname=($_POST['lname']); > $street=($_POST['street']); > $town=($_POST['town']); > $state=($_POST['state']); > $zip=($_POST['zip']); > $phone=($_POST['phone']); > $fax=($_POST['fax']); > $email=($_POST['email']); > $comments=($_POST['comments']); > $REMOTE_ADDR=$_SERVER['REMOTE_ADDR']; > > $dbc=mysqli_connect('localhost','root','','test'); > $query="INSERT INTO address (street, town, state, > zip)"."VALUES('$street','$town','$state','$zip')". > "INSERT INTO comments(comments)"."VALUES('$comments')". > "INSERT INTO contact(phone,fax,email)"."VALUES('$phone','$fax','$email')". > "INSERT INTO name (fname, lname)"."VALUES('$fname','$lname')"; > > $result = mysqli_query($dbc, $query) > or die('Error querying database.'); > > mysqli_close($dbc); > > ?> > > > > > > __ Information from ESET Smart Security, version of virus signature > database 5017 (20100411) __ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=kali...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ft_min_word_len does not pick up on a debian box
hi all, i'm trying to set ft_min_word_len to 2 in my.cnf of a debian box. i found it does not pick up the new value but the default value 3. i just upgraded the mysql version to 5.1. setting the value to a higher value (12) works, tried rebuilding the indexes and dropping and adding the fulltext 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. > thanks jesper. ~viraj > It is of course possible to do a workaround in a stored procedure and use > permissions to ensure that the normal users cannot update the table directly. > I don't know whether that will be an acceptable solution in your case though. > > Jesper > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=kali...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ERROR 1442 (HY000) when delete inside trigger statement
i have two table, T1, T2. and 1 trigger. trigger is before update on T1 and it updates some values in T2. once it's done, the trigger tries to delete the subject row of T1 (delete from T1 where id = new.id) i tried with second trigger on T2 (after/before update) and with a procedure inside this trigger.. but, all the time i get.. issue: ERROR 1442 (HY000): Can't update table 'T1' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. found http://forums.mysql.com/read.php?99,122354,122354#msg-122354 and many 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
slow performance with MERGE tables
`) ) TYPE=MRG_MyISAM UNION=(accounting_2002W29,accounting_2002W30,accounting_2002W31,accounting_2002W32,accounting_2002W33,accounting_2002W34,accounting_2002W35) Thanks for any help, Viraj. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: install mysql on RedHat7.1
Actually, in my redhat 7.1 distribution, it has only mysql-VERSION.rpm, mysql-server-VERSION.rpm and mysql-devel-VERSION.rpm only, it's missing it's client rpm. I checked with my previous 7.0 cd set, it's missing the client too. So is it possible to install without client. Now i'm tring it with latest tar.gz, and following the online tutorial http://perl.about.com/ but when i run the command "/support-files/mysql.server start", it says permission denied problem. I tried to execute as root and the created mysql user, but the same error returns. Can anybody 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 '; '[EMAIL PROTECTED] ' Subject: RE: install mysql on RedHat7.1 Can you please post the error message and/or number that you are receiving? -Original Message- From: Viraj Kalinga Abayarathna To: [EMAIL PROTECTED] Sent: 8/7/02 8:43 PM Subject: install mysql on RedHat7.1 hi, I'm tring to install mysql RPMs which ships with redhat 7.1. Rpms installed successfully, but when mysqld it says var/lib/mysql/mysql.error , if anybody knows the solution please explain me, or send me a url to a online tutorial, i have tried the mysql installation guide, it id not help me. I download the latest tar.gz available on mysql site, it gives some errormessae.sys not existed problem. please help on the same vk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: insert delayed and timestamps
On Tue, Apr 02, 2002 at 08:53:27AM -0600, Rick Emery wrote: > What happened when you tried this experiment? I just did the following: In one client connection, issued 'lock tables outgoing write'. Then in another client connection, tried to do an 'insert delayed' without specifying the timestamp. This query finished right away but was not inserted. About a minute later, I issued 'unlock tables' in the first client. The row from the 2nd client was inserted, and it it had the timestamp value of the original delayed insert (not the current time after 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 timestamps > > > Hello, > > When using 'insert delayed' syntax and there is a timestamp field in the > table > but not specified in the insert query, which timestamp is actually used when > the record ends up in the destination table? In other words, will the > timestamp value be the actual timestamp that the 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. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
help optimizing log table deletes
Hello, We have an 'outgoing' table being used to store email header information defined as follows: CREATE TABLE outgoing ( rpath varchar(80) default NULL, auth varchar(80) NOT NULL default '', ip varchar(80) default NULL, hfrom varchar(80) default NULL, hto varchar(80) default NULL, subject varchar(80) default NULL, messageid varchar(80) default NULL, timestamp timestamp(14) NOT NULL, rcpts smallint(5) unsigned default '0', KEY at_ind (auth,timestamp,rcpts) ) TYPE=MyISAM; On average we have about 300k records in this table. Every day we archive data older than 7 days to another table, with a query similar to: $last_time = select now() - interval 7 day; insert into newtable select * from outoing where timestamp < '$last_time'; delete from outgoing where timestamp < '$last_time'; The problem is the 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 but this seems overkill for this slight issue. sql Viraj. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert delayed and timestamps
Hello, When using 'insert delayed' syntax and there is a timestamp field in the table but not specified in the insert query, which timestamp is actually used when the record ends up in the destination table? In other words, will the timestamp value be the actual timestamp that the 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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 actually mean? Viraj. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sql help examining log table
Hello, We use mysql to store outgoing email headers from our users and do throttling on users that appear to be spamming based on some simple queries to this table. We use the Communigate mail server and this throttling script is a PERL program implemented as a content filter. More information is here for those interested: http://www.cse.fau.edu/~valankar/ I am trying to figure out what is the best way to do a certain query. My outgoing log table looks like this: mysql> desc outgoing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | rpath | varchar(80) | YES | | NULL| | | auth | varchar(80) | | MUL | | | | ip| varchar(80) | YES | | NULL| | | hfrom | varchar(80) | YES | | NULL| | | hto | varchar(80) | YES | | NULL| | | subject | varchar(80) | YES | | NULL| | | messageid | varchar(80) | YES | | NULL| | | timestamp | timestamp(14)| YES | | NULL| | | rcpts | smallint(5) unsigned | YES | | 0 | | +---+--+--+-+-+---+ What I would like to do is reject a message if the last 50 messages have the same subject. In other words, I want to look at the 50 latest entries in this table for a certain user (identified by the auth field) to find out if all of these messages have the same subject. The only way I can think of doing this is basically: select subject from outgoing where auth='USER' order by timestamp desc limit 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://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_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, Viraj. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database= in my.cnf causes mysqldump to fail
Hello, I'm not sure if this is a bug or not, but I've noticed that if I have a 'database=' in my ~/.my.cnf, calling mysqldump with any possible options always returns: mysqldump: option `--databases' doesn't allow an argument The only way I can get it working is 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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help on optimizing
Hello, I'm trying to optimize a table but not sure what more I can do. I have a table like the following: CREATE TABLE `outgoing` ( `rpath` varchar(80) default NULL, `auth` varchar(80) NOT NULL default '', `ip` varchar(80) default NULL, `hfrom` varchar(80) default NULL, `hto` varchar(80) default NULL, `subject` varchar(80) default NULL, `messageid` varchar(80) default NULL, `timestamp` timestamp(14) NOT NULL, `rcpts` smallint(5) unsigned default '0', KEY `at_ind` (`auth`,`timestamp`,`rcpts`) ) TYPE=MyISAM CREATE TABLE `exempt_users` ( `auth` varchar(80) NOT NULL default '', `comment` varchar(80) default NULL, `timestamp` timestamp(14) NOT NULL, PRIMARY KEY (`auth`) ) TYPE=MyISAM Now on these tables I am doing the following query: select count(outgoing.auth),sum(outgoing.rcpts) from outgoing left join exempt_users on outgoing.auth=exempt_users.auth where exempt_users.auth is null and outgoing.auth = 'USER' and timestamp >= (now() - interval 1 day) USER will be varying. I thought the indexes I have would be enough but I'm noticing from 'show status': | Select_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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php