yii2-backup icon indicating copy to clipboard operation
yii2-backup copied to clipboard

Problem if Views exist

Open klikar3 opened this issue 8 years ago • 1 comments

If Views exist in the database an error occurs in helpers\MysqlBackup.php because "SHOW TABLES" also lists Views.

Line 62 is now: $sql = 'SHOW TABLES'; it should be $sql = "SHOW FULL TABLES where Table_Type != 'VIEW'"; so that only Tables get scripted and saved...

Later on the scripting of Views but not their content could be added... ;-)

Regards Karl

klikar3 avatar Sep 27 '17 12:09 klikar3

Thanks @klikar3 . We shall update it in next release

spanjeta avatar Sep 28 '17 14:09 spanjeta