备份后恢复报错

现状

[Msg] Decompressing...
[Msg] Table Created: zt_user
[Msg] Importing Data...
[Msg] 1265 - Data truncated for column 'gender' at row 1
[Msg] Table Restored: zt_user
[Msg] Rolling back...
[Msg] Finished - Stopped before completion

解决办法  在insert 的时候 第一条的'gender' 字段值为空，应该是4.0的默认如此，运行过一4.1的更新，改为不可为空项，在恢复的时候要把第一条的admin 重新'gender'赋上'f' 即可