Toad World® Forums

Toad Edge MariaDB support

Toad Edge work seemsfully on MySQL. But I have some MariaDB installations and tried to use Toad Edge to compare DB between them.

When trying to compare, I get the following error: “Error occurred: Unknown table ‘INNODB_SYS_DATAFILES’ in information_schema”.

MariaDB does not come with this table (and some others too) on information_schema.

Will Toad Edge support MariaDB too? Is there a workaround to this error, so that I can continue doing my comparisons including MariaDB databases?

Thank you!

Will Toad Edge support MariaDB too?

Toad Edge already supports MariaDB.

Is there a workaround to this error, so that I can continue doing my comparisons including MariaDB databases?

The comparisons would generate the message, because MariaDB has different tables. May be the system schemas information_schema and performance_schema should be omitted from the comparison.

Hi,

this issue is probably caused by comparing older version of MariaDB - we officially support Maria 10.1 (10.2 should work as well). Both of these already contain INNODB_SYS_DATAFILES table.

Currently there is no plan to support older version.

Could you confirm that you have version < 10 ?

Regard

Petr Chudanic

I did not found where I can ommit the information_schema comparison. I think Toad do not compare them directly, but uses information stored in information_schema to do the comparisons on those tables that I have selected.

MariaDB version that I am tring to compare is 5.5.41 (on an old Debian Wheezy).

I have found that the old “Toad for MySQL” (not available to download anymore and droped in favor of “Toad Edge”) works correctly on this MariaDB 5.5.x version, althought “Toad for MySQL” does not have the report functionality that I need and that “Toad Edge” offers greatly.

Thak you all!

Henrique Augusto