From: Vitaly Gorshkov <vita55555@mail.ru> To: Community@lists.altlinux.org Subject: [Comm] MySQL 4.1 Date: Wed, 12 Apr 2006 16:23:49 +0400 Message-ID: <443CF155.7060100@mail.ru> (raw) АМ 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 вот такие дела.
next reply other threads:[~2006-04-12 12:23 UTC|newest] Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top 2006-04-12 12:23 Vitaly Gorshkov [this message] 2006-04-12 13:35 ` Dmitry Zorin 2006-04-13 4:47 ` Vitaly Gorshkov
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=443CF155.7060100@mail.ru \ --to=vita55555@mail.ru \ --cc=Community@lists.altlinux.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux Community general discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 community community/ http://lore.altlinux.org/community \ mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com public-inbox-index community Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.community AGPL code for this site: git clone https://public-inbox.org/public-inbox.git