Comments - Sakila DB errors
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
You don't specify how you are importing, or which version.
mysql < sakila-schema.sqlworks fine when I try import it on MariaDB 10.6.4.
The "Foreign key constraint is incorrectly formed" error is there because in the original sql file, foreign_key_checks is set to 0 (default 1), while presumably you don't do this when running the queries individually, so the foreign key check fails. Run the statements in the same order as they are in the file, in the same session.
I use the manual import function to upload the zip file. Here is my db version: Server: 127.0.0.1 via TCP/IP Server type: MariaDB Server connection: SSL is not being used Documentation Server version: 10.4.18-MariaDB - mariadb.org binary distribution Protocol version: 10 User: root@localhost Server charset: UTF-8 Unicode (utf8mb4) Web server