List:General Discussion« Previous MessageNext Message »
From:Michael Satterwhite Date:October 30 2004 3:07pm
Subject:Re: Converting table type
View as plain text  
On Saturday 30 October 2004 09:35 am, Martijn Tonies wrote:
> Why not simply recreate it with the InnoDB table type?
>
> If there's data in it, rename the old table, recreate the
> table and pump the data.
>
> All done!

Certainly that *COULD* be done, but it shouldn't be necessary (according to 
the documentation). In addition, one of the tables needing this doesn't just 
have data in it ... it has A LOT of data in it. It would not be a small, 
short running job.

Attachment: [application/pgp-signature]
Thread
Converting table typeMichael Satterwhite30 Oct
  • Re: Converting table typeMartijn Tonies30 Oct
    • Re: Converting table typeMichael Satterwhite30 Oct
  • Re: Converting table typeMartijn Tonies30 Oct
  • Re: Converting table typePaul DuBois30 Oct
    • Re: Converting table typeMichael Satterwhite30 Oct
      • Re: Converting table typePaul DuBois30 Oct
  • Re: Converting table typeGleb Paharenko30 Oct
  • Re: Converting table typeMartijn Tonies31 Oct