How to use django's manage.py sql* commands with mysql

Question

How are the sql* commands meant to be used? They just output sql, so is there an elegant way to pass it to mysql? ./manage.py sqlindexes [app] gives me the mysql code - do I just note it down and then type it in? (edit: erm...copy and paste for others. heh.)

Pardon my ignorance, and please let me know if there's a completely different but better way of using it.

Sam Dolan · Accepted Answer · 2011-01-18 01:27:01Z

5

Pipe it to the dbshell command like so:

python manage.py sqlindexes my_app | python manage.py dbshell

answered Jan 18, 2011 at 1:27

Sam Dolan

32.6k10 gold badges93 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

munchybunch Over a year ago

Thanks, I knew I was missing something!

Santi Agüero Over a year ago

@sdolan I couldn't find this in the django-admin official documentation. Did you find this somewhere documented? Where?

Sam Dolan Over a year ago

@SantiagoAgüero: I'm not sure if it's documented anywhere. It's just using unix principles to pipe output into a script.

Collectives™ on Stack Overflow

How to use django's manage.py sql* commands with mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related