Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

mysqlhotcopy works great for me to do the whole DB, but I can't seem to do a single table. I thought this should work

/usr/bin/mysqlhotcopy mydb_cms./^SiteUsers$/ /db0/bkp --user=xxx --password=xxx --allowold --method=cp

When I run that I get:

No tables to hot-copy at /usr/bin/mysqlhotcopy line 396

That is the right DB and table:

mysql> show tables;
| Tables_in_mydb_cms |
| SiteUsers          | 
| UserTemp           | 
2 rows in set (0.00 sec)
mysql> select version();
| version()                    |
| 5.0.45                       | 
1 row in set (0.00 sec)

Any ideas?


share|improve this question

Put quotes around the arguments with special characters such as $.

share|improve this answer
Didn't work, I shouldn't even need the $ but mydb_cms./^SiteUsers/ doesn't work either. – Chris Sep 4 '09 at 12:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.