some tables do not copy?
| User, date | Message |
|---|---|
|
Written by ds
6 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
6 years ago 3949 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
6 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
6 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
6 years ago 3949 posts since Fri, 07 Apr 06 |
And this table (alphalist) is the table which is not exported or ... ? |
|
Written by ds
6 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
6 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. |