Announcement

Collapse
No announcement yet.

2 servers 2 database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 2 servers 2 database

    I am using a chat program by eshare technologies located on a different server and using db format.

    Is it possible to, when someone registers or update their profile in VB, to have it simultaneously update the other database?

  • #2
    This is possible but requires quite a lot of code modifications - which you would have to do yourself or hire someone to do it for you.

    Comment


    • #3
      thanks James

      I just posted from my desktop... I guess that would be to include a <form> in register?

      Comment


      • #4
        I was thinking more along the lines of either:

        Make register.php and member.php connect to the other database server as well and update the files

        Make register.php send a 'POST' request to a file on the other server that does the updates.

        Comment


        • #5
          ok

          do you know someone who could implement that for me?

          Comment


          • #6
            I wanted to do the same things with images .. put all images on a rackshack server which cost a lot less for bandwidth. I was told it would be way to hard to do.
            Jason Miller
            http://www.GMPerformanceTuning.com
            http://projecthillside.com
            http://weekendoasis.net
            http://jamz.net

            Comment


            • #7
              What database software is the other server running?

              Comment


              • #8
                database

                Have no idea. the format is db. Look over there

                Comment


                • #9
                  Can't get to that page - I get a popup saying 'access this page from www.haitiwebs.com or an authorized affiliate'.

                  Comment


                  • #10
                    sorry

                    on the next page that loads up, click on "chat" in to links menu.

                    Comment


                    • #11
                      You could try doing what I've done for the forums and main site, which has bespoke news posting/commenting functionality. We use the same username/password and profile (email and icq) on the main site which is grabbed from a database on another server.

                      If you can schedule a cron job to run a script (sync.sh - chmod 774 to execute ./sync.sh) something like mine:

                      Code:
                      mysql -u username -p password database table > dump.sql
                      mysql -u username -p password -h remotehost database < dump.sql

                      check the syntax by doing mysql --help at the prompt and change as required. The idea, which is very inefficient, is to dump the bits you want to disk, then insert them into the remote - which will of cause need permissions setting up. If its local, just insert into the other table.

                      You could of course get a php script which you would run on a cron or manually which could do this a lot better using arrays or another approach.

                      HTH...
                      HP DL-380 G6, 2x E5520, 28GB RAM, 4x300GB SAS, VMWare ESXi
                      -
                      Unreal Tournament : Assault forums - irc://irc.utassault.net:6667 -

                      Comment


                      • #12
                        ... and I was hoping that this post was going to help me in my situation...
                        HP DL-380 G6, 2x E5520, 28GB RAM, 4x300GB SAS, VMWare ESXi
                        -
                        Unreal Tournament : Assault forums - irc://irc.utassault.net:6667 -

                        Comment

                        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                        Working...
                        X