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

[Adam V. <amv...@gm...>]

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


-- 
Adam Vandemore
Systems Administrator
IMED Mobility