Instiki with MySQL

I have a very very simple question. How can I use Instiki
with MySQL? I
downloaded the instiki's zip and changed
"database.yml." What should I
do next?
_______________________________________________
Instiki-users mailing list
Instiki-usersrubyforge.org
h
ttp://rubyforge.org/mailman/listinfo/instiki-users

Assuming that in updating database.yml, you've also created
a MySQL  
db for Instiki, then you just need to run "rake
migrate".  If you're  
on Windows using the all-in-one bundle zipfile, you may need
to do  
this as:

pathtorubybinruby.exe pathtorubybinrake migrate

(The rake tool is just a ruby script, and it typically lives
in the  
ruby/bin directory.)

-- John

On Dec 5, 2006, at 8:39 PM, keiyakanno.com wrote:

> I have a very very simple question. How can I use
Instiki with  
> MySQL? I
> downloaded the instiki's zip and changed
"database.yml." What should I
> do next?
> _______________________________________________
> Instiki-users mailing list
> Instiki-usersrubyforge.org
> h
ttp://rubyforge.org/mailman/listinfo/instiki-users

_______________________________________________
Instiki-users mailing list
Instiki-usersrubyforge.org
h
ttp://rubyforge.org/mailman/listinfo/instiki-users

Thank you very much for your answer.

I'm done with migration. Then I runed the
"instiki.cmd" and opened the 
http://localhost:2500/
but only blank page appears. What is wrong? Am I 
missing something that I should do?

John Whitley wrote:
> Assuming that in updating database.yml, you've also
created a MySQL  
> db for Instiki, then you just need to run "rake
migrate".  If you're  
> on Windows using the all-in-one bundle zipfile, you may
need to do  
> this as:
> 
> pathtorubybinruby.exe pathtorubybinrake migrate
> 
> (The rake tool is just a ruby script, and it typically
lives in the  
> ruby/bin directory.)
> 
> -- John
> 
> On Dec 5, 2006, at 8:39 PM, keiyakanno.com wrote:
> 
>> I have a very very simple question. How can I use
Instiki with  
>> MySQL? I
>> downloaded the instiki's zip and changed
"database.yml." What should I
>> do next?
>> _______________________________________________
>> Instiki-users mailing list
>> Instiki-usersrubyforge.org
>> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
> 
> _______________________________________________
> Instiki-users mailing list
> Instiki-usersrubyforge.org
> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
> 
> 
> 
> 

_______________________________________________
Instiki-users mailing list
Instiki-usersrubyforge.org
h
ttp://rubyforge.org/mailman/listinfo/instiki-users

Argh.  It occurs to me that I probably left out a step which
may have  
caused the migration to run incorrectly.  You need to
explicitly tell  
rake db:migrate to use the production (vs. development)
database  
defined in database.yml.  Thus the command should be:

ruby rake migrate RAILS_ENV=production

(Again, you may need to use full paths for ruby & rake.)

If that doesn't work, check what log files were created in
the log/  
directory.  Check the end of those file(s) for messages that
suggest  
a problem, and post those fragments here if the answer isn't
obvious  
(e.g. database name misspelled or not created, etc.).

-- John


On Dec 6, 2006, at 2:37 PM, keiyakanno.com wrote:

> Thank you very much for your answer.
>
> I'm done with migration. Then I runed the
"instiki.cmd" and opened the
> http://localhost:2500/ but
only blank page appears. What is wrong?  
> Am I
> missing something that I should do?
>
> John Whitley wrote:
>> Assuming that in updating database.yml, you've also
created a MySQL
>> db for Instiki, then you just need to run
"rake migrate".  If you're
>> on Windows using the all-in-one bundle zipfile, you
may need to do
>> this as:
>>
>> pathtorubybinruby.exe pathtorubybinrake
migrate
>>
>> (The rake tool is just a ruby script, and it
typically lives in the
>> ruby/bin directory.)
>>
>> -- John
>>
>> On Dec 5, 2006, at 8:39 PM, keiyakanno.com
wrote:
>>
>>> I have a very very simple question. How can I
use Instiki with
>>> MySQL? I
>>> downloaded the instiki's zip and changed
"database.yml." What  
>>> should I
>>> do next?
>>> _______________________________________________
>>> Instiki-users mailing list
>>> Instiki-usersrubyforge.org
>>> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
>>
>> _______________________________________________
>> Instiki-users mailing list
>> Instiki-usersrubyforge.org
>> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
>>
>>
>>
>>
>
> _______________________________________________
> Instiki-users mailing list
> Instiki-usersrubyforge.org
> h
ttp://rubyforge.org/mailman/listinfo/instiki-users

_______________________________________________
Instiki-users mailing list
Instiki-usersrubyforge.org
h
ttp://rubyforge.org/mailman/listinfo/instiki-users

Thank you very much John!

It worked properly and I started to use it to organize my
documents. 
Also I want to inform you there was a page in instiki.org
that explains 
how to switch Instiki's database to MySQL
http://inst
iki.org/show/Instiki+and+MySQL

Again I want to thank you for your very very particular
answer.

John Whitley wrote:
> Argh.  It occurs to me that I probably left out a step
which may have  
> caused the migration to run incorrectly.  You need to
explicitly tell  
> rake db:migrate to use the production (vs. development)
database  
> defined in database.yml.  Thus the command should be:
> 
> ruby rake migrate RAILS_ENV=production
> 
> (Again, you may need to use full paths for ruby &
rake.)
> 
> If that doesn't work, check what log files were created
in the log/  
> directory.  Check the end of those file(s) for messages
that suggest  
> a problem, and post those fragments here if the answer
isn't obvious  
> (e.g. database name misspelled or not created, etc.).
> 
> -- John
> 
> 
> On Dec 6, 2006, at 2:37 PM, keiyakanno.com wrote:
> 
>> Thank you very much for your answer.
>>
>> I'm done with migration. Then I runed the
"instiki.cmd" and opened the
>> http://localhost:2500/ but
only blank page appears. What is wrong?  
>> Am I
>> missing something that I should do?
>>
>> John Whitley wrote:
>>> Assuming that in updating database.yml, you've
also created a MySQL
>>> db for Instiki, then you just need to run
"rake migrate".  If you're
>>> on Windows using the all-in-one bundle zipfile,
you may need to do
>>> this as:
>>>
>>> pathtorubybinruby.exe pathtorubybinrake
migrate
>>>
>>> (The rake tool is just a ruby script, and it
typically lives in the
>>> ruby/bin directory.)
>>>
>>> -- John
>>>
>>> On Dec 5, 2006, at 8:39 PM, keiyakanno.com
wrote:
>>>
>>>> I have a very very simple question. How can
I use Instiki with
>>>> MySQL? I
>>>> downloaded the instiki's zip and changed
"database.yml." What  
>>>> should I
>>>> do next?
>>>>
_______________________________________________
>>>> Instiki-users mailing list
>>>> Instiki-usersrubyforge.org
>>>> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
>>> _______________________________________________
>>> Instiki-users mailing list
>>> Instiki-usersrubyforge.org
>>> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
>>>
>>>
>>>
>>>
>> _______________________________________________
>> Instiki-users mailing list
>> Instiki-usersrubyforge.org
>> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
> 
> _______________________________________________
> Instiki-users mailing list
> Instiki-usersrubyforge.org
> h
ttp://rubyforge.org/mailman/listinfo/instiki-users
_______________________________________________
Instiki-users mailing list
Instiki-usersrubyforge.org
h
ttp://rubyforge.org/mailman/listinfo/instiki-users