[daisy] Daisy 1.5.1 -> Daisy 2.0 with sauce

[Caleb Callaway]

That worked quite handily. Thank you kindly! 

-----Original Message-----
From: daisy-bounces at lists.cocoondev.org
[mailto:daisy-bounces at lists.cocoondev.org] On Behalf Of Bruno Dumon
Sent: Thursday, April 05, 2007 8:53 AM
To: Daisy: open source CMS - general mailinglist
Subject: Re: [daisy] Daisy 1.5.1 -> Daisy 2.0 with sauce

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

_______________________________________________
daisy community mailing list
Professional Daisy support:
http://outerthought.org/site/services/daisy/daisysupport.html
mail to: daisy at lists.cocoondev.org
list information: http://lists.cocoondev.org/mailman/listinfo/daisy


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.26/746 - Release Date: 4/4/2007
1:09 PM