I am using mysqlhotcopy from within a cron job to make a backup copy of my database each night. Once I have run mysqlhotcopy and made the backup directory in my /usr/local/mysql/data directory, I'm able to do select statements on the data in the backups, but the mysqlshow command does not show any tables like it would on the regular database. I get the following: bash> mysqlshow -pXXXXXX ontario_bkup_may29 Wildcard: ontario_bkup_may29 +--------------------+ | Databases | +--------------------+ | ontario_bkup_may29 | +--------------------+ Normally, I would get this: # mysqlshow -pXXXXXX ontario Database: ontario +---------------------+ | Tables | +---------------------+ | account | | account_deleted | | bank | | basicwebsite | | billing | | circuit | etc. (many more tables.) Any ideas as to why this happens? Is there something wrong? Griff Hamlin, III Quik International. --------------------------------------------------------------------- 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
