Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.

#1 Dec. 28, 2010 23:38:17

Emmanuel M.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


I have a classic database dump question....

I would like to migrate from sqlite to mysql.
How can I dump and import the data?
Regards,
--
E

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#2 Dec. 29, 2010 02:12:05

Michael P.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


On 28/12/10 Emmanuel Mayssat said:

> I have a classic database dump question....
>
> I would like to migrate from sqlite to mysql.
> How can I dump and import the data?

See the manage.py dumpdata/loaddata commands.

Mikesignature.ascDescription:Digital signature

Attachments:
attachment signature.asc (197 bytes)

Offline

#3 Dec. 29, 2010 04:20:28

n.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


see if this url could help you:http://www.maxkpage.com/blog/free-sqlite-to-mysql-converter-super-easy/On Dec 29, 7:37 am, Emmanuel Mayssat <emays...@gmail.com> wrote:
> I have a classic database dump question....
>
> I would like to migrate from sqlite to mysql.
> How can I dump and import the data?
> Regards,
> --
> E

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#4 Dec. 29, 2010 04:20:39

Emrah U.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


within the main project directory in linux

python manage.py dumpdata > data.json

command will dump your data to a json file

change settings.py to use mysql, after that

python manage.py syncdb

this will create tables followed by

python manage.py loaddata data.json

will load everything back

cheers



On 12/29/2010 01:37 AM, Emmanuel Mayssat wrote:I have a classic database dump question....

I would like to migrate from sqlite to mysql.
How can I dump and import the data?
Regards,
--
E--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#5 Dec. 29, 2010 07:51:26

Torsten B.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


Hallöchen!

Michael P. Soulier writes:

> On 28/12/10 Emmanuel Mayssat said:
>
>> I have a classic database dump question....
>>
>> I would like to migrate from sqlite to mysql.
>> How can I dump and import the data?
>
> See the manage.py dumpdata/loaddata commands.

I don't recommend that. If the database exceeds a certain size (and
"certain" is MBs, not GBs), this simply fails.

Tschö,
Torsten.

--
Torsten Bronger, aquisgrana, europa vetus
Jabber ID: torsten.bron...@jabber.rwth-aachen.de
orhttp://bronger-jmp.appspot.com--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#6 Dec. 29, 2010 09:34:59

Emmanuel M.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


Michael, that's encouraging ;-)
I was looking at a possibility of using manage.py dumpscript and
manage.py runscript
from django-extensions. But it is not straight forward either.

Wasn't django supposed to be database agnostic?
Now, I understand what they really meant.
Pick you database carefully and stick with it.
But django code is not database specific.
...
For one second, I though django was the holy grail of all web frameworks
...

--
E

On Tue, Dec 28, 2010 at 11:48 PM, Torsten Bronger
<bron...@physik.rwth-aachen.de> wrote:
> Hallöchen!
>
> Michael P. Soulier writes:
>
>> On 28/12/10 Emmanuel Mayssat said:
>>
>>> I have a classic database dump question....
>>>
>>> I would like to migrate from sqlite to mysql.
>>> How can I dump and import the data?
>>
>> See the manage.py dumpdata/loaddata commands.
>
> I don't recommend that.  If the database exceeds a certain size (and
> "certain" is MBs, not GBs), this simply fails.
>
> Tschö,
> Torsten.
>
> --
> Torsten Bronger, aquisgrana, europa vetus
>                   Jabber ID: torsten.bron...@jabber.rwth-aachen.de
>                                  orhttp://bronger-jmp.appspot.com>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
>http://groups.google.com/group/django-users?hl=en.
>
>

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#7 Dec. 30, 2010 02:27:46

Michael P.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


On 29/12/10 Torsten Bronger said:

> I don't recommend that. If the database exceeds a certain size (and
> "certain" is MBs, not GBs), this simply fails.

Is there a bug report for this issue? I find that very disappointing.

Mike
--
Michael P. Soulier <msoul...@digitaltorque.ca>
"Any intelligent fool can make things bigger and more complex... It takes a
touch of genius - and a lot of courage to move in the opposite direction."
--Albert Einsteinsignature.ascDescription:Digital signature

Attachments:
attachment signature.asc (197 bytes)

Offline

#8 Dec. 30, 2010 02:30:24

Michael P.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


On 29/12/10 Emmanuel Mayssat said:

> I was looking at a possibility of using manage.py dumpscript and
> manage.py runscript
> from django-extensions. But it is not straight forward either.

dumpdata/loaddata is quite simple, I recently used it myself. Torsten
suggested that there's a problem using it with large data sets. I have not
seen this myself.

> Wasn't django supposed to be database agnostic?

Yeah, and ANSI C was supposed to be platform independent. And so was Java. And
Python. And...

> Now, I understand what they really meant.
> Pick you database carefully and stick with it.
> But django code is not database specific.
> ...
> For one second, I though django was the holy grail of all web frameworks
> ...

If anyone claims a holy grail, they are selling you something.

Mikesignature.ascDescription:Digital signature

Attachments:
attachment signature.asc (197 bytes)

Offline

#9 Dec. 30, 2010 12:58:30

Torsten B.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


Hallöchen!

Michael P. Soulier writes:

> On 29/12/10 Torsten Bronger said:
>
>> I don't recommend that. If the database exceeds a certain size
>> (and "certain" is MBs, not GBs), this simply fails.
>
> Is there a bug report for this issue? I find that very
> disappointing.http://1.2.3.12/bmi/stc.celeb.gate.cc/banner/pi/0120.gifTschö,
Torsten.

--
Torsten Bronger, aquisgrana, europa vetus
Jabber ID: torsten.bron...@jabber.rwth-aachen.de
orhttp://bronger-jmp.appspot.com--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#10 Dec. 30, 2010 13:04:53

F.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

database migration


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 30/12/10 13:17, Torsten Bronger wrote:
>> Is there a bug report for this issue? I find that very
>> > disappointing.
>http://1.2.3.12/bmi/stc.celeb.gate.cc/banner/pi/0120.gifWhat i found disappointing is sending a NSFW image to a django list
without a note.

Thank your for my first post-xmas first boss talk :D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org/iQIcBAEBCAAGBQJNHIMpAAoJEAWOKfEESaOw7rEQAI8AUH7EeF51ZocVJJOzi5sa
gavH1N9MesBtEiraN1t+sQyXy7m/wzlO4qRbhDkb56V8LrS2UME6kse7OY6TmmLV
Qkmqfmg4s0RdVQnWaOPEQax0oqb19kwjetr2HSleVV/uWB6DV5xiDVqojtuP7s9x
Tj3PJs8V1kUBpK5twHkRFSJRFqv5Yy/KRNiOdLXrRpenqivbqVHb8jwLPtZFN4Cc
FSpOljQ/A08jI644vhfUCOQJuI40IRaRQjVINolRhqmR5i0nI7ZOEz/rIgksgiIq
m+T//vuXKfJJ7QxMw5zl8ERpqwl67uebkKEeeFgKzIW8Y1v39OWNcK0TkJlI3bgW
MHicwZ+TNkmzNwINPDbnuNiBmZdLE6Ypg+Cng5na4j7IKr/aiyRcRAQl2MWR67XK
hS+MPCmEZMyPFVyM0cnKz3DIMhVZWXVyCu6rf1iR4yyI/5FAdYLxAwsRKGeh9Llp
BLM4fozVrkx6aUnEaAgLpaOLTSD41M3lQiIlT/NtXM3zqWUWWFtYZT2/m5XwWins
yaeFSHiYobmAuYz6Z6uwLLsejpsv/TTLpuxi5vyOWAVZd1UBdTnLtYEtX5+twrur
/4qHgxs8S7y3XnDvc/Hei1sDq9QA9OLs+UXD8cOHqtFrDoS22g7rxzQnU2dSsal8
GdMSrAYBtIjeTnqJSiLS
=tOGZ
-----END PGP SIGNATURE-----

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

Board footer

Moderator control

Enjoy the 23rd of October
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support