Date: Thu, 20 Sep 2012 04:17:48 GMT From: Imil <charlz_klug@mail.ru> To: freebsd-gnats-submit@FreeBSD.org Subject: misc/171801: Problem with creating MySQL database from squid_db.sql. Message-ID: <201209200417.q8K4HmsS025564@red.freebsd.org> Resent-Message-ID: <201209200420.q8K4K614038178@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 171801 >Category: misc >Synopsis: Problem with creating MySQL database from squid_db.sql. >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Thu Sep 20 04:20:05 UTC 2012 >Closed-Date: >Last-Modified: >Originator: Imil >Release: FreeBSD 8.0-RELEASE >Organization: >Environment: FreeBSD test.local 8.0-RELEASE FreeBSD 8.0-RELEASE #0: Sat Nov 21 15:48:17 UTC 2009 root@almeida.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386 >Description: I install /usr/ports/www/sams and /usr/ports/databases/mysql55-server/ . This problem appear with creating MySQL databases from /usr/local/share/sams/data/sams_db.sql . I enter "http://[My_IP_address]/sams/install.php" in web-browser address string. Next, I press [Create Database] button in web-page. And get some messages: SAMS installations File squid_db.sql opened Please wait, database createst may take up to 30 minutes........ ERROR: line 6: query:[ CREATE TABLE `cache` ( `date` date, `time` time, `user` char(25), `domain` char(25), `size` BIGINT UNSIGNED NULL, `ipaddr` char(15) NOT NULL, `period` BIGINT UNSIGNED NULL, `url` char(100) NOT NULL, `hit` BIGINT UNSIGNED NULL, `method` char(15) NOT NULL ) TYPE=MyISAM] failed mysql error: 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 'TYPE=MyISAM' at line 12 (err:1064) >How-To-Repeat: >Fix: >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201209200417.q8K4HmsS025564>