Skip to Content
Last modified by John Huss on 2010/07/23 14:35
From version 4.1
edited by David Holt
on 2008/05/12 19:07
Change comment: There is no comment for this version
To version 3.1
edited by Pascal Robert
on 2007/09/03 21:23
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.dholt
1 +XWiki.probert
Content
... ... @@ -1,26 +1,5 @@
1 1  FrontBase is now available for free. Please see the FrontBase website [[http://www.frontbase.com]] for details.
2 2  
3 -----
4 -
5 -**Useful SQL commands in FrontBase**
6 -
7 -{{code value="sql"}}
8 -
9 -// writes an ascii backup of your database
10 -write all output(dir='/path/to/export/dir', type = 'FrontBase', content=true);
11 -
12 -// creates a database from the exported files that results from the previous command
13 -SCRIPT <path-to-export-directory>/schema.sql;
14 -
15 -// to rename a table
16 -alter table name Item to ItemArchive;
17 -
18 -{{/code}}
19 -
20 -If you don't use type='FrontBase', you end up losing precision on your timestamp columns, which can really suck.
21 -
22 -----
23 -
24 24  A first experience with FrontBase, WO 5.3.1 and MacOSX 10.4.6
25 25  
26 26  Make sure you have the FrontBase jdbc connector accessible from your WebObjects applications. I placed mine in /Library/Java/Extensions/