PDA

View Full Version : Backing up views



dcbrown
March 18th, 2009, 12:15 PM
I'm looking at our options for backing up MySQL. We currently use mysqldump and another product.

Our issues is mysqldump will dump the databases and views, but you cannot restore them as you get errors on import. The errors are because of the views. This happens with both products (mysqldump and the commercial product)

I see at least one of Zmanda's methods is mysqldump which I can already tell you will fail if it uses the version that comes with our current version of MySQL (5.0.45 RHEL release)

We currently have to use --ignore-table=dbname.dbtable for each view when dumping the database so that we can actually import it afterwards. Then recreate the views once restored.

Does anyone have these issues with Zmanda?

raktri4u
March 24th, 2009, 11:01 AM
Go for mysql-ZRM tool..this is awesome and work efficiently

cheers
Rak