Re: Django MySQL database backup and restore to new server

2020-07-28 Thread mcaay
Thanks a lot! Solved my django.db.utils.IntegrityError: Problem installing fixture ... duplicate key value violates unique constraint problem :) W dniu wtorek, 5 maja 2020 18:24:12 UTC+2 użytkownik marc bellazzini napisał: > > SOLVED > > # after more extensive googling . > > ORIGINAL SE

Re: Django MySQL database backup and restore to new server

2020-05-05 Thread marc bellazzini
SOLVED # after more extensive googling . ORIGINAL SERVER - cd to your web project directory - python manage.py dumpdata > db.json NEW SERVER - sftp db.json file to new server web project directory - python manage.py migrate - python manage.py shell -- >> from django.contrib.contenttypes.mode

Re: Django MySQL database backup and restore to new server

2020-05-05 Thread marc bellazzini
SOLVED # after more extensive googling I found a solution myself. I hope this helps someone else ORIGINAL SERVER - cd to your web project directory - python manage.py dumpdata > db.json - python manage.py migrate - python manage.py shell -- >> from django.contrib.contenttypes.models import

Django MySQL database backup and restore to new server

2020-05-04 Thread marc bellazzini
Hello, I have Django 2.x running on an old Ubuntu server with a MySQL database. I have installed a new Ubuntu 20.04 server on another machine with Django 3.x and MySQL. I would like to backup the old Django/mysql database and restore it on the new server. What is the best practice for doing th

Re: Database Backup

2005-12-14 Thread Andreas Neumeier
> It'd be nice to have this in a database independent format - to make it > easy to change the database you're using. I didn't think about this before, but you are right. In the end, users may want to backup the django application and not the (postgres) database, which speaks for the "independan

Re: Database Backup

2005-12-14 Thread Daniel James
Andreas Neumeier wrote: like executing pg_dump from the view? I thought about that, but I did not want to execute something external. I was more thinking of get_list(...) or something similare, but that would propably break relations on restoring? so pg_dump would be the most consistent soluti

Re: Database Backup

2005-12-14 Thread Jeroen Ruigrok van der Werven
On 12/14/05, Andreas Neumeier <[EMAIL PROTECTED]> wrote: > I was wondering, if it is possible to do a entire backup of the > database into a, let's say XML file or something. > > The intention is to offer a easy possibility to users to install > applications and roll back to previor states, like ha

Re: Database Backup

2005-12-14 Thread Jacob Kaplan-Moss
On Dec 14, 2005, at 2:24 PM, Andreas Neumeier wrote: I was wondering, if it is possible to do a entire backup of the database into a, let's say XML file or something. The intention is to offer a easy possibility to users to install applications and roll back to previor states, like having a bac

Re: Database Backup

2005-12-14 Thread Andreas Neumeier
like executing pg_dump from the view? I thought about that, but I did not want to execute something external. I was more thinking of get_list(...) or something similare, but that would propably break relations on restoring? so pg_dump would be the most consistent solution, tho. -- Andreas Neume

Re: Database Backup

2005-12-14 Thread Medium
Andreas Neumeier wrote: Hi there, I was wondering, if it is possible to do a entire backup of the database into a, let's say XML file or something. The intention is to offer a easy possibility to users to install applications and roll back to previor states, like having a backup/restore butto

Database Backup

2005-12-14 Thread Andreas Neumeier
Hi there, I was wondering, if it is possible to do a entire backup of the database into a, let's say XML file or something. The intention is to offer a easy possibility to users to install applications and roll back to previor states, like having a backup/restore button on the admin interface. N