loaddb and loaddata both require that you have an existing database schema
in place.

You'll need to first use the version of Review Board you were using for the
sqlite database. I'm assuming in this case that it's the same one and that
you aren't also trying trying to upgrade the software. If you are, you'll
first need to update the sqlite database.

Then, once you've configured your site to use MySQL (by modifying the
settings_local.py file), you can create the initial schema by doing:

    $ rb-site manage /path/to/site syncdb -- --no-initial-data

(Note the extra "--" in there.)

If you already had data in the database, you'll need to wipe it before
doing that.

You should then be able to do the import.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com


On Tue, Apr 15, 2014 at 5:08 AM, Joe <jothira...@gmail.com> wrote:

> 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 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 I gave the full path
>>
>> rb-site manage /path/to/site loaddb /home/rbusr/backup/database.json
>>
>> 3. But this loaddb command did not complete. It got failed with the
>> following error:
>>
>> ine 2019: '{"pk": "2cb7881974e3b16dc27d181a7afad869", "model":
>> "sessions.session", "fields": {"expire_date": "2015-03-19T05:43:49.644Z",
>> "session_data": "gAJ9cQFVCnRlc3Rjb29raWVxAlUGd2
>> 9ya2VkcQNzLjViMGE0ODQwNDRhMjdjY2UyNDhjODgxYWIx\nZjlkZDky\n"}}
>> 'Error: (1146, "Table 'reviewboard_mysqldb.django_session' doesn't
>> exist")
>> Line 2020: '{"pk": "57e2c5013b1a55003e2df355c69bc722", "model":
>> "sessions.session", "fields": {"expire_date": "2015-03-19T06:25:37.154Z",
>> "session_data": "gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2
>> tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\
>> ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEES4t1LmNhYTJlZmF
>> mMzM0YWY5NDY1ZjAx\nNjM3ZjA3NTA1M2Rl\n"}}
>> 'Error: (1146, "Table 'reviewboard_mysqldb.django_session' doesn't
>> exist")
>> Line 2021: '{"pk": "f5039c679f6f5d0fcd4e1ce45375d2c9", "model":
>> "sessions.session", "fields": {"expire_date": "2015-04-01T05:35:47.003Z",
>> "session_data": "gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2
>> tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\
>> ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEES2R1LjA3ODVlNzk
>> 1YzNkYmExMmJmY2Fm\nMTNmMmMzODI0MmFh\n"}}
>> 'Error: (1146, "Table 'reviewboard_mysqldb.django_session' doesn't
>> exist")
>> Line 2022: '{"pk": "b9da809d942c8ab930c14843aabd5d9b", "model":
>> "sessions.session", "fields": {"expire_date": "2015-03-20T22:06:59.624Z",
>> "session_data": "gAJ9cQEoVQ1fYXV0aF91c2VyX2lkcQ
>> JLKFUSX2F1dGhfdXNlcl9iYWNrZW5kcQNVKWRqYW5nby5j\
>> nb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kcQR1LjIzNzk5MzQ
>> wY2ZhODUwMWNmMzU5\nMWY4MWUyNmY5YjIx\n"}}
>> 'Error: (1146, "Table 'reviewboard_mysqldb.django_session' doesn't
>> exist")
>> Line 2023: '{"pk": "ba719abc8094a9bc8cc3b677cbc3db1d", "model":
>> "sessions.session", "fields": {"expire_date": "2015-03-20T00:34:54.056Z",
>> "session_data": "gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2
>> tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\
>> ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEES311LjZmZWI3MGM
>> 5NzUyNTIxOGM2OTk1\nNjg1NGQyOTE5NDc1\n"}}
>> 'Error: (1146, "Table 'reviewboard_mysqldb.django_session' doesn't
>> exist")
>> Line 2024: '{"pk": "b7ef1ec805fba7b77c567fe403ffcc80", "model":
>> "sessions.session", "fields": {"expire_date": "2015-03-20T00:36:22.807Z",
>> "session_data": "gAJ9cQFVCnRlc3Rjb29raWVxAlUGd2
>> 9ya2VkcQNzLjViMGE0ODQwNDRhMjdjY2UyNDhjODgxYWIx\nZjlkZDky\n"}}
>> 'Error: (1146, "Table 'reviewboard_mysqldb.django_session' doesn't
>> exist")
>> Line 2025: '{"pk": "4eefe47bedaa52c81faaf65f3fec65e7", "model":
>> "sessions.session", "fields": {"expire_date": "2015-03-20T00:37:22.556Z",
>> "session_data": "gAJ9cQFVCnRlc3Rjb29raWVxAlUGd2
>> 9ya2VkcQNzLjViMGE0ODQwNDRhMjdjY2UyNDhjODgxYWIx\nZjlkZDky\n"}}
>> Line 2166: '{"pk": "0fb6592d2c2784aafd9fa256f522dd52", "model":
>> "sessions.session", "fields": {"expire_date": "2015-04-14T10:18:01.105Z",
>> "session_data": "MTgzOTdhYTQzYzIzMWUyNTJhOTcwYz
>> k3ODQwNTE0MDFjN2JhNzYxYjqAAn1xAShVEl9hdXRoX3Vz\
>> nZXJfYmFja2VuZHECVTFyZXZpZXdib2FyZC5hY2NvdW50cy5iYWNrZW5kcy5
>> TdGFuZGFyZEF1dGhC\nYWNrZW5kcQNVDV9hdXRoX3VzZXJfaWRxBEsQdS4=\n"}}
>>
>> 'Problem installing '/home/rbusr/reviewboard/database.json': (1146,
>> "Table 'reviewboard_mysqldb.django_site' doesn't exist")
>>
>>
>>
>>
>>
>> Any thoughts on how to fix this..
>>
>> Best regards,
>> Joe.
>>
>>
>>
>> On Saturday, April 12, 2014 8:29:54 AM UTC+2, David Trowbridge wrote:
>>>
>>> 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 to what expertise people have.
>>>
>>> -David
>>>
>>>
>>> On Fri, Apr 11, 2014 at 7:45 AM, Joe <jothi...@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> I believe I'm still running my review board in sqlite3 (how to confirm
>>>> it)
>>>>
>>>> Are there any scripts from review board to convert this database to
>>>> MySQL or PostgreSQL.
>>>>
>>>> Also which one (MySQL or PostgreSQL) is better option.
>>>>
>>>> Best regards,
>>>> Joe.
>>>>
>>>> --
>>>> Get the Review Board Power Pack at http://www.reviewboard.org/
>>>> powerpack/
>>>> ---
>>>> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
>>>> ---
>>>> Happy user? Let us know at http://www.reviewboard.org/users/
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "reviewboard" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to reviewboard...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>  --
> Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
> ---
> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
> ---
> Happy user? Let us know at http://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "reviewboard" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to