Secure Database Backup Solution For Lareg Databases

[legal-medium]

I have a MySQL database "MySQL version 3.23.58 " that is around 2 gigs in size and growing, I would like to automate a secure back-up from the production server to another remote server.

any I deas or sugestions on how to approach this task?

Thanks in Advance

[drag0n]

Im just curious, but what are you storing in the db if its not confidental, 2gb is pretty big 🙂

[legal-medium]

I have a MySQL database "MySQL version 3.23.58 " that is around 2 gigs in size and growing, I would like to automate a secure back-up from the production server to another remote server.

any I deas or sugestions on how to approach this task?

Thanks in Advance

[drag0n]

dont repeat

[legal-medium]

I have a MySQL database "MySQL version 3.23.58 " that is around 2 gigs in size and growing, I would like to automate a secure back-up from the production server to another remote server.

any I deas or sugestions on how to approach this task?

Thanks in Advance

[jweissig]

hello,

Where do you plan to transfer the information? On the same network or a remote server.. and via what protocol? FTP, SMB, NFS?

Here is the easy part..

If you have a large database like this i assume that you have shell access of a method of getting a script to run via "crond".

I would create a shell script that runs "mysqldump" compresses the database backup (possibly splits the compresses files for transfer).

Once this is complete you would implements something to move the files to the remote machine.. via FTP, SMB or NFS..

thanks,
- justin

[legal-medium]

Thanks