Hello.
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. Jim Seymour wrote: > My bad. I was renaming some columns in a table. I incorrectly set the > type to decimal(4,2) and the data was truncated/hosed. Is there a way to > recover the data. I tried a system backup from yesterday. That changed > nothing. I have already set the column type back to the correct > settings. I am running MySQL v5.0.13 on a Debian Etch(Testing) box. > > TIA, > > Jim Seymour > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]