Nevermind. I see that the manual online has this information. Sigh. It
doesn't do what I want unfortunately.
Best,
Kyle
On Monday 29 January 2001 09:32, Kyle Hayes wrote:
> The manual section on BACKUP does not state what locking behavior the
> command has. Does it lock all the tables at once that you backup in one
> statement or does it lock them one at a time?
>
> I.e. if I run:
>
> BACKUP foo.bar, foo.baz, foo.blah TO '/tmp/mysqlbackups/'
>
> Will it lock all three tables and then dump them? I need this kind of
> behavior. If it locks them one at a time and dumps them one at a time then
> I'll have to use something else.
>
> Additionally, can you RESTORE a backed-up table to a different database.
> I.e. suppose I did the BACKUP line above, can I do this:
>
> RESTORE foo_backup.bar, foo_backup.baz, foo_backup.blah FROM
> '/tmp/mysqlbackups/'
>
> ???
>
> Best,
> Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.quicknet.net
USA
********************************************************************
"HEAR THE DIFFERENCE" with a live MICROTELCO demo at:
INTERNET TELEPHONY EXPO, Feb 7-9, Miami, FL
MicroTelco is a revolutionary service that brings multiple Internet
Telephony Service Providers (ITSPs) together in a convenient,
simple to use account center for greater reliability and flexibility.
For more information visit: http://www.microtelco.com.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
