As a starting point, it would be useful to know what fields your wiki
is going to recover.
My preliminary review found that it would probably be surprisingly
difficult to translate. The problem is the tiddler itself -- the
contents of each tiddler have a mixed bag of quote marks, commas,
linebreaks, etc. and would have to be exported to a separate file
(each tiddler!), which can then later be uploaded with the MySql
load_file function.
I can see how this might work.
A script would first add an id field and unique value to each tiddler.
The contents of each tiddler would be saved to a directory (will FF
security allow this?) with a file name like 1234.txt. The script would
then write a CSV file that would contain the tiddler title, unique ID,
and any other exportable fields/tags. The TW script would then write
an SQL script that would say something like:
update mediwikitable set txtcolumn=load_file("/export/1234.txt")
where
twid=1234;
update mediwikitable set txtcolumn=load_file("/export/1235.txt")
where
twid=1235;
You would load the CSV (1) file using the standard MySql import
utility. Then run the update sql script (2) from within your MySql
console or application.
Might just be better to cut & paste ;-)
Mark
On Jan 15, 8:13 am, geert Geurts <[email protected]> wrote:
> Hello,
> I'm using tiddlywiki at my work to document all the things I learn about
> linux. I'm very happy with my personal wiki except tiddlywiki is getting
> quite slow... probably because it's growing too big... So I was thinking to
> start using a mysql database to host my wiki in, but I don't want to copy
> past ALL of my tiddlers to the new mysql enabled wiki.
> Does anyone know of a script or plugin or something like that to convert my
> current standalone tiddlywiki to mysql?
>
> Thanks!!!
>
> Greetings,
> Geert
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/tiddlywiki?hl=en.
