List:General Discussion« Previous MessageNext Message »
From:Malka Cymbalista Date:November 13 2007 10:09am
Subject:mysqlhotcopy
View as plain text  
I am trying to use mysqlhotcopy on 2 different machines and I am having trouble on both of
them.

On the first machine, which is a Sun Solaris running mysql 4.0.15a, when I give the
mysqlhotcopy command, I get the following error:
DBD::mysql::db do failed: File './zemed/form_342.MYD' not found (Errcode: 24) at
/usr/local/mysql/bin/mysqlhotcopy line 449.
The file zemed/form_342.MYD does exist, but it's size is 0.  

On the second machine, which is a linux machine running mysql 5.0.45, when I give the
mysqlhotcopy command, 
mysqlhotcopy  web_positions /tmp/web_positions
I get the error 
Invalid db.table name 'web_positions.web_positions`.`acadsec' at 
/usr/local/mysql/bin/mysqlhotcopy line 855.

If I try to copy the mysql database, I get the error
Invalid db.table name 'mysql.mysql`.`columns_priv' at 
/usr/local/mysql/bin/mysqlhotcopy line 855.

Does anyone have any suggestions as to what I can do to get this to work.  thanks.



-- 

Malka Cymbalista
Webmaster, Weizmann Institute of Science
malki.cymbalista@stripped
08-934-3036

Thread
Transactions and lockingYves Goergen12 Nov
  • Re: Transactions and lockingMartijn Tonies12 Nov
  • Re: Transactions and lockingPerrin Harkins12 Nov
    • Re: Transactions and lockingYves Goergen12 Nov
      • Re: Transactions and lockingPerrin Harkins12 Nov
      • Re: Transactions and lockingYves Goergen12 Nov
        • Re: Transactions and lockingYves Goergen12 Nov
          • Re: Transactions and lockingPerrin Harkins12 Nov
            • Re: Transactions and lockingYves Goergen12 Nov
              • Re: Transactions and lockingPerrin Harkins13 Nov
                • Re: Transactions and lockingYves Goergen13 Nov
                  • mysqlhotcopyMalka Cymbalista13 Nov
                  • Re: Transactions and lockingBaron Schwartz13 Nov
                    • Re: Transactions and lockingmark addison13 Nov
                      • Re: Transactions and lockingYves Goergen13 Nov
                        • Re: Transactions and lockingBaron Schwartz13 Nov
                          • Re: Transactions and lockingYves Goergen13 Nov
                            • Re: Transactions and lockingBaron Schwartz13 Nov
                          • Re: Transactions and lockingPerrin Harkins13 Nov
                            • Re: Transactions and lockingYves Goergen13 Nov
                              • Re: Transactions and lockingBaron Schwartz13 Nov
                                • Re: Transactions and lockingYves Goergen13 Nov
                    • Re: Transactions and lockingYves Goergen13 Nov
                    • Re: Transactions and lockingYves Goergen13 Nov
                      • Re: Transactions and lockingBaron Schwartz13 Nov
                        • Re: Transactions and lockingYves Goergen13 Nov
                        • Re: Transactions and lockingYves Goergen13 Nov
                          • Re: Transactions and lockingPerrin Harkins13 Nov
  • Re: Transactions and lockingMartijn Tonies13 Nov
  • Re: Transactions and lockingMartijn Tonies14 Nov
    • Re: Transactions and lockingYves Goergen15 Nov
  • Re: Transactions and lockingMartijn Tonies15 Nov
Re: Transactions and lockingYves Goergen13 Nov
  • Re: Transactions and lockingPerrin Harkins13 Nov