Is this normal for exporting in Gzip? I exported my posts table as sql.gz and it has almost half the rows than the existing posts table on my forum.
no, number of rows should not be reduced in the gZip backup of the table.
that is, if that database table is restored then it should have same number of posts rows.
Strange. I tried the gzip export feature in AdminCP but the export always comes out corrupted. So I tried exporting a gzip through PHPMyAdmin but the table row comes up short. What are the correct custom export options I should be setting for a successful gzip export in PHPMyAdmin?