Tables size = 0

I have around 50 lines like these:

SELECT engine, ( data_length + index_length ) AS size, table_rows FROM information_schema.TABLES WHERE table_schema = 'sql835818_1' AND table_name = 'mythos_bwg_album'
SELECT engine, ( data_length + index_length ) AS size, table_rows FROM information_schema.TABLES WHERE table_schema = 'sql835818_1' AND table_name = 'mythos_bwg_album_gallery'
SELECT engine, ( data_length + index_length ) AS size, table_rows FROM information_schema.TABLES WHERE table_schema = 'sql835818_1' AND table_name = 'mythos_bwg_gallery

‘

Next time, please use a pastebin for large files –

https://codex.www.ads-software.com/Forum_Welcome#Posting_Code

It went in the spam filter…

Sorry, thanks

Okay, cool, thanks!

These queries won’t give any results in PHPMyAadmin, since the ‘table_schema’ is mixed case in the database:

SELECT engine, ( data_length + index_length ) AS size, table_rows FROM information_schema.TABLES WHERE table_schema = ‘sql835818_1’ AND table_name = ‘mythos_bwg_album’

So, please try to run (in PHPMyAdmin):

SELECT engine, ( data_length + index_length ) AS size, table_rows FROM information_schema.TABLES WHERE LCASE(table_schema) = ‘sql835818_1’ AND LCASE(table_name) = ‘mythos_bwg_album’

Thanks for the tip, WPyogi!

I am using email