Koozali.org: home of the SME Server

backupp2ws and mysql

Offline mcp_dk

  • *
  • 34
  • +0/-0
    • http://lillenet.dk
backupp2ws and mysql
« 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  :-(
Who is General Failure and why is he reading my harddrive?

Offline warren

  • *
  • 291
  • +0/-0
backupp2ws and mysql
« Reply #1 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

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: backupp2ws and mysql
« Reply #2 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.

Offline raem

  • *
  • 3,972
  • +4/-0
Re: backupp2ws and mysql
« Reply #3 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.
...

Offline mcp_dk

  • *
  • 34
  • +0/-0
    • http://lillenet.dk
backupp2ws and mysql
« Reply #4 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.
Who is General Failure and why is he reading my harddrive?

Offline raem

  • *
  • 3,972
  • +4/-0
backupp2ws and mysql
« Reply #5 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.
...

Offline warren

  • *
  • 291
  • +0/-0
backupp2ws and mysql
« Reply #6 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.