Automated Database / MySQL Backup

[kwright]

What do most folks use for auto db back up of their Zen Carts?

I would like to automatically do a complete weekly backup and a per transaction backup. The per transaction would just need to backup the tables involved!

Any thoughts???

Thanks

[kobra]

We use a script that backups the DB daily so that the most lost would be 1 day or part of a day...it emails the backup file to, preferably an email account not on your server

[kwright]

Thanks kobra,

Do you use a custom script, Zen addon or other?

[kobra]

It is a custom shell script....this avoids any php limits

[kwright]

Sounds as if it would be better to do backups through shell script rather then php...

Do you have any suggestions as to a ready made shell script? I have root access since we are on a dedicated server.

I have read that using mysqldump may cause issues with the mysql cache and table locking...not being that versed with this level of mysql...don't know if this is something I should worry about.

Are you using MyISAM or InnoDB? Would Zen benifit from InnoDB?

[data_digger]

There's no way to make backups after each transaction. The closest to it would be MySQL ##############tion (lol, Zen Cart thinks that I sell watches?:) it was r e p l i c a tion) - but You need two servers for that.

[data_digger]

Are you using MyISAM or InnoDB? Would Zen benifit from InnoDB?

Use InnoDB - MyISAM tables might get corrupted during server crash. InnoDB might also be faster.

[kwright]

Thanks all,

You gave me some food for thought. Database backups would seem to be a straightforward deal, but I am finding there is much more to it. Especially if you ever had to do a real life restore!

additional input is welcomed...