Re: Migrating from sqlite3 to MySQL or PostgreSQL

2017-06-05 Thread dave . anderson
Sure, I'd be willing to try it, thanks. I'm back up and running on SQLite for now but we haven't rolled out yet so I have a lot of freedom to play with it. I'm going to go back to MySQL and clear out all but the bare schema. On Monday, June 5, 2017 at 2:39:41 PM UTC-7, Christian Hammond wrote:

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2017-06-05 Thread Christian Hammond
Hi Dave, Converting the data between databases is very tricky. The loaddb/dumpdb scripts were an attempt at this, but we'll be throwing them away, because they were the wrong approach. Off-hand, I don't know why this particular attempt is failing the way it is, but I suspect it's an ordering

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2017-06-05 Thread dave . anderson
I attempted the same, moving from SQLite to MySQL. It didn't go well First I was asked to install a django package, then it tried but failed on a LOT of FK constraints: sudo rb-site manage `pwd` dumpdb > ~/database.json (change settings_local.py) sudo rb-site manage `pwd` loaddb

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-24 Thread Joe
Hi Christian, Thanks for the details. When I run the below command I get the error --no-initial-data is not an avaialble option. Am I missing something here: # rb-site manage /var/www/reviewboard syncdb -- --no-initial-data Usage:

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-24 Thread Joe
Hi Christian, It worked when I gave without the --no-initial-data. So following are the steps I followed: I have assumed the /path/to/reviewboard in my case as /var/www/reviewboard 1. Stop reviewboard 2. # rb-site manage /var/www/reviewboard dumpdb database.json 3. In reviewboard folder go

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-15 Thread Joe
Hello, Anyone who can say what could be the issue that I have mentioned below. Best regards, Joe. On Monday, April 14, 2014 3:45:48 PM UTC+2, Joe wrote: David: When I tried this, I get the following errors: 1. rb-site manage /path/to/site dumpdb database.json Success. Database.json

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-14 Thread Joe
David: When I tried this, I get the following errors: 1. rb-site manage /path/to/site dumpdb database.json Success. Database.json was created 2. rb-site manage /path/to/site loaddb database.json Interestingly it said that database.json doesn't exist, while it exists. It started running when

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-12 Thread David Trowbridge
Joe, There are two management commands you can use for this. They aren't well-documented, but there's an example of how to use them at http://www.reviewboard.org/docs/releasenotes/reviewboard/1.6.4/ I don't think there's a strong reason to choose either over the other. It usually comes down more

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-12 Thread Michael Zhilin
Hi Joe, David, Few years ago I've used Django command dump db to json format. Hope it will be useful for you Best regards, Michael. On Apr 12, 2014 10:30 AM, David Trowbridge trowb...@gmail.com wrote: Joe, There are two management commands you can use for this. They aren't well-documented,