Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 27 Sep 2012 17:00:22 GMT
From:      Ametov Imil Ilimdarovich <charlz.klug@gmail.com>
To:        freebsd-bugs@FreeBSD.org
Subject:   Re: misc/171801: Problem with creating MySQL database from squid_db.sql.
Message-ID:  <201209271700.q8RH0MvD023973@freefall.freebsd.org>

next in thread | raw e-mail | index | archive | help
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--
 



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201209271700.q8RH0MvD023973>