[Moodle] Problems upgrading the database

[Laurie Savage]

It's slow but I've fixed my problem - don't do this with a large site 
boys and girls! I have backed up and restored each course via the 
backup/restore modules in Moodle. It works.

Why oh why doesn't somebody write a tool to fix MySQL 3.23 dumps to 
import into MySQL > 4!

Laurie

Laurie Savage wrote:
> 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
===============================================