Thanks for the response well i guess a backup is just copying the DB records from one pace to another and is a solution however I need something more precise, could someone point to a good reference on mapping tables and a good programming language to execute an updating process please Andrew
>-----Original Message----- >From: olinux [mailto:[EMAIL PROTECTED] >Sent: 12 July 2004 08:07 >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Subject: Re: oscommerce online offline replication > > >I think you are looking for a backup solution. > >This script is awesome for automatic >daily/weekly/monthly backups (and compresses them) > >http://members.lycos.co.uk/wipe_out/automysqlbackup/ >http://sourceforge.net/projects/automysqlbackup/ > >To recreate the database from a backup: copy the >backup to the *other* server and do the following >shell> mysqladmin drop db_name >shell> mysqladmin create db_name >shell> mysql db_name < backup-file.sql > >see also: >http://dev.mysql.com/doc/mysql/en/mysqldump.html > >olinux > > >--- Business A2Z <[EMAIL PROTECTED]> wrote: >> Hi All >> >> This may be a longshot or it could just be the place >> where the answer is. I >> have asked something similiar before regarding this >> but never could a clear view >> of the way to proceed. >> >> Anyway, here it is. Simply I have an offline mirror >> of oscommerce what I woould >> like to do is keep the online version updated with >> the offline recordset >> (products) is there a way to do this without >> overwriting the tables? Ideally >> there are other fields from the online version I >> would like to keep updated >> offline in which case there is always an exact copy >> on and offline? >> >> If there is a way to do this I would appreciate any >> clues, links, books, and >> methods and programming techniques to achieve this. >> >> Andrew >> > > > >__________________________________ >Do you Yahoo!? >Yahoo! Mail Address AutoComplete - You start. We finish. >http://promotions.yahoo.com/new_mail > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.718 / Virus Database: 474 - Release Date: 09/07/2004 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
