[aspage]

CalEvans wrote on May 14 2004, 02:02 PM:

mysqldump does not have to be run on the same machine as the server. (check out the –host=name option)

I routinely use it to backup all of my server from a central location. These servers are spread out throughout the Southeast US. Since none of them are available via the Interment directly, I use ssh to create tunnels into machines that can see them. Then mysqldump all of the databases into a file named for the date and server.

Once a week, a script runs that deletes anything that is more than X days old. (I think it's 2 weeks, not sure anymore)

Unless I am misunderstanding your needs, it is entirely possible to simply use mysqldump to do what you are needing to do.

=C=

hahaha, thank you Cal!! It does work. I'm sorry about the misunderstanding. Thank you very much for you patience and explanation. It works perfectly here 😉

Aspage

[aspage]

Yes, but the MySQL server is not on the same server as MYSQLYOG. MYSQLserver is online on the internet and MYSQLYOG is on the internal network.

I can access the MYSQL-server from the internal network (over the internet), but I cannot reach the internal network, from the MYSQL-server. Do you understand what I mean ?

[aspage]

CalEvans wrote on May 13 2004, 09:09 PM:

mysqldump won't do the trick?

=C=

No, because mysqldump has to be done on the server, which contains the source databases. The target server is unknown on the internet, because it is on the internal network of the company.

With MYSQLYOG I can synchronize on any PC on the internal network and still access the internet database-server.

I hope you all understand my above statements………..

[Author]

Posts