Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to restore a database that was backed up using navicat's compressed backup feature. But on the restore, there's an error coming up on one of the tables.

I can't look at the SQL statements in the file directly because they're compressed, and I don't know what compression format it's in.

Does anyone know of a way to decompress this file into a regular text file?

share|improve this question

I solved this by dragging the backup file into the listing on the backups tab of Navicat, and then right clicking on that entry and selecting the "Extract SQL" option. This then allowed me to save out the raw SQL.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.