import mappingsupport csv into mysql

Question

Warn: 

 

MySQL table field name will cause error if you use "-" in column name.

 

 "-" in column name at original CSV file, such as server-owner, arcgis-url must be change to server_owner, arcgis_url before import.

 

1) remove unwanted lines 1 - 5

 

 

2) Check each column, some fields have accidently URL instead of text, remove them. 

 

MySQL workbench not importing all rows from csv

https://stackoverflow.com/questions/68402612/mysql-workbench-not-importing-all-rows-from-csv/71576151#71576151

 

 

 

 

 

rename column name as: 

 

 

When upload to server,   error 

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

https://stackoverflow.com/questions/42385099/1273-unknown-collation-utf8mb4-unicode-520-ci

This error is caused because the local server and live server are running different versions of MySQL. To solve this:

 

1. Open the sql file in your text editor
2. Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci
3. Save and upload to a fresh mySql db