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
