[mezzanine-users] Re: Bizarre issue- Dumping data from one server to another doesn't transfer keywords properly

2014-02-14 Thread Jackson Hong
This was exactly the issue. Thank you so much for this tip.

Cheers.

On Tuesday, February 11, 2014 6:21:06 PM UTC-5, Justin McKeon wrote:
>
> Keywords have a foreign key to ContentType which can have different 
> primary keys between databases.
>
> https://docs.djangoproject.com/en/dev/topics/serialization/#natural-keys
>
> I'm assuming you are using the django dump.  The quick and dirty way to do 
> is to manually update your dump file but a better solution is to use MySQL 
> to backup/drop/full restore .
> I'm use PostgreSQL and am not familiar with the MySQL options, though.
>
> On Tuesday, February 11, 2014 10:54:48 AM UTC-6, Jackson Hong wrote:
>>
>> Hello,
>>
>> This is the situation. I have a staging and a production server. I make 
>> changes to pages on the staging server and then dump and load it into the 
>> production server. 
>>
>> Everything transfers fine except for keywords of a page.
>>
>> I am using MySQL.
>>
>> Let me know if more information is required.
>>
>> Has anyone encountered this before?
>>
>>
>>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[mezzanine-users] Re: Bizarre issue- Dumping data from one server to another doesn't transfer keywords properly

2014-02-11 Thread Justin McKeon
Keywords have a foreign key to ContentType which can have different primary 
keys between databases.

https://docs.djangoproject.com/en/dev/topics/serialization/#natural-keys

I'm assuming you are using the django dump.  The quick and dirty way to do 
is to manually update your dump file but a better solution is to use MySQL 
to backup/drop/full restore .
I'm use PostgreSQL and am not familiar with the MySQL options, though.

On Tuesday, February 11, 2014 10:54:48 AM UTC-6, Jackson Hong wrote:
>
> Hello,
>
> This is the situation. I have a staging and a production server. I make 
> changes to pages on the staging server and then dump and load it into the 
> production server. 
>
> Everything transfers fine except for keywords of a page.
>
> I am using MySQL.
>
> Let me know if more information is required.
>
> Has anyone encountered this before?
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.