On Sat, 2002-03-23 at 15:19, Hans Kind wrote:
> Hi,
>
> What is the correct syntax to use to backup all databases in the
> /usr/local/mysql/var directory.
>
> We tried a number of different options, but at best we get only 1 database,
> backup completely. Using a wildcard, *, only creates the directory, but
> doesn't copy the tables.
>
[snip]
Hi,
mysqlhotcopy has a regexp argument which makes it backup all databases
matching the regexp. The regexp uses perl regexp syntax, not shell
wildcards:
So:
mysqlhotcopy --regexp='.*'
backs up all databases, whereas:
mysqlhotcopy --regexp='*'
isn't a correct regexp.
regards,
Martin
---------------------------------------------------------------------
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
