Database restore fails due to wrong INSERT INTO with NOT NULL table definition

  • Database restore fails, due to INSERT INTO lines with NULL values into a table where the value is defined as NOT NULL DEFAULT ‘ ‘.

    With the exact same database exported to SQL via PHPmyAdmin those INSERT INTO commands contain ‘ ‘ iunstead of NULL.

    This renders the database backup relatively useless….

    • This topic was modified 6 years, 8 months ago by martinderm.
    • This topic was modified 6 years, 8 months ago by martinderm.
  • The topic ‘Database restore fails due to wrong INSERT INTO with NOT NULL table definition’ is closed to new replies.