Mysqldump visszatoltese problema

[Paczkó András]

Hello!

nem lehet, hogy a show "reserved" word ? 

Vagyis ez egy foglalt rendszernev?

lásd: show tables;



üdv,



Paczkó András
IT manager
 
Internet Securities, Inc. 
(trading as ISI Emerging Markets) is a Euromoney Institutional Investor
Company
http://www.securities.com
 
tel: +36 (1)  327-4010
fax: +36 (1) 266-8639

-----Original Message-----
From: techinfo-bounces at lista.sulinet.hu
[mailto:techinfo-bounces at lista.sulinet.hu] On Behalf Of Kovacs Marietta
Sent: Saturday, July 02, 2005 9:05 PM
To: techinfo at lista.sulinet.hu
Subject: Mysqldump visszatoltese problema

Le akarom cserelni kisse regi webszerverunket (apache+php+mysql). A regin
woody van, az alapertelmezett mysql 3.23-mal, az uj gepre sarge-ot
telepitettem, abban mysql 4.valamennyi az alapertelmezett. 

Megprobaltam atvinni az adatbazist mysqldump-pal, de amikor az uj szerveren
be akarom tolteni az sql fajl, syntax errort jelez. A hibas
utasitas:

CREATE TABLE gallery_files (
  id int(10) unsigned NOT NULL auto_increment,
  dir_id int(10) unsigned NOT NULL default '0',
  path blob NOT NULL,
  width int(10) unsigned NOT NULL default '0',
  height int(10) unsigned NOT NULL default '0',
  comment varchar(255) NOT NULL default '',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  show tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY (id)
) TYPE=MYISAM;

A MySql a show... kezdetu sort relkamalja. Mar kinezem a szemem, de nem
latok semmi hibat ebben az utasitasban. Mivel a regi szerveren mukodik,
valami kompatibilitasi problemat gyanitok, de hiaba olvasgatom a valtozasok
listajat, nem latom, mi a gond. A hiba egyebkent a "sokat mondo" 1064-es
"SQL syntax error....".

Valakinek valami otlet? 

 
Kovacs Marietta 


_______________________________________________
Techinfo mailing list
Techinfo at lista.sulinet.hu
http://lista.sulinet.hu/mailman/listinfo/techinfo
Illemtan: http://support.bkf.hu/illemtan.html
Ügyfélszolgálat FAQ: http://www.sulinet.hu/tart/cikk/sc/0/19789/1

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. BlackList requests should be sent to
blacklist at securities.com, WhiteList requests should be sent to
whitelist at securities.com. Contact the Global Operations Team
(globalops at securities.com) if you need additional support.
________________________________________________________________________


Internet Securities, Inc. (trading as ISI Emerging Markets) is a Euromoney Institutional Investor company.
________________________________________________________________________

This communication contains information which is confidential. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note any distribution, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error please notify us by e-mail or bytelephone (as above) and then delete the e-mail and all attachments and any copies thereof.
________________________________________________________________________