You could use the MySQLDump program to write out the values in the tables to text files, the files could be compress or not, then copy the file to on off site location. there is also replication. we have setup with replication on mysql 5.0 then pull the backups from the readonly server. just some ideas.
MB Software Solutions General Account wrote: > I've got a couple clients who have a VFP9 app that uses a MySQL5 > database as the backend in their shop. > > What advice would you give for creating a backup strategy so that the > database is regularly backed up to an offsite location to prevent > catastrophic loss of data due to fire/robbery/etc. ? I had thought of > creating a similar database on the web and adding a column called > "ibackup" to all tables (a number that represents the backup > event...stored in a simple table where the user/datetime is stored and > that resulting record's PK is the iNumber value) and then copying from > the local to the web database, but I don't like that idea as it would > take too long and is not a simple process to create. There's no RI at > the database level and I could change it so that there were no Primary > or Candidate keys, so that option wouldn't be impossible. I just > figured there's gotta be a better way. Perhaps doing a backup > programmatically locally, then FTPing that resulting file to the web? > (...Encrypted, of course.) > > > In my VFP9-backend apps, I had always created a backup database in a > different folder and then did a COPY TO series of commands to create the > 2nd (backup) database, then zipped it with encryption with 7zip and then > FTPed it to the web. > > tia! > --Michael > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
