Wiki - dump and load

33 views
Skip to first unread message

janiv

unread,
Jan 9, 2011, 8:34:59 AM1/9/11
to Trac Users
Hi,
I have two environments, I want to import wiki pages from one trac to
another one.
On one of my trac I can do dump & load.
On another trac environment I cannot do dump nor load.
I get the following error:
OperationalError: no such table: cache

My commands are as follows:

trac-admin EssenceSecurity wiki dump E:\Janiv\Wiki\AgiloWiki
trac-admin EssenceSecurity wiki load E:\Janiv\Wiki\AgiloWiki

Both commands return the same error:
OperationalError: no such table: cache

The following command works fine for me:

trac-admin EssenceSecurity wiki list

Any ideas on how to solve it?
Thanks,
Janiv Ratson.

Phil

unread,
Jan 11, 2011, 9:52:41 AM1/11/11
to Trac Users
Which versions of trac do you use?

janiv

unread,
Jan 11, 2011, 10:17:08 AM1/11/11
to Trac Users
0.11.7

Olemis Lang

unread,
Jan 11, 2011, 10:24:34 AM1/11/11
to trac-...@googlegroups.com
On Sun, Jan 9, 2011 at 8:34 AM, janiv <jan...@gmail.com> wrote:
> Hi,
> I have two environments, I want to import wiki pages from one trac to
> another one.
> On one of my trac I can do dump & load.
> On another trac environment I cannot do dump nor load.
> I get the following error:
> OperationalError: no such table: cache
>
> My commands are as follows:
>
> trac-admin EssenceSecurity wiki dump E:\Janiv\Wiki\AgiloWiki
> trac-admin EssenceSecurity wiki load E:\Janiv\Wiki\AgiloWiki
>

JFTR , have you considered trying WikiImport plugin (web UI rather
than command-line but may be useful ...)

I've used it to import wiki pages using admin panel .

--
Regards,

Olemis.

Blog ES: http://simelo-es.blogspot.com/
Blog EN: http://simelo-en.blogspot.com/

Featured article:
Barça es todo CORAZÓN -
http://simelo-es.blogspot.com/2010/12/barca-es-todo-corazon.html

janiv

unread,
Jan 11, 2011, 3:06:20 PM1/11/11
to Trac Users
Where can I find this plugin?
Thanks,
J.

Olemis Lang

unread,
Jan 11, 2011, 3:20:38 PM1/11/11
to trac-...@googlegroups.com
On Tue, Jan 11, 2011 at 3:06 PM, janiv <jan...@gmail.com> wrote:
> Where can I find this plugin?
> Thanks,
> J.
>

Standard reply : http://trac-hacks.org/wiki/WikiImportPlugin

--
Regards,

Olemis.

Blog ES: http://simelo-es.blogspot.com/
Blog EN: http://simelo-en.blogspot.com/

Featured article:
Usar bindings de XAML para mostrar valores de tipos enumerados en
controles WPF -
http://simelo-es.blogspot.com/2010/12/usar-bindings-de-xaml-con-tipos.html

janiv

unread,
Jan 11, 2011, 4:01:20 PM1/11/11
to Trac Users
Thanks,
Will it work in my case, where the wiki pages that I want to import
are on another server?

Thanks,
Janiv.
> controles WPF -http://simelo-es.blogspot.com/2010/12/usar-bindings-de-xaml-con-tipos...

Olemis Lang

unread,
Jan 11, 2011, 4:12:38 PM1/11/11
to trac-...@googlegroups.com
On Tue, Jan 11, 2011 at 4:01 PM, janiv <jan...@gmail.com> wrote:
> Thanks,
> Will it work in my case, where the wiki pages that I want to import
> are on another server?
>

Don't remember right now , sorry. You should try. On failure, consider
these approaches (maybe in this order) :

- Map network drive ... many ways to do so .
- Simple script using Trac XmlRpcPlugin's wiki namespace .

--
Regards,

Olemis.

Blog ES: http://simelo-es.blogspot.com/
Blog EN: http://simelo-en.blogspot.com/

Featured article:

janiv

unread,
Jan 13, 2011, 9:30:13 AM1/13/11
to Trac Users
Thanks,
Tried it.
Did not work for me.
I prefer working with the command line.
I get back to my original question:

I have two environments, I want to import wiki pages from one trac to
another one.
On one of my trac I can do dump & load.
On another trac environment I cannot do dump nor load.

I get the following error:
OperationalError: no such table: cache

My commands are as follows:
trac-admin EssenceSecurity wiki dump E:\Janiv\Wiki\AgiloWiki
trac-admin EssenceSecurity wiki load E:\Janiv\Wiki\AgiloWiki

Both commands return the same error:
OperationalError: no such table: cache

The following command works fine for me:
trac-admin EssenceSecurity wiki list

Any ideas on how to solve it?
Thanks,
Janiv Ratson.


========================================================================================================

Christian Boos

unread,
Jan 13, 2011, 10:45:22 AM1/13/11
to trac-...@googlegroups.com
Hello,

On 1/13/2011 3:30 PM, janiv wrote:
> Thanks,
> Tried it.
> Did not work for me.
> I prefer working with the command line.
> I get back to my original question:
>
> I have two environments, I want to import wiki pages from one trac to
> another one.
> On one of my trac I can do dump& load.

This is a Trac >= 0.12 environment.

> On another trac environment I cannot do dump nor load.

This is a Trac < 0.12 environment.

> I get the following error:
> OperationalError: no such table: cache
>
> My commands are as follows:
> trac-admin EssenceSecurity wiki dump E:\Janiv\Wiki\AgiloWiki
> trac-admin EssenceSecurity wiki load E:\Janiv\Wiki\AgiloWiki
>
> Both commands return the same error:
> OperationalError: no such table: cache

This must be the trac-admin script from Trac 0.12, as at one point the
code expects to deal with the `cache` table, which is not present in
Trac databases that have not been upgraded to 0.12.

> The following command works fine for me:
> trac-admin EssenceSecurity wiki list

That command doesn't trigger the use of `cache`.

> Any ideas on how to solve it?

2 possibilities:
- trac-admin E:\Janiv\Wiki\AgiloWiki upgrade
- use a matching version of trac-admin (i.e. from Trac 0.11 or Trac 0.10)

Apparently we don't check for the need to upgrade the environment, for
trac-admin commands...

-- Christian

Christian Boos

unread,
Jan 13, 2011, 10:59:23 AM1/13/11
to trac-...@googlegroups.com
Oops...

>> My commands are as follows:
>> trac-admin EssenceSecurity wiki dump E:\Janiv\Wiki\AgiloWiki

>> ...
>
...


> 2 possibilities:
> - trac-admin E:\Janiv\Wiki\AgiloWiki upgrade

I should have written: trac-admin EssenceSecurity upgrade

-- Christian

Reply all
Reply to author
Forward
0 new messages