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]

Reply via email to