Check out the manual section about replication. http://dev.mysql.com/doc/mysql/en/Replication.html
Also read the user comments, sometimes you will find useful code snippets and URLs. PHP or perl would be my language of choice. A PHP solution is mentioned in the user comments of the above URL. olinux --- Business A2Z <[EMAIL PROTECTED]> wrote: > 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!? New and Improved Yahoo! Mail - Send 10MB messages! 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]
