posted by Sakila The Librarian
on
Mon 07 Sep 2009 12:11 UTC
Tags:
Open Source means that the source code is open. There are many inferences that can be made from this, and many stereotypes that can be applied, but in the end, all it means is that you can read the source code as well as use the binaries.I am not a developer. I fully admit this. What I mean by this is that my strengths do not lie in engineering new code to do things. Give me some Lego™s or some Wedgits™ and I look at the instructions to see what to build.However, I am an engineer.One of my team's current tasks is to restore a backup (using InnoDB Hot Backup, and compressed) from a client's production machine to a development instance.....Weekly -- thus we want to automate it......And did I mention the development machine has 5 different MySQL instances on it, running all on 127.0.0.1 on different ports?The steps are:0) stop the desired mysql instance 1) move the development datadir and logs to a backup directory2) copy the most recent production backup to the development machine3) uncompress the production backup and apply any logs (with ibbackup)4) start the desired mysql instance5) check and celebrateBeing smart, and knowing my own limitations, I delegated the task to another team member. Remember, I am not a good developer! But my team member is smart, and he got everything going well, except step 3. The problem was with running:"ibbackup --apply-log --uncompress ./restore-my.cnf"