I tried to reinstall mysql on my machine, but it keeps failing. Everytime it fails, it does this locking and that locking and future effort would fail again.
Finally I decided to do truly clean install
- Delete everything
The procedure is listed here : http://stuffthatspins.com/2011/01/08/ubuntu-10-x-completely-remove-and-clean-mysql-installation/
I do not want to lose data already there. Yea, it's backed up but I kind of like it there.
So, can I just mv content of /etc/mysql and then copy it back after I reinstall everything?
My programmer said it wouldn't work
If not, what else I should know?
I sort of forget where mysql store data. It's the default for ubuntu I guess.
Update: I tried that on some local databases using available computers. The Myisam table get transferred. However the innodb tables do not.
Also http://www.chriscalender.com/?tag=innodb-error-tablespace-id-in-file shows that innodb won't get transferred as easily by just copying files. Am I missing something?
Another Update: The answer is yes we can. We did it :D
The short answer is yes we can. My programmer just did it. The key is to copy thew whole file and realize that innodb store database in one big file. Not sure why.
The other answer is better so I pick that (I don't think it's objective to pick my own answer). I just want to share that it works.