Dear Martin, I tried that option, but it returns a errono 24:
../bin/mysqlhotcopy -u username -p password --flushlog --allowold --regexp='.*' /d1/terminal-a/mysql/ 'mail' is an empty database 'opt' is an empty database 'oveas' is an empty database DBD::mysql::db do failed: Can't find file: './alternat/nuke_bannerfinish.frm' (errno: 24) at ../bin/mysqlhotcopy line 434. It creates the directories, but doesn't backup any of the tables. In the archives I found similar reports, but it was mentioned the problem was fixed!. Not sure how this errono 24 (Error code 24: Too many open files) relates to this problem. rgds Hans At 09:19 25-3-2002 +0000, you wrote: >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
