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" <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [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]
