|Subject||Re: [firebird-support] Backaup&Restore error|
I´m trying to compact my database, so I´ve run backup (gbak) and restore (gbak) but with errors (Windows XP SP3 + Firebird 2.5.4)
Trying “–FIX_FSS_METADATA” (is this the intended behavior?) gbak ask me for a character set that I don´t know how to pass in.
gbak.exe -c frigo.bak frigo2.gdb -USER SYSDBA -PAS masterkey -FIX_FSS_METADATA
gbak: ERROR:Character set parameter missing
gbak:Exiting before completion due to errors
The -fix_fss_metadata switch needs an argument, which is the character set of any text data that is stored in your metadata, e.g., in CHECK constraints, triggers, stored procedures and such.
If you know that such strings in the metadata are in the same character set as the default character set of the database, then use that character set as the argument. If you do not know the default character set, you can get it from the SHOW DATABASE command in isql, or from any other database tool that provides the header information; or you can query it from any DSQL tool:
SELECT RDB$CHARACTER_SET_NAME FROM RDB$DATABASE
Unfortunately, if the character set name is NONE, the -FIX... switches have no effect. In that case, you will have no choice but to recreate the database manually from a script - including the default character set parameter that is valid for your data! - and to pump the data into the new database.