some tables do not copy?

I am attempting to transfer a database. When I exported tables (25) from my website to my local machine - three tables did not copy. So I recreated them and then transferred the data via HeidiSQL. And then when I attempted to export these tables to my client's site, sure enough, these same three tables did not transfer over. What could be the reason? Am new to Heidi and MySQL...

HeidiSQL version? (3.1 RC1 is the brandnew and latest, see http://dev.heidisql.com/)

And please post the CREATE TABLE statements of these 3 tables so we can find out what could be the cause. You get these statements (using HS 3.1 RC1!) by right clicking a table > Alter table.

thanks for following up so quickly..

I am on HeidiSQL 3.0 Revision 572.

Will look into how to upgrade.

When I run the export sequence, I can see the SQL zipping by through the SQL log window - so that part seems to be operational.

This is the SQL from the SQL log as I tried to run another export table:

USE `web`
CREATE TABLE `alphalist` ( `AlphaID` char(1) NOT NULL, `Alpha_Lower` char(1) NOT NULL, PRIMARY KEY (`AlphaID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
ALTER TABLE `web`.`alphalist` DISABLE KEYS
LOCK TABLES `web`.`alphalist` WRITE
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('A','a')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('B','b')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('C','c')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('D','d')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('E','e')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('F','f')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('G','g')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('H','h')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('I','i')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('J','j')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('K','k')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('L','l')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('M','m')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('N','n')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('O','o')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('P','p')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('Q','q')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('R','r')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('S','s')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('T','t')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('U','u')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('V','v')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('W','w')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('X','x')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('Y','y')
INSERT INTO `web`.`alphalist` (`AlphaID`, `Alpha_Lower`) VALUES ('Z','z')
UNLOCK TABLES
ALTER TABLE `web`.`alphalist` ENABLE KEYS

And this table (alphalist) is the table which is not exported or ... ?

yes this is the table that did not get exported - this was the SQL I pulled from the log. Odd is it not? I refreshed the views etc. to confirm that I could not see the table.

I ultimately recreated the table and then did an export with only the data insert checkbox checked and the data filled up promptly.

Am trying to think if there is some value/property within the table that might prevent it and the set of others from being copied over?

-ds

I have a feeling it may be related to this:

https://sourceforge.net/tracker/index.php?func=detail&aid=1733155&group_id=164593&atid=832347

Where charset is not compatible with Mysql versions prior to 4.1.

Is your mysql server < 4.1 by any chance?

If so, its supposed to be fixed in the newest version.