[daisy] Daisy 1.5.1 -> Daisy 2.0 with sauce

[Bruno Dumon]

On Thu, 2007-04-05 at 17:38 +0200, Bruno Dumon wrote:
> On Wed, 2007-04-04 at 16:29 -0700, Caleb Callaway wrote:
<snip/>
> To switch the DB to UTF-8:
> 
>  * check MySQL docs to see how to do it on the MySQL side.
> 

One way to do this might be:

mysqldump -uroot daisyrepository > mysqldump.sql

Open mysqldump.sql in a texteditor (using utf8 encoding -- at least if
you're using MySQL > 4.1.2, which you should), and do a search and
replace of CHARSET=what-it-is-now to CHARSET=utf8

Go into the mysql tool:

mysql -Ddaisyrepository -uroot

and execute:
drop database daisyrepository;
create database daisyrepository CHARACTER SET 'utf8';

and then reload the dump:

mysql -uroot -Ddaisyrepository < mysqldump.sql

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org