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]
