Re: Frontbase restore
Re: Frontbase restore
- Subject: Re: Frontbase restore
- From: Stamenkovic Florijan <email@hidden>
- Date: Thu, 12 Feb 2009 23:06:41 -0400
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:
email@hidden
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