Gleb, > I don't think that it is possible to recover the data from the new > table, because ALTER operation creates a new table and fills it with > data (and truncates the data). But why did the system backup not help > you? Could you describe the situation more in detail. If you haven't > flushed you binary logs, you may want to make an attempt to recover the > data from them.
As a sidenote - shouldn't MySQL raise an error when data gets truncated? If the truncation happens silently, chances are you'll never find out until someone does a report or whatever?! With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]