I have a script to backup a database and email it.
Brendan Brink wrote:
hi there,
Am wanting to automatically create a php script to create a copy of a
database onto a different server.
The script would run each evening at midnight.
Unfortunately, we are not able to simply write each DB transaction to
both databases on the fly.
The database has the following statistics:
127 tables
237,000 rows
30MB in size.
It is a MYSQL5 database.
Does anyone know of a script they have used that can handle this?
Ideally want the database to be backed up to a functional secondary
database, so that we can switch to it if the original server goes
down, and hence the data would be new as at the last midnight.
Looking forward to your advice / information regarding this.
Thanks
Brendan.
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
