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 Test