<div>
Yes the INNODB is the issue. &nbsp;It seems the script, mysqlhotcopy, only supports MYISAM and ARCHIVE tables: <a href="http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html" rel="ugc nofollow">http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html</a><br />
<br />
Why not use mysqldump?<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html</a>
</div>


<div>
I have tried mysqldump with no success. &nbsp;I eventually get an error that the output file has exceeded a certain size (if I remember correctly). &nbsp;I will try it again to verify.<br />
Mean while I am changing those two INNODB tables to MYISAM. &nbsp;Then I will try mysqlhotcopy again.<br />
Also, I almost constantly have data being written to these DB's. &nbsp;MySQLDump reqires me to lock the DB. 
</div>


<div>
the location to where you are saving the file can not be FAT or it will be limited by the 4GB size limit of a FAT partition.<br />
<br />
You can either make the entire Database MYISAM and use mysqlhotcopy. Or you can make the entire DB INNODB or use with yuur existing setup a binary log with the mysqldump:<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html</a><br />
<br />
Alternatively, if you have another server where you have mysql, you can setup replication for a hot backup.
</div>


<div>
It is a perl script and possibly should run on either platform since it likely uses DBD::Mysql or Mysql with DBI to access the databases. Both DBD and DBI are part of the active perl distribution.
</div>


<div>
I would think so. &nbsp;I have Perl installed on my machine. I also have the DBI's for MySQL access.<br />
I've tried every syntax combination I can think of, but no-go.<br />
<br />
I used MySQLDump yesterday to the D:\ drive and it worked this time.<br />
Guess I'll use that even if I have to lock the tables.<br />
<br />
Thank you for your help and comments Arnold. 
</div>


<div>
<div class="content wysiwyg-content">
Mysqlhotcopy syntax error. &nbsp;Maybe I can't do what I am trying to do.<br />
Windows Xp Pro<br />
MySQL 5.0.51a Community nt<br />
Server is on C: drive <br />
Data is on external HD F:<br />
I have a back up hard drive &nbsp;D:<br />
I am trying this from my C:\ drive after I log into MySql by doing this: &nbsp;mysql -u root -p<br />
<br />
mysqlhotcopy -u root -p password mcbts D:/MySqlBackup/MCBTS<br />
( Yes, I am replacing password with the actual password.)<br />
<br />
I just get a syntax error at &quot;line 1&quot;.<br />
I tried putting the commands on different lines before I enter the ; to show the end of the command but it still says syntax error on line 1.<br />
I see all but two of the tables in the MCBTS DB are MYISAM. &nbsp;Two are INNODB.<br />
Could that be the problem?
</div>
</div>


Mysqlhotcopy syntax error.  Maybe I can't do what I am trying to do.
Windows Xp Pro
MySQL 5.0.51a Community nt
Server is on C: drive 
Data is on external HD F:
I have a back up hard drive  D:
I am trying this from my C:\ drive after I log into MySql by doing this:  mysql -u root -p

mysqlhotcopy -u root -p password mcbts D:/MySqlBackup/MCBTS
( Yes, I am replacing password with the actual password.)

I just get a syntax error at "line 1".
I tried putting the commands on different lines before I enter the ; to show the end of the command but it still says syntax error on line 1.
I see all but two of the tables in the MCBTS DB are MYISAM.  Two are INNODB.
Could that be the problem?

MySQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.