Professional Web Applications Themes

change storage engine - MySQL

Hello all, I need to change the storage engine of an existing table from MyIsam to InnoDB. Can I do this by one alter tabel statement (if yes how?) or is the best aproach create a backup, drop the table re-create the table but then with the InnoDB type and then insert the backup? Thanks for your help Nick...

  1. #1

    Default change storage engine

    Hello all,

    I need to change the storage engine of an existing table from MyIsam to
    InnoDB. Can I do this by one alter tabel statement (if yes how?) or is the
    best aproach create a backup, drop the table re-create the table but then
    with the InnoDB type and then insert the backup?

    Thanks for your help

    Nick


    somebody Guest

  2. #2

    Default Re: change storage engine

    >I need to change the storage engine of an existing table from MyIsam to
    >InnoDB. Can I do this by one alter tabel statement (if yes how?) or is the
    >best aproach create a backup, drop the table re-create the table but then
    >with the InnoDB type and then insert the backup?
    ALTER TABLE foo ENGINE=InnoDB;

    This works for MySQL 5. I believe some earlier versions used
    Type= instead of ENGINE= .

    Gordon L. Burditt
    Gordon Burditt Guest

  3. #3

    Default Re: change storage engine

    Gordon Burditt wrote:
    >> I need to change the storage engine of an existing table from MyIsam
    >> to InnoDB. Can I do this by one alter tabel statement (if yes how?)
    >> or is the best aproach create a backup, drop the table re-create
    >> the table but then with the InnoDB type and then insert the backup?
    >
    > ALTER TABLE foo ENGINE=InnoDB;
    >
    > This works for MySQL 5. I believe some earlier versions used
    > Type= instead of ENGINE= .
    Yup, ALTER TABLE `table_name` TYPE = innodb
    --
    Rik Wasmus


    Rik Guest

  4. #4

    Default Re: change storage engine

    thanks all

    "Rik" <luiheidsgoeroehotmail.com> schreef in bericht
    news:e3tsg7$sci$1netlx020.civ.utwente.nl...
    > Gordon Burditt wrote:
    >>> I need to change the storage engine of an existing table from MyIsam
    >>> to InnoDB. Can I do this by one alter tabel statement (if yes how?)
    >>> or is the best aproach create a backup, drop the table re-create
    >>> the table but then with the InnoDB type and then insert the backup?
    >>
    >> ALTER TABLE foo ENGINE=InnoDB;
    >>
    >> This works for MySQL 5. I believe some earlier versions used
    >> Type= instead of ENGINE= .
    >
    > Yup, ALTER TABLE `table_name` TYPE = innodb
    > --
    > Rik Wasmus
    >
    >

    Rob Guest

Similar Threads

  1. How do I change Internet search engine???(Acrobat 7.01 Professional)
    By Jon_Bessant@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: May 1st, 09:12 PM
  2. OT: Portable Storage
    By Paul G Elson in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 0
    Last Post: April 9th, 04:18 PM
  3. Using XML data storage
    By John Smith in forum ASP Database
    Replies: 1
    Last Post: December 15th, 04:07 PM
  4. Not enough storage available to PCKCACHE??
    By Stuart H in forum IBM DB2
    Replies: 1
    Last Post: September 16th, 05:51 AM
  5. XP Pro Net thru VPN - Not enough server storage...
    By Rush in forum Windows Networking
    Replies: 3
    Last Post: July 3rd, 05:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139