« previous next »
Pages: [1]

Author Topic: Forwarding data to other server  (Read 317 times)

0 Members and 1 Guest are viewing this topic.

Offline JakeD2Topic starter

  • Irregular
  • Posts: 2
    • View Profile
Forwarding data to other server
« on: February 24, 2010, 02:59:23 PM »
Hello.

Is it possible to create a PHP script that would forward everything from one MySQL database to another database (in another host)?

I mean when I already have my website running in x host, I'd want to create a script that would every day automatically forward data to y host or upload SQL dump file to y host.

I'm only interested in doing that with 1 simple table that is built fairly simple. It consists of daily error reports.

Any hints or examples of how to build this kind of script are appreciated!

Thank you.  ;)

Logged

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,443
  • Gender: Male
    • View Profile
Re: Forwarding data to other server
« Reply #1 on: February 24, 2010, 03:42:23 PM »
Why not just copy over the log? Or use replication?
Logged
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

Offline JakeD2Topic starter

  • Irregular
  • Posts: 2
    • View Profile
Re: Forwarding data to other server
« Reply #2 on: February 25, 2010, 01:51:25 PM »
Great! Thank you. ;)

Replication method worked perfectly. Can close this thread.
Logged
Pages: [1]
« previous next »