Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.