misc/171801: Problem with creating MySQL database from
squid_db.sql.
Ametov Imil Ilimdarovich
charlz.klug at gmail.com
Thu Sep 27 17:00:23 UTC 2012
The following reply was made to PR misc/171801; it has been noted by GNATS.
From: Ametov Imil Ilimdarovich <charlz.klug at gmail.com>
To: bug-followup at FreeBSD.org, charlz_klug at 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--
More information about the freebsd-bugs
mailing list