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.
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
