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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
_______________________________________________
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
_______________________________________________
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
