I've been working with Trevor's DB library, and it includes
Transcript routines for uploading and download dumps. It's a bit slow
on the data gathering side, however it works well. I think it needs
to be optimized however for faster downloads, but it might be a place
to start. His lib is completely open.
Here's Trevor's site:
http://mangomultimedia.com/developer/revolution/
Incidentally, he's working on some database objects stuff right now
that will knock your socks off.
You also might consider Applescripting CocoaMySQL or Navicat (both
Mac) if they have the stuff.
Navicat has the fastest DB Dump I've seen. And the fastest upload as well.
I don't know about backing up raw DB files on the server that MYSQL
creates. I think that's a no-no, unless it's an image of the whole
server.
sqb
Hi gang,
I have created a few (and still more coming up) client-server
applications using RR and mySQL, but now I am in need for a way to
to create a back-up possibility for remote databases...
The clients are Macs and PC's, the servers running the database
Server can be Windows or Mac
I need to create a dump of the whole database, including all table
descriptions and content.
Anyone any idea what to do, to get a dump of the database on one of
the remote administrator desktops, or on my own development Mac, to
have a local copy of the database?
What I can do of course is use the "DESCRIBE" function and create my
own dump, but is there another way anybody knows of? The content can
run into thousands and thousands of records, so retrieving that and
storing it locally can be a small problem when doing it this way, so
any suggestions are welcome...
Warm regards,
Ton Kuypers
--
stephen barncard
s a n f r a n c i s c o
- - - - - - - - - - - -
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
