dvharrison Posted January 27, 2009 Share Posted January 27, 2009 Hi I am testing how to backup/restore database using Database manager. I can download the uncompressed SQL but have been recommended not to as the database is 1.1Mb! So I am downloading it using GZIP to my PC, but I get the following error message when i open the file: db_kelscrafts_co_uk_products-20090127194416.sql.gz is either in unknown format or damaged. I have tried sending it to the support team at my hosting company and they get a message: gunzip: db_kelscrafts_co_uk_products-20090127194416.sql.gz: not in gzip format There is probably a very simple explanation but how can I get this to work? Please help. :blink: Debbie Harrison Link to comment Share on other sites More sharing options...
Jan Zonjee Posted January 27, 2009 Share Posted January 27, 2009 I am testing how to backup/restore database using Database manager. I can download the uncompressed SQL but have been recommended not to as the database is 1.1Mb! So I am downloading it using GZIP to my PC, but I get the following error message when i open the file: Downloading using GZIP???? What on earth are you talking about? With the database manager that comes with osC you can check a box or a radio button (forgot which one) that you want the sql to be gzipped. A lot of times that is not possible because the gzip executable cannot be called by the webserver (safety measure). Have you tried opening the file with a text editor instead? Perhaps it is not gzip'ed at all. You might need to change the extension to .sql or .txt first before trying. Link to comment Share on other sites More sharing options...
dvharrison Posted January 28, 2009 Author Share Posted January 28, 2009 Hi jan You are given 2 options to backup either: No Compression (Pure SQL) or Use GZIP I opted for GZIP as the database is big (600-700 lines) and thats what I meant. However I have tried backing up and restoring the database from the OSCOmmerce admin panel (compressed and uncompressed) and in both instances I get redirected back to login screen. HTH Debbie Harrison Link to comment Share on other sites More sharing options...
Jan Zonjee Posted January 28, 2009 Share Posted January 28, 2009 I opted for GZIP as the database is big (600-700 lines) and thats what I meant That is not big in my view. However I have tried backing up and restoring the database from the OSCOmmerce admin panel (compressed and uncompressed) and in both instances I get redirected back to login screen. So that made you conclude it is not working? Strange conclusion. A. When restoring a backup this is normal because the table sessions is emptied in the restore. That means your admin session is gone too: hence the need to login again. B. A more logical way to see if something changes is to make sure you change something compared to the backup and then doing the restore. If the change is gone the backup was restored. Link to comment Share on other sites More sharing options...
dvharrison Posted January 28, 2009 Author Share Posted January 28, 2009 Jan This is new to me. I wish I had half your expertise (I would be very happy). And yes you are right. It does restore the database. Debbie Harrison Link to comment Share on other sites More sharing options...
Jan Zonjee Posted January 28, 2009 Share Posted January 28, 2009 And yes you are right. It does restore the database. The logging out puzzled me too when it happened. Harald PDL set me straight on that. So don't assume I know everything :) The gz that cannot be opened is strange though. Is the .sql the same size as the .sql.gz file? If it is than you should be able to open the gz file with a text editor and see that it is a plain text file. You could try this contribution. It should work more reliably with large databases (although 1 MB is not large yet). Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.