Dont know if this is important: However, to make the last point more clear. I compared both databases and found only table template_inputs was missing. The mariadb schema of that table looks like:
MariaDB [foreman]> show columns from template_inputs;
MariaDB [foreman]> show columns from template_inputs;
+-----------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
| required | tinyint(1) | NO | | 0 | |
| input_type | varchar(255) | NO | | NULL | |
| fact_name | varchar(255) | YES | | NULL | |
| variable_name | varchar(255) | YES | | NULL | |
| puppet_class_name | varchar(255) | YES | | NULL | |
| puppet_parameter_name | varchar(255) | YES | | NULL | |
| description | text | YES | | NULL | |
| template_id | int(11) | YES | MUL | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| options | text | YES | | NULL | |
| advanced | tinyint(1) | NO | | 0 | |
+-----------------------+--------------+------+-----+---------+----------------+
Anyway, seems like there is no data in the table:
MariaDB [foreman]> select * from template_inputs;
Empty set (0.01 sec)