I stumbled across this error when I tried to import an InnoDB backup into my existing MySQL server.
I have one application that collects data that I need to tie to another set of data that is recorded on a different server through a different application.
It’s been rather challenging, cause I had to work of an InnoDB backup and they aren’t easily imported to another MySQL server, especially if you want to keep the data on that other server.
Okay, so what I tried, and ultimately prevented me from restarting MySQL was:
- changing all tables on the MySQL server to MyISAM
- killing MySQL (yes, I couldn’t stop it)
- copying the files in the MySQL DataDir to a backup location
- Copying the InnoDB backup files that I want to import into my DataDir
- trying to restart MySQL
# sudo /etc/init.d/mysql start
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
# sudo rm -f /var/lock/subsys/mysql
# sudo /etc/init.d/mysql start
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
After long fiddling, I found out that the files in my DataDir have changed it’s owner, since I copied them as root to the backup location and back. They were now owned by root. So after:
# sudo chown mysql:mysql *
# sudo chgrp mysql *
I could do:
# sudo /etc/init.d/mysql start
Starting MySQL. SUCCESS!
Hope this helps you too!
I would like to exchange links with your site d3ngar.blogspot.com
Is this possible?
Thanks a lot for writing this, it was unbelieveably informative and told me a ton
Es evidente que hay mucho que aprender acerca de esto. Creo que hizo algunas cosas buenas en características también. Sigue trabajando, gran trabajo!
Thanks for requests for link exchange. I do like to exchange links in some form or another, preferably with my eCommerce site. I do need to know how I can contact you though. Posting an anonymous request doesn't help me very much.
Think before you post!
How can i ask you for more details? Great post needda know more….
Well, you could email me if you really wanna know more.