Home Community Forum Plugins

Documentation

For Developers For Storeowners

Services Donate Get Started

Forums / General Questions / Automated Database / MySQL Backup

Automated Database / MySQL Backup

Locked

Results 1 to 8 of 8

This thread is locked. New replies are disabled.

14 Jul 2009, 01:15

kwright

Zen Follower

Join Date:: Nov 2004
Posts:: 355
Plugin Contributions:: 0

Automated Database / MySQL Backup

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

14 Jul 2009, 01:23

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Automated Database / MySQL Backup

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

14 Jul 2009, 03:26

kwright

Zen Follower

Join Date:: Nov 2004
Posts:: 355
Plugin Contributions:: 0

Re: Automated Database / MySQL Backup

Thanks kobra,

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

14 Jul 2009, 10:14

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Automated Database / MySQL Backup

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

14 Jul 2009, 13:25

kwright

Zen Follower

Join Date:: Nov 2004
Posts:: 355
Plugin Contributions:: 0

Re: Automated Database / MySQL Backup

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?

14 Jul 2009, 13:59

data_digger

Zen Follower

Join Date:: Jan 2009
Posts:: 222
Plugin Contributions:: 2

Re: Automated Database / MySQL Backup

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.

14 Jul 2009, 14:03

data_digger

Zen Follower

Join Date:: Jan 2009
Posts:: 222
Plugin Contributions:: 2

Re: Automated Database / MySQL Backup

kwright:
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.

14 Jul 2009, 20:27

kwright

Zen Follower

Join Date:: Nov 2004
Posts:: 355
Plugin Contributions:: 0

Re: Automated Database / MySQL Backup

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... :smile: