| |
Haven't registered yet? Do it here now!
|
rhino
Joined: 07 Aug 2007
Posts: 57
|
|
|
 |
|
 |
|
 Posted: Sun Nov 25, 2007 7:24 am Post subject: BO system backup stopped working? |
 |
|
|
 |
|
 |
|
|
|
|
BO system backup was working, now seems to time out prior to completing the operation. BO reports it completes the system files backup as done, then starts the MySQL backup but it doesn't complete the process so no backup file is added to ./bo/bobackups. Bo reports Backing Up your MySQL Database now... and I see the dotted lines as its running, but then it seems to time out.
All other BO script functions appear normal, just can't complete the backup process (several attempts, thought it was working but then noticed the date/time stamp displayed was 30+ days old and realized last 3 backup attempts failed. Any suggestions?
Thanks!
Rhino |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Sun Nov 25, 2007 3:35 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
hm, that can happen if your database has grown much and web server times out before the operation is completed. I will see if i can improve it more so it doesn't time out, though i set it smartly to send output several seconds so it doesn't timeout.
meanwhile you can create backups with "mysqldump" server command, it always works best and most reliable.
_________________
Thanks,
Kaktusan
 |
|
|
|
|
|
|
|
rhino
Joined: 07 Aug 2007
Posts: 57
|
|
|
|
|
|
|
| Posted: Tue Nov 27, 2007 9:52 pm Post subject: Command line backup resolved the timeout |
|
|
|
|
|
|
|
|
|
|
DB is pretty good sized as BO, BA, GS, and LO all share the same DB.
I've added the backup routine to cron to run every 1,10,20 days so should be good... and the DB backup has the data for all of the scripts (just have to remember to download the backup).
Appreciate the help! 
Rhino |
|
|
|
|
|
|
|
htdnsm
Joined: 10 Jun 2008
Posts: 1
|
|
|
|
|
|
|
| Posted: Tue Jun 10, 2008 9:06 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
I am having the same problem with timing out. I am hosted on a managed server. What do I tell the support people so I can get backups created for bo?
thanks |
|
|
|
|
|
|
|
rhino
Joined: 07 Aug 2007
Posts: 57
|
|
|
|
|
|
|
| Posted: Tue Jun 10, 2008 9:59 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
Submit a support request for them to add a new cronjob using mysqldump to backup the DB. This is what I added to my crontab for the backup...
0 4 1,10,20 * * /usr/bin/mysqldump --complete-insert --opt --quote-names --compact --compress --quick -h localhost -u MySQL_username -MySQL_password MySQL_DB_name| gzip -9 > /server/path/to/domain/bo/bobackups/backup.gz
Rhino |
|
|
|
|
|
|
|
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 © 2001, 2002 phpBB Group
|
 |
|
 |
| |
