MySQL Forums
Forum List  »  Backup

tinytext has no default after restoring db
Posted by: Michael Lentz
Date: October 23, 2015 06:43AM

I backup my databases daily with mysqldump --all-databases.
After losing a hard drive, and reinstalling MySql, I loaded the databases from the backup SQL file.

Now I get the following error on some inserts :
java.sql.SQLException: Field 'foo' doesn't have a default value

A 'describe' of the table shows these fields with a default value of NULL.
They were created as tinytext NOT NULL.

Options: ReplyQuote

Written By
tinytext has no default after restoring db
October 23, 2015 06:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.