Moving to the right list for some follow up ... > Having been running Firebird for many years without a single problem, I've > just > lost a database! > > Firebird 2.5.1 on Linux > Went to back up the database so I could move it over to another machine to > work > on. I got an error > page 1 is of wrong type (expected 2, found 9) during the backup ( via Flamerobin ) > > Trying to reconnect I got - file not found - and now there is no sign of the > file in the folder! > > The automatic backup had failed as well, so I'm back with an earlier version, > and everything else seems to be running fine on the machine. Several other > websites are fine. > > So 'what the f has happened and why?'
Alexey posted ... I think it's well-known problem with database file at Linux http://www.ib-aid.com/articles/item70 See "Disappeared” files on Linux/Unix/HP-UX/... But this is the first time I've even heard of this and now I need to establish what I did wrong. The database was not 'replaced', it had been created from a backup of the development machine and has been running for a couple of weeks only. Since I have a number of more critical (i.e. Larger) sites running on the same machine what do I need to do to prevent problems. I DON'T restore over an existing file, I will always create a new file and rename the alias so how is a 'replace' created? Also was the problem with the backup a result of the problem, or did it cause it? -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
