Level 1
I have the same problem. How come there is no solution/reply yet to this?
Nov 14, 2020
5
Level 1
Can't import sample sakila database to table plus.
When I try to import sakila database from mysql i am having this error?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER ;;
CREATE TRIGGER ins_film AFTER INSERT ON film FOR EACH ROW BEGIN' at line 5
Level 13
Please check the installation instructions provided here : https://dev.mysql.com/doc/sakila/en/sakila-installation.html
It seems that creating the database by directly importing the schema and data on mysql command line is the only error-free installation way.
6 likes
Level 9
I was facing the same problem when importing using tableplus as well as sequel pro. Then imported via cli and it worked fine. after importing I used the tableplus to access the data and it is working fine.
Level 4
You can use "Restore" option instead. Importing didn't work for me because of versions mismatch - 5.7 for the SQL file for Sakila, v8 for my local database.
3 likes
Level 14
I had the same issue last night, using TablePlus on Windows, and this is what seemed to work for me:
- Open sakila-schema.sql and then sakila-data.sql in a text editor. I used Jetbrain's Fleet.
- Copy the entire document/text to clipboard
- In TablePlus open the database and then SQL Editor (SQL Query)
- Paste the entire file and then "Run All"
1 like
Please or to participate in this conversation.