MySql Backup

Hi,

Our conquest server runs on-line for 42 days.
It holds MR and CT images.
Today numbers are;
2.605 study, 146.786 images and 49 GB image storage.

I backup conquest mysql innodb tables with mysqldump.
Procedure is;
1. At 00:10, a folder named with current date is created.
2. At 00:20, the complete full back up is taken with mysqldump.
3. Each hour incremental backup is run on full backup.

Each procedure is written in a seperate .bat files, and timing is handled
by windows scheduled tasks.

Today dump file reached 79 MB.

So,

After one year and integrating CR to conquest, I guess dump file will reach
approximately 1 GB.
What about after 2 years, 3 years , .. 10 years later ?

What do you suggest for mysql backup?
I searched several tools but i didn't catch a solution.

Thanks Ali

I think it is very important topic.
Any idea or experience?

Thanks LJJaszczak,

I understand that you back up mysql data directory with raid, right?
What operation do you take to backup on offsite server? Only file copy
or mysqldump or innodb hot backup? Ali

Hi blub,

How do you back your db up? FileCopy the data directory or
using mysqldump or some other techniques? Ali

Thanks friends,

Mysqldump file size reached to 104 MB after 50 days (CR is connected).
Creation of that size of dump file takes 21 seconds on our Pentium E2180 2ghz single cpu w/ 2 GB RAM, Database on Seagate SCSI disc.

As much as i understood from ljaszcza and blub, i now think that i won't take
dump file, i will take the copy of mysql data directory periodically eg daily.

Infact i think that my procedure i mentioned at the beginning of the post
is like a bit more secure, it takes hourly increments and hence when a breakdown is occured only data within last hour will be missing.

But after 5 years and 10 Gb database dump (single) file size with say 35 minutes creation time may be a high drawback.

Since i am not a database expert, i share my thoughts with you.
Ali