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]