[Gambas-user] database

[Ricardo Díaz Martín]

Because you are using MySQL database you can symply copy the database folder
to /var/lib/mysql. All the database table type must be use MyISAM engine and
the user must exist on detination server.

You can use shell comands to do this. It's recomended first stop mysql
service, then copy database folder, set new database folder to the user and
group mysql:mysql access, start mysql service and create the same mysql user
and grant access to new database.

I use something like this (but not the same you want) to update database
versions (add new tables and updates views kepping data) of an in
producction applications.

I can publish this app but is written in spanish :-(

Regards,
Ricardo Díaz

2010/2/26 Robert JUHASZ <robert1juhasz at ...626...>

> Hello List,
>
> I am creating an application working with some databases.
> I have no problem to create the empty database from code, but now I wish to
> have a pre-filled database which creates itself when I install the
> application or what I can create during the first run.
>
> Is there an easy way to attach a database to the project (I suppose yes, by
> adding to the data) and copy this database to the selected server? I work
> with mysql.
>
> Thanks if you can give me any idea or a bit a example code.
>
> Regards,
> Robi
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>