You need to locate the mySQL config file (helpfully named) my.cnf file. On
linux it is located at /etc/my.cnf
Then under the [mysqld] add the following line as shown below!
*[mysqld]
default-storage_engine = InnoDB*
And don't forget to restart mysql. After this whenever you create a table
its de
On Sun, Apr 18, 2010 at 8:31 PM, Angelina Paul wrote:
> I want to change the mysql default storage engine from MyISAM to InnoDB.
> What are the steps involved .Is it edit my.cnf file and add a line
> default-storage-engine=innodb and restart the mysql server?
If you do not want to change any exi
I want to change the mysql default storage engine from MyISAM to InnoDB.
What are the steps involved .Is it edit my.cnf file and add a line
default-storage-engine=innodb and restart the mysql server? How I can bring
my databases with mixed storage engine down without any data loss. What
steps I ha