I have found the py-mysql2pgsql to work without problems.

Did you install it using "pip install py-mysql2pgsql" (if you are using a 
virtualenv make sure you are running it from there or have activated the 
virtualenv)?

No command found suggests there is a problem with your path and it can't find 
the script.

From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On 
Behalf Of frocco
Sent: 21 March 2013 13:06
To: django-users@googlegroups.com
Subject: Re: PostgresSQL or MySql with django?

Has anyone used this?

https://github.com/lanyrd/mysql-postgresql-converter/

I cannot get this working, says cannot find the file

On Thursday, March 21, 2013 8:14:04 AM UTC-4, frocco wrote:
I have not been able to get this to work.
Says no command found.

I must say, porting Mysql data to Postgresql is a big pain on a mac.
I am almost inclined to stay with mysql.

I googled for an easy solution, but could not find anything except dbconvert 
for 100.00


On Wednesday, March 20, 2013 10:20:19 AM UTC-4, Patrick Craston wrote:
Alternatively, I've found this tool works very well:

https://pypi.python.org/pypi/py-mysql2pgsql

(only thing to look out for are Django IPAddressFields as they are char(15) 
fields in MySQL and inet fields in Postgres - py-mysql2pgsql is obviously not 
aware of this)

HTH

Patrick

-----Original Message-----
From: django...@googlegroups.com<mailto:django...@googlegroups.com> 
[mailto:django...@googlegroups.com] On Behalf Of Tom Evans
Sent: 20 March 2013 14:12
To: django...@googlegroups.com<mailto:django...@googlegroups.com>
Subject: Re: PostgresSQL or MySql with django?

On Wed, Mar 20, 2013 at 1:54 PM, frocco 
<far...@gmail.com<mailto:far...@gmail.com>> wrote:
> Hello,
>
> I know this is not django related, but can someone help me with the
> syntax to port mysql to postgresql?
> I tried the mysqldump command with the postgresql compatibility
> option, but I still cannot import the data.
>
> Thanks
>
>

Django itself has mechanisms for importing and exporting data in a database 
independent format:

https://docs.djangoproject.com/en/1.5/ref/django-admin/#django-admin-dumpdata

If you are not dealing with huge amounts of data, this can be the simplest way 
forward.

Cheers

Tom

--
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users...@googlegroups.com<mailto:django-users...@googlegroups.com>.
To post to this group, send email to 
django...@googlegroups.com<mailto:django...@googlegroups.com>.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
django-users+unsubscr...@googlegroups.com<mailto:django-users+unsubscr...@googlegroups.com>.
To post to this group, send email to 
django-users@googlegroups.com<mailto:django-users@googlegroups.com>.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to