[OGDev] Converting a database

[Clair]

Nick Burch wrote:
> 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)