Forum Replies Created
-
AuthorPosts
-
lsemel
MemberYou are correct, I checked, and in fact the version is: 4.1.14
I have 4.1.14 as the source, and am trying to apply changes to a 5.0.45 database so it matches with 4.1.14.
Here is the SHOW CREATE TABLE output:
[codebox]
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 636
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show create table t;
+
+
+| Table | Create Table |
+
+
+| aaafelix | CREATE TABLE `t` (
`id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+
+
+Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 396549 to server version: 4.1.14-standard-log
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show create table t;
+
+
+| Table | Create Table |
+
+
+| aaafelix | CREATE TABLE `t` (
`id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+
+
+1 row in set (0.00 sec)[/codebox]
You should also know that the MySQL 5 database is running on Windows, and the MySQL 4 database is running on Linux. I'm connecting to the MySQL 4 database over an SSH tunnel, if that matters.
The generated sql is:
/* Alter table in First database */
alter table `first`.`t`
change `id` `id` int(11) COLLATE NULL NULL first, COMMENT='';
I had copied the generated SQL in an editor and removed COLLATE NULL, and it ran.
Any ideas about the second problem, regarding the order of columns? When running a sync on tables with more than one column, it often insists that the column positions have changed, no matter how often I sync it.
-
AuthorPosts
