On Tue, 29 Aug 2006, Clair wrote:
I'm trying to convert a database to the
'new' schema used in the latest
OG version. When running wiki-toolkit-setupdb, I get the following
message:
Upgrading: old_to_9
Grabbing and upgrading old data... read 333 nodes... read 1250
contents... done
Hmm, it doesn't seem to be doing the next steps, where it drops the
tables. After that, it'll create the new versions (including the version
table), and then put all your data back
If it breaks on the permissions check, you ought to get an error reported
to you. Odd that you're not. However, that's my hunch - check that your
database user can create and drop tables
Yep, the database user can do 'all'.
If it helps, the script I'm using is:
#!/usr/bin/perl
use CGI::Carp qw( fatalsToBrowser );
use Wiki::Toolkit
print "Content-type: text/plain\n\n";
system("wiki-toolkit-setupdb --type mysql --name [database] --user
[user] --pass [password]")
(as CGI)