MySQL backup

[TERRYRICKETTS]

We are presently backing up a MS SQL server with our Retrospect server. We are now needing to setup an EPrints server, which runs on Linux and uses MySQL and Apache for the database and access. We will need to be able to backup this machine.

 

I know that Retrospect can backup Linux but can it handle MySQL databases? If we get another license for a SQL server will that handle this type of database?

 

Please respond via email. Thanks. Terry_Ricketts@sil.org

[natew]

Hi

 

The safest way to handle this is to set up your databases to a flat file every day. Then use Retrospect to backup those files.

 

Since the databases are on a linux client the additional Retrospect licenses are not necessary.

 

Thanks

Nate

[queball]

You can use sql dump to dump the contents of the database into a file for backup.

 

You can even do this remotely if your mysql allows network access:

mysqldump -a -e -r /backup/destinationfile.sql -h hostname -u username -ppassword Databasename

 

Run mysqldump --help for info on options.

 

We run a batch file on the windows computer using task scheduler that dumps the database over the network and retrospect just backs up that dump file.