Forum Replies Created
-
AuthorPosts
-
terryriley
MemberIn 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
MemberYes, 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
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
-
AuthorPosts
