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. There are a number of other postings on this subject, but no clear instructions can be found. mysqlhotcopy -u username -p xxxxx --flushlog --allowold name_database /backup/mysql This will backup the dabase with the name name_database, that is working fine. mysqlhotcopy -u username -p xxxxx --flushlog --allowold a* /backup/mysql This will backup all databaes starting with a, works ok mysqlhotcopy -u username -p xxxxx --flushlog --allowold s /backup/mysql This will back up all databases with a s in the name, works ok mysqlhotcopy -u username -p xxxxx --flushlog --allowold * /backup/mysql This is what we want, backup of all databases, but only creates the directory's, doesn't backup the tables, and returns the following error: DBD::mysql::db do failed: File '/usr/local/mysql/var/alternat/nuke_bannerclient.MYD' not found (Errcode: 24) at ../bin/mysqlhotcopy line 434. Not sure what this error 24 is about. rgds Hans Kind --------------------------------------------------------------------- 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
