Hello,
I read the manual(http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html)
and especially:
" Back up tables in the given database that match a regular expression:
shell> mysqlhotcopy db_name./regex/
The regular expression for the table name can be negated by prefixing it
with a tilde (‘~’):
shell> mysqlhotcopy db_name./~regex/
"
I want to backup all my tables except two -'rtt' and 'expirations'.
I use
/usr/local/bin/mysqlhotcopy -p mypass --allowold
mydb./~expirations/~rtt/ /var/backups/mysqlbackup/$1
However for some reason mysqlhotcopy do NOT skip tables 'rtt' and
'expirations'.
Please give me an idea what is wrong. Thanks :-))
Kind regards,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]