$ mysql -u root -p
mysql> CREATE DATABASE depot_development_tg;
mysql> GRANT ALL PRIVILEGES ON depot_development_tg.*
TO hoge@localhost IDENTIFIED BY 'password';
sqlobject.dburi="mysql://hoge:password@localhost/depot_development_tg"
$ cd /path/to/dionea/sample/tg/depot $ tg-admin sql create
$ mysql -u hoge -p depot_development_tg < /path/to/dionea/sample/tg/db/insert.sql
lock tables products write;
insert into products values(null,
"Pragmatic Unit Testing (C#)",
"Pragmatic programmers ... ",
"/static/images/sk_utc_small.jpg",
"29.95",
"2006-03-13 22:05:00");
insert into products values(null,
"Pragmatic Project Automation",
"A really great read!",
"/static/images/sk_auto_small.jpg",
"29.95",
"2004-12-25 05:00:00");
insert into products values(null,
"Pragmatic Versin Control",
"A really controlled read!",
"/static/images/sk_svn_small.jpg",
"29.95",
"2004-12-25 05:00:00");
unlock tables;