Hi! On Dec 04, Reverend Deuce wrote: > > I'm having a time deciphering this stuff. The mediumint and int say they use > 3 bytes and 4 bytes each, respectively, but using that in the table > definition yields invalid numbers. > > Any ideas?
As you still have MYI file, you can simply use myisamchk -dvv to get the table definition. It will be not exactly your table definition, as more than one MySQL data type are mapped to one MyISAM data type (e.g. DATE in MySQL is MEDIUMINT in MyISAM), but you'll get back your data. Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]