Core.sql.gz -

: Many web-based management tools like phpMyAdmin have strict file size limits for imports. Compressing a large .sql file into a .sql.gz often brings it under these limits, allowing for easy browser-based uploads.

You can interact with these files directly in a terminal without needing to fully extract them first: How to Compress .SQL file to .SQL.GZ gzip format ? core.sql.gz

: Gzip compression can reduce the size of plain text SQL files by up to 70–90% . This is particularly effective because SQL dumps contain many repetitive strings (like table names and column headers) that compress efficiently. : Many web-based management tools like phpMyAdmin have