OGR connection for LINUX

[Frank Warmerdam]

On 5/23/05, joÿffffffffffe3o Antunes <bluetuna_goes_skying at yahoo.co.uk> wrote:
> Hello frank,
> 
> I am still fighting to have mysql support using OGR..
> 
> the "funny" thing is that each time I run
> 
> ogrinfo -ro -al -so
> 'MYSQL:database=abruzzo,tablename=zzz,user=arit,password=arit,host=localhost,port:3306'
> 
> I get this message:
> 
> Warning 1: 'tablename=zzz' in MYSQL datasource
> definition not recognised and ignored.
> Warning 1: 'port:3306' in MYSQL datasource definition
> not recognised and ignored.

Joao, 

I see the documentation was wrong.  The table name list parameter
is actually tables=, not tablename=.  I have corrected the docs online.

Also, your port specifier should be port=n, not port:n. 

And finally you don't use database=, just make the database name
the first argument.  Try instead something like:
  
ogrinfo -ro -al -so
'MYSQL:abruzzo,tables=zzz,user=arit,password=arit,host=localhost,port=3306'
  
Good luck,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent