database to database back up

pleo

hi,

I was wondering if anyone can reccomend a script that exists or can guide me in what exactly i need to do to make a script that will take all the data from my database and transfer it to another database on a different server automatically. Basically it's so that i can back up my database on two servers. If anyone can help me i would really appreciate it. thanks

Jeb_

Your database server should allow you to do a dump of a database to an SQL file. You can then take this SQL file, and run it on the other database server, and you should be okay.

As for the commands you need, you'd have to check the manual for your database server.

pleo

yea, that is what i want to do, but i was wondering if there is a script (or a failry easy way to make one) that will do it for me. I don't want to have to export the sql from one then upload it to another manually each time i need it done - there has to be a more economical way to do this.

pleo

does any one know how to help me out here?

pleo

alright, since no one really seems to be able to help, lemme tell you what i was thinking about, and maybe someone can help me go about coding such a thing. So, i want to extract the data from database A to an .sql file or something. Then have the script connect to database B and execute the .sql file, updating all the data and creating a nice backup for me on a remote server.

Seems pretty straight forward but i'm not sure where to begin. ANY help is greatly appreciated. thanks

Jeb_

Well, all you do is write the script in your favourite language (PHP I'll assume) to send the query for the SQL dump to one server, disconnect from that server, re-connect to the backup server and load the SQL file.

First place the start - find the functions for your database software in PHP (or, whatever your language is you're using).

Sxooter

In Postgresql you can something like this:

pg_dumpall -h source_machine | psql -h dest_machine

and that will backup the source machine to a freshly initialized destination machine. I'm sure MySQL can do the same basic thing...