Koozali.org: home of the SME Server

Obsolete Releases => SME 6.x Contribs => Topic started by: mcp_dk on May 22, 2006, 10:58:28 PM

Title: backupp2ws and mysql
Post by: mcp_dk on May 22, 2006, 10:58:28 PM

How do i setup backup2 ws to do a daily backup of my MySQL database ?
I have no idea where all my databases are stored on the box  :-(

Title: backupp2ws and mysql
Post by: warren on May 23, 2006, 11:31:43 PM

mcp_dk,

I have used with great success :

Quote

AutoMySQLBackup VER 2.3
http://sourceforge.net/projects/automysqlbackup/

You can set it up so that it does a daily backup of mysql db's to a specific
ibay, which would then be backed up by backup2ws.

warren

Title: Re: backupp2ws and mysql
Post by: CharlieBrady on May 24, 2006, 07:53:43 PM

Quote from: "mcp_dk"

How do i setup backup2 ws to do a daily backup of my MySQL database ?
I have no idea where all my databases are stored on the box  :-(

backup2ws should already be doing a backup of mysql databases every time it runs. If it doesn't, then there's a bug in it, and you should open a bug in the bug tracker.

Title: Re: backupp2ws and mysql
Post by: raem on May 25, 2006, 04:22:49 AM

mcp_dk

>>How do i setup backup2 ws to do a daily backup of my MySQL database ?

> backup2ws should already be doing a backup of mysql databases every time it runs.


The mysql databases are only included in the Disaster Recovery 911 backup job.

Any other manually configured backup jobs DO NOT include the mysql db's, so be warned.

Title: backupp2ws and mysql
Post by: mcp_dk on May 25, 2006, 08:11:34 PM

that is just it. I dont do backup of all my ibays at the moment. I only want to backup a handfull and their equivalent MySQL databases.

Title: backupp2ws and mysql
Post by: raem on May 26, 2006, 12:30:17 AM

mcp_dk

the mysql db's are in
/var/lib/mysql/...

To back them up correctly, you need to stop mysql, as open databases will not be backed up. The standard backup scripts in sme server do a dump of the mysql db's immediately before running a backup. This dump is then included in the backup.
The backup2ws contrib also makes use of this dump function.
Note that the dump file is deleted after the backup is complete.

You can see this  "temporary" dump file in
/home/e-smith/db/mysql/mysql.dump
but only after the pre backup routines and before the post backuo routines.

All I can suggest is that you need to create your own backup scripts to selectively dump the contents of certain mysql dbs, and include that in your usual backup job.
Have a look at the sme server backup scripts to see how it is done.

Alternatively schedule the 911 backup job, but set it up to exclude all the user & ibay folders. Then it will have minimal configuration data plus the mysql dump for all your mysql db's.
Then have additional backup jobs scheduled to backup specific ibays & user data etc.

Title: backupp2ws and mysql
Post by: warren on May 28, 2006, 12:04:18 PM

mcp_dk,

You can still use

Quote

Quote:
AutoMySQLBackup VER 2.3
http://sourceforge.net/projects/automysqlbackup/
 

You can set it up so that it does a daily backup of mysql db's to a specific
ibay, which would then be backed up by backup2ws.

as Ray mentions

Quote

To back them up correctly, you need to stop mysql, as open databases will not be backed up. The standard backup scripts in sme server do a dump of the mysql db's immediately before running a backup. This dump is then included in the backup.

The AutoMySQLBackup has functions you can run prior to starting the backup( here you can stop mysql ) do the dump of specified DB's to an ibay that is already in your backup2ws list, and run the post backup function to restart mysql.