Mysql dump problem in migration

Discussion in 'Installation/Configuration' started by plucchetti, Aug 21, 2007.

  1. plucchetti

    plucchetti New Member


    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.

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Which linux distribution do you use?
  3. mccharlet

    mccharlet Member HowtoForge Supporter

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

    plucchetti New Member

    I'm using Debian
  5. falko

    falko Super Moderator ISPConfig Developer

    Just install MySQL 5 on the server. You can find the appropriate packages by running
    apt-cache search mysql
  6. plucchetti

    plucchetti New Member

    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?

  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Install the libmysqlclient-dev pacakge for your mysql version:

    apt-get install libmysqlclient15-dev

    and then download the latest ISPConfig version and run setup to update ispconfig.

Share This Page