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 <[email protected]> > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
