UPDATE:
I changed the compression from g-zipped to zipped And that seemed to temporarily solve the problem with no issues uploading the SQL and no errors appearing.
However now the only page that works is the homepage
Any other pages return:
404 Error File Not Found
The page you are looking for might have been removed,
had its name changed, or is temporarily unavailable.
I thought I’d try to use SQL to change any broken URLS
But… to no avail.
Completley bizzare? Even when I create a new page…. It still returns that error. Why can’t it see any other page than the home page?