aws-samples / aws-samples/aws-database-migration-samples

mySQL install script errors

Open
#13 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
PLpgSQL
Stars
185
Forks
215
PR merge metrics
No merged PRs in 30d

Description

There are bunch of syntax and duplicate record errors that I came across while trying to install the mysql sample database.
I've tried to document most of them:

ERROR 1064 (42000) at line 1625 in file: './data/name_data.sql': 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 'Insert into name_data (name_type,name) values ('LAST','Yoervis')' at line 2
Operation failed with exitcode 1

ERROR 1062 (23000) at line 1692 in file: './data/name_data.sql': Duplicate entry 'LAST-Mcdaniel' for key 'PRIMARY'
Operation failed with exitcode 1

ERROR 1062 (23000) at line 1721 in file: './data/name_data.sql': Duplicate entry 'LAST-Mckinney' for key 'PRIMARY'
Operation failed with exitcode 1

ERROR 1062 (23000) at line 1771 in file: './data/name_data.sql': Duplicate entry 'LAST-Mcgee' for key 'PRIMARY'
Operation failed with exitcode 1

ERROR 1062 (23000) at line 1861 in file: './data/name_data.sql': Duplicate entry 'LAST-Mcbride' for key 'PRIMARY'
Operation failed with exitcode 1

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.