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 [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]