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
