Re: [libreoffice-users] Base - embedded DB backup and restore

Hi

On Thu, 2011-08-18 at 07:28 -0700, ncreamer wrote: 

> I'm working through the Base_Tutorial to create a small, single-user
> database.  The guide teaches me to create my tables using SQL.  The commands
> have me "drop table" as I make changes and warns that all data will be lost
> - fair enough.  Once I reach a stage where I'm comfortable with the
> structure/queries/etc. I'll begin to enter data.  

In SQL there is an INSERT [INTO] and INTO commands that can be used in
data to tables. JOIN can be used to select data from two or more tables.
CREATE TABLE will create a new table with the columns and data types
assigned. ALTER TABLE with ADD/DROP will allow you to add or deleter a
column. 

> But what happens if I need to make a change after that? Like add a field or
> even new tables?  How can I back up all the table data and restore it after
> making changes. I see that I can copy the table data to calc but when I
> follow steps back to copy the data back to base, a new table is created as
> far as I can tell.  Is there a way for me to backup and restore data for
> this purpose?

Backing up tables can be done by copying them into another table,
normally what is done when working in a database is to create working
tables from the main tables. The working tables can be deleted when you
are done with them. The only time you would actually work with the main
tables is when you are entering/deleting data.

The basic command you would use to copy data into another table is

SELECT (specify the columns or use * for all columns)
INTO Temporary_Table
FROM Original_Table
WHERE selection criteria (optional - if omitted the entire table is
copied)

I think you are asking about backing up the database, Base creates a
file with all the database objects in it and this file can be backed up
or exported to another location. 

> --
> View this message in context: 
> http://nabble.documentfoundation.org/Base-embedded-DB-backup-and-restore-tp3265050p3265050.html
> Sent from the Users mailing list archive at Nabble.com.



-- 
Jay Lozier
jslozier@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted