Restoring a backup that is a .sql.gz file type

  • wethmank

    (@wethmank)


    15 years ago

    I recently had to delete my database and reinstall WordPress (GoDaddy hosting). I was using a backup plug in that emailed me my file in a format with the extension .sql.gz

    I went to the PHPMyAdmin/Import to try to restore, but when I try to upload in the “Location of text file” field, it says it only recognizes .zip files and no extension files. How do I get this backup file imported in?

    I’m a newbie so please be as detailed as possible in responses. Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • Clayton James

    (@claytonjames)

    .gz (gzip) is a compressed file extension more commonly associated with non-windows operating systems. You can however, easily decompress the files using existing tools usually already present on a Mac or in Linux. If you use windows, there is an excellent open source -and free to use-
    compression utility for windows that can decompress or “unzip” those files. Then you can re-compress it in the .zip format if you like. I use it almost every day.


    7-Zip

    Thread Starter wethmank

    (@wethmank)

    ClaytonJames — You are my hero!! I spent hours and hours today on this, and GoDaddy was completely useless. I used 7-Zip, extracted it to a straight sql file, and uploaded via PHPMyAdmin and voila, blog is back and working perfectly. Thank you for salvaging the rest of my holiday weekend!

    Clayton James

    (@claytonjames)

    You are very, very welcome!

    Now I can tell you that I felt sort of bad for not remembering to suggest that you resist the urge to open the .sql file on your desktop once you decompressed it. (Curiosity once killed this cat… bad things. Bad things indeed.) Glad it worked for you.

    Best wishes!

    Clayton,

    What do you mean by “bad things”?

    What happens if you open the SQL file? I’ve opened it with a web editor (Taco) and it didn’t explode.

    Perhaps you can elborate on why the .sql file shouldn’t be opened and what you experienced when you opened it.

    What happens if you open the SQL file? I’ve opened it with a web editor (Taco) and it didn’t explode.

    Perhaps you can elborate on why the .sql file shouldn’t be opened and what you experienced when you opened it.

    There’s no harm in opening the .sql file. It’s just a text file like anything else.

    There might be harm if you open it and then save it, making MySQL syntax errors. I’ve seen a couple of people make the mistake of opening the .sql file in a word processor application like Microsoft Word, which then converted quotation marks into “curly” quotation marks.

    I never knew that opening the sql back up files could corrupt it. Thanks for the info guys !

    Can you guys help me out on how to restore the SQL files on a 1&1 hosting?

    Moderator James Huff

    (@macmanx)

    deepakeapen, if this guide doesn’t cover something that you can use with 1&1, you’ll have to ask them for assistance:

    https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Restoring a backup that is a .sql.gz file type’ is closed to new replies.