Closed Thread
Results 1 to 4 of 4

Thread: sql database does not restore

  1. #1
    softwork is offline x10Hosting Member softwork is an unknown quantity at this point
    Join Date
    Nov 2007
    Posts
    36

    sql database does not restore

    i have a sql database extracted from a full backup which I opened than with an editor to check if the file is corrupted. Comparing the file with the file from a working sql database everything seems to be ok.

    If I now try to upload and restore the sql database file zipped as *.gz using the cpanel restore wizard the database appears under sql databases but has only a size of 0.01mb, where the file I uploaded is 0.5 mb (zipped 0.1mb).

    working sql database file size / zipped: 122kB / 22kB
    restored sql database filesize / zipped: 500kB / 98kB


    what could be wrong?
    Last edited by softwork; 05-17-2008 at 02:16 PM.

  2. #2
    Brandon's Avatar
    Brandon is offline Former Senior Account Rep Brandon is on a distinguished road
    Join Date
    Jun 2006
    Location
    Tewksbury, MA
    Posts
    9,589

    Re: sql database does not restore

    Try importing the backup with phpMyAdmin.
    Thanks,
    Brandon Long

  3. #3
    softwork is offline x10Hosting Member softwork is an unknown quantity at this point
    Join Date
    Nov 2007
    Posts
    36

    Re: sql database does not restore

    the behaviour doesnt really change...

    if I upload the file as *.sql or *.gz phpmyadmin says

    Import has been successfully finished, 161 queries executed.

    but no additional database appears. If I upload the file as *.zip an error appears saying

    Error in ZIP archive: Compressed size is not equal with the value in header information.

    is any special sql mode necessary ?
    Last edited by softwork; 05-18-2008 at 07:37 AM.

  4. #4
    softwork is offline x10Hosting Member softwork is an unknown quantity at this point
    Join Date
    Nov 2007
    Posts
    36

    Re: sql database does not restore

    any help?
    Edit:
    so I helped myself. The crux was simply to rename the backup *.gz file. strange...
    Last edited by softwork; 05-20-2008 at 06:48 AM. Reason: Automerged Doublepost

Closed Thread

Similar Threads

  1. SQL Database location?
    By martynball in forum Programming Help
    Replies: 4
    Last Post: 05-15-2008, 12:20 PM
  2. SQL database
    By holeepassion in forum Free Hosting
    Replies: 2
    Last Post: 05-06-2008, 12:38 PM
  3. Make other people access my Database (SQL)
    By Blazer9131 in forum Scripts & 3rd Party Apps
    Replies: 11
    Last Post: 05-05-2008, 05:57 PM
  4. SQL Database Issue
    By digitaljit in forum Free Hosting
    Replies: 2
    Last Post: 04-18-2008, 09:54 AM
  5. Database links to back end on SQL
    By slinky in forum Free Hosting
    Replies: 1
    Last Post: 11-06-2007, 08:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers