Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

back up for gossamer mail

Quote Reply
back up for gossamer mail
Hello,

I would like to make a daily back up of GM MySQL database. Would this cron be ok?

45 20 * * * mysqldump --add-drop-table -uUSERNAME -pPASSWORD DATABASENAME > backup.txt

I would run it as root.

Thanks a lot,

Narcís
Quote Reply
Re: [narcis] back up for gossamer mail In reply to
You might need a full path to the backup file.
Quote Reply
Re: [Paul] back up for gossamer mail In reply to
I have a question for GM staff!

Exactly what files should be backed up to be able to restore GM completely?

So far I am backing up the data directory and the mysql database. Anything else in the public_html folder I should backup?

One question, when I use tar to backup the data directory I get this message:

tar: Removing leading `/' from member names

Is this bad or is it normal?

Thanks
Quote Reply
Re: [Surfer2] back up for gossamer mail In reply to
Tar will try to use relative paths which is why you get that leading '/' message.

You can use the P switch to stop that.

Last edited by:

Paul: Jun 2, 2002, 5:29 PM
Quote Reply
Re: [Paul] back up for gossamer mail In reply to
Ok, thanks a lot Paul!
Quote Reply
Re: [Paul] back up for gossamer mail In reply to
Hi,

I am using "tar czpf" is this correct?

thanks
Quote Reply
Re: [Surfer2] back up for gossamer mail In reply to
Yeah that should work I think.
Quote Reply
Re: [Paul] back up for gossamer mail In reply to
but that's the one that gave me the message!

What does the message mean? Can I leave it, or will it affect the data?
Quote Reply
Re: [Surfer2] back up for gossamer mail In reply to
Its a P not a p
Quote Reply
Re: [Paul] back up for gossamer mail In reply to
Thanks Paul! That worked!

I also want to know what files that are needed to back up in order to do a full restore if my server crashes! Do I need to backup the entire DATA directory? Any other directories?

Any future plans on making a mysql only storage system? What are the benefits of both using files and mysql???

thanks