Re: dbconfig-common

[Niko Tyni <ntyni@debian.org>]

Nur Aini Rakhmawati wrote:

> I would like to cerate debian package which needs to generate database.
> Suppose I create foo.sql that contains SQL syntaxes such as create table, insert etc ...
> and put those following lines in config file
> . /usr/share/dbconfig-common/dpkg/config 
> dbc_dbuser=debian
> dbc_dbname=debian
> dbc_dbtypes=mysql
> dbc_go debian $@
> 
> How could I execute foo.sql for generating tables ?
> So far I just create empty database.

Hi,

you should install foo.sql as /usr/share/dbconfig-common/data/PACKAGE/install/DBTYPE

where DBTYPE is mysql in this case, and PACKAGE is the name of your package.

See e.g.

http://people.debian.org/~seanius/policy/dbconfig-common.html/ch-develguide.html#s-bootstrap

Hope this helps,
-- 
Niko Tyni   ntyni@debian.org