I agree that sqlite is much better for data portability.
Reinier Van: [email protected] [mailto:[email protected]] Namens Tim Madden Verzonden: donderdag 24 mei 2012 20:19 Aan: [email protected] Onderwerp: [Tracks-discuss] Re: Offline version for airplane travel Good idea Reinier. Thinking about it, maybe using an Sqlite database instead of Mysql would be easier. Then you would just have to copy the file back and forth. Maybe even use a sync program like unison ( http://www.cis.upenn.edu/~bcpierce/unison/ <http://www.cis.upenn.edu/%7Ebcpierce/unison/> ). It would only be able to sync on file level, that is it would be able to merge changes inside the database, you'd be able to pull the file over and then bring it back as needed. I use unison between my various laptops and desktops. Goes over your local network. You'd want to make sure that you had the same version of tracks code in both places as you wouldn't want any database schema differences... On 05/24/2012 01:11 PM, John Mussell wrote: That's exactly the answer I was looking for. I was concerned that the database might not like being switched around. Thank you. _____ From: Reinier Balt Sent: 5/24/2012 1:51 PM To: John Mussell; [email protected] Subject: RE: [Tracks-discuss] Offline version for airplane travel If you install tracks locally on your laptop (with a local mysql), you can make a database dump on your server, import it locally and work from it. Reverse this procedure to update your server when you return. Any changes to your server while you are travelling will be lost when you restore the database from your laptop on your server, so this works only for single-user installs Reinier Van: [email protected] [mailto:[email protected]] Namens John Mussell Verzonden: donderdag 24 mei 2012 16:06 Aan: [email protected] Onderwerp: [Tracks-discuss] Offline version for airplane travel Does anyone have any suggestions of how I could take my mysql database version and copy to a local version on my laptop for travel then put it back on my server when I return? Would a simple mysql backup then restore work or is there too many unique things in the database for the server that it is hosted on? _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
_______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
