News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Vid Luther's Blog:
Changing MySQL storage engine for one table in your Propel/Symfony project
September 29, 2009 @ 08:26:15

Vid Luther has a new post to his blog showing how to switch the storage engine only one (or any number of individual tables) in your MySQL-backed Propel/Symfony project.

I need one MyISAM table in my schema, I'm using Symfony 1.2 and Propel 1.3. As flexible as Symfony and it's YAML files are, Propel currently doesn't allow you to change the storage engine on the fly. [...] So, the next best thing to do now is to have it so that when Symfony runs propel:insert-sql, I can piggyback my own SQL to it. Luckily, this is possible, and it's explained here.

He gives an example of how he's doing it - making a simple alter table script, putting it into a SQL file and pushing it out into the project's setup via a "propel:insert:sql" command.

0 comments voice your opinion now!
symfony storage engine mysql change tip


blog comments powered by Disqus

Similar Posts

Wojciech Sznapka: Immutable value objects in PHP

Codewalkers.com: Book Raffle - Beginning PHP and MySQL 5 - From Novice to Professional

Job Posting: PoR, Inc Seeks PHP/MySQL Developer (Telecommute)

Symfony Project: symfony at PHP Paris forum

Wez Furlong\'s Blog: PDO MySQL slides from MySQLUC 2006


Community Events





Don't see your event here?
Let us know!


language install interview package symfony opinion series tips list laravel bugfix framework release deployment voicesoftheelephpant podcast community library introduction api

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework