Offline version for airplane travel

[John Mussell]

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?

[Patrick Decat]

On Android, you can sync the Shuffle GTD app with Tracks.

Regards,
Patrick.

Post by John Mussell
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
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

[Nate Plamondon]

Shuffle hasn't worked reliably with tracks since 1.6. I would love to use
Shuffle, but it doesn't sync properly, and can lead to lost data.

--
Nate Plamondon
Sent from a tiny on-screen keyboard

Post by Patrick Decat
On Android, you can sync the Shuffle GTD app with Tracks.
Regards,
Patrick.

Post by John Mussell
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
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

_______________________________________________
Tracks-discuss mailing list
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

[Patrick Decat]

I'm a bit surprised as I've been using Shuffle 1.6 then 2.0 with Tracks for
a long time without issues.

Post by Nate Plamondon
Shuffle hasn't worked reliably with tracks since 1.6. I would love to use
Shuffle, but it doesn't sync properly, and can lead to lost data.
--
Nate Plamondon
Sent from a tiny on-screen keyboard

Post by Patrick Decat
On Android, you can sync the Shuffle GTD app with Tracks.
Regards,
Patrick.

Post by John Mussell
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
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

_______________________________________________
Tracks-discuss mailing list
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

[Nate Plamondon]

I'd like to be wrong about this... What version of Tracks are you running?
https://code.google.com/p/android-shuffle/issues/detail?id=238
https://code.google.com/p/android-shuffle/issues/detail?id=134
https://code.google.com/p/android-shuffle/issues/detail?id=194

--
Nate Plamondon

Post by Patrick Decat
I'm a bit surprised as I've been using Shuffle 1.6 then 2.0 with Tracks
for a long time without issues.
Shuffle hasn't worked reliably with tracks since 1.6. I would love to use

Post by Nate Plamondon
Shuffle, but it doesn't sync properly, and can lead to lost data.
--
Nate Plamondon
Sent from a tiny on-screen keyboard

Post by Patrick Decat
On Android, you can sync the Shuffle GTD app with Tracks.
Regards,
Patrick.

Post by John Mussell
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
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

_______________________________________________
Tracks-discuss mailing list
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

[Patrick Decat]

Nowadays, I'm running Tracks 2.1, but version 1.7.2 was the first one I
installed.

Patrick.

Post by Nate Plamondon
I'd like to be wrong about this... What version of Tracks are you running?
https://code.google.com/p/android-shuffle/issues/detail?id=238
https://code.google.com/p/android-shuffle/issues/detail?id=134
https://code.google.com/p/android-shuffle/issues/detail?id=194
--
Nate Plamondon

Post by Patrick Decat
I'm a bit surprised as I've been using Shuffle 1.6 then 2.0 with Tracks
for a long time without issues.
Shuffle hasn't worked reliably with tracks since 1.6. I would love to use

Post by Nate Plamondon
Shuffle, but it doesn't sync properly, and can lead to lost data.
--
Nate Plamondon
Sent from a tiny on-screen keyboard

Post by Patrick Decat
On Android, you can sync the Shuffle GTD app with Tracks.
Regards,
Patrick.

Post by John Mussell
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
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

_______________________________________________
Tracks-discuss mailing list
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

[John Mussell]

Unfortunately I have an iPhone and I was really hoping to work in my
laptop.

Sent from my Windows Phone
------------------------------
From: Patrick Decat
Sent: 5/24/2012 11:18 AM
To: Nate Plamondon
Cc: John Mussell; tracks-discuss-g9ZBwUv/***@public.gmane.org
Subject: Re: [Tracks-discuss] Re: Offline version for airplane travel

I'm a bit surprised as I've been using Shuffle 1.6 then 2.0 with Tracks for
a long time without issues.

Post by Nate Plamondon
Shuffle hasn't worked reliably with tracks since 1.6. I would love to use
Shuffle, but it doesn't sync properly, and can lead to lost data.
--
Nate Plamondon
Sent from a tiny on-screen keyboard

Post by Patrick Decat
On Android, you can sync the Shuffle GTD app with Tracks.
Regards,
Patrick.

Post by John Mussell
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
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

_______________________________________________
Tracks-discuss mailing list
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

[Reinier Balt]

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-bounces-g9ZBwUv/***@public.gmane.org
[mailto:tracks-discuss-bounces-g9ZBwUv/***@public.gmane.org] Namens John Mussell
Verzonden: donderdag 24 mei 2012 16:06
Aan: tracks-discuss-g9ZBwUv/***@public.gmane.org
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?

[John Mussell]

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-g9ZBwUv/***@public.gmane.org
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-bounces-g9ZBwUv/***@public.gmane.org [mailto:
tracks-discuss-bounces-g9ZBwUv/***@public.gmane.org] *Namens *John Mussell
*Verzonden:* donderdag 24 mei 2012 16:06
*Aan:* tracks-discuss-g9ZBwUv/***@public.gmane.org
*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?

[Tim Madden]

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...

Post by John Mussell
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
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
Mussell
*Verzonden:* donderdag 24 mei 2012 16:06
*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
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss

[Reinier Balt]

I agree that sqlite is much better for data portability.



Reinier



Van: tracks-discuss-bounces-g9ZBwUv/***@public.gmane.org
[mailto:tracks-discuss-bounces-g9ZBwUv/***@public.gmane.org] Namens Tim Madden
Verzonden: donderdag 24 mei 2012 20:19
Aan: tracks-discuss-g9ZBwUv/***@public.gmane.org
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; tracks-discuss-g9ZBwUv/***@public.gmane.org
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-bounces-g9ZBwUv/***@public.gmane.org
[mailto:tracks-discuss-bounces-g9ZBwUv/***@public.gmane.org] Namens John Mussell
Verzonden: donderdag 24 mei 2012 16:06
Aan: tracks-discuss-g9ZBwUv/***@public.gmane.org
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?