Doctrine2: required version of MySql

Question

Can someone tell me which version of MySql is required to use Doctrine2?

I am trying to create my model from an existing database using:

php app/console doctrine:mapping:convert xml ./src/Acme/BlogBundle/Resources/config/doctrine/metadata/orm --from-database --force 

But I get an SQL error since the following query (called Doctrine in Symfony2) does not seem to be supported by MySql version (4.1.14):

 SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' 

Thanks.

Answer 1

Required Mysql Version: Mysql 5.1

Answer 2

The Doctrine project does not explicitly require a specific version of MySQL, because database abstraction and access level is a thin shell around PDO

So the question is: What is required PDO_MYSQL?

From the PDO_MYSQL docs :

PDO_MYSQL is a driver that implements the PHP Data Objects (PDO) interface to provide access from PHP to MySQL 3.x, 4.x and 5.x databases.

PDO_MYSQL (and by extension Doctrine2) can work with versions of MySQL already in 3.x.

But, note that on the same page he mentions:

since PHP 5.4. MySQL client libraries 4.1 and below are no longer supported.

So, if you are using PHP 5.4+, you need to use MySQL 5.0 to use Doctrine2.