NoBIGTech Wiki Técnico

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====  Helping commands when migrating MySQL databases to different servers ====

\\
If you have a **full databases dump in a single file**, you can get only the dump for the wanted database, by doing this commands:
<code bash>
# search for the create database sentences and track yours (get the line number)
grep -inP '^create database' all-databases-dump.sql

# imagine, the line number given by the previous command, is 564, then you'will do:
tail -n +564 all-databases-dump.sql > yourapp-dump.sql
</code>

\\
In case you are migrating to a database and you get this **datetime default value error**, do as follow to fix the value:
<code bash>
> Invalid default value for 'Date'

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

User Tools

Site Tools

Page Tools