Re: What returns from distance function?
I used below query from http://lists.mysql.com/mysql/219805
SET @center = GeomFromText( 'POINT(39.78824896727801 30.50930339115439)' )
;# MySQL returned an empty result set (i.e. zero rows).
SET @radius = 0.005;# MySQL returned an empty result set (i.e. zero rows).
SET @bbox = GeomFromText( CONCAT( 'POLYGON((', X( @center ) - @radius , ' ',
Y( @center ) - @radius , ',', X( @center ) + @radius , ' ', Y( @center ) -
@radius , ',', X( @center ) + @radius , ' ', Y( @center ) + @radius , ',',
X( @center ) - @radius , ' ', Y( @center ) + @radius , ',', X( @center ) -
@radius , ' ', Y( @center ) - @radius , '))' ) ) ;# MySQL returned an empty
result set (i.e. zero rows).
SELECT astext( point ) , Distance( @center , point ) AS dist
FROM psn.psn_place
WHERE MBRContains( @bbox , point )
ORDER BY dist
LIMIT 10;
I don't know type of 'dist' in this result, I need 'dist' column in meter
format.
+--+-+
| astext( point ) | dist|
+--+-+
| POINT(39.7872360228843 30.5097413063049) | 0.00110355155014048 |
| POINT(39.7872648779901 30.5084055662155) | 0.00133211161219657 |
| POINT(39.7871288466708 30.5080997943878) | 0.00164417619226759 |
+--+-+
On Sun, Apr 18, 2010 at 4:25 PM, Onur UZUN wrote:
> Distance between two points. but in which type? and how can i convert this
> value to meter?
What returns from distance function?
Distance between two points. but in which type? and how can i convert this value to meter?
Re: #2002 - The server is not responding
> I haven't been into phpMyAdmin for a while, but when I tried today I got > > the error: > |#2002 - The server is not responding (or the local MySQL server's > > socket is not correctly configured) > > This error message didn't seem to tie in with anything on the MySQL > site, which gives: > > Error: |2002| (|CR_CONNECTION_ERROR|) > Message: Can't connect to local MySQL server through socket '%s' (%d) > > I only use MySQL every now and then, just for experimenting with > programming projects, so it could be that phpMyAdmin hasn't been working > for some time. > > I'm on a SUSE 10.0 box with an AMD64 dual core 4200+ processor. > > The server is up and running and is using the socket file: > > /var/lib/mysql/mysql.sock > > The permissions on that file are: > > srwxrwxrwx 1 mysql mysql 0 2007-02-15 19:24 /var/lib/mysql/mysql.sock > > mysql.log is completely empty. > > Am I missing something really obvious? I'm a decent programmer, but the > world's worst sysadmin, I'm afraid. > > Thanks > > > Peter Hi Peter, Please check phpMyAdmin Configuration file ( for Port addr ) . Thanx Onur -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump problem
VenuGopal Papasani wrote: hi all, I have got a problem with mysql and i want to uninstall it and then re-install it but the problem is how to recover my data.My mysqldump command is not working.Can i have any other procedure to recover my data like copying the folder of my database from the data folder and then making a backup.But when i tried i m getting the following error as * databasename.tablename doesn't exist* Can anyone give me the solution asap. Thanks and regards, venu Hi, May be i find a solution for you. I write a bash script for linux users to backup database and upload database it's very simple. If you want to try it please visit : www.witkey.org/vt.php and take it. ( Program Language: Turkish :) ) Cincerly, Onur Yerlikaya -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: www.innodb.com
Bill MacAllister wrote: What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't there anymore. Bill +--- | Bill MacAllister, Senior Programmer | 10030 Foothills Blvd | Roseville, CA 95747 Hi, Maybe domain name down. Best Regards, Onur Yerlikaya mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
