Troubleshooting of MySQL errors: Difference between revisions

Jump to navigation Jump to search
Line 339: Line 339:
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.
== PHP Fatal Error: Allowed Memory Size Exhausted when import SQL.GZ file using adminer ==
solution: Using the naive mysqldump command to generate the backup file. And import the backup by using mysql command.


== Database and Table Operation Errors ==
== Database and Table Operation Errors ==

Navigation menu