Can i use wildcards to tellthe script to backup all databases on a machine instead of having to put new ones into the scipt every time they are created? Can I use something like all-databases and how?
Do I have to create one script for every machine or is there a way of stating multiple server variables and using only one script on one machine??
Sorry for being a bit naive
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you have a quick readt through the docs in the script, below all the settings, you will see the details of using "all" to backup all databases on the server that the chosen user has access to..
To backup multiple servers you would need to create multiple copies of the script.. Just give then ditterent file names and it should be fairly simple..
Hope that helps..
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've just read them myself, probably should have done that first, doh!!
Out of interest, do you know how it moves the backed up files from remote servers to the the server where the script is running from and hte authentication method it uses?
Thanks again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The server running the script will connect to the MySQL server directly from the mysqldump utility so the backup is in fact done on the server running the script, this means there are no files to move from the databse server to the backup server..
Authentication is just standard mysql authentication..
If you want to reduce the bandwidth used you can enable compression with the COMMCOMP option..
At this point there is no native encryption supported from the script directly but you could use SSH port forwarding and create a secure "tunnel" between the two servers prior to executing the script if you needed encrypted communications betreen the two servers.. You may be able to use the Pre and Post options to execute the command line to setup the tunnel but I haven't actually done this so YMMV..
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello all
Can i use wildcards to tellthe script to backup all databases on a machine instead of having to put new ones into the scipt every time they are created? Can I use something like all-databases and how?
Do I have to create one script for every machine or is there a way of stating multiple server variables and using only one script on one machine??
Sorry for being a bit naive
Hi,
If you have a quick readt through the docs in the script, below all the settings, you will see the details of using "all" to backup all databases on the server that the chosen user has access to..
To backup multiple servers you would need to create multiple copies of the script.. Just give then ditterent file names and it should be fairly simple..
Hope that helps..
Thanks wipe-out
I've just read them myself, probably should have done that first, doh!!
Out of interest, do you know how it moves the backed up files from remote servers to the the server where the script is running from and hte authentication method it uses?
Thanks again.
The server running the script will connect to the MySQL server directly from the mysqldump utility so the backup is in fact done on the server running the script, this means there are no files to move from the databse server to the backup server..
Authentication is just standard mysql authentication..
If you want to reduce the bandwidth used you can enable compression with the COMMCOMP option..
At this point there is no native encryption supported from the script directly but you could use SSH port forwarding and create a secure "tunnel" between the two servers prior to executing the script if you needed encrypted communications betreen the two servers.. You may be able to use the Pre and Post options to execute the command line to setup the tunnel but I haven't actually done this so YMMV..