Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mySQL install script errors #13

Open
veera-nunna opened this issue Feb 13, 2019 · 1 comment
Open

mySQL install script errors #13

veera-nunna opened this issue Feb 13, 2019 · 1 comment

Comments

@veera-nunna
Copy link

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

@veera-nunna
Copy link
Author

I was able to correct the syntax error and move on but there too many duplicate entry errors. I just modified the 'Insert into' to 'Insert Ignore into' in the name_data.sql file to be able to move on and install the database. Please let me know if that is a correct way to go. Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant