[TYPO3-english] No InnoDB Engine

[Ries van Twisk]

On Sep 29, 2009, at 2:27 PM, Ryan Bilesky wrote:

>
> It has created the tables but now its trying to alter it to use  
> InnoDB, so I take it the engine isn;t important?

Yes it's important for some reasons, but if your site has low traffic  
then in general
there is nothing to really worry about.

However I would talk to your hoster and ask them to turn InnoDB on...

RIes


>
>> Date: Tue, 29 Sep 2009 21:13:20 +0200
>> From: typo3-en at bruchmann-web.de
>> To: typo3-english at lists.netfielders.de
>> Subject: Re: [TYPO3-english] No InnoDB Engine
>>
>> ----- Ursprüngliche Nachricht -----
>> Von:        Ryan Bilesky <rbilesky at hotmail.com>
>> Gesendet:   Dienstag, 29. September 2009 20:12:15
>> An:         Typo3 Mailing List <typo3-english at lists.netfielders.de>
>> CC:
>> Betreff:    [TYPO3-english] No InnoDB Engine
>>> So I am installing typo3 and I am configuring it with the install  
>>> tool.  I got the basic settings setup and now I am trying to make  
>>> the database, I make the changes but some of the tables need to be  
>>> set to use the InnoDB engine, which my server does not appear to  
>>> have.
>>>
>>> I am running a VPS box with CentOS and I have full root access,  
>>> but I am not a linux person and have no clue what I am doing.  How  
>>> do I add InnoDB?
>>>
>>
>>
>> in the files
>> 1) t3lib\stddb\tables.sql
>> 2) typo3\sysext\cms\ext_tables.sql
>>
>> you can comment the expression "ENGINE=InnoDB" out, so that the  
>> tables
>> are created with default format.
>>
>> Best Regards
>> David
>> _______________________________________________
>> TYPO3-english mailing list
>> TYPO3-english at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> 		 	   		
> _________________________________________________________________
> Bing™  brings you maps, menus, and reviews organized in one place.    
> Try it now.
> http://www.bing.com/search?q=restaurants&form=MLOGEN&publ=WLHMTAG&crea=TEXT_MLOGEN_Core_tagline_local_1x1
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english


			regards, Ries van Twisk

- Join us on #TYPO3 on freenode | irc://chat.freenode.net/#typo3

-------------------------------------------------------------------------------------------------
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS  
WebORB PostgreSQL DB-Architect
email: ries at vantwisk.nl        web:   http://www.rvantwisk.nl/     
skype: callto://r.vantwisk