sql database does not restore

[softwork]

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?

 

[Brandon]

Try importing the backup with phpMyAdmin.

 

[softwork]

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 ?

 

[softwork]

any help?
Edit:
so I helped myself. The crux was simply to rename the backup *.gz file. strange...