|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
March 24th, 2006, 04:29 AM
|
|||
|
|||
Replace database without restarting service
I need to replace the existing database every 2 hours with fresh database from the other server.
If I try with with "gfix -shut -force 0", deleting old .fdb file and setting up the new database (localy restored backup) with the old name, it has no effect - if I connect after this I get old data (from cache?). Only if I restart service over "/etc/rc.d/init.d/firebird restart" I get new data. The problem is that I cannot restart service every 2 hours because of other active database-client connections. Is there any other solution for shutting down database and replacing it without restarting service. I also wanted to install new separated firebird service (on port 3051) for this database but I don't find any documentation or examples for doing this.
|
|
#3
March 27th, 2006, 11:58 AM
|
||||
|
||||
|
Probably a stupid question, but ...
Do you also put it back online with Code:
gfix -online
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Replace database without restarting service |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
