[Moodle] Problems upgrading the database

[Laurie Savage]

Thanks Kevork, I'm trying that now, but I'm stuck in a dependency trap 
on the machine I'm downgrading on! (MySQL 5 > MySQL 4!) I dont' seem to 
be able to move either way now without finding a spare machine to 
install a bare bone legacy MySQL setup.

Laurie

Kevork Krozian wrote:
> Hi Laurie,
> 
>  During an informal chat with Martin Dougiamas I think he mentioned the
> problem and one solution was 
> 
> ( Obviously backup everything first) .
> 
>    1. upgrade from MysQL 3 to 4 and then 
>    2. that rather than "dump" the sql data, copy it in its native form
> to the destination when going from mySQL 4 to 5 .  
> 
>  Maybe worth a try ?
> 
> Regards
> Kevork
> 
>>>> sav at pvgc.vic.edu.au 12/11/06 11:56am >>>
> I am moving our Moodle to a brand new server (Ubuntu 6.10, MySQL 5 etc)
> 
> and am having a nasty problem.
> 
> The old data is in MySQL 3.23. I've dumped the database to a .sql file
> 
> and am having problems importing it into MySQL 5. Apparently some 
> formats are not recognized. The import is choking on some TINYINT data.
> 
> Any ideas? This should not be taking me a whole day!!!!
> 
> Laurie

-- 
Laurie Savage
===============================================
Student Assessment, Reporting and Tracking
Pascoe Vale Girls College, Pascoe Vale, Vic, AU
+613 9306 2544
===============================================