Re: backup/restore DB data...

2007-03-16 Thread Russell Keith-Magee

On 3/17/07, Michael <[EMAIL PROTECTED]> wrote:
>
> > You can try db_dump.py tool, it's not a web-gui based, but a command line
> tool.
> >
> > http://www.djangosnippets.org/snippets/14/
> >
>
> It is a very good tool to work with Mysql or sqlite3 but not with
> Postgresql.

An alternative is to use the database dumping capability that is built
into Django (./manage.py dumpdata) - this works fine with Postgres and
SQLite; MySQL will have some problems, depending on which backend you
are using.

Yours,
Russ Magee %-)

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



Re: backup/restore DB data...

2007-03-16 Thread limodou

On 3/16/07, Jens Diemer <[EMAIL PROTECTED]> wrote:
>
> limodou schrieb:
> > You can try db_dump.py tool, it's not a web-gui based, but a command line 
> > tool.
> >
> > http://www.djangosnippets.org/snippets/14/
>
> Very cool! It seems to work without problems ;)
>
> I made a hack to put it into my web install section:
> http://pylucid.net/trac/changeset/930
>
> But i must redirect the stdout and make a fake optparse options...
>
> Is it possible you change the script, so its easy to use it without a shell?
>

So you want just run it as a module? And what output do you want? Just
output to stdout?

>
> And a feature request: a option to zip all dumpfiles and load the dump
> on-the-fly from a zip archive. So a user can download one zipfile as a
> backup ;)
>

It's a good idea. I'll think about it.

>
> btw. can you insert a Licence statements into you script?

Ok, I'll add a BSD License.

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



Re: backup/restore DB data...

2007-03-16 Thread limodou

On 3/17/07, Michael <[EMAIL PROTECTED]> wrote:
>
>
> On 3/17/07, limodou <[EMAIL PROTECTED] > wrote:
> >
> > On 3/16/07, Jens Diemer <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > > I would like to backup and restore my django App-Database. This should
> > > be usable with a Web-GUI.
> > > I thought fixtures would be well usable for it. But there are some
> > > problems with this. Look at:
> > >
> http://groups.google.com/group/django-users/browse_thread/thread/6a4e9781d08ae815
> > >
> > > What is a good/other way, for DB backups?
> > >
> > You can try db_dump.py tool, it's not a web-gui based, but a command line
> tool.
> >
> > http://www.djangosnippets.org/snippets/14/
> >
>
> It is a very good tool to work with Mysql or sqlite3 but not with
> Postgresql.
>
I haven't worked with Postgresql ever, or if you like you can help me
with it. Or if I have time, I need to learn about Postgresql.

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



Re: backup/restore DB data...

2007-03-16 Thread Michael
On 3/17/07, limodou <[EMAIL PROTECTED]> wrote:
>
>
> On 3/16/07, Jens Diemer <[EMAIL PROTECTED]> wrote:
> >
> >
> > I would like to backup and restore my django App-Database. This should
> > be usable with a Web-GUI.
> > I thought fixtures would be well usable for it. But there are some
> > problems with this. Look at:
> > http://groups.google.com/group/django-users/browse_thread/thread/6a4e9781d08ae815
>
> >
> > What is a good/other way, for DB backups?
> >
> You can try db_dump.py tool, it's not a web-gui based, but a command line
> tool.
>
> http://www.djangosnippets.org/snippets/14/
>

It is a very good tool to work with Mysql or sqlite3 but not with
Postgresql.



-- 
--
Michael

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



Re: backup/restore DB data...

2007-03-16 Thread Jens Diemer

limodou schrieb:
> You can try db_dump.py tool, it's not a web-gui based, but a command line 
> tool.
> 
> http://www.djangosnippets.org/snippets/14/

Very cool! It seems to work without problems ;)

I made a hack to put it into my web install section:
http://pylucid.net/trac/changeset/930

But i must redirect the stdout and make a fake optparse options...

Is it possible you change the script, so its easy to use it without a shell?


And a feature request: a option to zip all dumpfiles and load the dump 
on-the-fly from a zip archive. So a user can download one zipfile as a 
backup ;)


btw. can you insert a Licence statements into you script?

-- 
Mfg.

Jens Diemer



A django powered CMS: http://www.pylucid.org


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



Re: backup/restore DB data...

2007-03-16 Thread limodou

On 3/16/07, Jens Diemer <[EMAIL PROTECTED]> wrote:
>
>
> I would like to backup and restore my django App-Database. This should
> be usable with a Web-GUI.
> I thought fixtures would be well usable for it. But there are some
> problems with this. Look at:
> http://groups.google.com/group/django-users/browse_thread/thread/6a4e9781d08ae815
>
> What is a good/other way, for DB backups?
>
You can try db_dump.py tool, it's not a web-gui based, but a command line tool.

http://www.djangosnippets.org/snippets/14/

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



backup/restore DB data...

2007-03-16 Thread Jens Diemer


I would like to backup and restore my django App-Database. This should 
be usable with a Web-GUI.
I thought fixtures would be well usable for it. But there are some 
problems with this. Look at:
http://groups.google.com/group/django-users/browse_thread/thread/6a4e9781d08ae815

What is a good/other way, for DB backups?


-- 
Mfg.

Jens Diemer



A django powered CMS: http://www.pylucid.org


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---