It is no longer possible to create MySQL 5.1 databases. Every new MySQL database created in the 1&1 Control Panel will use MySQL 5.5. This is to ensure optimal compatibility with script applications based on PHP 5.6.
In some cases, migrating your MySQL 5.1 database to a MySQL 5.5 database may result in some errors. This is because MySQL 5.5 has addtional keywords and reserved words which MySQL will recognize as part of the SQL language, rather than as an identifier (i.e. a table name, database name, etc). If a table name, database name or any other identifier matches one of the reserved words below, it will cause an error in the execution.
In order to avoid errors, surround any identifiers that match the keywords or reserved words above in backticks as shown in the example below.