MDB 10 error with NOT NULL columns

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MDB 10 error with NOT NULL columns

Postby _paddy » 11. June 2022 06:31

I'm moving my MariaDB dbs from a server with MDB5.5 to a different one with MDB10. I just created a mysqldump of all dbs from MDB5.5 and then input them on the new server to MDB10.

A lot of my table columns have NOT NULL set even though they are somethimes left empty which (while maybe a design flaw) hasn't been a problem in the mysql and MariaDB versions I've used over the past 20 years. However I'm now getting fatal errors with inserts where those columns are left empty. Short of manually correcting 100's of table definitions or many 100's of INSERT/UPDATE statements is there a workaround such as any global setting in MDB10 to turn off that reqiurement? Or if I were to upgrade the old server to MDB10 before the mysqldump would that correct them. FWIW many of those columns are TEXT of some sort so they don't accept DEFAULT in the column definition.

Thanks

Pat
_paddy
 
Posts: 1
Joined: 11. June 2022 06:04
XAMPP version: LAMP
Operating System: Amazon Linux 2

Re: MDB 10 error with NOT NULL columns

Postby Nobbie » 09. July 2022 09:25

Cant you simply run a shell script over the export files which deletes all NOT NULL tags from the table definition?
Nobbie
 
Posts: 13165
Joined: 09. March 2008 13:04


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 30 guests