Differences

This shows you the differences between two versions of the page.

--- docu:csheet:sysadm:db:my:database_migration_help [2021/06/17 12:16] – admin
+++ docu:csheet:sysadm:db:my:database_migration_help [2021/06/17 13:01] (current) – admin
@@ Line 16: / Line 16: @@
 > Invalid default value for 'Date'
-sed -i 's/'"'"'0000-00-00 00:00:00'"'"'/NULL/' yourapp-dump.sql
+sed -i 's/datetime NOT NULL DEFAULT '"'"'0000-00-00 00:00:00'"'"'/datetime NULL DEFAULT NULL/g' yourapp-dump.sql
+sed -i 's/timestamp NOT NULL DEFAULT '"'"'0000-00-00 00:00:00'"'"'/timestamp NULL DEFAULT NULL/g' yourapp-dump.sql
+sed -i 's/'"'"'0000-00-00 00:00:00'"'"'/NULL/g' yourapp-dump.sql
 </code>

NoBIGTech Wiki Técnico