Obnova dat a syntax error
Vladimir Rengevic
linux na grafon.sk
Pondělí Říjen 10 11:53:23 CEST 2005
Dobry den,
ugradujem server a vytvoril som si zalohu starych dat z MySQL
(mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686))
/usr/bin/mysqldump --host=localhost --user=root --password=heslo
--all-databases > mysqlbackup
Pokusam sa to natiahnut do novej verzie MySQL
(mysql Ver 14.7 Distrib 4.1.11, for redhat-linux-gnu (i386))
a dostavam chybovu hlasku....
mysql < mysqlbackup
ERROR 1064 (42000) at line 29273: 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 'order (image_order),
KEY item_name (item_name)
) TYPE=MyISAM' at line 17
Prosim, poradte co s tym. Vopred dakujem! ;o)
Vlado
--
Ing. Vladimir Rengevic
GRAFON dtp studio
Tranovskeho 19, Liptovsky Mikulas, Slovakia
phone: +421/44/5526153, fax: +421/44/5621454
mobil: +421/905/642799
Další informace o konferenci Databases