Re: Spatial extensions

Rene: We've easily integrated GIS with MySQL into our sites: http://tenant.com/map-search.php http://yearlyrentals.com http://acnj.com/map.php ... Thanks! Jim Ginn Visit My Work (888) 546-4466 office (609) 226-5709 cell > Awesome, this is what I was trying to find, as you su

Re: MySQL versus PostgreSQL for GPS Data

Juan: Still seems excessive but in that case, ignore inserts that have no change in lat / lon ... Jim > Jim Ginn wrote: > >>>Not sure why you you need the trucks location 'every second' ie: >>>31,536,000 rows per year per truck ? >>>doing every 30 seco

Re: MySQL versus PostgreSQL for GPS Data

Juan: We've had success with spatial indexes and mysql on our sites however our numbers are smaller: http://brokersnetwork.com (200,000+ records) http://yearlyrentals.com (200,000+ records) http://avalonrealestate.com/map.php (4,400+ records) ... Not sure why you you need the trucks location

Re: long login times?

Jed: Are you using an in-network IP to access the database ie: 127.0.0.1 192.168.98.## or are you using a public IP or full domain name ie: DB001.MY-DOMAIN.COM ... Jim > I've started logging how long my php application takes to login to > mysql, and often it's well below 1 millisecond. Howeve

Re: Calendar creation

Craig: Not sure but we use: http://www.cascade.org.uk/software/php/calendar/ (ie. php) at: http://downtownoceancity.com/events Jim > On Thu, Jul 17, 2008 at 8:50 AM, Weston, Craig (OFT) > <[EMAIL PROTECTED]> wrote: >> Hi there, >> >> Is there any simple way to create a calendar table? For e

Re: MySQL only listens on localhost

Franz: Did you setup user access permissions outside of 127.0.0.1 and is port 3306 open on your firewall/router? Jim Ginn http://www.Tenant.com > Hello, > > Can anyone please give me a hint what I can do that MySQL also listens to > the physical address of the host. > I see th

Re: MySQL admin GUI

Jerry: or: http://www.phpmyadmin.net/home_page/index.php ? Thanks! Jim Ginn http://www.Tenant.com > Does anyone know how to add a field anyplace but at the bottom? I haven't > found any "insert here" functionality. > > Regards, > > Jerry Schwartz >

RE: Help With a Week ( date ) query

Jerry: We do this exactly at: http://www.WeeklyRentals.com Jim > I'm not sure if this gets you all the way, or not. > > There is a WEEK() function that converts a date into its week of the year. > There isn't any obvious way to turn it back into a date, but it doesn't > sound like you need it f

Re: Searching for Dates

Dan: Thanks! Jim > In the last episode (Mar 18), Jim Ginn said: >> > In the last episode (Mar 16), Bob Cooper said: >> >> I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new >> >> to both SQL and MySQL. I have been able to query out most of

Re: Searching for Dates

Dan: I've used the TO_DAYS on a SELECT statement ie: SELECT * FROM properties WHERE (TO_DAYS(NOW()) - TO_DAYS(CreationDate) = 1) ORDER BY id DESC however it didn't seem to take advantage or use the index on that field (ie. CreationDate) ... Jim > In the last episode (Mar 16), Bob Cooper said:

Re: SCO Openserver Install

Boyd Lyn Gerber: Not sure why we can get PHP-MySQL functions working? We're using PHP: php4/4.3.6a (SCO build) Are you using same build of PHP? Thanks! Jim > On Sun, 18 Jul 2004, Jim Ginn wrote: >> First - Thanks again for your help. > > Your welcome. > >> S

Re: SCO Openserver Install

h-mysql=shared' '--with-pgsql=shared,/usr' '--with-expat-dir=/usr' '--enable-calendar=shared' '--enable-dba=shared' '--enable-dbase=shared' '--enable-dbx=shared' '--enable-dio=shared' '--enable-exif=shared' '--e

Re: SCO Openserver Install

Boyd Lynn Gerber: I have (think) the MySQL dataserver running. You wouldn't know where I could find a compiled: mysql.so module for apache/php data access? Thanks! Jim > On Tue, 13 Jul 2004, Jim Ginn wrote: >> Much better but it complains about max_allowed_packet? It

Re: SCO Openserver Install

bin/mysqld: Shutdown complete > On Tue, 13 Jul 2004, Jim Ginn wrote: >> Updated to (your) 4.1.3-beta and now get: >> >> ./bin/mysqld --skip-grant & >> dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m >> >> Check in /usr/lib and see: &g

Re: SCO Openserver Install

looking for with 'm' suffix? Thanks! Jim > On Tue, 13 Jul 2004, Jim Ginn wrote: >> Trying to get MySQL running on SCO Openserver 5.0.7 and get this >> message: >> >> dynamic linker: ./bin/mysqld: binder error: symbol not found: >> pthread_key_delete; referen

Re: SCO Openserver Install

Boyd Lynn Gerber: I'll give the newer version a try as I was using: /usr/local/mysql-4.0.18-pc-sco3.2v5.0.7-i386 build from your site ... Thanks! Jim > On Tue, 13 Jul 2004, Jim Ginn wrote: >> Trying to get MySQL running on SCO Openserver 5.0.7 and get this >> message:

SCO Openserver Install

Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld And I have FSU threads installed ... Any help would be appreciated Thanks! Jim Ginn -- MySQL

Re: 16 Index Table Limit

Thanks! Jim Dan Nelson wrote: > > In the last episode (Feb 05), Jim Ginn said: > > Is there a way to define more than 16 btrees per table? Can this > > index limit be increased to 32 or more? It's a static database that > > is massively updated once or twice a

16 Index Table Limit

Is there a way to define more than 16 btrees per table? Can this index limit be increased to 32 or more? It's a static database that is massively updated once or twice a year so update performance is not the issue, rather speed of queries. Please respond to [EMAIL PROTECTED] because I am not su