SQL Export Broken in 12.6.0.6823

neik's profile image neik posted 3 months ago in General Permalink

I am trying to export the schema of my SQLite database. There are two errors:

  1. Triggers are not exported at all
  2. Views are exported as tables, in my case with "ENGINE=MyISAM" (This is SQLite!)

Is this a known problem?

ansgar's profile image ansgar posted 3 months ago Permalink

Yes, the SQL export of DDL queries is mostly compatible to MySQL and MariaDB only. SQLite exports should only be used for data, not structure.

Please login to leave a reply, or register at first.