Re: Frontbase restore
Re: Frontbase restore
- Subject: Re: Frontbase restore
- From: Stamenkovic Florijan <email@hidden>
- Date: Sat, 14 Feb 2009 10:16:06 -0400
Jeff,
You need to enclose the path in single quotes:
WRITE BACKUP TO '/Users/netBrackets/backup';
F
On Feb 13, 2009, at 23:35, Jeff Schmitz wrote:
Looks easy enough, but when I try to write my database to a file
using:
WRITE BACKUP TO /Users/netBrackets/backup ;
But I'm getting this error:
Syntax error 023. Expected <factor> not found.
Any ideas?
Thanks,
Jeff
On Feb 12, 2009, at 9:06 PM, Stamenkovic Florijan wrote:
Jeff,
WRITE DATA;
Should that not be WRITE BACKUP?
or, fully: WRITE BACKUP [TO <path-name-expr>] [ COMPRESSED ];
Also, I am not sure this is the issue, but I think FB by default
restores from the last backup. Maybe somehow that is a backup that
was performed immediately after the drop-recreate?
Just to be sure, you can try backing up to a specific file and the
restoring from that same file. Using the above mentioned command to
perform the backup, and then restoring by doing:
FrontBase -create –restore=<path-name-expr> <database-name>
I've performed both (though I mostly perform the backup from the
Manager GUI, but it should do exactly the same thing) many times
and have not had any problems, nor the weirdness that you describe.
HTH,
F
On Feb 12, 2009, at 20:33, Jeff Schmitz wrote:
Hello,
I'm trying to follow the seemingly very simple Frontbase backup
and restore instructions:
You need to connect to a database as the user _SYSTEM and issue
the following SQL statement:
WRITE DATA;
To restore a database from a backup, you need to do so from a
command
line (logged in as root):
Syntax:
FrontBase -create -restore <database name>
However, when I do a backup, then drop and recreate all the tables
(i.e. make them empty), and then do the restore, none of my data
is actually restored. What am I missing here?
Thanks,
Jeff
_______________________________________________
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
_______________________________________________
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