distal-attribute
distal-attribute
distal-attribute
distal-attribute

some tables do not copy?

User, date Message
Written by ds
7 years ago
Category: General
4 posts since Sat, 13 Oct 07
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...
Written by ansgar
7 years ago
5015 posts since Fri, 07 Apr 06
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.
Written by ds
7 years ago
4 posts since Sat, 13 Oct 07
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.
Written by ds
7 years ago
4 posts since Sat, 13 Oct 07
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
Written by ansgar
7 years ago
5015 posts since Fri, 07 Apr 06
And this table (alphalist) is the table which is not exported or ... ?
Written by ds
7 years ago
4 posts since Sat, 13 Oct 07
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
Written by superspace
7 years ago
22 posts since Mon, 28 Aug 06
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.
 

Please login to leave a reply, or register at first.