DEFAULT CHARSET=latin1 ERROR

ampash
Posts: 23
Joined: 2002-12-04 19:39

DEFAULT CHARSET=latin1 ERROR

Post by ampash »

hallo,
ich möchte datenbanken von mysql 4.1.12 windows 2003 in mysql 4.0.24 debian 3.1 importieren und bekomme folgenden fehler:

ERROR 1064 at line 20: 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 3

gibt es da eine lösung ohne mysql update?

greats
ampash
Top

User avatar
Joe User
Project Manager
Project Manager
Posts: 11519
Joined: 2003-02-27 01:00
Location: Hamburg

Re: DEFAULT CHARSET=latin1 ERROR

Post by Joe User »

Code: Select all

sed 's/ DEFAULT CHARSET=latin1/ /g' -i /path/to/mysqldump.sql
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
Top

ampash
Posts: 23
Joined: 2002-12-04 19:39

Re: DEFAULT CHARSET=latin1 ERROR

Post by ampash »

funktioniert ... dankeschön!
Top