MB Software Solutions General Account wrote: > Brian Erickson wrote: >> 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. >> >> > > I'd like to code the MYSQLDUMP into the VFP9 application, so that > backups could be made "on demand" instead of on timer. There are times > where I'd want the data immediately instead of waiting for the timer. > I'll have a look at the MYSQLDUMP syntax on the mysql.com website to see > how easy (hopefully!) it would be for me to write that into my app. > Once I get it working (assuming I do), I'll post the code here for > others to hopefully get something out of it if they're also using MySQL > as the backend.
I've found mysqldump to be very quick, efficient, and reliable, btw. -- pkm ~ http://paulmcnett.com _______________________________________________ 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.
