A Quick Look at MySQL 6.0's New Backup

Monday Aug 25th 2008 by DatabaseJournal.com Staff

In MySQL 6.0 (now in alpha), a new backup and restore utility is being introduced that many will find beneficial. This article takes a quick look at the new backup/restore tool and takes it for a quick test drive through a number of common scenarios to see how well it performs.

[From MySQL AB]

I still remember the day. I was working for a large systems integrator on a very major account, and had responsibility for some DB2 databases, but also had the unfortunate duty of also taking care of some legacy IMS databases (hierarchical IBM databases used quite a lot ‘back in the day’), which I knew next to nothing about. One morning I was asked to make a small change to a very large and prominent IMS database – just remove one record – what could go wrong? The guy who knew IMS real well was gone so I put together a program to do the job (yes, you actually had to write a program to do it), and ran it after hours. I came in the next day and tried to access some records in the database. Nothing. All gone, except for – ta-da – the one record I wanted to remove! At the instant I realized my mistake, I was acutely aware of two things: (1) I was in serious trouble if I didn’t have a backup, and (2) I was in desperate need of a complete change in underwear.

The article continues at http://dev.mysql.com/tech-resources/articles/mysql-60-backup.html

Mobile Site | Full Site