Yes, InnoDB is the default storage engine for MySQL as of MySQL 5.5.MyISAM
and InnoDB has its own features.
InnoDB probably the best RDBMS out there. InnoDB is default engine might be
due nowadays most of the application required fully ACID-compliant modes,
self recovery from a crash, and many
2011/05/25 10:53 +0200, Reindl Harald
if there is no good reason i will never enable innodb because
MyISAM is enough for most web-apps
And also MyISAM supports auto-increment in a lesser part of a primary key and
InnoDB not--but although it is of interest, I have not tryed it.
Am 25.05.2011 10:35, schrieb Brent Clark:
> Hiya
>
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
> default storage engine.
>
> The question I would like to ask is. For those still running Mysql 5.0 / 5.1.
> Have any of you set the mysql def
On 2011-05-25 10:35:45 Brent Clark wrote:
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
> default storage engine.
>
> The question I would like to ask is. For those still running Mysql 5.0 /
> 5.1. Have any of you set the mysql default variable to be / u
Hiya
I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
default storage engine.
The question I would like to ask is. For those still running Mysql 5.0 /
5.1. Have any of you set the mysql default variable to be / use Innodb?
Regards
Brent Clark
--
MySQL General Mailing
e
its default storage engine is InnoDB. but it will not change any existing
table storage engine to Innodb.
To do this there is two way.
a. You can change storage engine by alter command of tables, but one by one.
eg. *Alter table [tablename] engine=myisam; *
b. export the database , an then re
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 c
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
s the default storage engine so it should not be specified.
Cheers
Claudio Nanni
2009/1/14 Walter Heck
> You can only copy files liek that for MyISAM tables. Are you sure you
> didn't
> accidentally convert to INNODB somewhere along the line? If so, go back to
> your old insta
ad because WAMPSERVER defaults
> to INNODB and ALL my work is MYISAM so after I figured out that I just
> need to change the default storage engine, everything worked as
> expected, copy the files, fire it up and it works. THIS TIME, I have a
> real problem because the default storage en
he default storage engine, everything worked as
expected, copy the files, fire it up and it works. THIS TIME, I have a
real problem because the default storage engine has disappeared from
the my.ini file and if I put it in MySQL does not even start anymore.
Not only that, when I copy the database
Try just 'storage-engine'
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2007 5:26:40 AM (GMT-0500) America/New_York
Subject: default-storage-engine not working?
Hi, we have just upgraded from mysql 4.1
Hi, we have just upgraded from mysql 4.1 to 5.0 and this far I only have one
problem. I can't get default-storage-engine to work.
I have "default-storage-engine = INNODB" under my [mysqld] in my.cnf which is
loaded by the daemon (tested with password=xxx). I have also tried
def
13 matches
Mail list logo
