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

[Bob G. <bo...@rc...>]

As long as she understands that it is just a training system at home and
the information she keys into her home system will NOT be imported back
into the office system (this is where the problems can occur..), just
set up the home system with a copy of the office system.

The temptation will be to 'save some keystrokes' and attempt to import
the newly keyed data in the home system back into the live office
system.

Good Luck

Bob G

On Tue, 2008-01-29 at 15:50 -0600, Adam Vandemore wrote:
> Another option which we do is create a new dataset in the existing SL 
> installation, then restore a current backup to the new dataset and then 
> have your new user use the test dataset.  Easy to update and restore if 
> there's a screwup and you've avoided running multiple installations of SL.
> > 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 happen..
> >>
> >> 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 $B2P(B, 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 -=- slu .at. ccsr.uchicago.edu
> >>>> University of Chicago -=- CCSR
> >>>> $B:MJ8$HCRF`H~$NIc(B -=-    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
> >
> >   
> 
>