I was wondering how you use the file that is created by the SQLDump option...

I created a tar.gz file, but when I try to open it via WINZIP, nothing appears, although the file is close to 1 MG large. I am able to open backup files (tar.gz) just fine.

Any ideas?

Regards,

Eliot Lee

When you created the dump, when it asks for the path to the dump file did you use....

/path/to/file/myfile.tar.gz ?

I use /path/to/file/myfile.mysql

This creates the dumped data in a text file and you can then gzip that file.

(I think this is the first thread ive seen you start).



Paul Wilson.
new - http://www.wiredon.net

The file is created just fine...just can't open...I will try to save it under another extension.

Thanks for the reply.

Regards,

Eliot Lee

No probs....

Just out of interest were you saving it as tar.gz?

It got me thinking as to whether MySQLMan automatically creates the gzipped file for you because I have never tried....always used the .mysql extension.

Would it work using .tar.gz do you think?

Paul Wilson.
new - http://www.wiredon.net

I saved it as dbdump.tar.gz and when I downloaded the file and tried to open via WINZIP..it didn't work. The weird thing is that exported text files from the same database are backed up just fine in a tar.gz file and I can open it with WINZIP.

I will experiment with different file extensions to come up with the right one.

Thanks again...and BTW: This is probably the fifth Thread I've started in the last six months...spend too much time responding to other people's Threads.

Regards,

Eliot Lee

I know you do....

I think that Links uses extra code to create backups that gzips the backup for storage in the backups dir.....whereas MySQLMan doesn't and so it has to be stored as a text file and gzipped seperately.

You could probably find the code that creates the Links backup and paste it into MySQLMan so that the generated dump gets gzipped automatically.

I may be WAY off but I'm trying to think logically...let me know if you have success.

Paul Wilson.
new - http://www.wiredon.net

Thanks, Paul...I figured out that tar.gz is not the best file extension...I used .mysql and .db instead and it works fine.

Thanks again for responding.