forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › FK Management Gone
- This topic is empty.
-
AuthorPosts
-
-
July 30, 2004 at 3:10 pm #16132
Ritesh
MemberCan you cut-n-paste the output of the following SQL:
Code:show table status from `yourdb`for both the MySQL servers?
-
July 30, 2004 at 3:55 pm #16133
terryriley
MemberRitesh – apologies for the formatting – it was easiest to take from the commandline:
mysql> show table status;
+
+
+
+
+
+
+
+
+
+
+
+
-+
+
+
+
+
+—
+| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_le
ngth | Max_data_length | Index_length | Data_free | Auto_increment | Create_time
| Update_time | Check_time | Collation | Checksum | Create_options | Co
mment
|
+
+
+
+
+
+
+
+
+
+
+
+
-+
+
+
+
+
+—
+| appearance | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 49152 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`PlayerID`) REFER `fm1999/player`(`ID`); (`FixtureID`) REF
ER `fm1999/fixture`(`ID`)
|
| committee | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 32768 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| constitution | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 98304 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`DivisionID`) REFER `fm1999/division`(`ID`); (`TeamID`) RE
FER `fm1999/team`(`ID`); (`OrdinalID`) REFER `fm1999/ordinal`(`ID`); (`ThisMatch
NoID`) REFER `fm1999/matchno`(`ID`); (`NextMatchNoID`) REFER `fm1999/matchno`(`I
D`) |
| division | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| fixture | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 163840 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`AsstRef2ID`) REFER `fm1999/referee`(`ID`); (`AwayID`) REF
ER `fm1999/fixture`(`AwayID`); (`RefereeID`) REFER `fm1999/referee`(`ID`); (`Hom
eID`) REFER `fm1999/constitution`(`ID`); (`KORoundID`) REFER `fm1999/koround`(`I
D`); (`AsstRef1ID`) REFER `fm1999/referee`(`ID`) |
| koround | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| matchno | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| matchreport | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`FixtureID`) REFER `fm1999/fixture`(`ID`)
|
| newsitem | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| ordinal | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| player | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| referee | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| register | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 49152 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`TeamID`) REFER `fm1999/team`(`ID`); (`PlayerID`) REFER `f
m1999/player`(`ID`)
|
| sponsor | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| suspension | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 32768 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`PlayerID`) REFER `fm1999/player`(`ID`)
|
| team | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
+
+
+
+
+
+
+
+
+
+
+
+
-+
+
+
+
+
+—
+16 rows in set (0.05 sec)
The data is exactly the same for the other NT server – databases are also identical.
None of them (including newly-added) show in the dialogue.
Terry
-
July 30, 2004 at 3:59 pm #16134Member
Hello,
I think this result returned from 4.1.3. Can you cut and paste the result returned from 4.1.1?
You can use SQLyog to get the same result and it is formatted also 😀
-
July 30, 2004 at 4:18 pm #16135Member
Yes, it is – and as stated earlier, neither of us can go BACK to 4.1.1 – we have both committed to 4.1.3b, and the MySQL on his machine is live!
If I remember correctly, the output was the same (or certainly very similar).
Terry
-
July 30, 2004 at 4:59 pm #16136Member
In fact, Ritesh, 4.1.1 does not seem to be available for download any longer from the MySQL site! It is now almost exclusively 4.1.3b-beta.
Terry
-
July 31, 2004 at 6:06 am #16137Member
Ok.
I think I have a binary of 4.1.1 in my development box. Will work on it over the weekend and let you know 😀
-
August 2, 2004 at 8:42 am #16138Member
I confirm the bug. There has been some changes with the information returned by 4.1.3.
This bug will be fixed in 3.8. If you would like to beta-test 3.8 then send me a mail. I would add you in our beta testers list 😀
-
-
AuthorPosts
- You must be logged in to reply to this topic.
