icon Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog! | Welcome! Please register to access all of our features.

» Surpass Web Hosting Forums » Discussions » PHP, MySQL » MyISAM to InnoDB

PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >>

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
Old October 23rd, 2009, 5:40 PM   #1 (permalink)
A little special...
Comfy Contributor
 
jelew1985's Avatar
 
Joined in Apr 2009
Lives in Omaha, NE
Hosted on Pass84
284 posts
Gave thanks: 14
Thanked 9 times
Send a message via AIM to jelew1985 Send a message via Yahoo to jelew1985
MyISAM to InnoDB

How can I change the default storage engine from MyISAM to InnoDB?

I only ask because it would be easier than having to go back and change it from MyISAM to InnoDB.

Thanks!!!
__________________
Jeffrey L. - MYAdvantage - Facebook - Twitter - Make the most out of your life :-)
jelew1985 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old November 4th, 2009, 2:21 PM   #2 (permalink)
Surpass Developer
Excelling Contributor
 
Mark's Avatar
 
Joined in Jan 2004
Lives in Florida
Hosted on core.surpasshosting.com
731 posts
Gave thanks: 32
Thanked 96 times
The default storage engine is specified on a server wide basis. You can specify InnoDB when you create the new tables in PHPmyAdmin
__________________
Mark
Surpass Hosting Developer
ǝɹnʇɐubıs ʎɯ ǝ1oʇs xǝ1ɐ
Mark is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
This user thanks Mark for this great post!
jelew1985 (November 4th, 2009)
Old November 4th, 2009, 10:34 PM   #3 (permalink)
A little special...
Comfy Contributor
 
jelew1985's Avatar
 
Joined in Apr 2009
Lives in Omaha, NE
Hosted on Pass84
284 posts
Gave thanks: 14
Thanked 9 times
Send a message via AIM to jelew1985 Send a message via Yahoo to jelew1985
Quote:
Originally Posted by Mark View Post
The default storage engine is specified on a server wide basis. You can specify InnoDB when you create the new tables in PHPmyAdmin
thanks!!!
__________________
Jeffrey L. - MYAdvantage - Facebook - Twitter - Make the most out of your life :-)
jelew1985 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On