mySQL & RR question

[Stephen Barncard]

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
- - -  - - - - - - - - -