Importing Database-Dump in MySQL/MariaDB leads to errors

craftcms / europa-museum

Craft CMS demo site.

https://craftcms.com/demo?kind=europa

BSD Zero Clause License

47 stars 24 forks source link

Importing Database-Dump in MySQL/MariaDB leads to errors #10

Closed alexgit2k closed 3 years ago

alexgit2k commented 3 years ago

Description

Demo-website should work with "PostgreSQL (11.5+) / MySQL (5.7+)", however importing the database-dump leads to errors.

Steps to reproduce

mysql craftcms < seed.sql ERROR 1193 (HY000) at line 8: Unknown system variable 'statement_timeout'

Additional info

Craft version: 3
PHP version: -
Database driver & version: MariaDB 10.6
Plugins & versions:

mattstein commented 3 years ago

Fixed that line in the readme since it was misleadingly describing Craft’s database requirements and not the project’s. Local Development Setup step 2 is more specific/accurate:

Make sure you’ve used nitro db new to create a PostgreSQL 13 database engine.

Thanks for pointing this out!