On 1/07/2013 8:28am, François Schiettecatte wrote:
Mike
FWIW - I have a site for which I need to do that, I use MySQL so I
just dump the data using mysqldump, transfer it to the other machine
and load it up. There is some scripting around it to keep track of
IDs so I dump deltas only, works just fine.
François
I use Postgres but I'm sure that doesn't matter much. Would you be able
to share your scripts? Off-list if you prefer. When I get it working
I'll try and refine things so it becomes an easily repeatable process
and post it all back here for others.
Miike
Best regards
François
On Jun 30, 2013, at 6:24 PM, Mike Dewhirst <mi...@dewhirst.com.au>
wrote:
mulianto and Avraham
Thanks for your suggestions. Dumping data isn't the entire problem
- which is this:
There will be an *ongoing* need to add new data from tables in one
database to the same-named tables in another database on a remote
machine. Two of the tables are in a m2m relationship.
Thanks
Mike
On 30/06/2013 5:40pm, Mike Dewhirst wrote:
This is probably a Postgres question but someone might be able to
offer advice on how to transfer data :)
New "reference" or read-only data gets input during development
and I want to transfer it to the production database from time to
time.
I think my choices are:
1. Re-enter it manually - only if all else fails.
2. Use Django's multi-database feature and write a utility to
transfer data which doesn't already exist. Except the databases
are on different machines in different data centres.
3. Exploit some pre-existing tool written for precisely this
problem.
Any suggestions?
There are currently three reference tables involved and two have
m2m relationships between themselves. The other is stand-alone.
Customer data is fine in the production database and won't be
touched. There are no relationships with the reference tables.
Thanks
Mike
-- 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. 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.
For more options, visit https://groups.google.com/groups/opt_out.
