Transfering Data from one MySQL db to another

From: Sims (siminfrance_at_hotmail.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 16:07:49 +0100

Hi,

We have 2 websites on 2 separate servers.
The databases are also separated, (the servers are not even in the same
countries).

We use one website for design and once we are happy we copy some of the data
across to the server.

But because we do that fairly often we would like have control panel that
would allow us to do the above work.

What script would you run to say something like, "copy db1.TABLEA =>
db2.TABLEB". Given that the passwords are not the same on both databases?

Both tables are the same, (apart from the name of the table itself).

What would be the best way to achieve the above so that I can include it in
a pretty form?

Sims

Relevant Pages

  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SAN (NetApp SnapMirror) replicated Exchange databases usability
    ... to stage Exchange 2007 servers at siteB with SG's and databases that are ... This is achieved by having Exchange ...
    (microsoft.public.exchange.design)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... that be the case then I would still work to consolidate the databases ...
    (comp.databases.oracle.server)
  • Re: contact forms not working
    ... though you may need additional help tailoring the form handler to work with GoDaddy's servers. ... Use a different method for processing forms - php, asp, asp.NET ... i can not get the contact forms to submit on any of my websites. ... Frontpage extensions are installed and must be working, as my main site works fine. ...
    (microsoft.public.frontpage.client)