Nov 22, 2009

How To Restore A Sql.gz File

 		free web hosting
Open Discussion & Free Web Hosting > Computers & Tech > Databases

How To Restore A Sql.gz File

PigFat
May 14 2006, 05:02 AM
How do i restore a sql.gz file?

Im confused mellow.gif

Comment/Reply (w/o sign-up)

Quatrux
May 14 2006, 07:45 AM
Well, if you have phpmyadmin, you can run the sql query through it.. the sql.gz usually is just a file with queries and comments.. I don't know how you exported it, but uncompress it and if the method you used is INSERT blah, then run the query with some kind of language such as PHP.. I think you really can find something on google, it is really easy.. You can have problems if you want to restore a large database, for example 1 GB. wink.gif

Good luck!

Comment/Reply (w/o sign-up)

yordan
May 16 2006, 10:55 AM
QUOTE
How do i restore a sql.gz file?

How did you get that sql.gz file ?
If you got it through a cpanel "make backup" menu, you restore it with the correspondig "restore backup" menu.
If you obtained it from somebody, this guy should tell you how he created the file and how the file has to be restored. Remember, it's an old Unix rule : when you give somebody a backup file, you must provide the way of restoring (cpio, tar, import, etc...)
Nevertheless, Quatrux is right : get this file on your own computer, untar it, and see what is inside, and if it's simple "insert into mytable" things, just run this file.

Comment/Reply (w/o sign-up)

vhortex
May 19 2006, 06:41 PM
hope this help with decompressing the file..

not all compressing programs can understand *.GZ file
since this is a *NIX native file

you can use powerarchiever for this matter since it have support for *NIX files.

--

nomally, other decompressors will only create a new folder with a tar file inside when you decompress the file and yank that you confirm an overwrite for the TAR file.


Comment/Reply (w/o sign-up)

yordan
May 19 2006, 09:25 PM
QUOTE
not all compressing programs can understand *.GZ file

winrar also knows how to manage the .rar or .gz files, you can get it at winrar.com
Yordan

Comment/Reply (w/o sign-up)

(G)Demonz Media
Nov 16 2009, 11:31 PM
Resotring .sql.gz files
How To Restore A Sql.gz File

The easiest way is to restore directly from the MySQL statement using the gzip program (especially if you're working with a 1GB .Gz file which is HUGE):

gunzip -c /path/backup.Sql.Gz | mysql -h[database host - usually localhost] -u[username] -p[password] [database-name]

-reply by Demonz Media

 


Comment/Reply (w/o sign-up)

Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.
Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : restore, sql, gz, file

  1. Mysql And User File_priv
    (0)
  2. Can't Import Backup Sql File To Localhost
    (11)
    Hi, I downloaded a backup of my forum database and wanted to import it on my computer locally for
    testing purposes. This has always worked for me in the past, but I'm having some problems with
    it lately. I'm backing up my database via phpMyAdmin->Database->Export->Select All and
    downloaded as a .gz file. I'm using Windows XP Home with WAMP installed, so it has MySQL built
    in. It's version 5.0.27. I ran all the services and at the prompt typed in: mysql -u root -p
    backup.sql > testDB My root account in WAMP has no password, so when it prompts for a ....
  3. Read/Write Issues After Copying An Access .mdb File
    (4)
    Alright, I'm currently creating an interface program for a MS Access database. I've only
    used Access once in the past but used other DB's a handful of times so I didn't have any
    trouble getting the general program created. My issue arose when I tried to make it so that the
    users needing to use the program can just copy the .exe and the .mdb files and use it. The program
    doesn't require users to share the database but to store their OWN programs information in their
    OWN database, so basically each needs to have their own database with the exact same d....
  4. Restore Database Backup Locally?
    (7)
    I wanted to use my live forum database (in another webhost) on Astahost for testing purposes. But I
    guess the free accounts we have do not support that restore backup option...tried it and got a
    message saying that. Is there any way we can do this locally? I will probably install XAMPP or one
    of the variants of those packages. I don't assume cPanel can be included also locally? If not,
    I just want to know how I can use the database from my live forum in my own computer. Thanks.....
  5. Recover Tables From A MySQL .frm File
    (9)
    I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
    the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
    innodb....
  6. Sample My.cnf - MySQL Configuration File
    if you need as startup (2)
    Hi all, Recently there has been lots of questions about configuring MySQL. Usually the rpm
    comes with a few sample MySQL config files, but here I'm providing you with a fully working one
    for your reference. Feel free to modify it to suit your needs. One word: My MySQL is configured to
    use only large InnoDB Databases, because of the large volume of transactions it handles. You'll
    find a reflection of that in the my.cnf... Most home users would use ISAM DB instead. So make the
    suitable modifications before you use... Sample "my.cnf" QUOTE #-----------....
  7. How To Restore MySQL Database
    (1)
    login to mysql, type command below: mysql db_name < back.sql....


      8. Looking for restore, sql, gz, file

See Also,

*SIMILAR VIDEOS*
Searching Video's for restore, sql, gz, file
advertisement



How To Restore A Sql.gz File

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com