Best method for backing up DB?

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
Lawrence
-


Joined: 16 Jan 2003
Posts: 206
Location: Brisbane, AU

PostPosted: Tue Nov 27, 2007 1:01 pm    Post subject: Best method for backing up DB? Reply with quote

Can anyone suggest a good way to back up the database? I'm looking to set up a script to trigger a backup to another machine in the middle of the night, but... I can't just copy the DB files, as they're locked while in use.

What else can I do? Should I try and stop the SQL server while the copying's taking place? Is there an SQL command to back the data up to a new location?

Also, if I have to shut the SQL server down, is there a way to automate an Abyss shutdown or redirect to a 'now performing maintenance' page?

I look forward to any suggestions.
Back to top View user's profile Send private message Visit poster's website ICQ Number
olly86
-


Joined: 25 Apr 2003
Posts: 993
Location: Wiltshire, UK

PostPosted: Tue Nov 27, 2007 1:02 pm    Post subject: Reply with quote

If you are using MySQL, you can use the MySQL Administrator to schedule a backup.
_________________
Olly
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Nov 27, 2007 1:17 pm    Post subject: Reply with quote

I use a program called Delta Copy which ignores the locked files problem and copies it anyway.

Norton Ghost will also do this, but costs. Delta Copy is free.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
hyperial
-


Joined: 22 Aug 2007
Posts: 23

PostPosted: Mon Feb 25, 2008 10:40 pm    Post subject: Reply with quote

I wrote a script that does database backup as well as backing up the web files, then it FTPs (using CURL) it up to a remote server every night at 11:50pm. It tars and gzips the files before uploading them.

The script is written in BASH shell on Linux... I have modified it a little to work using cygwin on a Windows box as well as writing a similar DOS batch file using the CURL and ZIP commandline ports.

Here is the linux version I blogged on last year...

http://www.idude.org/2007/04/07/automated-backup-dated-bash-script-with-cron-execution/
Back to top View user's profile Send private message
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Wed Mar 19, 2008 5:49 pm    Post subject: Re: Best method for backing up DB? Reply with quote

Lawrence wrote:
Also, if I have to shut the SQL server down, is there a way to automate an Abyss shutdown or redirect to a 'now performing maintenance' page?


To automate Abyss' shutdown, we suggest that you have a look on http://www.aprelium.com/forum/viewtopic.php?t=7959 and http://www.aprelium.com/forum/viewtopic.php?p=39369#39369 .
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group