ifsnop / mysqldump-php

PHP version of mysqldump cli that comes with MySQL
https://github.com/ifsnop/mysqldump-php
GNU General Public License v3.0
1.25k stars 300 forks source link

Order table names for MariaDB-to-MySQL compatibility #218

Closed Slamdunk closed 1 year ago

Slamdunk commented 3 years ago

Hi, unlike MySQL, MariaDB stores table names into INFORMATION_SCHEMA.TABLES randomly. This result in a different output on different systems.

The fix proposed is compatible with both MySQL and MariaDB, all versions included.

back-2-95 commented 2 years ago

Thanks @Slamdunk . I added your fix on our fork https://github.com/druidfi/mysqldump-php/pull/9

Tests now pass with MariaDB 10.6 https://github.com/druidfi/mysqldump-php/actions/runs/2953510316