mysql backup

[pc_user]

can anyone recommend a mysql backup solution, I want to be able to run backups on the local mysql db and store them remotely in an encrypted manner. Preferably sftp transfer too.

The problem I Have is the tables are big, anything to do on that? Even selects lock the tables.

[nirghum]

Do you have root access? if then i have a good solution with which you can get the core backup of your mysql database.

[pc_user]

Well, I do but not interested in the raw files. Too many corruption issues, even if you repair the files post transfer. Let me know what you have.

[nirghum]

I was about to recommend you to use "rsync" for remote syncronising the mysql database from one server to another server. And that is the best policy although according my idea, as if you copy the databases with sql format, then the most bad thing is, the sql language corruption can hault your whole database restore.

[aplus]

i use mysqlblasy
I have a nightly cron job and it creates a single file like:
date-time.tar.gz

I recommend it. You can also backupninja. Backs up databases or files, or both

[niloy]

i use mysqlblasy
I have a nightly cron job and it creates a single file like:
date-time.tar.gz

I recommend it. You can also backupninja. Backs up databases or files, or both
taking backup of mysql datbases with sql format is really problematic. Sometimes it gets crapped, i realy agree with the raw files backup.

[krakjoe]

What server software are you using ?

[pc_user]

CentOS. I've used MySQL raw file backups before, the problem with that of course is that there is some corruption, not much but some, can't afford that ;) Any other suggestions? The problem with most is that they do a select * from which locks some larger tables. Thanks all.