| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> its an interesting idea i think, would be so happy to get it working :) it'd really differentiate my service from the competition
<1> well espionage` - QAS do both an API (QAS Rapid) for their database, and they also offer proxied lookup services iirc. If you don't manage to solve your problem internally you can usually negotiate a good discount with QAS sales staff.
<0> Ive already got the database etc, i'd rather do it for free :\
<0> but yeah ill keep it in mind
<2> has the db got long lat
<0> yes
<2> or ngr
<0> outcode, x-coord, y-coord, long, lat
<0> my tables have name, address, outcode, incode
<1> I really don't want to beg, but i'm low enough, pleeze. how to do "Where field=not null", can it be done?
<0> ah
<3> vandemar everything seems to be ok
<0> it doesnt use pythagorus
<0> it uses a square rather than a circle
<0> i got 3 tables (table1 provides auto_increment'd id, for each area of each city available, table2 provides the same ids (not incremented) to identify certain services i provide, with outcode and incode fields, and table3 contains a list of all the UK's postcodes with fields: outcode, x-coord, y-coord, long, lat)
<4> febo, are the mysql grant tables there? In /data/dir/mysql/ there should be a bunch of tables like db and user
<3> vandemar where /data/dir/mysql I do not know where it is ?
<4> you just checked the permissions of it, didn't you?
<0> lines 6,7 13-77, 94-98: http://pastebin.com/623125
<2> espionage`, pythagarus is for triangles you have x,y .... calc the long side
<0> i know
<0> but this system doesnt use pythagorus
<0> if you want to simplify it so that it does, that'd be good too :p
<2> its for you to do the calcs
<0> Here you would expect to find pythagoras' theorem to calculate the distances exactly. However, it is not here. This formula below just uses a "square" around the postcode that you input, rather than a circle. You may be wondering if this is not a rather gross approximation. Yes, it is - but I think it is justifed. The key advantage is that the performance of the algorithm improves m***ively as the maths is very simple. Wha
<0> approximation (using a square instead of a circle is not a major problem, because we are only searching on outcodes, which are quite large areas anyway. So essentially the inaccuracy is masked by the size of the data.
<1> omg- theres a null constant. pfft.
<3> where are store myslq grant tables
<4> febo, search my.cnf for "datadir"
<2> in the mysql db in the data dir
<0> anyone fancy giving me a hand? :\
<0> you'd get some satisfaction and a new best friend!! :P
<2> seems like you need to read your pdf to learn how to use it
<0> i hav :\
<0> it unnecessarily introduces a user/p*** system
<0> which is confusing me :x
<3> vandemar : and so I clean everything
<3> vandemar I remove everything do remove and install still the same problem
<4> complain to debian.
<1> ok, another question. How to get unique rows - fx select distinct cat from docs; only returns the field cat - I need all fields returned but where cat is unique among results.
<3> fed up ...
<3> bye bye
<1> cya febo
<3> cya ... MrCraig... vandemar
<2> espionage`, it looks like what you hav at the moment is it selects only within a bounding box rather than by distance
<3> bye bye thank you for your help
<0> yeah, a square rather than a circle, i.e. never a consistent distance
<0> its all i have to work with though :\
<0> trying to make the best of it
<2> so do you own search using the real distance
<2> is the data a freebie
<0> it cost me
<0> i dont particularly want to modify the method it uses until i understand the way it all works
<2> add a new one
<4> AND SQRT((ABS(dest.x-source.x)*ABS(dest.x-source.x))+(ABS(dest.y-source.y)*ABS(dest.y-source.y))) < %s
<0> :O
<0> i will put all the documentation into my php, commented
<0> then try understand it
<2> espionage`, look at the line vandemar has typed for you
<5> Is it normal to have 30 mysql processes running, each taking up 30megs of RAM ?
<4> are you sure none of that 30MB isn't shared?
<4> oh, mysql has POW()
<5> I'm not sure, I actually don't know how mysql handles memory
<4> it's probably shared. don't worry about it unless you're having memory problems
<5> well I'm having problems (not totally sure they're memory related though), my site is very slow after a few hours, restarting apache/mysql helps a little, rebooting makes it really fast again
<4> what does top say?
<5> http://pastebin.com/623189
<4> ram is fine. ide disks?
<4> what is the site running that's so slow?
<5> I recently rebooted though, so its doing fine right now
<5> its podemus.com
<4> when it gets bad, run 'vmstat 1' and you'll see what's going on in terms of swap, disk, and cpu usage
<2> retroneo show processlist to see if mysql is waiting
<2> retroneo and stop using pconnect if you are
<5> archivist: you mean see the process with with top? and i'm not using pconnect
<2> no use the mysql client and show processlist; it may help you see whats happening
<5> there are many that are "sleeping"
<6> hi re
<5> hi
<6> I found solution on my debian mysql starting problem
<6> var/lib/mysql were corrupted
<6> I remove it and reinstall older mysql version and it works...
<7> I doubt there is a way to do this from current tools but I figured I should ask
<7> is there a way to do a mysqldump that changes all int(*) to just int and reorder from column,type, option, default to column,type,default,option
<7> ?
<2> do a select into outfile and format and order any which way you want
<7> yeah thats what I have been doing
<7> just very tedious
<7> trying to import a db into h2/hsqldb..
<7> syntax is a bit diff
<7> thanks all
<8> whats the deal when i try to save something in a myqsl db char(32), if there are 0's as first numbers, they dont count?
<8> ie if i save "0045" it only saves "45" ?
<9> extr3m> From a char point of view "45" is not the same as "0045", which suggests that it should be stored as "0045".
<10> hi! Can you please tell me why I'm getting values like "yyyy-MM-ddThh:mm:ss" (note the "T" in the middle) in the result for a datetime(14) value?
<11> because it's correct?
<10> Where's the T from?
<11> T is a delimiter between the date and the time
<10> mmh. can I switch it off somehow?
<11> dunno :)
<12> i have a "band" table, i was thinking of having 2 fields for the name, one for the "order name" and one for "display" name, to avoid bands like "the beatles" getting listed under t
<12> bad idea?
<10> and, why can't i find it in the manual? there's no mention of it in the datetime section!
<10> Wulf4: is the same true for timestamp?
<11> kernelpnc: I haven't used datetime stuff in mysql yet
<10> ok, thanks for your help!
<9> jals> Not at all, you can also treat it as a person name with prefixes to the lastname.. have a seperate field for "the" for instance
<9> the name is "Beatles" and prefix = "The" you can still search on beatles and on the beatles.. etc :)
<12> yeah makes sense
<7> is there a cnf file setting to set the default table type if not specified?
<13> Hey guys, I have shall and root access to a server, but lost my mysql p***word. Can I create a new user for mysql so I can access again?
<13> this is on a very old mysql 3.x installation
<11> !m ries recover root p***word
<14> ries: Nothing found
<11> !m ries reset root
<14> ries: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<7> nm. found it
<9> I installed mysql a while back and it's running great, but I want to edit my my.cnf file... but it's not installed.. can this be, or am I just not looking good enough?
<9> It's a rpm installation on FC3
<13> Wulf4: I don't want to reset, I just want to create a new user with the same rights....
<15> where are the mysql databases stored by default?
<15> /var/lib/mysql
<15> learn this boys...
<15> :p
<16> mine at /var/db/mysql :D
<15> :)
<17> where ever you want them to be edit my.cnf
<18> I was looking at mysql cluster and read that it doesn't support text fields. Is this still the case?
<0> http://pastebin.com/623351
<0> anyone any ideas why im getting: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM hwz_postcodes AS source, hwz_postcodes AS dest, cuisine WHERE source.'
<0> ??
<19> n00b question : how to rm the db in mysql ?
<9> drop database databasename;
<4> espionage, "AS foo" goes after the column name you want to rename
<0> i have, havent i ?
<4> you're trying to rename tables. I don't think that works, and it certainly doesn't work the way you have it if you're getting an error
<4> I don't understand the query at all. what are you trying to do with AS
<4> the first one is okay. the cuisine and hwz_postcodes ones are not
<20> Hi! Did anybody manage to install MYSQL Workbench on Linux?
<5> is this memory usage normal in mysql : http://pastebin.com/623372
<4> espionage, I think you want to do something like: $dest="hwz_postcodes"; $source="cuisine"; $query_userCoords = "SELECT COUNT($dest.outcode) AS density, $dest.outcode, $dest.x, $dest.y FROM $source, $dest WHERE $source.outcode = $dest.outcode GROUP BY dest.outcode ASC";
<5> vandemar : mysql is now using 300megs it seems
<4> so?
<5> I gather it is a normal figure?
<5> also the processlist in phpmyadmin shows the majority are in "sleep" state, they aren't stoped if they are not used (like apache does) ?
<0> anyone know a link to QAS's website
<18> if you have 4 machines arranged as a mysql cluster. They all exchange data in milliseconds. Then can you make, these same servers, one a Master and the other three slaves for text field replication using innoDB or myISAM?
<21> hi there
Return to
#mysql
or
Go to some related
logs:
dapper cups command line install printer
preg_match shortest occurrence
#python
audiowrapper source
#suse
marilat mirror
php_flag not allowed here
#oe
#perl
#gimp
|
|