Re: [OT] Frontbase Export/Dump

Subject: Re: [OT] Frontbase Export/Dump
From: Mike Schrag <email@hidden>
Date: Mon, 12 May 2008 06:44:13 -0400

5.5.5 Export Into Flat-Files
FrontBase can export an entire database, schema definitions and contents, into flat files in ASCII format
from which a database can later be rebuilt.
Two purposes of the flat-file export/import functionality are:
1. Backup and Restore of a database in ASCII form.
2. Porting of a database between platforms of different "endian" type (big-endian/little-endian).
The following SQL 92 statements will respectively export and import a complete database:
WRITE ALL OUTPUT(DIR='<path-to-export-directory>', CONTENT=TRUE);

SCRIPT <path-to-export-directory>/schema.sql;

Actually, this is not quite right, and I hate that FrontBase doesn't say this prominently ... you ACTUALLY want:

write all output(dir='/path/to/export/dir', type = 'FrontBase', content=true);

without type='FrontBase', you end up losing precision on your timestamp columns, which can really suck.

The other notable point here (which I've always thought was pretty silly) is that whatever path you use for export has to match the path you use for import. Meaning, if you exported into /tmp/MyDatabase and you're importing on another machine, you need to put the files in /tmp/MyDatabase on the other machine. They actually write the path name of the export into the files.

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References:
	>[OT] Frontbase Export/Dump (From: Joshua Paul <email@hidden>)
	>Re: [OT] Frontbase Export/Dump (From: David Holt <email@hidden>)

Prev by Date: Re: [OT] Frontbase Export/Dump
Next by Date: Re: [OT] Frontbase Export/Dump
Previous by thread: Re: [OT] Frontbase Export/Dump
Next by thread: Re: [OT] Frontbase Export/Dump
Index(es):
- Date
- Thread