Subject Re: [firebird-support] Backaup&Restore error
Author Helen Borrie
Re: [firebird-support] Backaup&Restore error Friday, November 27, 2015, 9:01:04 PM, you wrote:

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:


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.