From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <vita55555@mail.ru>
Message-ID: <443CF155.7060100@mail.ru>
Date: Wed, 12 Apr 2006 16:23:49 +0400
From: Vitaly Gorshkov <vita55555@mail.ru>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
To: Community@lists.altlinux.org
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: 8bit
Subject: [Comm] MySQL 4.1
X-BeenThere: community@lists.altlinux.org
X-Mailman-Version: 2.1.7
Precedence: list
Reply-To: ALT Linux Community <community@lists.altlinux.org>
List-Id: ALT Linux Community <community.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/community>
List-Post: <mailto:community@lists.altlinux.org>
List-Help: <mailto:community-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Wed, 12 Apr 2006 12:23:50 -0000
Archived-At: <http://lore.altlinux.org/community/443CF155.7060100@mail.ru/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>

АМ 2.4 +updates +backports

попытался NaWT (http://netams.com/download.html) для netams поставить.
rpm -qa|grep netams
netams-3.3.1a-alt0.M24.1
тут http://netams.com/download.html уже 3.3.3a

дык вот пытаюсь как написано в доке к NaWT импортировать таблицу из
файлика create.sql.

а она ругается:
ERROR 1064 at line 19: 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 'character set latin1 NOT NULL default '',
  `passport_ser` varc


вот кусочек файла create.sql :
CREATE TABLE `nawt_accountdata` (
  `oid` varchar(6) character set latin1 NOT NULL default '',
  `surname` varchar(80) character set latin1 NOT NULL default '',
  `name` varchar(80) character set latin1 NOT NULL default '',
  `patronymic` varchar(80) character set latin1 NOT NULL default '',
  `street` varchar(80) character set latin1 NOT NULL default '',
  `house` varchar(20) character set latin1 NOT NULL default '',
  `flat` varchar(10) character set latin1 NOT NULL default '',
  `room` varchar(10) character set latin1 NOT NULL default '',
  `phone` varchar(40) character set latin1 NOT NULL default '',
  `comment` text character set latin1 NOT NULL default '',
  `passport_ser` varchar(40) character set latin1 NOT NULL default '',
  `passport_num` varchar(40) character set latin1 NOT NULL default '',
  PRIMARY KEY  (`oid`),
  KEY `surname` (`surname`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

Знакомый сказал что чарсеты кажися поддерживаются в MySQL 4.1

у меня:
rpm -qa| grep MySQL
MySQL-client-4.0.24-alt0.M24.2
libMySQL-4.0.24-alt0.M24.2
MySQL-server-4.0.24-alt0.M24.2
libMySQL-devel-4.0.24-alt0.M24.2

вот такие дела.