From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Tue Jan 18 2005 - 02:28:56 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello.

You can change the default storage engine by using the
--default-storage-engine or --default-table-type server
startup option, or by setting the storage_engine or
table_type system variable.

"Paul Wallace" <paulwisell.com.au> wrote:
> Hi,
> I need to obtain FK data from my DB. I am designing the database
> using DBDesigner. Using the said tool, do I have to export my schema as
> SQL and manually append the table type (TYPE =3D InnoDB) at the end of =
> the
> table definition? For each table?! For those of you who are using
> DBDesigner with MySQL, is it, and if so how is it possible to use the
> Database Synchronisation function so that the resulting tables are of
> type InnoDB? As it is, the tables are created fine, but I can not access
> them to get the FK data, as they are of type MyISAM.
>
> Thanks and regards
>
> Paul.=20
>

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]