Re: [SL] Moving SQL Ledger from one System to another

[Luke <acc...@li...>]

Why don't you just create a test company for her on the office database =

server?  Let her work with that, like one of the test versions on =

sql-ledger's web site.

 On Tue, 29 Jan 2008, =

lh...@pa... wrote:

> See I already have a secure openvpn tunnel to the office.
> But my problem was letting her "try" things on the "live"
> data. That is why I wanted to bring the data from the office
> to the home. So that way she can play with the system and
> I do not have to worry about anything.
> =

> Now Do I have to do
> =

> create a blank database and restore the data.
> =

> psql -U sql-ledger -c "create database newdb;" template1
> psql -U sql-ledger newdb < backup.sql
> =

> with the backup file on the home system ?
> =

> And does "newdb" have to be the same name as the one from the store ?
> =

> Thanks
> =

> Steven L'Heureux
> =

> > Why not create a secure but remote login?
> > She can then enter anything she wants in the real database.
> >
> > Just remember to backup, preferably also remote (email to different
> > locations is a smart bet).
> >
> > Two databases in two locations sounds like an accident waiting to happe=
n..
> >
> > 2008/1/29, lh...@pa... <lh...@pa...>:
> >>
> >> Basicly it's just so she can learn how to input everything now.
> >> Not just her daily sales. All her expenses, reciepts and such.
> >> So I want to bring an up to date copy of her data home and
> >> import it there so she can do work on it so she does not mess
> >> anything up.
> >>
> >> Steven L'Heureux
> >>
> >>
> >> > On =B2=D0, 2008-01-29 at 09:29 -0500, lh...@pa... wrote:
> >> >> How and what is the prefered method for moving
> >> >> my SQL Ledger Data from my wife's work to her
> >> >> home office?
> >> >>
> >> >> Systems are using Fedora.
> >> >
> >> > One-time thing? If so, do System -> Backup -> Save to file, copy the
> >> > file to the other system, and do restore as explained in the manual.
> >> > That will back up the data base. You should probably tar up and copy
> >> > over the users/ directory.
> >> > --
> >> > Stuart Luppescu -=3D- slu .at. ccsr.uchicago.edu
> >> > University of Chicago -=3D- CCSR
> >> > =BA=CD=CA=B8=A4=C8=C3=D2=C6=E0=C8=FE=A4=CE=C9=E3 -=3D-    Kernel 2.6=
.23-gentoo-r3
> >> > There is no time like the present for postponing
> >> >  what you ought to be doing.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> ----------------------------------------------------------------------=
---
> >> > This SF.net email is sponsored by: Microsoft
> >> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> >> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >> > _______________________________________________
> >> > sql-ledger-users mailing list
> >> > sql...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >> ----------------------------------------------------------------------=
---
> >> This SF.net email is sponsored by: Microsoft
> >> Defy all challenges. Microsoft(R) Visual Studio 2008.
> >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >>
> > -----------------------------------------------------------------------=
--------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > !DSPAM:11,479f77a446224379617435!
> >
> >
> =

> =

> =

> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20