aws-samples / aws-samples/aws-database-migration-samples
mySQL install script errors
- 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
Assessment
This issue has not been assessed yet.