Hi Guys

 

I have recently purchased a 27" iMac and I'm slowly learning my way around things.

 

I have just made a backup of my site's Database. The file is { db_backup.sql.gz }

 

On Windows I use to Right Click and Extract with WinRAR, to see if any errors existed in the extraction.

 

How can I do a similar thing on the iMac. I want to know that there won't be extraction errors in the backup.

 

I would greatly appreciate any help.

 

Thank You.

Anyone ?

 

Sorry if this is posted in the wrong section by the way !

I believe OS X can open .gz archives without third party software so make a copy of the file (so you have a backup) and try double-clicking it. It should just work.

 

I've never needed to download any extraction software for any of my Macs, excluding a very odd-ball one which I used a free version of StuffIt Expander for.

 

New iMacs in October - you should have waited!

http://developer.apple.com/mac/library/documentation/Darwin/Reference/ManPages/man1/gunzip.1.html

Thanks Andyl

 

When I double click on the file, I get the same file name but with the { .sql.gz.cpgz } extension !

 

Is that normal ? All I want to do is some how confirm that I have a full error-free database backup.

 

Are there easy ways to do that ?

 

Thanks

Just open up terminal and type...

 

gunzip database.sql.gz

Thanks for the link Jock.

 

It sounds very complex though ! It sounds like terminal commands ! But I've never opened the terminal, since I've heard it is a dangerous tool if you don't know what you're doing.

 

Are there simpler methods of extracting ?

hehe you beat me to the post !

 

Ok I'll try that I guess.

 

thanks

Hi again

 

It did not work. I get the following:

 

gzip: db_backup.sql.gz: not in gzip format

 

What am I doing wrong ?

I guess its trying to say your file is not a gzip file. What program did you use to generate the sql file?

I used IPB's Built in Backup thingy !! Form the Admin CP

 

I use DirectAdmin on my Server, but I don't really know how to make a backup of my Database through DirectAdmin.

meh... use proper backup

 

 

mysqldump –-user [user name] –-password=[password] [database name] > forum.sql

 

get that working then set it up as a cron

wait wait I'm confused !!

 

I can use that command you've given straight from my iMac's Terminal ??? Do I have to navigate to a specific folder first ?

 

It seems too easy if that's all it takes !!

 

Sorry Mac n00b here.

That command is to use from the servers command line. If you have mysqldump in your mac you can technically use it to backup your server remotely, using...

 

mysqldump --host=123.123.123.123 --user [user name] --password=[password] [database name] > forum.sql

 

Where the IP address is your server IP and your database accepts remote connections.

I don't really know whether I have mysqldump on my iMac or not. However I do know that I have not installed it myself.

 

It's OK I'll use that command from the Server's Command Line. However What do I do If I've lost the database username and password ?

It will be in your IPB config file.