Mysql dump problem in migration
I'm migrating ISPConfig server, all looks ok but when i'm triying to create database from sqldump I've an error:
ERROR 1064 at line 23: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 13
Old server version: mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
New Server version: mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
How I can upgrade Mysql Version?
Thanks in advance.