From owner-freebsd-bugs@FreeBSD.ORG  Thu Sep 27 17:00:23 2012
Return-Path: <owner-freebsd-bugs@FreeBSD.ORG>
Delivered-To: freebsd-bugs@hub.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 38D281065673
	for <freebsd-bugs@hub.freebsd.org>;
	Thu, 27 Sep 2012 17:00:23 +0000 (UTC)
	(envelope-from gnats@FreeBSD.org)
Received: from freefall.freebsd.org (freefall.freebsd.org
	[IPv6:2001:4f8:fff6::28])
	by mx1.freebsd.org (Postfix) with ESMTP id DC7C08FC1D
	for <freebsd-bugs@hub.freebsd.org>;
	Thu, 27 Sep 2012 17:00:22 +0000 (UTC)
Received: from freefall.freebsd.org (localhost [127.0.0.1])
	by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q8RH0Mq2023981
	for <freebsd-bugs@freefall.freebsd.org>; Thu, 27 Sep 2012 17:00:22 GMT
	(envelope-from gnats@freefall.freebsd.org)
Received: (from gnats@localhost)
	by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q8RH0MvD023973;
	Thu, 27 Sep 2012 17:00:22 GMT (envelope-from gnats)
Date: Thu, 27 Sep 2012 17:00:22 GMT
Message-Id: <201209271700.q8RH0MvD023973@freefall.freebsd.org>
To: freebsd-bugs@FreeBSD.org
From: Ametov Imil Ilimdarovich <charlz.klug@gmail.com>
Cc: 
Subject: Re: misc/171801: Problem with creating MySQL database from
 squid_db.sql.
X-BeenThere: freebsd-bugs@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: Ametov Imil Ilimdarovich <charlz.klug@gmail.com>
List-Id: Bug reports <freebsd-bugs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-bugs>,
	<mailto:freebsd-bugs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-bugs>
List-Post: <mailto:freebsd-bugs@freebsd.org>
List-Help: <mailto:freebsd-bugs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-bugs>,
	<mailto:freebsd-bugs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 27 Sep 2012 17:00:23 -0000

The following reply was made to PR misc/171801; it has been noted by GNATS.

From: Ametov Imil Ilimdarovich <charlz.klug@gmail.com>
To: bug-followup@FreeBSD.org, charlz_klug@mail.ru
Cc:  
Subject: Re: misc/171801: Problem with creating MySQL database from
 squid_db.sql.
Date: Thu, 27 Sep 2012 21:58:41 +0500

 --=-EZliALCiucyOKDXkDTmt
 Content-Type: text/plain; charset="UTF-8"
 Content-Transfer-Encoding: 7bit
 
 Same problem with /usr/local/share/sams/data/squid_db.sql. This file has
 strings "TYPE=MyISAM". When I delete this lines MySQL database has
 successfully created.
 
 --=-EZliALCiucyOKDXkDTmt
 Content-Disposition: attachment; filename="squid_db.sql.patch"
 Content-Type: text/x-patch; name="squid_db.sql.patch"; charset="UTF-8"
 Content-Transfer-Encoding: 7bit
 
 --- squid_db.sql.old	2012-09-27 21:52:23.000000000 +0500
 +++ squid_db.sql	2012-09-27 21:53:50.000000000 +0500
 @@ -21,7 +21,7 @@
    `url` char(100) NOT NULL,
    `hit` BIGINT UNSIGNED NULL,
    `method` char(15) NOT NULL
 -) TYPE=MyISAM;
 +);
     
  ALTER TABLE cache ADD INDEX (date);
  ALTER TABLE cache ADD INDEX (user);
 @@ -35,7 +35,7 @@
    size bigint(20) unsigned default NULL,
    hit bigint(20) unsigned default NULL,
    PRIMARY KEY  (date,user,domain)
 -) TYPE=MyISAM;
 +);
  
  insert into cachesum select date,user,domain,sum(size),sum(hit) from cache group by date,user;
  
 @@ -45,6 +45,6 @@
    filepath varchar(50) NOT NULL default '',
    url varchar(120) NOT NULL default '',
    size int(12) NOT NULL default '0'
 -) TYPE=MyISAM;
 +);
  
  
 
 
 --=-EZliALCiucyOKDXkDTmt--