geodjango using mysql

Question

I have been working on an application using django and mysql, am trying now to work on the tutorial from this here

http://docs.djangoproject.com/en/1.2/ref/contrib/gis/tutorial/

but it failed the moment I ran syncdb with the following error

AttributeError: 'DatabaseOperations' object has no attribute 'geo_db_type'

When I read around, it says that this can be solved if changed the backend to use postGIS. Is there a way to continue using mysql as my backend and yet be able to use geodjango? if not, is it possible to use both in the same project?

Regards,

The [GeoDjango installation docs](https://docs.djangoproject.com/en/2.1/ref/contrib/gis/install/#ref-gis-install) go into detail about what libraries are needed to use the various db backends. — Daniel Roseman, Jan 02 '11 at 12:36

score 36 · Accepted Answer · answered Jan 14 '11 at 16:29

36

set django.contrib.gis.db.backends.mysql in your settings.DATABASE engine db config.

answered Jan 14 '11 at 16:29

panchicore

11,451
12
74
100

"The used table type doesn't support SPATIAL indexes" – Cerin Jan 17 '13 at 17:37
1

where exactly do you put this? – raaj Aug 04 '14 at 05:24

score 5 · Answer 2 · answered Jan 02 '11 at 14:17

5

Does your MySQL have spatial data types installed? What do you get if you do:

CREATE TABLE geom (g GEOMETRY);

If that doesn't recognise the GEOMETRY type, then you need to upgrade/recompile/reconfigure your MySQL.

answered Jan 02 '11 at 14:17

Spacedman

92,590
12
140
224

I tried it and it worked, the table was created. Anything from django setup I must do? – Mo J. Mughrabi Jan 02 '11 at 19:33
I found the problem, I was suppose to update the settings.py with the new mysql gis driver 'django.db.backends.mysql'. Now its working :) – Mo J. Mughrabi Jan 02 '11 at 19:43

geodjango using mysql

2 Answers2