SimpleJ
asked on
MySQL Error 1067: Invalid default value for
Hello.
I have created a backup of a database
(mysqldump -h localhost -u root -p database_name > database_dump.sql)
Then I have updated my system from MySQL 4.0 to 5.0.45. I have created a clean OS install (centos 5.3 and mysql 5.0.45)
Since the old database wasn`t Utf-8 I converted it:
ICONV -f ISO-8859-2 -t UTF-8 database_dump.sql > database_dump_utf.sql
Then I `ve tried to import this dump:
(mysql -u root -p)
(create database database_name)
mysql -h localhost -u root -p database_name < database_dump_utf.sql
... but I get this error:
ERROR 1067 (42000) at line 10: Invalid default value for
For all others databases the procedure worked ok,
Thank you
I have created a backup of a database
(mysqldump -h localhost -u root -p database_name > database_dump.sql)
Then I have updated my system from MySQL 4.0 to 5.0.45. I have created a clean OS install (centos 5.3 and mysql 5.0.45)
Since the old database wasn`t Utf-8 I converted it:
ICONV -f ISO-8859-2 -t UTF-8 database_dump.sql > database_dump_utf.sql
Then I `ve tried to import this dump:
(mysql -u root -p)
(create database database_name)
mysql -h localhost -u root -p database_name < database_dump_utf.sql
... but I get this error:
ERROR 1067 (42000) at line 10: Invalid default value for
For all others databases the procedure worked ok,
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Will try and report ....
thank you