Clint, Thanks for the tip. The server is running but I noticed when I was inside a mysql session, I was getting messages that the mysql went away and then came back. Anyway, I updated the password and now I have 'Got error 28 from storage engine' when trying to dump tablespaces mysqldump: couldn't execute 'show fields from `jos_banner`': Got error 28 from storage engine (1030) So, it might be getting stuck on the first table. Or does it matter where you run this command? Bruce
-----Original Message----- From: centos-boun...@centos.org [mailto:centos-boun...@centos.org] On Behalf Of Clint Dilks Sent: Tuesday, April 23, 2013 9:42 PM To: CentOS mailing list Subject: Re: [CentOS] Problem getting mysqldump on Centos 5.x server Hi Bruce >From your message I am assuming that either you installed MySQL >yourself or had some do it for you? Is the mysql database currently running? If not it should be. Are you able to access the database using the command line tools ? From the machine its currently running on try mysql -p ( when prompted enter the password you believe should work) If it is running I suggest you schedule a time to shut it down and reset the root password See http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html or Google Moving the physical files associated with a MySQL Database can be made to work if you absolutely must. But getting a mysql dump is a much cleaner approach. I hope this helps :) _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
