Mysql dump problem in migration

Hello,

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.

Pablo

 

I had this problem,
I have deleted "'DEFAULT CHARSET=latin1" on my sqldump file.

 

I'm using Debian

 

Just install MySQL 5 on the server. You can find the appropriate packages by running

Code:

apt-cache search mysql

 

I upgraded MySql via Aptitude, but when I restart ISPConfig, can't connect to Database:

mail:/home/admispconfig/ispconfig# /etc/init.d/ispconfig_server restart
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd stopped
ISPConfig system stopped!
Starting ISPConfig system...
/root/ispconfig/httpd/bin/apachectl startssl: httpd started
Could not connect to MySQL server!ISPConfig system is now up and running!

The db root password is the same as old database.

What's wrong?

Thanks,
Pablo