#1  
Old 21st August 2007, 05:50
plucchetti plucchetti is offline
Member
 
Join Date: Feb 2006
Posts: 74
Thanks: 2
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 21st August 2007, 10:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,814
Thanks: 821
Thanked 5,339 Times in 4,188 Posts
Default

Which linux distribution do you use?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 21st August 2007, 11:06
mccharlet mccharlet is offline
Senior Member
 
Join Date: Feb 2007
Posts: 261
Thanks: 62
Thanked 11 Times in 7 Posts
Default

I had this problem,
I have deleted "'DEFAULT CHARSET=latin1" on my sqldump file.
__________________
Thanks
Cédric

Sorry for my english

Hosting : http://www.jheberge.ch
Reply With Quote
  #4  
Old 21st August 2007, 13:22
plucchetti plucchetti is offline
Member
 
Join Date: Feb 2006
Posts: 74
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till
Which linux distribution do you use?
I'm using Debian
Reply With Quote
  #5  
Old 22nd August 2007, 18:10
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Just install MySQL 5 on the server. You can find the appropriate packages by running
Code:
apt-cache search mysql
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 23rd August 2007, 16:49
plucchetti plucchetti is offline
Member
 
Join Date: Feb 2006
Posts: 74
Thanks: 2
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #7  
Old 23rd August 2007, 16:58
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,814
Thanks: 821
Thanked 5,339 Times in 4,188 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
plucchetti (23rd August 2007)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 19:20.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.