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; tracks-discuss@lists.rousette.org.uk
<mailto:tracks-discuss@lists.rousette.org.uk>
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:*tracks-discuss-boun...@lists.rousette.org.uk
<mailto:tracks-discuss-boun...@lists.rousette.org.uk>
[mailto:tracks-discuss-boun...@lists.rousette.org.uk
<mailto:tracks-discuss-boun...@lists.rousette.org.uk>] *Namens *John
Mussell
*Verzonden:* donderdag 24 mei 2012 16:06
*Aan:* tracks-discuss@lists.rousette.org.uk
<mailto:tracks-discuss@lists.rousette.org.uk>
*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
Tracks-discuss@lists.rousette.org.uk
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
_______________________________________________
Tracks-discuss mailing list
Tracks-discuss@lists.rousette.org.uk
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
