WordPress.org

Ready to get started?Download WordPress

Forums

Restoring a backup that is a .sql.gz file type (9 posts)

  1. wethmank
    Member
    Posted 4 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!

  2. ClaytonJames
    Member
    Posted 4 years ago #

    .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

  3. wethmank
    Member
    Posted 4 years ago #

    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!

  4. ClaytonJames
    Member
    Posted 4 years ago #

    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!

  5. Dave333
    Member
    Posted 4 years ago #

    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.

  6. Austin Matzko
    Member
    Posted 4 years ago #

    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.

  7. deepakeapen
    Member
    Posted 3 years ago #

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

  8. deepakeapen
    Member
    Posted 3 years ago #

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

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

    http://codex.wordpress.org/Restoring_Your_Database_From_Backup

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.