Error Update MySQL 5.5.41 Ubuntu Server 14.04

7 posts / 0 new
Topic locked
Last post
#1 Thu, 01/22/2015 - 18:15
LupettoOne

Error Update MySQL 5.5.41 Ubuntu Server 14.04

Hi, I upgraded to the MySQL server version 5.5.41 but something will go wrong. My database disappeared. I would like to know if there is a way to return to the previous version 5.5.40. A species recovery. Please help me. They are in total despair. I have all my sites offline.

Thank You.

Thu, 01/22/2015 - 22:43
andreychek

Howdy,

Can you describe the symptoms that you're seeing? Is it that one database is no longer accessible, or is no database accessible?

Are you receiving any error messages?

And if you look in /var/lib/mysql, do you see the databases there?

-Eric

Fri, 01/23/2015 - 03:02
LupettoOne

Thanks for the support andreychek. In the path you indicated I can see my database while the symptom that I receive in virtualmin databases do not read them. If I go in virtualmin: Webmin ---> Server ---> MySQL Database Server

SQL select table_schema,table_name from information_schema.views where table_schema = ? non riuscito : Out of resources when opening file '/tmp/#sql_250e_0.MYD' (Errcode: 24)

Symptoms seem to crash? I can not even run the Backup as it gives me error. I'm desperate ... I could format my VPS but I need to recover the database updated so if you can risolvore without formatting is best.

Thanks await your help.

Fri, 01/23/2015 - 03:13
LupettoOne

"Update"

I did a refresh of the system, and if I go in the path: Webmin ---> Server ---> MySQL Database Server

I view the page correctly but without Database:

MySQL database

No MySQL database has been found on your system. Create a new database

If I go to the path: Webmin ---> Server ---> MySQL Database Server ---> Permit Host

I see this error:

SQL select * from host order by host non riuscito : Can't open file: './mysql/host.frm' (errno: 24)

Fri, 01/23/2015 - 04:25
LupettoOne

I finally solved the problem! :) I could not think what to do as I was panicked. I calmed down and I've been thinking. MySQL error file in the /var/log/mysql/ and the result was this:

150123 10:23:53 [ERROR] /usr/sbin/mysqld: Can't open file

Performing research suffered the first result was this topic:

http://askubuntu.com/questions/288471/mysql-cant-open-files-after-updati...

It was enough to put those two lines in the configuration file of MySQL.

But why this problem just me? It had to be a common problem at all. And that's what I can not understand. There is an answer to everything?

andreychek thank you for interested in my problem.

Fri, 01/23/2015 - 07:32
andreychek

Howdy,

Okay, thanks, that helps -- I think that error you posted is the key.

I don't think the issue was caused by upgrading MySQL -- I think it was likely a coincidence, and that it was going to happen anyway.

Take a peek at my comment to this Forum post here:

https://virtualmin.com/node/24829

Does that solution mentioned there work for you? Although in this particular case it was for a CentOS 6 system, the same sort of thing should work on Ubuntu.

-Eric

Fri, 01/23/2015 - 09:02
LupettoOne

Hi andreychek, It is the problem of link you posted is similar to mine. The logic is the same. I also save your guide posted in this case occurs at a next try this latest update your link. But this time before I will make a backup of the system and of all sites. I do not want to risk anymore after this bad experience! :) We are talking about 68 sites offline and from 09:30 came the first customer calls. A total chaos! :)

Thanks for everything!

Topic locked