I'm a developer in a local company, and I'm currently working on a project which involves migrating a website to my company's server, from some other hosting provider.
For some reason this other company won't give us access to the cPanel, but rather provided us with the project (files) and an exported db script(.sql).
Now I'm having issues after importing the db because it lacks few tables. I actually think the db export is okay itself. While the script file is rather large ~1.5GB, the db after importing is only ~1GB.
I'm using cPanel & phpMyAdmin, and now I'm wondering if there's any scenario where the db SQL script file could be larger than the database itself, or might there be a limitation within cPanel or phpMyAdmin regarding the size, which would cause the import to skip/stop or anything similar on about 1GB?
I always thought (and still think it makes more sense) that the db could be only bigger than the script file, due to how the SQL scripts are built, lack of indexes etc.
Just wanted to check if this is possible, before I start inspecting the 1.5GB sql file myself and see wether tables are missing there too.
Thanks PS couldn't find similar questions.