I was working with one client who want to migrate MySql 4 to MySql 5. It can be easily done using the Export and Import feature of phpmyadmin. Problem here is with size of database. Size of the database is over 900mb. so phpmyadmin does not allow to import or export the database.