Troubleshooting of MySQL errors: Difference between revisions

Jump to navigation Jump to search
Line 159: Line 159:
Solution:
Solution:
* When importing from Excel to a database, if the 'source' field is empty or not specified, it's necessary to assign a value to the 'source' field. Alternatively, modify the field definition to allow the field value to be NULL.
* When importing from Excel to a database, if the 'source' field is empty or not specified, it's necessary to assign a value to the 'source' field. Alternatively, modify the field definition to allow the field value to be NULL.
=== ERROR 1813: Tablespace for table xxx exists ===
Message: ERROR 1813 Tablespace for table xxx exists.
Solution
* [https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp mysql - Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT - Stack Overflow]


== Access and Authentication Errors ==
== Access and Authentication Errors ==

Navigation menu