mySQL & RR question

[Ton Kuypers]

ok, the mysqldump I know, what I didn't know I could use it across  
the network...
Will give it a try, thanks :-)

Warm regards,

Ton Kuypers
Digital Media Partners bvba
Tel. +32 (0)477 / 739 530
Fax +32 (0)14 / 71 03 04
http://www.dmp-int.com



On 31-aug-06, at 21:03, Ken Ray wrote:

> On 8/31/06 12:34 PM, "Ton Kuypers" <tkuypers at dmp-int.com> wrote:
>
>> 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?
>
> It's really simple - you just need to use shell() to call on the  
> mysqldump
> command line utility. For example, if you want to dump a database  
> called
> "test" to a file at "/Users/ken/test.sql" you'd execut this at the  
> command
> line (assuming a login of "root" and no password):
>
>   mysqldump -u root test > /Users/ken/test.sql
>
> Depending on the size of the database this can take anything from a  
> few
> seconds to several minutes. To give you an idea, I routinely "dump" a
> database with hundreds of thousands of records to a 250MB .sql file  
> and it
> takes about 8 minutes.
>
> If you execute this manually in the console (Terminal in OS X or  
> "DOS box"
> in Windows), you will know that it has completed when you get another
> command line prompt. You can, of course, execute it from Rev with  
> shell(),
> in which case you won't get control back until the dump has finished.
>
> HTH,
>
> Ken Ray
> Sons of Thunder Software
> Web site: http://www.sonsothunder.com/
> Email: kray at sonsothunder.com
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>