1 Reply by isa

(5 replies, posted in Discussions)

Hi  Slavok smile
Mmm, I looked at that article about 'backup API' but it doesn't seem to apply in sqlite2, particularly on a web server using php. I think that sqlite_open(for writing) will lock the db file, and then it can be copied and downloaded from the server.

One problem is the different URL - perhaps I can update the necessary tables with the new URL ...
I 'll have to write a script ...  hmm  ... I'll try to get round to it, it will make it a LOT easier ... still thinking.

Go to forum: Discussions

2 Reply by isa

(5 replies, posted in Discussions)

Hi Slavok smile
Well, they're running on 2 servers with 2 separate db's ... I was wondering if there was anyway to add the users/topics to each other without running sqlite manually every time.

I suppose that I have to choose a default server and run the other as a backup. However, I still have the problem of updating the backup server db regularly, and to start with they are 2 different url's which means I can't just simply 'replace one with the other'.
Perhaps I've partially answered the question myself  wink

Go to forum: Discussions

3 Topic by isa

(5 replies, posted in Discussions)

Hi smile
I've recently started using punbb/fluxbb forum software. I'm very impressed with it's relative simplicity and speed.

I'm trying to run 2 forums in tandem on different hosts, trying to maintain a 24 hour uptime ( if one is down etc.)

Would there be any way to merge the 2 databases together without 'breaking anything'? In this way, the forums would appear as one ...

I'm using sqlite2 ... has anybody been merging db's in this way before?
ie. any mods or plugins, perhaps?

Thanks...

Go to forum: Discussions