Hi Brendan, Does that mean you can't use replication for this task, as this seems like the most sensible solution?
Cheers, -Dan On 17 August 2010 08:30, Brendan Brink <[email protected]> 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] -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
