|Subject||Re: [firebird-support] Digest Number 9396|
I use only
CREATE TABLE <TN> and DROP TABLE <TN> metadata commands in runtime. I populate the tables and that's all. I don't create domains, not at all.
I use FB 3.0 on a Linux server (I don't maintain that server) .
The database file is very big - 1+ GB in size, my customers append arround 3000 records each day.
To try to fix my domain name problem I do as you suggested : I do the restore of the new database file with the correct structure and datapump the records. I just did that yesterday (I have some 6 million records in a few tables) but this process is very time consuming - around 4 hours of work.
I have one possible explanation : last time I upgraded from FB 2.55 to FB 3.0, I did the process on a Windows machine : backup FB 2.55 and restore FB 3.0 on the machine. I copied , then, the FDB file in Linux (Samba) , didn't performed a normal restore on Linux (because it is very time-consuming and my customer couldn't wait). Maybe something bad happened then with those domain names. Yesterday I did this :
1. Exported the records (in some XML files)
2. Restored an empty database file (full restore - not copy the FDB file)
3. Datapumped the records (from the XML files) .
I will see the result and keep you informed.
Thank you ,