thanks for your response Dan, No meant, ideally would like to write each SQL transaction for CREATE, UPDATE, DELETE across to the backup database at the time of transaction, but because of way the code is written this is not achievable easily.
But, can still replicate the task through a CRON job each night midnight... hope this answers your question? On Tue, Aug 17, 2010 at 8:37 AM, Dan Khan <[email protected]> wrote: > 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] -- Kind Regards, Brendan Brink SMS Marketing Consultant | Manager Sell2Cell Ltd. 021 0246 1646 | [email protected] | www.sell2cell.co.nz We provide customized, cost-effective SMS & Web Solutions Need a website? Need to integrate text-messaging into your business or website? Contact us today for a free no-obligation quote! VISIT OUR ASSOCIATED WEBSITES: textvouchers.com | textguru.co.nz WARNING This email contains information which is CONFIDENTIAL and may be subject to LEGAL PRIVILEGE. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy the email or attachments. If you have received this in error, please notify us immediately by return email, facsimile, or telephone (call us collect). -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
