NoBIGTech Wiki Técnico

User Tools

Site Tools

Trace:
docu:csheet:sysadm:db:my:database_migration_help

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
docu:csheet:sysadm:db:my:database_migration_help [2021/06/17 12:54] – admindocu:csheet:sysadm:db:my:database_migration_help [2021/06/17 13:01] (current) – admin
Line 18: Line 18:
 sed -i 's/datetime NOT NULL DEFAULT '"'"'0000-00-00 00:00:00'"'"'/datetime NULL DEFAULT NULL/g' 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/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/' yourapp-dump.sql+sed -i 's/'"'"'0000-00-00 00:00:00'"'"'/NULL/g' yourapp-dump.sql
 </code> </code>
docu/csheet/sysadm/db/my/database_migration_help.1623934484.txt.gz · Last modified: 2021/06/17 12:54 by admin

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
GNU Free Documentation License 1.3 Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki