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
DEFAULT CHARSET=latin1 ERROR
Re: DEFAULT CHARSET=latin1 ERROR
Code: Select all
sed 's/ DEFAULT CHARSET=latin1/ /g' -i /path/to/mysqldump.sql
PayPal.Me/JoeUser ● FreeBSD Remote Installation
Wings for Life ● Wings 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.
Wings for Life ● Wings 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.
Re: DEFAULT CHARSET=latin1 ERROR
funktioniert ... dankeschön!