Hi,
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?
TIA!